Lawson Insight Technical Documentation |
|
TAEEGROUP
TAEEGROUP FILE
UPDATED BY
HAP3.1 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 PA02.1 PA100 PA102
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 PRSC.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TGR-COMPANY Numeric 4 HAP3.1 HEP4.1
Element: Company Hr Identifies the AP company if the HPOS.1 HPQC.1
resource type = V. Identifies the HR HPRS.1 HR11.1
company if the resource type = E. It is HR11.2 HR15.1
blank for type A, P or Q resources. HR155 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TGR-EMPLOYEE Numeric 9 HAP3.1 HEP4.1
Element: Employee Contains the employee number. Each HPOS.1 HPQC.1
person employed by the company is HPRS.1 HR11.1
assigned a unique number. The system HR11.2 HR15.1
uses the employee number to correlate HR155 HR511
all of the information related to that HR515 HR54.1
person. HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TGR-EMPLOYEE-GROUP Alpha 10 HAP3.1 HEP4.1
Element: Group Name HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TGR-EFFECTIVE-DATE Numeric 8 (yyyymmdd) HAP3.1 HEP4.1
Element: Ta Begin Date The date a vendor's prices will be in HPOS.1 HPQC.1
effect. HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TGR-QUALIFY-FLAG Numeric 1 HAP3.1 HEP4.1
Element: Ta Qualify 0 = No HPOS.1 HPQC.1
1 = Yes HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TGR-HOLD-FLAG Numeric 1 HAP3.1 HEP4.1
Element: Ta Hold This field enables this entire lot to HPOS.1 HPQC.1
be put on hold, not allowing any issues HPRS.1 HR11.1
or transfers to be made for this lot. HR11.2 HR15.1
0 = No HR155 HR511
1 = Yes HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TGR-CREATE-DATE Numeric 8 (yyyymmdd)
Element: Date Stamp The creation date.
TGR-CREATE-TIME Numeric 6 (hhmmss)
Element: Time Stamp
TGR-CREATE-USER-ID Alpha 10 (Lower Case)
Element: User
TGR-DATE-STAMP Numeric 8 (yyyymmdd) HAP3.1 HEP4.1
Element: Date Stamp This field contains the server date HPOS.1 HPQC.1
(month, date, and year) of the last HPRS.1 HR11.1
change to this record. HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TGR-TIME-STAMP Numeric 6 (hhmmss) HAP3.1 HEP4.1
Element: Time Stamp Contains the server time (hour, minute, HPOS.1 HPQC.1
and second) when the record was last HPRS.1 HR11.1
changed. HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TGR-USER-ID Alpha 10 (Lower Case) HAP3.1 HEP4.1
Element: User Contains the user ID of the person who HPOS.1 HPQC.1
last changed this record. HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
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 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
TAEEGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TGRSET1 COMPANY HAP3.1 HEP4.1
EMPLOYEE HPOS.1 HPQC.1
EMPLOYEE-GROUP HPRS.1 HR11.1
EFFECTIVE-DATE HR11.2 HR15.1
QUALIFY-FLAG HR155 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
...
TGRSET2 COMPANY
EMPLOYEE
EFFECTIVE-DATE
EMPLOYEE-GROUP
QUALIFY-FLAG
TGRSET3 COMPANY HR11.1 HR511
EMPLOYEE PA100 PA52.4
EMPLOYEE-GROUP
HOLD-FLAG*
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
|