Lawson Insight Technical Documentation |
|
BNEMPGRNT
BNEMPGRNT FILE
REFERENCED BY
BN534 HR170 HR511 HR70.1 PA02.1 PA100
PA102 PA502 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 Identifies the AP company if the BN33.2 BN33.3
resource type = V. Identifies the HR BN533
company if the resource type = E. It is
blank for type A, P or Q resources.
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: Expiration Date BN33.2 BN33.3
BN533
BEG-VEST-SCHED Alpha 2 BN234 BN33.1
Element: Schedule 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 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 Contains the user ID of the person who BN33.1 BN33.2
last changed this record. 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
Account Currency Represents the number of decimals BN33.2 BN33.3
Code defined for the currency of the object. BN533
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
Base Number Of The number of decimal positions defined BN33.2 BN33.3
Decimals 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 BN33.1
EMPLOYEE BN33.2 BN33.3
OPT-GRANT-NBR BN33.4 BN533
STOCK-CTF BN534 HR11.1
HR11.2 HR170
HR511 HR70.1
PA02.1 PA100
PA102 PA115
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
BEGSET2 COMPANY KeyChange BN107 BN137
OPT-GRANT-NBR BN223 BN23.1
EMPLOYEE BN234 BN33.1
STOCK-CTF BN33.2 BN33.3
BN533
BEGSET3 COMPANY KeyChange
EXP-DATE
EMPLOYEE
OPT-GRANT-NBR
STOCK-CTF
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
|