|
|
BNEMPGRNT FILE
UPDATED BY
HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BEG-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
BEG-EMPLOYEE Numeric 9
Element: Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
BEG-OPT-GRANT-NBR Alpha 10
Element: Opt Grant Nbr
BEG-GRANT-DATE Numeric 8 (yyyymmdd)
Element: Grant Date
BEG-SHARES-GRANTED Numeric 9
Element: Shares Granted
BEG-GRANT-PRICE Signed 9.4
Element: Grant Price
BEG-EXP-DATE Numeric 8 (yyyymmdd)
Element: Expiration Date
BEG-EXPIRED-SHARES Numeric 9
Element: Expired Shares
BEG-FORFEIT-DATE Numeric 8 (yyyymmdd)
Element: Forfeit Date
BEG-FORFEIT-SHARES Numeric 9
Element: Forfeit Shares
BEG-STOCK-SPLIT Alpha 1
Element: Stock Split 1 = No
2 = Yes
BEG-TOT-OUT-SHARES Numeric 9
Element: Tot Out Shares
BEG-VEST-SCHED Alpha 2
Element: Schedule
BEG-VEST-FROM Numeric 8 (yyyymmdd)
Element: Vest From
BEG-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
BEG-VESTED-PERCENT Numeric 3
Element: Vested Percent
BEG-OPTION-TYPE Alpha 2
Element: Option Type 1 = Incentive Stock Option
2 = Non-Qualified
3 = Stock Appreciation Rights
BEG-VEST-AS-OF-DT Numeric 8 (yyyymmdd)
Element: Vest As Of Dt
BEG-VESTING-UPDATE Alpha 1
Element: Vesting Update1 = Do Not Update
2 = Update
BEG-VEST-TYPE Alpha 1
Element: Vest Type 1 = Annual
2 = Semi-Annual
3 = Quarterly
4 = Monthly
5 = Daily
BEG-APPROVAL-FLAG Alpha 1
Element: Approval N = No
Y = Yes
BEG-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.
BEG-TIME-STAMP Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BEG-USER-ID Alpha 10 (Lower Case)
Element: User
BEG-EXPIRE-UPDATE Alpha 1
Element: Expire Update N = No
Y = Yes
BEG-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BEG-CURR-ND Numeric 1
Account Currency
Code
BEG-BASE-GNT-PRICE Signed 9.4
Element: Base Gnt Price
BEG-EMP-GRNT-PRICE Signed 9.4
Element: Emp Grnt Price
BEG-BASE-CURRENCY Alpha 5
To Company Base
Currency
BEG-BASE-ND Numeric 1
Account Currency
Code
BEG-EMP-CURRENCY Alpha 5
Element: Emp Currency
BEG-EMP-ND Numeric 1
Element: Emp Nd
BEG-FAIR-MKT-VAL Signed 9.4
Element: Fair Mkt Val
BEG-BASE-FR-MKT-VL Signed 9.4
Element: Base Fr Mkt Vl
BEG-EMP-FR-MKT-VL Signed 9.4
Element: Emp Fr Mkt Vl
BEG-MKT-VAL-DATE Numeric 8 (yyyymmdd)
Element: Mkt Val Date
BNEMPGRNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BEGSET1 COMPANY KeyChange HR11.1 PA115
EMPLOYEE
OPT-GRANT-NBR
BEGSET2 COMPANY KeyChange
OPT-GRANT-NBR
EMPLOYEE
BEGSET3 COMPANY KeyChange
EXP-DATE
EMPLOYEE
OPT-GRANT-NBR
BEGSET4 COMPANY KeyChange
FORFEIT-DATE
EMPLOYEE
OPT-GRANT-NBR
BNEMPGRNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Not Required
BEG-BASE-CURRENCY -> CUC-CURRENCY-CODE (CUCSET1)
Bnstkgnt BNSTKGNT Required
BEG-COMPANY -> BSG-COMPANY
BEG-OPT-GRANT-NBR -> BSG-OPT-GRANT-NBR
Company PRSYSTEM Required
BEG-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Not Required
BEG-CURRENCY-CODE -> CUC-CURRENCY-CODE
Emp Currency CUCODES Not Required
BEG-EMP-CURRENCY -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
BEG-COMPANY -> EMP-COMPANY
BEG-EMPLOYEE -> EMP-EMPLOYEE
Vest Schedule VESTSCHDHD Required
When BEG-VEST-SCHED != Spaces
BEG-COMPANY -> VSH-COMPANY
BEG-VEST-SCHED -> VSH-VEST-SCHED
BNEMPGRNT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Exercise BNEMPEXER
BEG-COMPANY -> BXR-COMPANY
BEG-EMPLOYEE -> BXR-EMPLOYEE
BEG-OPT-GRANT-NBR -> BXR-OPT-GRANT-NBR
BXR-EXERCISE-DATE
BXR-SEQ-NBR
|
