BNEMPEXER FILE
UPDATED BY
HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BXR-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
BXR-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.
BXR-OPT-GRANT-NBR Alpha 10
Opt Grant Nbr
BXR-EXERCISE-DATE Numeric 8 (yyyymmdd)
Exercise Date
BXR-SEQ-NBR Numeric 4
Sequence Number An automatically assigned sequence
number.
BXR-STOCK-SYMBOL Alpha 6
Stock Symbol
BXR-SHARES-EXE Numeric 9
Shares Exe
BXR-EXERCISE-PRICE Signed 9.4
Exercise Price
BXR-PENDING Alpha 1
Pending 1 = Pending
2 = Completed
BXR-TRANSAC-VALUE Signed 13.2
Transac Value
BXR-GAIN-LOST-VAL Signed 13.2
Gain Lost Val
BXR-TAX-WAGE-UPD Signed 13.2
Tax Wage Upd
BXR-EMP-TAX-AMT Signed 13.2
Emp Tax Amt
BXR-FORFEIT-SHARES Numeric 9
Forfeit Shares
BXR-BROKER Alpha 4
Broker
BXR-EXERCISE-COST Signed 13.2
Exercise Cost
BXR-DATE-STAMP Numeric 8 (yyyymmdd)
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
BXR-TIME-STAMP Numeric 6 (hhmmss)
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BXR-USER-ID Alpha 10 (Lower Case)
User ID Name Contains the user ID of the person who
last changed this record.
BXR-APPROVAL-FLAG Alpha 1
Approval N = No
Y = Yes
BXR-PAYROLL-UPDATE Alpha 1
Payroll Update N = No
Y = Yes
BXR-FORFEIT-FLAG Alpha 1
Forfeit Flag N = No
Y = Yes
BXR-FAIR-MKT-VAL Signed 9.4
Fair Mkt Val
BXR-MKT-VAL-DATE Numeric 8 (yyyymmdd)
Mkt Val Date
BXR-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BXR-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
BXR-STOCK-FEES Signed 13.2
Stock Fees
BXR-BASE-EXER-PRIC Signed 9.4
Base Exer Pric
BXR-BASE-TRANS-VAL Signed 13.2
Base Trans Val
BXR-BASE-GAIN-LOST Signed 13.2
Base Gain Lost
BXR-BASE-TAX-WAGE Signed 13.2
Base Tax Wage
BXR-BASE-EMP-TAX Signed 13.2
Base Emp Tax
BXR-BASE-EXER-COST Signed 13.2
Base Exer Cost
BXR-BASE-FR-MKT-VL Signed 9.4
Base Fr Mkt Vl
BXR-BASE-STOCK-FEE Signed 13.2
Base Stock Fee
BXR-EMP-EXER-PRICE Signed 9.4
Emp Exer Price
BXR-EMP-TRANS-VAL Signed 13.2
Emp Trans Val
BXR-EMP-GAIN-LOST Signed 13.2
Emp Gain Lost
BXR-EMP-TAX-WAGE Signed 13.2
Emp Tax Wage
BXR-EMP-EMP-TAX Signed 13.2
Emp Emp Tax
BXR-EMP-EXER-COST Signed 13.2
Emp Exer Cost
BXR-EMP-FR-MKT-VAL Signed 9.4
Emp Fr Mkt Val
BXR-EMP-STOCK-FEES Signed 13.2
Emp Stock Fees
BXR-BASE-CURRENCY Alpha 5
Base Currency The company base currency.
BXR-BASE-ND Numeric 1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
BXR-EMP-CURRENCY Alpha 5
Emp Currency
BXR-EMP-ND Numeric 1
Emp Nd
BXR-EXER-TYPE Alpha 1
Exer Type 1 = Exercise and Sell
2 = Exercise and Hold
3 = Sell to Cover Exercise
4 = Stock Swap
5 = Forfeit
BNEMPEXER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BXRSET1 COMPANY HR11.1 PA115
EMPLOYEE
OPT-GRANT-NBR
EXERCISE-DATE
SEQ-NBR
BXRSET2 COMPANY KeyChange
EMPLOYEE
OPT-GRANT-NBR
EXERCISE-DATE*
SEQ-NBR
BXRSET3 BROKER KeyChange
COMPANY
EMPLOYEE
OPT-GRANT-NBR
EXERCISE-DATE
SEQ-NBR
BXRSET4 COMPANY
OPT-GRANT-NBR
EXERCISE-DATE
EMPLOYEE
SEQ-NBR
BXRSET5 COMPANY KeyChange, Subset
EMPLOYEE Where (PENDING = "1" )
OPT-GRANT-NBR
EXERCISE-DATE
SEQ-NBR
BNEMPEXER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Not Required
BXR-BASE-CURRENCY -> CUC-CURRENCY-CODE (CUCSET1)
Bnempgrnt BNEMPGRNT Required
BXR-COMPANY -> BEG-COMPANY
BXR-EMPLOYEE -> BEG-EMPLOYEE
BXR-OPT-GRANT-NBR -> BEG-OPT-GRANT-NBR
Broker BNBROKER Required
When (BXR-BROKER != Spaces )
BXR-BROKER -> BRK-BROKER
Company PRSYSTEM Required
BXR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Not Required
BXR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Emp Currency CUCODES Not Required
BXR-EMP-CURRENCY -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
BXR-COMPANY -> EMP-COMPANY
BXR-EMPLOYEE -> EMP-EMPLOYEE
Option BNSTKGNT Required
BXR-COMPANY -> BSG-COMPANY
BXR-OPT-GRANT-NBR -> BSG-OPT-GRANT-NBR
|
