|
|
BNSTKSPLT FILE
REFERENCED BY
HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSP-STOCK-SYMBOL Alpha 6
Element: Stock Symbol
BSP-SPLIT-DATE Numeric 8 (yyyymmdd)
Element: Split Date
BSP-SPLIT-FROM Numeric 3
Element: Split From
BSP-SPLIT-TO Numeric 3
Element: Split To
BSP-PRICE-FROM Signed 9.4
Element: Price From
BSP-PRICE-TO Signed 9.4
Element: Price To
BSP-ROUND-METH Alpha 1
Element: Rounding MethoH = High
L = Low
N = No Rounding
R = Normal Rounding
BSP-BEF-AFT-FLAG Alpha 1
Element: Before/After B = Before
A = After
BSP-ROUND-TO Signed 9.4
Element: Round To
BSP-STK-SPLIT-UPD Alpha 1
Element: Stk Split Upd 1 = Not Updated
2 = Updated
BSP-DATE-STAMP Numeric 8 (yyyymmdd)
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
BSP-TIME-STAMP Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BSP-USER-ID Alpha 10 (Lower Case)
Element: User
BNSTKSPLT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSPSET1 STOCK-SYMBOL HR00.1 HR01.1
SPLIT-DATE PBIP.1 PR197
BSPSET2 STOCK-SYMBOL
SPLIT-DATE*
BSPSET3 STOCK-SYMBOL Subset
SPLIT-DATE Where STK-SPLIT-UPD = "2"
BNSTKSPLT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Stock BNSTOCK Required
BSP-STOCK-SYMBOL -> BSK-STOCK-SYMBOL (BSKSET1)
|
