BNEMPGRNT

REFERENCED BY
BN534


UPDATED BY
BN107 BN137 BN234 BN33.1 BN33.2 BN33.3
BN533 BN305 HR11.1 HR11.2 HR170 HR511
HR70.1 PA02.1 PA100 PA102 PA115 PA13.1
PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8 PR13.9 BN223 BN23.1

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
HR170 HR511
HR70.1 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.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: Wed Jun 08 20:48:05 2016

Home
Contact Us



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