BNSTKGNT FILE
UPDATED BY
HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSG-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
BSG-OPT-GRANT-NBR Alpha 10
Opt Grant Nbr
BSG-OPTION-TYPE Alpha 2
Option Type 1 = Incentive Stock Option
2 = Non-Qualified
3 = Stock Appreciation Rights
BSG-STOCK-SYMBOL Alpha 6
Stock Symbol
BSG-GROUP-NAME Alpha 10
Group Name
BSG-MULTIPLE-EMPS Alpha 1
Multiple Emps 1 = No
2 = Yes
BSG-SHARES-AVAIL Numeric 12
Shares Avail
BSG-GRANT-DATE Numeric 8 (yyyymmdd)
Grant Date
BSG-GRANT-PRICE Signed 9.4
Grant Price
BSG-EXP-DATE Numeric 8 (yyyymmdd)
Expiration Date
BSG-VEST-SCHED Alpha 2
Schedule
BSG-OPT-VEST-FROM Alpha 2
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)
Vest From
BSG-VEST-TO Alpha 2
Vest To
BSG-VEST-AS-OF-DT Numeric 8 (yyyymmdd)
Vest As Of Dt
BSG-TOT-GRANTS Numeric 12
Tot Grants
BSG-TOT-EXER Numeric 12
Tot Exer
BSG-TOT-EXPIRED Numeric 12
Tot Expired
BSG-TOT-FORFEIT Numeric 12
Tot Forfeit
BSG-TOT-AVAIL Numeric 12
Tot Avail
BSG-VESTING-UPDATE Alpha 1
Vesting Update 1 = Not Updated
2 = Updated
BSG-STK-SPLIT-UPD Alpha 1
Stk Split Upd 1 = Not Updated
2 = Updated
BSG-ACTIVE-FLAG Alpha 1
Status The Active flag of the credit card
type.
A = Active
I = Inactive
BSG-VEST-TYPE Alpha 1
Vest Type 1 = Annual
2 = Semi-Annual
3 = Quarterly
4 = Monthly
5 = Daily
BSG-FORFEIT-FLAG Alpha 1
Forfeit Flag N = No
Y = Yes
BSG-WEB-AVAILABLE Alpha 1
Web Available N = No
Y = Yes
BSG-WEB-AVAIL-SUPV Alpha 1
Web Avail Supv 1 = Not Available
2 = Direct Supervisor
3 = Indirect Supervisor
4 = Direct;Indirect Supervisor
" " = Not applicable
BSG-WORKFLOW-FLAG Alpha 1
Workflow This field determines whether you are
using a Workflow system for approving
journal entries.
N = No
Y = Yes
BSG-DATE-STAMP Numeric 8 (yyyymmdd)
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)
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BSG-USER-ID Alpha 10 (Lower Case)
User ID Name Contains the user ID of the person who
last changed this record.
BSG-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BSG-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
BSG-BASE-GNT-PRICE Signed 9.4
Base Gnt Price
BSG-EXPIRED-FLAG Alpha 1
Expired Flag N = No
Y = Yes
BSG-EXER-WORKFLOW Alpha 1
Exer Workflow N = No
Y = Yes
BSG-EST-TAX-PCT Signed 5.2
Est Tax Pct
BSG-BASE-CURRENCY Alpha 5
Base Currency The company base currency.
BSG-BASE-ND Numeric 1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
BSG-VEST-TERM Alpha 1
Vest Term N = No
Y = Yes
BSG-FAIR-MKT-VAL Signed 9.4
Fair Mkt Val
BSG-BASE-FR-MKT-VL Signed 9.4
Base Fr Mkt Vl
BSG-MKT-VAL-DATE Numeric 8 (yyyymmdd)
Mkt Val Date
BNSTKGNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSGSET1 COMPANY HR00.1 HR01.1
OPT-GRANT-NBR PBIP.1 PR197
BSGSET2 STOCK-SYMBOL KeyChange
COMPANY
OPT-GRANT-NBR
BSGSET3 COMPANY KeyChange
EXP-DATE
OPT-GRANT-NBR
BSGSET4 COMPANY KeyChange, Subset
VESTING-UPDATEWhere VESTING-UPDATE = "1"
OPT-GRANT-NBR
BSGSET5 COMPANY KeyChange, Subset
STK-SPLIT-UPD Where STK-SPLIT-UPD = "1"
OPT-GRANT-NBR
BSGSET6 COMPANY Subset
OPT-GRANT-NBR Where ACTIVE-FLAG = "A"
BNSTKGNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Not Required
BSG-BASE-CURRENCY -> CUC-CURRENCY-CODE (CUCSET1)
Company PRSYSTEM Required
BSG-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Not 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
BSG-COMPANY -> BXR-COMPANY
BSG-OPT-GRANT-NBR -> BXR-OPT-GRANT-NBR
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
|
