Lawson Insight Technical Documentation |
|
BNTAEMPBAL
BNTAEMPBAL FILE
REFERENCED BY
BN15.1 HR11.1 HR511 LP02.1 LP100 LP101
LP180 LP197 LP31.1 LP331 LP80.1 PA100
PA52.4
UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN531 BS32.1
LP138 LP34.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BTE-COMPANY Numeric 4 BN100 BN101
Element: Company Hr BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-PLAN-CODE Alpha 4 BN100 BN101
Element: Plan Code Contains the user-defined code that BN102 BN103
represents a benefit plan. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-EMPLOYEE Numeric 9 BN100 BN101
Element: Employee Contains the employee number. Each BN102 BN103
person employed by the company is BN105 BN31.1
assigned a unique number. The system BN31.2 BN32.1
uses the employee number to correlate BN32.2 BN32.3
all of the information related to that BN531 BS32.1
person. LP34.1
BTE-TA-PLAN Alpha 10 BN100 BN101
Element: Ta Plan BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-EMPLOYEE-GROUP Alpha 10 BN100 BN101
Element: Group Name BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-POSITION Alpha 12 BN100 BN101
Element: Position Contains the user-defined code that BN102 BN103
represents a position in the company. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-START-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Start Date BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-STOP-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Stop Date BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-TA-OBJ-ID Numeric 12 BN100 BN101
Element: Obj Id Ties the record to teh associated BN102 BN103
BENEFIT record. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-TOTAL-HOURS Signed 8.4 BN100 BN101
Element: Bn Hours Store the total elected number of hours BN102 BN103
from the benefit. BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-PERCENT Signed 7.3 BN100 BN101
Element: Percent Stores the percent of the total hours BN102 BN103
that apply to this group or position. BN105 BN31.1
Used only when there are multiple master BN31.2 BN32.1
records for a TA plan. BN32.2 BN32.3
BN531 BS32.1
LP34.1
BTE-STATUS Numeric 1 BN100 BN101
Element: Status This field displays the status of the BN102 BN103
transaction. BN105 BN31.1
0 = Not Updated BN31.2 BN32.1
1 = Partial Update BN32.2 BN32.3
2 = Adjusted BN531 BS32.1
9 = Updated LP138 LP34.1
BTE-UPDATED-HOURS Signed 8.4 BN100 BN101
Element: Bn Hours BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-UPD-THRU-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Upd Date BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-DATE-STAMP Numeric 8 (yyyymmdd) BN100 BN101
Element: Date Stamp This field contains the server date BN102 BN103
(month, date, and year) of the last BN105 BN31.1
change to this record. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-TIME-STAMP Numeric 6 (hhmmss) BN100 BN101
Element: Time Stamp Contains the server time (hour, minute, BN102 BN103
and second) when the record was last BN105 BN31.1
changed. BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BTE-USER-ID Alpha 10 (Lower Case) BN100 BN101
Element: User BN102 BN103
BN105 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BS32.1
LP138 LP34.1
BNTAEMPBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BTESET1 COMPANY BN100 BN101
PLAN-CODE BN102 BN103
EMPLOYEE BN105 BN15.1
TA-PLAN BN31.1 BN31.2
EMPLOYEE-GROUP BN32.1 BN32.2
POSITION BN32.3 BN531
START-DATE BS32.1 LP138
LP34.1
BTESET2 COMPANY HR11.1 HR511
TA-PLAN LP02.1 LP100
EMPLOYEE-GROUP LP101 LP180
EMPLOYEE LP197 LP31.1
POSITION LP331 LP80.1
PLAN-CODE PA100 PA52.4
START-DATE
BTESET3 COMPANY BN100 BN101
PLAN-CODE BN102 BN103
EMPLOYEE BN105 BN31.1
START-DATE* BN31.2 BN32.1
EMPLOYEE-GROUP BN32.2 BN32.3
POSITION BN531 BS32.1
LP138 LP34.1
BNTAEMPBAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Benefit BENEFIT Required
BTE-COMPANY -> BEN-COMPANY
"VA" -> BEN-PLAN-TYPE
BTE-EMPLOYEE -> BEN-EMPLOYEE
BTE-START-DATE -> BEN-START-DATE
BTE-PLAN-CODE -> BEN-PLAN-CODE
Company PRSYSTEM Required
BTE-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
BTE-COMPANY -> EMP-COMPANY
BTE-EMPLOYEE -> EMP-EMPLOYEE
Employee Group PERSGROUP Required
BTE-COMPANY -> PRG-COMPANY
BTE-EMPLOYEE-GROUP -> PRG-GROUP-NAME
Paemployee PAEMPLOYEE Required
BTE-COMPANY -> PEM-COMPANY
BTE-EMPLOYEE -> PEM-EMPLOYEE
Plan PLAN Required
BTE-COMPANY -> PLN-COMPANY
"VA" -> PLN-PLAN-TYPE
BTE-PLAN-CODE -> PLN-PLAN-CODE
Ta Master TAEEMASTER Required
BTE-COMPANY -> TEM-COMPANY
BTE-EMPLOYEE -> TEM-EMPLOYEE
BTE-TA-PLAN -> TEM-PLAN
BTE-EMPLOYEE-GROUP -> TEM-EMPLOYEE-GROUP
BTE-POSITION -> TEM-POSITION
Ta Plan TAPLAN Required
BTE-COMPANY -> TAP-COMPANY
BTE-TA-PLAN -> TAP-PLAN
BNTAEMPBAL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When BTE-POSITION != Spaces
BTE-COMPANY -> POS-COMPANY
BTE-POSITION -> POS-POSITION
POS-EFFECT-DATE
Ta Structure TASTRUCTUR
BTE-COMPANY -> TST-COMPANY
BTE-TA-PLAN -> TST-PLAN
BTE-EMPLOYEE-GROUP -> TST-EMPLOYEE-GROUP
TST-BEGIN-DATE
|