Lawson Insight Technical Documentation |
|
TAEEGROUP
TAEEGROUP FILE
UPDATED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR15.1 HR155 HR511 HR515
HR54.1 HR55.2 HR55.1 HR55.3 HRS1.1 HRSC.1
LP100 LP101 LP35.1 PA02.1 PA100 PA102
PA115 PA13.1 PA13.2 PA16.1 PA20.1 PA21.1
PA22.1 PA24.1 PA27.1 PA34.1 PA35.1 PA36.1
PA38.1 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA520 PA54.1 TR21.1 TR22.1 TR26.1
TR500 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TGR-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Hr HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. Each HEP4.1 HPOS.1
person employed by the company is HPQC.1 HPRS.1
assigned a unique number. The system HR11.1 HR11.2
uses the employee number to correlate HR15.1 HR155
all of the information related to that HR511 HR515
person. HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-EMPLOYEE-GROUP Alpha 10 BN305 HAP3.1
Element: Group Name HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-EFFECTIVE-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Ta Begin Date HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-QUALIFY-FLAG Numeric 1 BN305 HAP3.1
Element: Ta Qualify 0 = No HEP4.1 HPOS.1
1 = Yes HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-HOLD-FLAG Numeric 1 BN305 HAP3.1
Element: Ta Hold 0 = No HEP4.1 HPOS.1
1 = Yes HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LP35.1 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
TR21.1 TR22.1
TR26.1 TR500
TGR-CREATE-DATE Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Date Stamp This field contains the server date HEP4.1 HPOS.1
(month, date, and year) of the last HPQC.1 HPRS.1
change to this record. HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-CREATE-TIME Numeric 6 (hhmmss) BN305 HAP3.1
Element: Time Stamp Contains the server time (hour, minute, HEP4.1 HPOS.1
and second) when the record was last HPQC.1 HPRS.1
changed. HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-CREATE-USER-ID Alpha 10 (Lower Case) BN305 HAP3.1
Element: User HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HAP3.1
Element: Date Stamp This field contains the server date HEP4.1 HPOS.1
(month, date, and year) of the last HPQC.1 HPRS.1
change to this record. HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-TIME-STAMP Numeric 6 (hhmmss) BN305 HAP3.1
Element: Time Stamp Contains the server time (hour, minute, HEP4.1 HPOS.1
and second) when the record was last HPQC.1 HPRS.1
changed. HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TGR-USER-ID Alpha 10 (Lower Case) BN305 HAP3.1
Element: User HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 TR21.1
TR22.1 TR26.1
TR500
TAEEGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TGRSET1 COMPANY BN305 HAP3.1
EMPLOYEE HEP4.1 HPOS.1
EMPLOYEE-GROUP HPQC.1 HPRS.1
EFFECTIVE-DATE HR11.1 HR11.2
QUALIFY-FLAG HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LP35.1 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
...
TGRSET2 COMPANY LP100
EMPLOYEE
EFFECTIVE-DATE
EMPLOYEE-GROUP
QUALIFY-FLAG
TGRSET3 COMPANY KeyChange HR11.1 HR511
EMPLOYEE LP100 PA100
EMPLOYEE-GROUP PA52.4
HOLD-FLAG*
EFFECTIVE-DATE*
QUALIFY-FLAG
TGRSET4 COMPANY HR55.1 HR55.2
EMPLOYEE-GROUP HR55.3
EMPLOYEE
EFFECTIVE-DATE
QUALIFY-FLAG
TAEEGROUP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TGR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
TGR-COMPANY -> EMP-COMPANY
TGR-EMPLOYEE -> EMP-EMPLOYEE
Employee Group PERSGROUP Required
TGR-COMPANY -> PRG-COMPANY
TGR-EMPLOYEE-GROUP -> PRG-GROUP-NAME
Paemployee PAEMPLOYEE Required
TGR-COMPANY -> PEM-COMPANY
TGR-EMPLOYEE -> PEM-EMPLOYEE
|