|
|
BNSTKGNT FILE
UPDATED BY
HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSG-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
BSG-OPT-GRANT-NBR Alpha 10
Element: Opt Grant Nbr
BSG-OPTION-TYPE Alpha 2
Element: Option Type 1 = Incentive Stock Option
2 = Non-Qualified
3 = Stock Appreciation Rights
BSG-STOCK-SYMBOL Alpha 6
Element: Stock Symbol
BSG-GROUP-NAME Alpha 10
Element: Group Name
BSG-MULTIPLE-EMPS Alpha 1
Element: Multiple Emps 1 = No
2 = Yes
BSG-SHARES-AVAIL Numeric 12
Element: Shares Avail
BSG-GRANT-DATE Numeric 8 (yyyymmdd)
Element: Grant Date
BSG-GRANT-PRICE Signed 9.4
Element: Grant Price
BSG-EXP-DATE Numeric 8 (yyyymmdd)
Element: Expiration Date
BSG-VEST-SCHED Alpha 2
Element: Schedule
BSG-OPT-VEST-FROM Alpha 2
Element: Opt Vest From 1 = Grant Date
2 = Hire Date
3 = Adjusted Hire Date
4 = Anniversary Date
5 = Seniority Date
6 = BN Date 1
7 = BN Date 2
8 = BN Date 3
9 = BN Date 4
10 = BN Date 5
BSG-VEST-FROM Numeric 8 (yyyymmdd)
Element: Vest From
BSG-VEST-TO Alpha 2
Element: Vest To
BSG-VEST-AS-OF-DT Numeric 8 (yyyymmdd)
Element: Vest As Of Dt
BSG-TOT-GRANTS Numeric 12
Element: Tot Grants
BSG-TOT-EXER Numeric 12
Element: Tot Exer
BSG-TOT-EXPIRED Numeric 12
Element: Tot Expired
BSG-TOT-FORFEIT Numeric 12
Element: Tot Forfeit
BSG-TOT-AVAIL Numeric 12
Element: Tot Avail
BSG-VESTING-UPDATE Alpha 1
Element: Vesting Update1 = Not Updated
2 = Updated
BSG-STK-SPLIT-UPD Alpha 1
Element: Stk Split Upd 1 = Not Updated
2 = Updated
BSG-ACTIVE-FLAG Alpha 1
Element: Status The Active flag of the credit card
type.
A = Active
I = Inactive
BSG-VEST-TYPE Alpha 1
Element: Vest Type 1 = Annual
2 = Semi-Annual
3 = Quarterly
4 = Monthly
5 = Daily
BSG-FORFEIT-FLAG Alpha 1
Element: Forfeit Flag N = No
Y = Yes
BSG-WEB-AVAILABLE Alpha 1
Element: Web Available N = No
Y = Yes
BSG-WEB-AVAIL-SUPV Alpha 1
Element: Web Avail Supv1 = Not Available
2 = Direct Supervisor
3 = Indirect Supervisor
4 = Direct;Indirect Supervisor
" " = Not applicable
BSG-WORKFLOW-FLAG Alpha 1
Element: All Flag N = No
Y = Yes
BSG-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.
BSG-TIME-STAMP Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BSG-USER-ID Alpha 10 (Lower Case)
Element: User
BSG-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BSG-CURR-ND Numeric 1
Account Currency
Code
BSG-BASE-GNT-PRICE Signed 9.4
Element: Base Gnt Price
BSG-EXPIRED-FLAG Alpha 1
Element: Expired Flag N = No
Y = Yes
BSG-EXER-WORKFLOW Alpha 1
Element: Exer Workflow N = No
Y = Yes
BSG-EST-TAX-PCT Signed 5.2
Element: Est Tax Pct
BSG-BASE-CURRENCY Alpha 5
To Company Base
Currency
BSG-BASE-ND Numeric 1
Account Currency
Code
BSG-VEST-TERM Alpha 1
Element: Vest Term N = No
Y = Yes
BSG-FAIR-MKT-VAL Signed 9.4
Element: Fair Mkt Val
BSG-BASE-FR-MKT-VL Signed 9.4
Element: Base Fr Mkt Vl
BSG-MKT-VAL-DATE Numeric 8 (yyyymmdd)
Element: Mkt Val Date
BNSTKGNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSGSET1 COMPANY HR00.1 HR01.1
OPT-GRANT-NBR PBIP.1 PR197
BSGSET2 STOCK-SYMBOL KeyChange
COMPANY
OPT-GRANT-NBR
BSGSET3 COMPANY KeyChange
EXP-DATE
OPT-GRANT-NBR
BSGSET4 COMPANY KeyChange, Subset
VESTING-UPDATEWhere VESTING-UPDATE = "1"
OPT-GRANT-NBR
BSGSET5 COMPANY KeyChange, Subset
STK-SPLIT-UPD Where STK-SPLIT-UPD = "1"
OPT-GRANT-NBR
BSGSET6 COMPANY Subset
OPT-GRANT-NBR Where ACTIVE-FLAG = "A"
BNSTKGNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Not Required
BSG-BASE-CURRENCY -> CUC-CURRENCY-CODE (CUCSET1)
Company PRSYSTEM Required
BSG-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Not Required
BSG-CURRENCY-CODE -> CUC-CURRENCY-CODE
Stock BNSTOCK Required
BSG-STOCK-SYMBOL -> BSK-STOCK-SYMBOL
Vesting VESTSCHDHD Required
When BSG-VEST-SCHED != Spaces
BSG-COMPANY -> VSH-COMPANY
BSG-VEST-SCHED -> VSH-VEST-SCHED
BNSTKGNT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Emp Exer BNEMPEXER
BSG-COMPANY -> BXR-COMPANY
BSG-OPT-GRANT-NBR -> BXR-OPT-GRANT-NBR
BXR-EXERCISE-DATE
BXR-EMPLOYEE
BXR-SEQ-NBR
Emp Grant BNEMPGRNT
BSG-COMPANY -> BEG-COMPANY
BSG-OPT-GRANT-NBR -> BEG-OPT-GRANT-NBR
BEG-EMPLOYEE
|
