|
|
BNEMPEXER FILE
UPDATED BY
HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BXR-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
BXR-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.
BXR-OPT-GRANT-NBR Alpha 10
Element: Opt Grant Nbr
BXR-EXERCISE-DATE Numeric 8 (yyyymmdd)
Element: Exercise Date
BXR-SEQ-NBR Numeric 4
Element: Sequence NumbeAn automatically assigned sequence
number.
BXR-STOCK-SYMBOL Alpha 6
Element: Stock Symbol
BXR-SHARES-EXE Numeric 9
Element: Shares Exe
BXR-EXERCISE-PRICE Signed 9.4
Element: Exercise Price
BXR-PENDING Alpha 1
Element: Pending 1 = Pending
2 = Completed
BXR-TRANSAC-VALUE Signed 13.2
Element: Transac Value
BXR-GAIN-LOST-VAL Signed 13.2
Element: Gain Lost Val
BXR-TAX-WAGE-UPD Signed 13.2
Element: Tax Wage Upd
BXR-EMP-TAX-AMT Signed 13.2
Element: Emp Tax Amt
BXR-FORFEIT-SHARES Numeric 9
Element: Forfeit Shares
BXR-BROKER Alpha 4
Element: Broker
BXR-EXERCISE-COST Signed 13.2
Element: Exercise Cost
BXR-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.
BXR-TIME-STAMP Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BXR-USER-ID Alpha 10 (Lower Case)
Element: User
BXR-APPROVAL-FLAG Alpha 1
Element: Approval N = No
Y = Yes
BXR-PAYROLL-UPDATE Alpha 1
Element: Payroll UpdateN = No
Y = Yes
BXR-FORFEIT-FLAG Alpha 1
Element: Forfeit Flag N = No
Y = Yes
BXR-FAIR-MKT-VAL Signed 9.4
Element: Fair Mkt Val
BXR-MKT-VAL-DATE Numeric 8 (yyyymmdd)
Element: Mkt Val Date
BXR-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BXR-CURR-ND Numeric 1
Account Currency
Code
BXR-STOCK-FEES Signed 13.2
Element: Stock Fees
BXR-BASE-EXER-PRIC Signed 9.4
Element: Base Exer Pric
BXR-BASE-TRANS-VAL Signed 13.2
Element: Base Trans Val
BXR-BASE-GAIN-LOST Signed 13.2
Element: Base Gain Lost
BXR-BASE-TAX-WAGE Signed 13.2
Element: Base Tax Wage
BXR-BASE-EMP-TAX Signed 13.2
Element: Base Emp Tax
BXR-BASE-EXER-COST Signed 13.2
Element: Base Exer Cost
BXR-BASE-FR-MKT-VL Signed 9.4
Element: Base Fr Mkt Vl
BXR-BASE-STOCK-FEE Signed 13.2
Element: Base Stock Fee
BXR-EMP-EXER-PRICE Signed 9.4
Element: Emp Exer Price
BXR-EMP-TRANS-VAL Signed 13.2
Element: Emp Trans Val
BXR-EMP-GAIN-LOST Signed 13.2
Element: Emp Gain Lost
BXR-EMP-TAX-WAGE Signed 13.2
Element: Emp Tax Wage
BXR-EMP-EMP-TAX Signed 13.2
Element: Emp Emp Tax
BXR-EMP-EXER-COST Signed 13.2
Element: Emp Exer Cost
BXR-EMP-FR-MKT-VAL Signed 9.4
Element: Emp Fr Mkt Val
BXR-EMP-STOCK-FEES Signed 13.2
Element: Emp Stock Fees
BXR-BASE-CURRENCY Alpha 5
To Company Base
Currency
BXR-BASE-ND Numeric 1
Account Currency
Code
BXR-EMP-CURRENCY Alpha 5
Element: Emp Currency
BXR-EMP-ND Numeric 1
Element: Emp Nd
BXR-EXER-TYPE Alpha 1
Element: 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
|
