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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BXRSET1COMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF, EXERCISE-DATE, SEQ-NBRPrimaryBN137, BN223, BN234, BN33.1, BN33.2, BN33.3, BN533, BN534 +4 more
BXRSET2COMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF, EXERCISE-DATE*, SEQ-NBRKeyChangeBN33.4
BXRSET3BROKER, COMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF, EXERCISE-DATE, SEQ-NBRKeyChangeBN01.2
BXRSET4COMPANY, OPT-GRANT-NBR, STOCK-CTF, EXERCISE-DATE, EMPLOYEE, SEQ-NBRBN107
BXRSET5COMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF, EXERCISE-DATE, SEQ-NBRKeyChange, SubsetWhere (PENDING = "1")BN234

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredBXR-BASE-CURRENCY → CUC-CURRENCY-CODE
BnempgrntBNEMPGRNTRequiredBXR-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
CompanyPRSYSTEMRequiredBXR-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredBXR-CURRENCY-CODE → CUC-CURRENCY-CODE
Emp CurrencyCUCODESRequiredBXR-EMP-CURRENCY → CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredBXR-COMPANY → EMP-COMPANY, BXR-EMPLOYEE → EMP-EMPLOYEE
OptionBNSTKGNTRequiredBXR-COMPANY → BSG-COMPANY, BXR-OPT-GRANT-NBR → BSG-OPT-GRANT-NBR

Programs

Updated by (5)

Referenced by (10)