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.

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

IndexKeysFlagsConditionUsed in
BSGSET1COMPANY, OPT-GRANT-NBRPrimaryBN137, BN223, BN23.1, BN234, BN33.1, BN33.2, BN33.3, BN33.4 +6 more
BSGSET2STOCK-SYMBOL, COMPANY, OPT-GRANT-NBRKeyChangeBN07.1, BN107

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredBSG-BASE-CURRENCY → CUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredBSG-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredBSG-CURRENCY-CODE → CUC-CURRENCY-CODE
StockBNSTOCKRequiredBSG-STOCK-SYMBOL → BSK-STOCK-SYMBOL
VestingVESTSCHDHDRequiredWhen BSG-VEST-SCHED != SpacesBSG-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 GrantBNEMPGRNTBSG-COMPANY → BEG-COMPANY, BSG-OPT-GRANT-NBR → BEG-OPT-GRANT-NBR, → BEG-EMPLOYEE, → BEG-STOCK-CTF

Programs

Updated by (5)

Referenced by (11)