|
|
BNSTKGNT FILE
REFERENCED BY
BN223 BN234 BN33.1 BN33.2 BN33.3 BN33.4
BN533 BN534 HR170 HR70.1 BN07.1
UPDATED BY
BN107 BN137 BN23.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSG-COMPANY Numeric 4 BN23.1
Element: Company Hr
BSG-OPT-GRANT-NBR Alpha 10 BN23.1
Element: Opt Grant Nbr
BSG-OPTION-TYPE Alpha 2 BN23.1
Element: Option Type 1 = Incentive Stock Option
2 = Non-Qualified
3 = Stock Appreciation Rights
BSG-STOCK-SYMBOL Alpha 6 BN23.1
Element: Stock Symbol
BSG-GROUP-NAME Alpha 10 BN23.1
Element: Group Name
BSG-SHARES-AVAIL Numeric 12 BN107 BN23.1
Element: Shares Avail
BSG-GRANT-DATE Numeric 8 (yyyymmdd) BN23.1
Element: Grant Date
BSG-GRANT-PRICE Signed 9.4 BN107 BN23.1
Element: Grant Price
BSG-EXP-DATE Numeric 8 (yyyymmdd) BN23.1
Element: Exp Date
BSG-VEST-SCHED Alpha 2 BN23.1
Element: Vest Sched
BSG-OPT-VEST-FROM Alpha 2 BN23.1
Element: Opt Vest From 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
BSG-VEST-FROM Numeric 8 (yyyymmdd) BN23.1
Element: Vest From
BSG-VEST-AS-OF-DT Numeric 8 (yyyymmdd) BN23.1
Element: Vest As Of Dt
BSG-ACTIVE-FLAG Alpha 1 BN23.1
Element: Active Flag The Active flag of the credit card
type.
A = Active
I = Inactive
BSG-VEST-TYPE Alpha 1 BN23.1
Element: Vest Type 1 = Annual
2 = Semi-Annual
3 = Quarterly
4 = Monthly
5 = Daily
BSG-FORFEIT-FLAG Alpha 1 BN23.1
Element: Forfeit Flag N = No
Y = Yes
BSG-WEB-AVAILABLE Alpha 1 BN23.1
Element: Web Available N = No
Y = Yes
BSG-WEB-AVAIL-SUPV Alpha 1 BN23.1
Element: Web Avail Supv1 = Not Available
2 = Direct Supervisor
3 = Indirect Supervisor
4 = Direct;Indirect Supervisor
" " = Not applicable
BSG-WORKFLOW-FLAG Alpha 1 BN23.1
Element: Workflow Flag This field determines whether you are
using a Workflow system for approving
journal entries.
N = No
Y = Yes
BSG-DATE-STAMP Numeric 8 (yyyymmdd) BN107 BN23.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
BSG-TIME-STAMP Numeric 6 (hhmmss) BN107 BN23.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BSG-USER-ID Alpha 10 (Lower Case) BN107 BN23.1
Element: User
BSG-CURRENCY-CODE Alpha 5 BN23.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BSG-CURR-ND Numeric 1 BN23.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
BSG-BASE-GNT-PRICE Signed 9.4 BN107 BN23.1
Element: Base Gnt Price
BSG-EXPIRED-FLAG Alpha 1 BN23.1
Element: Expired Flag N = No
Y = Yes
BSG-EXER-WORKFLOW Alpha 1 BN23.1
Element: Exer Workflow N = No
Y = Yes
BSG-BASE-CURRENCY Alpha 5
Element: Base Currency The company base currency.
BSG-BASE-ND Numeric 1
Element: Base Nd The number of decimal positions defined
for the company base currency.
BSG-VEST-TERM Alpha 1 BN23.1
Element: Vest Term N = No
Y = Yes
BSG-FAIR-MKT-VAL Signed 9.4 BN107 BN23.1
Element: Fair Mkt Val
BSG-BASE-FR-MKT-VL Signed 9.4 BN107 BN23.1
Element: Base Fr Mkt Vl
BSG-MKT-VAL-DATE Numeric 8 (yyyymmdd) BN23.1
Element: Mkt Val Date
BNSTKGNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSGSET1 COMPANY BN137 BN223
OPT-GRANT-NBR BN23.1 BN234
BN33.1 BN33.2
BN33.3 BN33.4
BN533 BN534
HR00.1 HR01.1
HR170 HR70.1
BSGSET2 STOCK-SYMBOL KeyChange BN07.1 BN107
COMPANY
OPT-GRANT-NBR
BNSTKGNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
