BNEMPGRNT FILE
UPDATED BY
HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BEG-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
BEG-EMPLOYEE Numeric 9
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
Opt Grant Nbr
BEG-GRANT-DATE Numeric 8 (yyyymmdd)
Grant Date
BEG-SHARES-GRANTED Numeric 9
Shares Granted
BEG-GRANT-PRICE Signed 9.4
Grant Price
BEG-EXP-DATE Numeric 8 (yyyymmdd)
Expiration Date
BEG-EXPIRED-SHARES Numeric 9
Expired Shares
BEG-FORFEIT-DATE Numeric 8 (yyyymmdd)
Forfeit Date
BEG-FORFEIT-SHARES Numeric 9
Forfeit Shares
BEG-STOCK-SPLIT Alpha 1
Stock Split 1 = No
2 = Yes
BEG-TOT-OUT-SHARES Numeric 9
Tot Out Shares
BEG-VEST-SCHED Alpha 2
Schedule
BEG-VEST-FROM Numeric 8 (yyyymmdd)
Vest From
BEG-OPT-VEST-FROM Alpha 2
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
Vested Percent
BEG-OPTION-TYPE Alpha 2
Option Type 1 = Incentive Stock Option
2 = Non-Qualified
3 = Stock Appreciation Rights
BEG-VEST-AS-OF-DT Numeric 8 (yyyymmdd)
Vest As Of Dt
BEG-VESTING-UPDATE Alpha 1
Vesting Update 1 = Do Not Update
2 = Update
BEG-VEST-TYPE Alpha 1
Vest Type 1 = Annual
2 = Semi-Annual
3 = Quarterly
4 = Monthly
5 = Daily
BEG-APPROVAL-FLAG Alpha 1
Approval N = No
Y = Yes
BEG-DATE-STAMP Numeric 8 (yyyymmdd)
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)
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BEG-USER-ID Alpha 10 (Lower Case)
User ID Name Contains the user ID of the person who
last changed this record.
BEG-EXPIRE-UPDATE Alpha 1
Expire Update N = No
Y = Yes
BEG-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BEG-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
BEG-BASE-GNT-PRICE Signed 9.4
Base Gnt Price
BEG-EMP-GRNT-PRICE Signed 9.4
Emp Grnt Price
BEG-BASE-CURRENCY Alpha 5
Base Currency The company base currency.
BEG-BASE-ND Numeric 1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
BEG-EMP-CURRENCY Alpha 5
Emp Currency
BEG-EMP-ND Numeric 1
Emp Nd
BEG-FAIR-MKT-VAL Signed 9.4
Fair Mkt Val
BEG-BASE-FR-MKT-VL Signed 9.4
Base Fr Mkt Vl
BEG-EMP-FR-MKT-VL Signed 9.4
Emp Fr Mkt Vl
BEG-MKT-VAL-DATE Numeric 8 (yyyymmdd)
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
|
