BNEMPGRNT

Emp Stock Option Grant

REFERENCED BY
BN305 BN534 HR170 HR28.1 HR511 HR70.1
LT101 LT111 ZH510 PA02.1 PA100 PA102
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR110 PR113 PR12.6 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR30.2
PR512 BN223 BN23.1


UPDATED BY
BN107 BN137 BN234 BN33.1 BN33.2 BN33.3
BN533 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BEG-COMPANY
Element: Company Hr
Numeric 4
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-OPT-GRANT-NBR
Element: Opt Grant Nbr
Alpha 10
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-GRANT-DATE
Element: Grant Date
Numeric 8 (yyyymmdd)
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-SHARES-GRANTED
Element: Shares Granted
Numeric 9
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-GRANT-PRICE
Element: Grant Price
Signed 9.4
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-EXP-DATE
Element: Exp Date
Numeric 8 (yyyymmdd)
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-VEST-SCHED
Element: Vest Sched
Alpha 2
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-VEST-FROM
Element: Vest From
Numeric 8 (yyyymmdd)
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-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
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-OPTION-TYPE
Element: Option Type
Alpha 2

1 = Incentive Stock Option
2 = Non-Qualified
3 = Stock Appreciation Rights
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-VEST-AS-OF-DT
Element: Vest As Of Dt
Numeric 8 (yyyymmdd)
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-VESTING-UPDATE
Element: Vesting Update
Alpha 1

N = No
Y = Yes
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-VEST-TYPE
Element: Vest Type
Alpha 1

1 = Annual
2 = Semi-Annual
3 = Quarterly
4 = Monthly
5 = Daily
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-APPROVAL-FLAG
Element: Approval Flag
Alpha 1

N = No
Y = Yes
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-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 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-USER-ID
Element: User
Alpha 10 (Lower Case)
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-BASE-GNT-PRICE
Element: Base Gnt Price
Signed 9.4
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-EMP-GRNT-PRICE
Element: Emp Grnt Price
Signed 9.4
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-BASE-CURRENCY
Element: Base Currency
Alpha 5
The company base currency.
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-EMP-CURRENCY
Element: Emp Currency
Alpha 5
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-EMP-ND
Element: Emp Nd
Numeric 1
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-FAIR-MKT-VAL
Element: Fair Mkt Val
Signed 9.4
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-BASE-FR-MKT-VL
Element: Base Fr Mkt Vl
Signed 9.4
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-EMP-FR-MKT-VL
Element: Emp Fr Mkt Vl
Signed 9.4
BN107 BN234
BN33.1 BN33.2
BN33.3 BN533
BEG-MKT-VAL-DATE
Element: Mkt Val Date
Numeric 8 (yyyymmdd)
BN234 BN33.1
BN33.2 BN33.3
BN533
BEG-STOCK-CTF
Element: Stock Ctf
Alpha 10
BN234 BN33.1
BN33.2 BN33.3
BN533


BNEMPGRNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BEGSET1 COMPANY
EMPLOYEE
OPT-GRANT-NBR
STOCK-CTF
KeyChange
...
BN234 BN305
BN33.1 BN33.2
BN33.3 BN33.4
BN533 BN534
HR11.1 HR11.2
HR11.4 HR170
HR28.1 HR511
HR70.1 LT101
LT111 ZH510
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
BEGSET2 COMPANY
OPT-GRANT-NBR
EMPLOYEE
STOCK-CTF
KeyChange
BN107 BN137
BN223 BN23.1
BN234 BN33.1
BN33.2 BN33.3
BN533
BEGSET4 COMPANY
OPT-GRANT-NBR
EXP-DATE*
EMPLOYEE
STOCK-CTF
KeyChange
BN23.1


BNEMPGRNT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
BEG-BASE-CURRENCY->CUC-CURRENCY-CODE
Bnstkgnt BNSTKGNT Required
BEG-COMPANY->BSG-COMPANY
BEG-OPT-GRANT-NBR->BSG-OPT-GRANT-NBR
Company PRSYSTEM Required
BEG-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
BEG-CURRENCY-CODE->CUC-CURRENCY-CODE
Department DEPTCODE Not Required
BEG-COMPANY->DPT-COMPANY
EMP-PROCESS-LEVEL->DPT-PROCESS-LEVEL
EMP-DEPARTMENT->DPT-DEPARTMENT
Emp Currency CUCODES Required
BEG-EMP-CURRENCY->CUC-CURRENCY-CODE
Employee EMPLOYEE Required
BEG-COMPANY->EMP-COMPANY
BEG-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
BEG-COMPANY->PEM-COMPANY
BEG-EMPLOYEE->PEM-EMPLOYEE
Process Level PRSYSTEM Not Required
BEG-COMPANY->PRS-COMPANY
EMP-PROCESS-LEVEL->PRS-PROCESS-LEVEL
Supervisor HRSUPER Not Required
BEG-COMPANY->HSU-COMPANY
EMP-SUPERVISOR->HSU-CODE
Vest Schedule VESTSCHDHD Required
When BEG-VEST-SCHED !=Spaces
BEG-COMPANY->VSH-COMPANY
BEG-VEST-SCHED->VSH-VEST-SCHED


BNEMPGRNT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Exercise BNEMPEXER
BEG-COMPANY->BXR-COMPANY
BEG-EMPLOYEE->BXR-EMPLOYEE
BEG-OPT-GRANT-NBR->BXR-OPT-GRANT-NBR
BEG-STOCK-CTF->BXR-STOCK-CTF
  BXR-EXERCISE-DATE
  BXR-SEQ-NBR


File created: Thu Jun 09 02:09:59 2016

Home
Contact Us



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