BNEMPGRNT – Emp Stock Option Grant

System
Benefits (BN)
Prefix
BEG
Primary key
COMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF
Fields
31
Updated by
9 programs
Referenced by
33 programs

BNEMPGRNT is the Emp Stock Option Grant table in Lawson Benefits (prefix BEG). It is indexed by COMPANY, EMPLOYEE, OPT-GRANT-NBR, STOCK-CTF (BEGSET1); alternate indexes: BEGSET2 and BEGSET4. It is related 1:1 to CUCODES, BNSTKGNT, PRSYSTEM, DEPTCODE, EMPLOYEE, PAEMPLOYEE, HRSUPER and VESTSCHDHD and 1:M to BNEMPEXER. It is updated by BN107, BN137, BN234, BN33.1, BN33.2, BN33.3, BN533, HR11.1 and 1 more and referenced by BN223, BN23.1, BN305, BN534, HR170, HR28.1, HR511, HR70.1 and 25 more. The table has 31 fields, 3 indexes and 12 documented relations.

About BNEMPGRNT

No description in the Lawson data dictionary.

Fields (31)

Column = COBOL field name without the BEG- 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
#BEG-COMPANY PK
COMPANY		Numeric 4—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-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.BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-OPT-GRANT-NBR PK
OPT_GRANT_NBR		Alpha 10—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-GRANT-DATE
GRANT_DATE		Numeric 8 (yyyymmdd)—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-SHARES-GRANTED
SHARES_GRANTED		Numeric 9—BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-GRANT-PRICE
GRANT_PRICE		Signed 9.4—BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-EXP-DATE SET4
EXP_DATE		Numeric 8 (yyyymmdd)—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-VEST-SCHED
VEST_SCHED		Alpha 2—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-VEST-FROM
VEST_FROM		Numeric 8 (yyyymmdd)—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-OPT-VEST-FROM
OPT_VEST_FROM		Alpha 2—
  • 1 Grant Date
  • 2 Hire Date
  • 3 Adjusted Hire Date
  • 4 Anniversary Date
  • 5 Seniority Date
  • 6 BN Date 1
  • 7 BN Date 2
  • 8 BN Date 3
  • 9 BN Date 4
  • 10 BN Date 5
BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-OPTION-TYPE
OPTION_TYPE		Alpha 2—
  • 1 Incentive Stock Option
  • 2 Non-Qualified
  • 3 Stock Appreciation Rights
BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-VEST-AS-OF-DT
VEST_AS_OF_DT		Numeric 8 (yyyymmdd)—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-VESTING-UPDATE
VESTING_UPDATE		Alpha 1—
  • N No
  • Y Yes
BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-VEST-TYPE
VEST_TYPE		Alpha 1—
  • 1 Annual
  • 2 Semi-Annual
  • 3 Quarterly
  • 4 Monthly
  • 5 Daily
BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-APPROVAL-FLAG
APPROVAL_FLAG		Alpha 1—
  • N No
  • Y Yes
BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-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, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-BASE-GNT-PRICE
BASE_GNT_PRICE		Signed 9.4—BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-EMP-GRNT-PRICE
EMP_GRNT_PRICE		Signed 9.4—BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-BASE-CURRENCY
BASE_CURRENCY		Alpha 5The company base currency.BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-EMP-CURRENCY
EMP_CURRENCY		Alpha 5—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-EMP-ND
EMP_ND		Numeric 1—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-FAIR-MKT-VAL
FAIR_MKT_VAL		Signed 9.4—BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-BASE-FR-MKT-VL
BASE_FR_MKT_VL		Signed 9.4—BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-EMP-FR-MKT-VL
EMP_FR_MKT_VL		Signed 9.4—BN107, BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-MKT-VAL-DATE
MKT_VAL_DATE		Numeric 8 (yyyymmdd)—BN234, BN33.1, BN33.2, BN33.3, BN533
#BEG-STOCK-CTF PK
STOCK_CTF		Alpha 10—BN234, BN33.1, BN33.2, BN33.3, BN533

Indexes (3)

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
BEGSET1
  1. COMPANY
  2. EMPLOYEE
  3. OPT-GRANT-NBR
  4. STOCK-CTF
Primary, KeyChangeBN234, BN305, BN33.1, BN33.2, BN33.3, BN33.4, BN533, BN534 +22 more (list truncated in source)
BEGSET2
  1. COMPANY
  2. OPT-GRANT-NBR
  3. EMPLOYEE
  4. STOCK-CTF
KeyChangeBN107, BN137, BN223, BN23.1, BN234, BN33.1, BN33.2, BN33.3 +1 more
BEGSET4
  1. COMPANY
  2. OPT-GRANT-NBR
  3. EXP-DATE ↓
  4. EMPLOYEE
  5. STOCK-CTF
KeyChangeBN23.1

Relations

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

One to one (11) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequired
BEG-BASE-CURRENCY→CUC-CURRENCY-CODE
BnstkgntBNSTKGNTRequired
BEG-COMPANY→BSG-COMPANY
BEG-OPT-GRANT-NBR→BSG-OPT-GRANT-NBR
CompanyPRSYSTEMRequired
BEG-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequired
BEG-CURRENCY-CODE→CUC-CURRENCY-CODE
DepartmentDEPTCODENot Required
BEG-COMPANY→DPT-COMPANY
EMP-PROCESS-LEVEL→DPT-PROCESS-LEVEL
EMP-DEPARTMENT→DPT-DEPARTMENT
Emp CurrencyCUCODESRequired
BEG-EMP-CURRENCY→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequired
BEG-COMPANY→EMP-COMPANY
BEG-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
BEG-COMPANY→PEM-COMPANY
BEG-EMPLOYEE→PEM-EMPLOYEE
Process LevelPRSYSTEMNot Required
BEG-COMPANY→PRS-COMPANY
EMP-PROCESS-LEVEL→PRS-PROCESS-LEVEL
SupervisorHRSUPERNot Required
BEG-COMPANY→HSU-COMPANY
EMP-SUPERVISOR→HSU-CODE
Vest ScheduleVESTSCHDHDRequiredWhen BEG-VEST-SCHED != Spaces
BEG-COMPANY→VSH-COMPANY
BEG-VEST-SCHED→VSH-VEST-SCHED

One to many (1) — child tables

RelationTableRulesConditionField map
ExerciseBNEMPEXER
BEG-COMPANY→BXR-COMPANY
BEG-EMPLOYEE→BXR-EMPLOYEE
BEG-OPT-GRANT-NBR→BXR-OPT-GRANT-NBR
BEG-STOCK-CTF→BXR-STOCK-CTF
—→BXR-EXERCISE-DATE
—→BXR-SEQ-NBR

Programs

Updated by (9)

Referenced by (33)