BNEMPEXER – Emp Stock Option Transactions

System
Benefits (BN)
Prefix
BXR
Primary key
COMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF, EXERCISE-DATE, SEQ-NBR
Fields
47
Updated by
5 programs
Referenced by
10 programs

BNEMPEXER is the Emp Stock Option Transactions table in Lawson Benefits (prefix BXR). It is indexed by COMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF, EXERCISE-DATE, SEQ-NBR (BXRSET1); alternate indexes: BXRSET2, BXRSET3, BXRSET4 and BXRSET5. It is related 1:1 to CUCODES, BNEMPGRNT, BNBROKER, PRSYSTEM, EMPLOYEE and BNSTKGNT. It is updated by BN107, BN137, BN534, HR11.1 and PA115 and referenced by BN01.2, BN223, BN234, BN33.1, BN33.2, BN33.3, BN33.4, BN533 and 2 more. The table has 47 fields, 5 indexes and 8 documented relations.

About BNEMPEXER

No description in the Lawson data dictionary.

Fields (47)

Column = COBOL field name without the BXR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BXR-COMPANY PK
COMPANY		Numeric 4—BN534
#BXR-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 PK
OPT_GRANT_NBR		Alpha 10—BN534
#BXR-EXERCISE-DATE PK
EXERCISE_DATE		Numeric 8 (yyyymmdd)—BN534
#BXR-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.BN534
#BXR-SHARES-EXE
SHARES_EXE		Numeric 9—BN107, BN534
#BXR-EXERCISE-PRICE
EXERCISE_PRICE		Signed 9.4—BN107, BN534
#BXR-PENDING
PENDING		Alpha 1—
  • 1 Pending
  • 2 Completed
BN534
#BXR-TRANSAC-VALUE
TRANSAC_VALUE		Signed 13.2——
#BXR-GAIN-LOST-VAL
GAIN_LOST_VAL		Signed 13.2——
#BXR-TAX-WAGE-UPD
TAX_WAGE_UPD		Signed 13.2—BN534
#BXR-EMP-TAX-AMT
EMP_TAX_AMT		Signed 13.2—BN534
#BXR-FORFEIT-SHARES
FORFEIT_SHARES		Numeric 9—BN107, BN534
#BXR-BROKER SET3
BROKER		Alpha 4—BN534
#BXR-EXERCISE-COST
EXERCISE_COST		Signed 13.2——
#BXR-DATE-STAMP
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
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN107, BN534
#BXR-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN107, BN534
#BXR-APPROVAL-FLAG
APPROVAL_FLAG		Alpha 1—
  • N No
  • Y Yes
—
#BXR-PAYROLL-UPDATE
PAYROLL_UPDATE		Alpha 1—
  • N No
  • Y Yes
—
#BXR-FAIR-MKT-VAL
FAIR_MKT_VAL		Signed 9.4—BN107, BN534
#BXR-MKT-VAL-DATE
MKT_VAL_DATE		Numeric 8 (yyyymmdd)—BN534
#BXR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN534
#BXR-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN534
#BXR-STOCK-FEES
STOCK_FEES		Signed 13.2—BN534
#BXR-BASE-EXER-PRIC
BASE_EXER_PRIC		Signed 9.4—BN107, BN534
#BXR-BASE-TRANS-VAL
BASE_TRANS_VAL		Signed 13.2—BN534
#BXR-BASE-GAIN-LOST
BASE_GAIN_LOST		Signed 13.2—BN534
#BXR-BASE-TAX-WAGE
BASE_TAX_WAGE		Signed 13.2—BN534
#BXR-BASE-EMP-TAX
BASE_EMP_TAX		Signed 13.2—BN534
#BXR-BASE-EXER-COST
BASE_EXER_COST		Signed 13.2—BN534
#BXR-BASE-FR-MKT-VL
BASE_FR_MKT_VL		Signed 9.4—BN107, BN534
#BXR-BASE-STOCK-FEE
BASE_STOCK_FEE		Signed 13.2—BN534
#BXR-EMP-EXER-PRICE
EMP_EXER_PRICE		Signed 9.4—BN107, BN534
#BXR-EMP-TRANS-VAL
EMP_TRANS_VAL		Signed 13.2—BN534
#BXR-EMP-GAIN-LOST
EMP_GAIN_LOST		Signed 13.2—BN534
#BXR-EMP-TAX-WAGE
EMP_TAX_WAGE		Signed 13.2—BN534
#BXR-EMP-EMP-TAX
EMP_EMP_TAX		Signed 13.2—BN534
#BXR-EMP-EXER-COST
EMP_EXER_COST		Signed 13.2—BN534
#BXR-EMP-FR-MKT-VAL
EMP_FR_MKT_VAL		Signed 9.4—BN107, BN534
#BXR-EMP-STOCK-FEES
EMP_STOCK_FEES		Signed 13.2—BN534
#BXR-BASE-CURRENCY
BASE_CURRENCY		Alpha 5The company base currency.BN534
#BXR-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.BN534
#BXR-EMP-CURRENCY
EMP_CURRENCY		Alpha 5—BN534
#BXR-EMP-ND
EMP_ND		Numeric 1—BN534
#BXR-EXER-TYPE
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 PK
STOCK_CTF		Alpha 10—BN534

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BXRSET1
  1. COMPANY
  2. EMPLOYEE
  3. OPT-GRANT-NBR
  4. STOCK-CTF
  5. EXERCISE-DATE
  6. SEQ-NBR
PrimaryBN137, BN223, BN234, BN33.1, BN33.2, BN33.3, BN533, BN534 +4 more
BXRSET2
  1. COMPANY
  2. EMPLOYEE
  3. OPT-GRANT-NBR
  4. STOCK-CTF
  5. EXERCISE-DATE ↓
  6. SEQ-NBR
KeyChangeBN33.4
BXRSET3
  1. BROKER
  2. COMPANY
  3. EMPLOYEE
  4. OPT-GRANT-NBR
  5. STOCK-CTF
  6. EXERCISE-DATE
  7. SEQ-NBR
KeyChangeBN01.2
BXRSET4
  1. COMPANY
  2. OPT-GRANT-NBR
  3. STOCK-CTF
  4. EXERCISE-DATE
  5. EMPLOYEE
  6. SEQ-NBR
BN107
BXRSET5
  1. COMPANY
  2. EMPLOYEE
  3. OPT-GRANT-NBR
  4. STOCK-CTF
  5. EXERCISE-DATE
  6. SEQ-NBR
KeyChange, SubsetWhere (PENDING = "1")BN234

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CUCODESBNEMPGRNTBNBROKERPRSYSTEMEMPLOYEEBNSTKGNTBNEMPEXER

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequired
BXR-BASE-CURRENCY→CUC-CURRENCY-CODE
BnempgrntBNEMPGRNTRequired
BXR-COMPANY→BEG-COMPANY
BXR-EMPLOYEE→BEG-EMPLOYEE
BXR-OPT-GRANT-NBR→BEG-OPT-GRANT-NBR
BXR-STOCK-CTF→BEG-STOCK-CTF
BrokerBNBROKERRequiredWhen (BXR-BROKER != Spaces)
BXR-BROKER→BRK-BROKER
CompanyPRSYSTEMRequired
BXR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequired
BXR-CURRENCY-CODE→CUC-CURRENCY-CODE
Emp CurrencyCUCODESRequired
BXR-EMP-CURRENCY→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequired
BXR-COMPANY→EMP-COMPANY
BXR-EMPLOYEE→EMP-EMPLOYEE
OptionBNSTKGNTRequired
BXR-COMPANY→BSG-COMPANY
BXR-OPT-GRANT-NBR→BSG-OPT-GRANT-NBR

Programs

Updated by (5)

Referenced by (10)