BNSTKGNT

REFERENCED BY
BN533 BN534 HR170 HR70.1 BN223


UPDATED BY
BN07.1 BN107 BN137 BN23.1 BN234 BN33.1
HR00.1 HR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSG-COMPANY
Element: Company Hr
Numeric 4
BN23.1
BSG-OPT-GRANT-NBR
Element: Opt Grant Nbr
Alpha 10
BN23.1
BSG-OPTION-TYPE
Element: Option Type
Alpha 2

1 = Incentive Stock Option
2 = Non-Qualified
3 = Stock Appreciation Rights
BN23.1
BSG-STOCK-SYMBOL
Element: Stock Symbol
Alpha 6
BN23.1
BSG-GROUP-NAME
Element: Group Name
Alpha 10
BN23.1
BSG-SHARES-AVAIL
Element: Shares Avail
Numeric 12
BN107 BN23.1
BSG-GRANT-DATE
Element: Grant Date
Numeric 8 (yyyymmdd)
BN23.1
BSG-GRANT-PRICE
Element: Grant Price
Signed 9.4
BN107 BN23.1
BSG-EXP-DATE
Element: Exp Date
Numeric 8 (yyyymmdd)
BN23.1
BSG-VEST-SCHED
Element: Vest Sched
Alpha 2
BN23.1
BSG-OPT-VEST-FROM
Element: 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
Element: Vest From
Numeric 8 (yyyymmdd)
BN23.1
BSG-VEST-AS-OF-DT
Element: Vest As Of Dt
Numeric 8 (yyyymmdd)
BN23.1
BSG-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
BN23.1
BSG-VEST-TYPE
Element: Vest Type
Alpha 1

1 = Annual
2 = Semi-Annual
3 = Quarterly
4 = Monthly
5 = Daily
BN23.1
BSG-FORFEIT-FLAG
Element: Forfeit Flag
Alpha 1

N = No
Y = Yes
BN23.1
BSG-WEB-AVAILABLE
Element: Web Available
Alpha 1

N = No
Y = Yes
BN23.1
BSG-WEB-AVAIL-SUPV
Element: Web Avail Supv
Alpha 1

1 = Not Available
2 = Direct Supervisor
3 = Indirect Supervisor
4 = Direct;Indirect Supervisor
" " = Not applicable
BN23.1
BSG-WORKFLOW-FLAG
Element: Workflow Flag
Alpha 1
This field determines whether you are using a Workflow system for approving journal entries.
N = No
Y = Yes
BN23.1
BSG-DATE-STAMP
Element: 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
Element: 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
Element: User
Alpha 10 (Lower Case)
BN107 BN23.1
BSG-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN23.1
BSG-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN23.1
BSG-BASE-GNT-PRICE
Element: Base Gnt Price
Signed 9.4
BN107 BN23.1
BSG-EXPIRED-FLAG
Element: Expired Flag
Alpha 1

N = No
Y = Yes
BN23.1
BSG-EXER-WORKFLOW
Element: Exer Workflow
Alpha 1

N = No
Y = Yes
BN23.1
BSG-BASE-CURRENCY
Element: Base Currency
Alpha 5
The company base currency.
BSG-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
BSG-VEST-TERM
Element: Vest Term
Alpha 1

N = No
Y = Yes
BN23.1
BSG-FAIR-MKT-VAL
Element: Fair Mkt Val
Signed 9.4
BN107 BN23.1
BSG-BASE-FR-MKT-VL
Element: Base Fr Mkt Vl
Signed 9.4
BN107 BN23.1
BSG-MKT-VAL-DATE
Element: Mkt Val Date
Numeric 8 (yyyymmdd)
BN23.1


BNSTKGNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSGSET1 COMPANY
OPT-GRANT-NBR
BN137 BN223
BN23.1 BN234
BN33.1 BN33.2
BN33.3 BN33.4
BN533 BN534
HR00.1 HR01.1
HR170 HR70.1
BSGSET2 STOCK-SYMBOL
COMPANY
OPT-GRANT-NBR
KeyChange
BN07.1 BN107


BNSTKGNT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
BSG-BASE-CURRENCY->CUC-CURRENCY-CODE
Company PRSYSTEM Required
BSG-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
BSG-CURRENCY-CODE->CUC-CURRENCY-CODE
Stock BNSTOCK Required
BSG-STOCK-SYMBOL->BSK-STOCK-SYMBOL
Vesting VESTSCHDHD Required
When BSG-VEST-SCHED !=Spaces
BSG-COMPANY->VSH-COMPANY
BSG-VEST-SCHED->VSH-VEST-SCHED


BNSTKGNT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Emp Exer BNEMPEXER
Valid 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 Grant BNEMPGRNT
BSG-COMPANY->BEG-COMPANY
BSG-OPT-GRANT-NBR->BEG-OPT-GRANT-NBR
  BEG-EMPLOYEE
  BEG-STOCK-CTF


File created: Thu Jun 09 11:10:01 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.