|
|
BNEMPEXER FILE
REFERENCED BY
BN223 BN234 BN33.1 BN33.2 BN33.3 BN33.4
BN533 HR170 HR70.1 BN01.2
UPDATED BY
BN107 BN137 BN534 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BXR-COMPANY Numeric 4 BN534
Element: Company Hr
BXR-EMPLOYEE Numeric 9 BN534
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 BN534
Element: Opt Grant Nbr
BXR-EXERCISE-DATE Numeric 8 (yyyymmdd) BN534
Element: Exercise Date
BXR-SEQ-NBR Numeric 4 BN534
Element: Seq Nbr An automatically assigned sequence
number.
BXR-SHARES-EXE Numeric 9 BN107 BN534
Element: Shares Exe
BXR-EXERCISE-PRICE Signed 9.4 BN107 BN534
Element: Exercise Price
BXR-PENDING Alpha 1 BN534
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 BN534
Element: Tax Wage Upd
BXR-EMP-TAX-AMT Signed 13.2 BN534
Element: Emp Tax Amt
BXR-FORFEIT-SHARES Numeric 9 BN107 BN534
Element: Forfeit Shares
BXR-BROKER Alpha 4 BN534
Element: Broker
BXR-EXERCISE-COST Signed 13.2
Element: Exercise Cost
BXR-DATE-STAMP Numeric 8 (yyyymmdd) BN107 BN534
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) BN107 BN534
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BXR-USER-ID Alpha 10 (Lower Case) BN107 BN534
Element: User
BXR-APPROVAL-FLAG Alpha 1
Element: Approval Flag N = No
Y = Yes
BXR-PAYROLL-UPDATE Alpha 1
Element: Payroll UpdateN = No
Y = Yes
BXR-FAIR-MKT-VAL Signed 9.4 BN107 BN534
Element: Fair Mkt Val
BXR-MKT-VAL-DATE Numeric 8 (yyyymmdd) BN534
Element: Mkt Val Date
BXR-CURRENCY-CODE Alpha 5 BN534
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BXR-CURR-ND Numeric 1 BN534
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
BXR-STOCK-FEES Signed 13.2 BN534
Element: Stock Fees
BXR-BASE-EXER-PRIC Signed 9.4 BN107 BN534
Element: Base Exer Pric
BXR-BASE-TRANS-VAL Signed 13.2 BN534
Element: Base Trans Val
BXR-BASE-GAIN-LOST Signed 13.2 BN534
Element: Base Gain Lost
BXR-BASE-TAX-WAGE Signed 13.2 BN534
Element: Base Tax Wage
BXR-BASE-EMP-TAX Signed 13.2 BN534
Element: Base Emp Tax
BXR-BASE-EXER-COST Signed 13.2 BN534
Element: Base Exer Cost
BXR-BASE-FR-MKT-VL Signed 9.4 BN107 BN534
Element: Base Fr Mkt Vl
BXR-BASE-STOCK-FEE Signed 13.2 BN534
Element: Base Stock Fee
BXR-EMP-EXER-PRICE Signed 9.4 BN107 BN534
Element: Emp Exer Price
BXR-EMP-TRANS-VAL Signed 13.2 BN534
Element: Emp Trans Val
BXR-EMP-GAIN-LOST Signed 13.2 BN534
Element: Emp Gain Lost
BXR-EMP-TAX-WAGE Signed 13.2 BN534
Element: Emp Tax Wage
BXR-EMP-EMP-TAX Signed 13.2 BN534
Element: Emp Emp Tax
BXR-EMP-EXER-COST Signed 13.2 BN534
Element: Emp Exer Cost
BXR-EMP-FR-MKT-VAL Signed 9.4 BN107 BN534
Element: Emp Fr Mkt Val
BXR-EMP-STOCK-FEES Signed 13.2 BN534
Element: Emp Stock Fees
BXR-BASE-CURRENCY Alpha 5 BN534
Element: Base Currency The company base currency.
BXR-BASE-ND Numeric 1 BN534
Element: Base Nd The number of decimal positions defined
for the company base currency.
BXR-EMP-CURRENCY Alpha 5 BN534
Element: Emp Currency
BXR-EMP-ND Numeric 1 BN534
Element: Emp Nd
BXR-EXER-TYPE Alpha 1 BN534
Element: Exer Type 1 = Exercise and Sell
2 = Exercise and Hold
3 = Sell to Cover Exercise
4 = Stock Swap
5 = Forfeit
BXR-STOCK-CTF Alpha 10 BN534
Element: Stock Ctf
BNEMPEXER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BXRSET1 COMPANY BN137 BN223
EMPLOYEE BN234 BN33.1
OPT-GRANT-NBR BN33.2 BN33.3
STOCK-CTF BN533 BN534
EXERCISE-DATE HR11.1 HR170
SEQ-NBR HR70.1 PA115
BXRSET2 COMPANY KeyChange BN33.4
EMPLOYEE
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE*
SEQ-NBR
BXRSET3 BROKER KeyChange BN01.2
COMPANY
EMPLOYEE
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE
SEQ-NBR
BXRSET4 COMPANY BN107
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE
EMPLOYEE
SEQ-NBR
BXRSET5 COMPANY KeyChange, Subset BN234
EMPLOYEE Where (PENDING = "1" )
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE
SEQ-NBR
BNEMPEXER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
BXR-BASE-CURRENCY -> CUC-CURRENCY-CODE
Bnempgrnt BNEMPGRNT Required
BXR-COMPANY -> BEG-COMPANY
BXR-EMPLOYEE -> BEG-EMPLOYEE
BXR-OPT-GRANT-NBR -> BEG-OPT-GRANT-NBR
BXR-STOCK-CTF -> BEG-STOCK-CTF
Broker BNBROKER Required
When (BXR-BROKER != Spaces )
BXR-BROKER -> BRK-BROKER
Company PRSYSTEM Required
BXR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
BXR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Emp Currency CUCODES 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
|
