BNSTKGNT – No description in the Lawson data dictionary

System
Benefits (BN)
Prefix
BSG
Primary key
COMPANY, OPT-GRANT-NBR
Fields
33
Updated by
5 programs
Referenced by
11 programs

BNSTKGNT is a Lawson Benefits table (prefix BSG); no description in the lawson data dictionary. It is indexed by COMPANY, OPT-GRANT-NBR (BSGSET1); alternate indexes: BSGSET2. It is related 1:1 to CUCODES, PRSYSTEM, BNSTOCK and VESTSCHDHD and 1:M to BNEMPEXER and BNEMPGRNT. It is updated by BN107, BN137, BN23.1, HR00.1 and HR01.1 and referenced by BN07.1, BN223, BN234, BN33.1, BN33.2, BN33.3, BN33.4, BN533 and 3 more. The table has 33 fields, 2 indexes and 7 documented relations.

About BNSTKGNT

No description in the Lawson data dictionary.

Fields (33)

Column = COBOL field name without the BSG- 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
#BSG-COMPANY PK
COMPANY		Numeric 4—BN23.1
#BSG-OPT-GRANT-NBR PK
OPT_GRANT_NBR		Alpha 10—BN23.1
#BSG-OPTION-TYPE
OPTION_TYPE		Alpha 2—
  • 1 Incentive Stock Option
  • 2 Non-Qualified
  • 3 Stock Appreciation Rights
BN23.1
#BSG-STOCK-SYMBOL SET2
STOCK_SYMBOL		Alpha 6—BN23.1
#BSG-GROUP-NAME
GROUP_NAME		Alpha 10—BN23.1
#BSG-SHARES-AVAIL
SHARES_AVAIL		Numeric 12—BN107, BN23.1
#BSG-GRANT-DATE
GRANT_DATE		Numeric 8 (yyyymmdd)—BN23.1
#BSG-GRANT-PRICE
GRANT_PRICE		Signed 9.4—BN107, BN23.1
#BSG-EXP-DATE
EXP_DATE		Numeric 8 (yyyymmdd)—BN23.1
#BSG-VEST-SCHED
VEST_SCHED		Alpha 2—BN23.1
#BSG-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
BN23.1
#BSG-VEST-FROM
VEST_FROM		Numeric 8 (yyyymmdd)—BN23.1
#BSG-VEST-AS-OF-DT
VEST_AS_OF_DT		Numeric 8 (yyyymmdd)—BN23.1
#BSG-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
BN23.1
#BSG-VEST-TYPE
VEST_TYPE		Alpha 1—
  • 1 Annual
  • 2 Semi-Annual
  • 3 Quarterly
  • 4 Monthly
  • 5 Daily
BN23.1
#BSG-FORFEIT-FLAG
FORFEIT_FLAG		Alpha 1—
  • N No
  • Y Yes
BN23.1
#BSG-WEB-AVAILABLE
WEB_AVAILABLE		Alpha 1—
  • N No
  • Y Yes
BN23.1
#BSG-WEB-AVAIL-SUPV
WEB_AVAIL_SUPV		Alpha 1" " = Not applicable
  • 1 Not Available
  • 2 Direct Supervisor
  • 3 Indirect Supervisor
  • 4 Direct;Indirect Supervisor
BN23.1
#BSG-WORKFLOW-FLAG
WORKFLOW_FLAG		Alpha 1This field determines whether you are using a Workflow system for approving journal entries.
  • N No
  • Y Yes
BN23.1
#BSG-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, BN23.1
#BSG-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN107, BN23.1
#BSG-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN107, BN23.1
#BSG-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN23.1
#BSG-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN23.1
#BSG-BASE-GNT-PRICE
BASE_GNT_PRICE		Signed 9.4—BN107, BN23.1
#BSG-EXPIRED-FLAG
EXPIRED_FLAG		Alpha 1—
  • N No
  • Y Yes
BN23.1
#BSG-EXER-WORKFLOW
EXER_WORKFLOW		Alpha 1—
  • N No
  • Y Yes
BN23.1
#BSG-BASE-CURRENCY
BASE_CURRENCY		Alpha 5The company base currency.—
#BSG-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.—
#BSG-VEST-TERM
VEST_TERM		Alpha 1—
  • N No
  • Y Yes
BN23.1
#BSG-FAIR-MKT-VAL
FAIR_MKT_VAL		Signed 9.4—BN107, BN23.1
#BSG-BASE-FR-MKT-VL
BASE_FR_MKT_VL		Signed 9.4—BN107, BN23.1
#BSG-MKT-VAL-DATE
MKT_VAL_DATE		Numeric 8 (yyyymmdd)—BN23.1

Indexes (2)

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
BSGSET1
  1. COMPANY
  2. OPT-GRANT-NBR
PrimaryBN137, BN223, BN23.1, BN234, BN33.1, BN33.2, BN33.3, BN33.4 +6 more
BSGSET2
  1. STOCK-SYMBOL
  2. COMPANY
  3. OPT-GRANT-NBR
KeyChangeBN07.1, BN107

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequired
BSG-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
BSG-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequired
BSG-CURRENCY-CODE→CUC-CURRENCY-CODE
StockBNSTOCKRequired
BSG-STOCK-SYMBOL→BSK-STOCK-SYMBOL
VestingVESTSCHDHDRequiredWhen BSG-VEST-SCHED != Spaces
BSG-COMPANY→VSH-COMPANY
BSG-VEST-SCHED→VSH-VEST-SCHED

One to many (2) — child tables

RelationTableRulesConditionField map
Emp ExerBNEMPEXERValid When BXR- = BSG-
BSG-COMPANY→BXR-COMPANY
BSG-OPT-GRANT-NBR→BXR-OPT-GRANT-NBR
—→BXR-STOCK-CTF
—→BXR-EXERCISE-DATE
—→BXR-EMPLOYEE
—→BXR-SEQ-NBR
Emp GrantBNEMPGRNT
BSG-COMPANY→BEG-COMPANY
BSG-OPT-GRANT-NBR→BEG-OPT-GRANT-NBR
—→BEG-EMPLOYEE
—→BEG-STOCK-CTF

Programs

Updated by (5)

Referenced by (11)