BNEMPEXER

UPDATED BY
BN107 BN137 BN534 BN223 BN234 BN33.1
BN33.2 BN33.3 BN33.4 BN533 HR11.1 HR170
HR70.1 PA115 BN01.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BXR-COMPANY
Element: Company Hr
Numeric 4
BN534
BXR-EMPLOYEE
Element: Employee
Numeric 9
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.
BN534
BXR-OPT-GRANT-NBR
Element: Opt Grant Nbr
Alpha 10
BN534
BXR-EXERCISE-DATE
Element: Exercise Date
Numeric 8 (yyyymmdd)
BN534
BXR-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
BN534
BXR-SHARES-EXE
Element: Shares Exe
Numeric 9
BN107 BN534
BXR-EXERCISE-PRICE
Element: Exercise Price
Signed 9.4
BN107 BN534
BXR-PENDING
Element: Pending
Alpha 1

1 = Pending
2 = Completed
BN534
BXR-TRANSAC-VALUE
Element: Transac Value
Signed 13.2
BXR-GAIN-LOST-VAL
Element: Gain Lost Val
Signed 13.2
BXR-TAX-WAGE-UPD
Element: Tax Wage Upd
Signed 13.2
BN534
BXR-EMP-TAX-AMT
Element: Emp Tax Amt
Signed 13.2
BN534
BXR-FORFEIT-SHARES
Element: Forfeit Shares
Numeric 9
BN107 BN534
BXR-BROKER
Element: Broker
Alpha 4
BN534
BXR-EXERCISE-COST
Element: Exercise Cost
Signed 13.2
BXR-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN107 BN534
BXR-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN107 BN534
BXR-USER-ID
Element: User
Alpha 10 (Lower Case)
BN107 BN534
BXR-APPROVAL-FLAG
Element: Approval Flag
Alpha 1

N = No
Y = Yes
BXR-PAYROLL-UPDATE
Element: Payroll Update
Alpha 1

N = No
Y = Yes
BXR-FAIR-MKT-VAL
Element: Fair Mkt Val
Signed 9.4
BN107 BN534
BXR-MKT-VAL-DATE
Element: Mkt Val Date
Numeric 8 (yyyymmdd)
BN534
BXR-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN534
BXR-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN534
BXR-STOCK-FEES
Element: Stock Fees
Signed 13.2
BN534
BXR-BASE-EXER-PRIC
Element: Base Exer Pric
Signed 9.4
BN107 BN534
BXR-BASE-TRANS-VAL
Element: Base Trans Val
Signed 13.2
BN534
BXR-BASE-GAIN-LOST
Element: Base Gain Lost
Signed 13.2
BN534
BXR-BASE-TAX-WAGE
Element: Base Tax Wage
Signed 13.2
BN534
BXR-BASE-EMP-TAX
Element: Base Emp Tax
Signed 13.2
BN534
BXR-BASE-EXER-COST
Element: Base Exer Cost
Signed 13.2
BN534
BXR-BASE-FR-MKT-VL
Element: Base Fr Mkt Vl
Signed 9.4
BN107 BN534
BXR-BASE-STOCK-FEE
Element: Base Stock Fee
Signed 13.2
BN534
BXR-EMP-EXER-PRICE
Element: Emp Exer Price
Signed 9.4
BN107 BN534
BXR-EMP-TRANS-VAL
Element: Emp Trans Val
Signed 13.2
BN534
BXR-EMP-GAIN-LOST
Element: Emp Gain Lost
Signed 13.2
BN534
BXR-EMP-TAX-WAGE
Element: Emp Tax Wage
Signed 13.2
BN534
BXR-EMP-EMP-TAX
Element: Emp Emp Tax
Signed 13.2
BN534
BXR-EMP-EXER-COST
Element: Emp Exer Cost
Signed 13.2
BN534
BXR-EMP-FR-MKT-VAL
Element: Emp Fr Mkt Val
Signed 9.4
BN107 BN534
BXR-EMP-STOCK-FEES
Element: Emp Stock Fees
Signed 13.2
BN534
BXR-BASE-CURRENCY
Element: Base Currency
Alpha 5
The company base currency.
BN534
BXR-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
BN534
BXR-EMP-CURRENCY
Element: Emp Currency
Alpha 5
BN534
BXR-EMP-ND
Element: Emp Nd
Numeric 1
BN534
BXR-EXER-TYPE
Element: Exer Type
Alpha 1

1 = Exercise and Sell
2 = Exercise and Hold
3 = Sell to Cover Exercise
4 = Stock Swap
5 = Forfeit
BN534
BXR-STOCK-CTF
Element: Stock Ctf
Alpha 10
BN534


BNEMPEXER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BXRSET1 COMPANY
EMPLOYEE
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE
SEQ-NBR
BN137 BN223
BN234 BN33.1
BN33.2 BN33.3
BN533 BN534
HR11.1 HR170
HR70.1 PA115
BXRSET2 COMPANY
EMPLOYEE
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE*
SEQ-NBR
KeyChange
BN33.4
BXRSET3 BROKER
COMPANY
EMPLOYEE
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE
SEQ-NBR
KeyChange
BN01.2
BXRSET4 COMPANY
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE
EMPLOYEE
SEQ-NBR
BN107
BXRSET5 COMPANY
EMPLOYEE
OPT-GRANT-NBR
STOCK-CTF
EXERCISE-DATE
SEQ-NBR
KeyChange, Subset
Where(PENDING ="1")
BN234


BNEMPEXER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:48:05 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.