TAEEGROUP

UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR15.1 HR155 HR156
HR28.1 HR511 HR515 HR54.1 HR55.1 HR55.2
HR55.3 HRS1.1 HRSC.1 LT101 ZH156 ZH510
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 ZE521 ZE531 ZE540 PR110 PR113
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TGR-COMPANY
Element: Company Hr		Numeric 4
 ...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. 		...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-EMPLOYEE-GROUP
Element: Group Name		Alpha 10
 ...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-EFFECTIVE-DATE
Element: Ta Begin Date		Numeric 8 (yyyymmdd)
 ...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-QUALIFY-FLAG
Element: Ta Qualify		Numeric 1

0 = No
1 = Yes		 ...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-HOLD-FLAG
Element: Ta Hold		Numeric 1

0 = No
1 = Yes		 ...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LP35.1
LT101 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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 TR21.1
TR22.1 TR26.1
TGR-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record. 		...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed. 		...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
 ...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record. 		...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed. 		...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500
TGR-USER-ID
Element: User		Alpha 10 (Lower Case)
 ...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LP100
LP101 LT101
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
TR21.1 TR22.1
TR26.1 TR500


TAEEGROUP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TGRSET1 COMPANY
EMPLOYEE
EMPLOYEE-GROUP
EFFECTIVE-DATE
QUALIFY-FLAG
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LT101
ZH156 ZH510
LP100 LP101
LP35.1 PA02.1
PA100 PA102
PA115 PA13.1
TGRSET2 COMPANY
EMPLOYEE
EFFECTIVE-DATE
EMPLOYEE-GROUP
QUALIFY-FLAG
LP100
TGRSET3 COMPANY
EMPLOYEE
EMPLOYEE-GROUP
HOLD-FLAG*
EFFECTIVE-DATE*
QUALIFY-FLAG
KeyChange
HR11.1 HR511
LT101 LP100
PA100 PA52.4
TGRSET4 COMPANY
EMPLOYEE-GROUP
EMPLOYEE
EFFECTIVE-DATE
QUALIFY-FLAG
HR55.1 HR55.2
HR55.3


TAEEGROUP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:19:38 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.