Lawson Insight Technical Documentation |
|
BNEMPGRNT
BNEMPGRNT FILE
REFERENCED BY
BN305 BN534 HR170 HR511 HR70.1 PA02.1
PA100 PA102 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 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 Numeric 4 BN234 BN33.1
Element: Company Hr BN33.2 BN33.3
BN533
BEG-EMPLOYEE Numeric 9 BN234 BN33.1
Element: Employee Contains the employee number. Each BN33.2 BN33.3
person employed by the company is BN533
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
BEG-OPT-GRANT-NBR Alpha 10 BN234 BN33.1
Element: Opt Grant Nbr BN33.2 BN33.3
BN533
BEG-GRANT-DATE Numeric 8 (yyyymmdd) BN234 BN33.1
Element: Grant Date BN33.2 BN33.3
BN533
BEG-SHARES-GRANTED Numeric 9 BN107 BN234
Element: Shares Granted BN33.1 BN33.2
BN33.3 BN533
BEG-GRANT-PRICE Signed 9.4 BN107 BN234
Element: Grant Price BN33.1 BN33.2
BN33.3 BN533
BEG-EXP-DATE Numeric 8 (yyyymmdd) BN234 BN33.1
Element: Exp Date BN33.2 BN33.3
BN533
BEG-VEST-SCHED Alpha 2 BN234 BN33.1
Element: Vest Sched BN33.2 BN33.3
BN533
BEG-VEST-FROM Numeric 8 (yyyymmdd) BN234 BN33.1
Element: Vest From BN33.2 BN33.3
BN533
BEG-OPT-VEST-FROM Alpha 2 BN234 BN33.1
Element: Opt Vest From 1 = Grant Date BN33.2 BN33.3
2 = Hire Date BN533
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
BEG-OPTION-TYPE Alpha 2 BN234 BN33.1
Element: Option Type 1 = Incentive Stock Option BN33.2 BN33.3
2 = Non-Qualified BN533
3 = Stock Appreciation Rights
BEG-VEST-AS-OF-DT Numeric 8 (yyyymmdd) BN234 BN33.1
Element: Vest As Of Dt BN33.2 BN33.3
BN533
BEG-VESTING-UPDATE Alpha 1 BN234 BN33.1
Element: Vesting UpdateN = No BN33.2 BN33.3
Y = Yes BN533
BEG-VEST-TYPE Alpha 1 BN234 BN33.1
Element: Vest Type 1 = Annual BN33.2 BN33.3
2 = Semi-Annual BN533
3 = Quarterly
4 = Monthly
5 = Daily
BEG-APPROVAL-FLAG Alpha 1 BN234 BN33.1
Element: Approval Flag N = No BN33.2 BN33.3
Y = Yes BN533
BEG-DATE-STAMP Numeric 8 (yyyymmdd) BN107 BN234
Element: Date Stamp This field contains the server date BN33.1 BN33.2
(month, date, and year) of the last BN33.3 BN533
change to this record.
BEG-TIME-STAMP Numeric 6 (hhmmss) BN107 BN234
Element: Time Stamp Contains the server time (hour, minute, BN33.1 BN33.2
and second) when the record was last BN33.3 BN533
changed.
BEG-USER-ID Alpha 10 (Lower Case) BN107 BN234
Element: User BN33.1 BN33.2
BN33.3 BN533
BEG-CURRENCY-CODE Alpha 5 BN234 BN33.1
Element: Currency Code This field contains the company base BN33.2 BN33.3
currency code established in Company BN533
(GL10.1 ).
BEG-CURR-ND Numeric 1 BN234 BN33.1
Element: Acct Nd The number of decimals assigned to a BN33.2 BN33.3
particular account as determined by the BN533
account currency.
BEG-BASE-GNT-PRICE Signed 9.4 BN107 BN234
Element: Base Gnt Price BN33.1 BN33.2
BN33.3 BN533
BEG-EMP-GRNT-PRICE Signed 9.4 BN107 BN234
Element: Emp Grnt Price BN33.1 BN33.2
BN33.3 BN533
BEG-BASE-CURRENCY Alpha 5 BN234 BN33.1
Element: Base Currency The company base currency. BN33.2 BN33.3
BN533
BEG-BASE-ND Numeric 1 BN234 BN33.1
Element: Base Nd The number of decimal positions defined BN33.2 BN33.3
for the company base currency. BN533
BEG-EMP-CURRENCY Alpha 5 BN234 BN33.1
Element: Emp Currency BN33.2 BN33.3
BN533
BEG-EMP-ND Numeric 1 BN234 BN33.1
Element: Emp Nd BN33.2 BN33.3
BN533
BEG-FAIR-MKT-VAL Signed 9.4 BN107 BN234
Element: Fair Mkt Val BN33.1 BN33.2
BN33.3 BN533
BEG-BASE-FR-MKT-VL Signed 9.4 BN107 BN234
Element: Base Fr Mkt Vl BN33.1 BN33.2
BN33.3 BN533
BEG-EMP-FR-MKT-VL Signed 9.4 BN107 BN234
Element: Emp Fr Mkt Vl BN33.1 BN33.2
BN33.3 BN533
BEG-MKT-VAL-DATE Numeric 8 (yyyymmdd) BN234 BN33.1
Element: Mkt Val Date BN33.2 BN33.3
BN533
BEG-STOCK-CTF Alpha 10 BN234 BN33.1
Element: Stock Ctf BN33.2 BN33.3
BN533
BNEMPGRNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BEGSET1 COMPANY KeyChange BN234 BN305
EMPLOYEE BN33.1 BN33.2
OPT-GRANT-NBR BN33.3 BN33.4
STOCK-CTF 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 KeyChange BN107 BN137
OPT-GRANT-NBR BN223 BN23.1
EMPLOYEE BN234 BN33.1
STOCK-CTF BN33.2 BN33.3
BN533
BEGSET4 COMPANY KeyChange BN23.1
OPT-GRANT-NBR
EXP-DATE*
EMPLOYEE
STOCK-CTF
BNEMPGRNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|