BNSTKSPLT FILE
REFERENCED BY
HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSP-STOCK-SYMBOL Alpha 6
Stock Symbol
BSP-SPLIT-DATE Numeric 8 (yyyymmdd)
Split Date
BSP-SPLIT-FROM Numeric 3
Split From
BSP-SPLIT-TO Numeric 3
Split To
BSP-PRICE-FROM Signed 9.4
Price From
BSP-PRICE-TO Signed 9.4
Price To
BSP-ROUND-METH Alpha 1
Rounding Method H = High
L = Low
N = No Rounding
R = Normal Rounding
BSP-BEF-AFT-FLAG Alpha 1
Before/After B = Before
A = After
BSP-ROUND-TO Signed 9.4
Round To
BSP-STK-SPLIT-UPD Alpha 1
Stk Split Upd 1 = Not Updated
2 = Updated
BSP-DATE-STAMP Numeric 8 (yyyymmdd)
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)
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BSP-USER-ID Alpha 10 (Lower Case)
User ID Name Contains the user ID of the person who
last changed this record.
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)
|
