ETRESOURCE FILE
REFERENCED BY
ET175 ET530 ET540 ET542 ET545 ET09.1
UPDATED BY
ET700
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RES-ERES-ID Numeric 10
Element: Numeric 1
RES-ERES-IMPORT-ID Numeric 10
Element: Numeric 1
RES-ERES-TYPE Numeric 5 ET700
Element: Numeric 00010 = Employee
00020 = Sub Contractor
RES-ERES-CODE Alpha 12 ET700
Element: Alpha 12
RES-ERES-FIRSTNAME Alpha 30 (Lower Case)
Element: Name
RES-ERES-LASTNAME Alpha 66 ET700
Element: Alpha 66
RES-ERES-MNGR-ID Numeric 9
Element: Employee
RES-ERES-GROUP-ID Numeric 10 ET700
Element: Numeric 1
RES-ERES-STATUS Numeric 10 ET700
Element: Numeric 1
RES-ERES-LOCATION Alpha 12
Element: Alpha 12
RES-ERES-CITY Alpha 20 ET700
Element: Alpha 1
RES-ERES-ADDRESS1 Alpha 255 ET700
Element: Alpha 255
RES-ERES-ADDRESS2 Alpha 255 ET700
Element: Alpha 255
RES-ERES-ADDRESS3 Alpha 255 ET700
Element: Alpha 255
RES-ERES-ADDRESS4 Alpha 255 ET700
Element: Alpha 255
RES-ERES-STATE Alpha 20 ET700
Element: Alpha 1
RES-ERES-POSTALCD Alpha 20 ET700
Element: Alpha 1
RES-ERES-COUNTRY Numeric 10 ET700
Element: Numeric 1
RES-ERES-PHONE Alpha 20
Element: Alpha 1
RES-ERES-PAGER Alpha 20
Element: Alpha 1
RES-ERES-EMAIL Alpha 50 ET700
Element: Alpha 50
RES-ERES-CURRENCY Numeric 10
Element: Numeric 1
RES-ERES-HR-CMPNY Numeric 10
Element: Numeric 1
RES-ERES-HR-GROUP Alpha 12
Element: Alpha 12
RES-ERES-DEPT Alpha 12
Element: Alpha 12
RES-ERES-AC-GROUP Alpha 15
Element: Alpha 15
RES-ERES-AP-GROUP Alpha 10 ET700
Element: Alpha 10
RES-ERES-VEN-CLASS Alpha 3 ET700
Element: Ven Class
RES-ERES-VENCONTCT Alpha 30 ET700
Element: Alpha 30
RES-ERES-GL-CMPNY Numeric 10
Element: Numeric 1
RES-ERES-ACCT-UNIT Alpha 15
Element: Alpha 15
RES-ERES-COST-CNTR Alpha 20
Element: Alpha 1
RES-ERES-AP-PROCLV Alpha 20
Element: Alpha 1
RES-ERES-PAY-VEN Alpha 12 ET700
Element: Alpha 12
RES-ERES-JOBCODE Alpha 20
Element: Alpha 1
RES-ERES-SHIFT Numeric 10
Element: Numeric 1
RES-ERES-POSITION Alpha 12
Element: Alpha 12
RES-ERES-PAY-GRADE Alpha 10
Element: Alpha 10
RES-ERES-PAY-STEP Numeric 10
Element: Numeric 1
RES-ERES-PAY-SCHED Alpha 10
Element: Alpha 10
RES-ERES-SOURCE Numeric 10 ET700
Element: Numeric 1 0000000010 = AC
0000000020 = PSA
0000000030 = HR
0000000040 = Other
RES-ERES-HIRE-DATE Numeric 8 (yyyymmdd)
Element: Date
RES-ERES-TERM-DATE Numeric 8 (yyyymmdd)
Element: Date
RES-ERES-STD-HOURS Numeric 10
Element: Numeric 1
RES-ERES-TC-RTEID Numeric 10
Element: Numeric 1
RES-ERES-ERPTRTEID Numeric 10
Element: Numeric 1
RES-ERES-ER-RTE-ID Numeric 10
Element: Numeric 1
RES-ERES-EA-RTE-ID Numeric 10
Element: Numeric 1
RES-ERES-EXP-DISP Numeric 10
Element: Numeric 1
RES-ERES-EXP-SYS Numeric 10
Element: Numeric 1
RES-ERES-TIM-DISP Numeric 10
Element: Numeric 1
RES-ERES-TIM-ENTRY Numeric 10
Element: Numeric 1
RES-ERES-TIM-EXCEP Numeric 10
Element: Numeric 1
RES-ERES-HOLIDAY Numeric 10
Element: Numeric 1
RES-ERES-PAYPERSET Numeric 10
Element: Numeric 1
RES-ERES-HRS-SUN Signed 7.2
Element: Hours
RES-ERES-HRS-MON Signed 7.2
Element: Hours
RES-ERES-HRS-TUES Signed 7.2
Element: Hours
RES-ERES-HRS-WED Signed 7.2
Element: Hours
RES-ERES-HRS-THUR Signed 7.2
Element: Hours
RES-ERES-HRS-FRI Signed 7.2
Element: Hours
RES-ERES-HRS-SAT Signed 7.2
Element: Hours
RES-ERES-TEMPID Alpha 40
Element: Alpha 40
RES-ERES-EXP-CODE Alpha 30
Element: Alpha 30
RES-ERES-COSTRATE Signed 18.7
Element: Psa Rate52
RES-ERES-BILLRATE Signed 18.7
Element: Psa Rate52
RES-ERES-WK-START Numeric 10
Element: Numeric 1
RES-ERES-SUP-CODE Alpha 10
Element: Alpha 10
RES-ERES-EXPCURSL Numeric 10
Element: Numeric 1
RES-ERES-ACCT Numeric 10
Element: Numeric 1
RES-ERES-SUBACCT Numeric 10
Element: Numeric 1
RES-ERES-BILLACCT Numeric 10
Element: Numeric 1
RES-ERES-BLSUBACCT Numeric 10
Element: Numeric 1
RES-ERES-TC-APPR Numeric 10
Element: Numeric 1
RES-ERES-EXP-APPR Numeric 10
Element: Numeric 1
RES-ERES-1099 Numeric 10
Element: Numeric 1
RES-ERES-SAL-CLASS Numeric 10
Element: Numeric 1
RES-ERES-EXEMPT Numeric 10
Element: Numeric 1
RES-ERES-FTE-TOTAL Signed 15.2
Element: Int Amount
RES-ERES-UNION-CD Alpha 10
Element: Alpha 10
RES-ERES-COUNTY Alpha 25 (Lower Case) ET700
Element: County
RES-ERES-PDSCH-ID Numeric 10
Element: Numeric 1
RES-ERES-PDW-ID Numeric 10
Element: Numeric 1
RES-ERES-PCSET-ID Numeric 10
Element: Numeric 1
ETRESOURCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RESSET1 ERES-ID ET175 ET530
ET540 ET542
ET545
RESSET2 ERES-HR-CMPNY ET09.1 ET700
ERES-CODE
ERES-ID
RESSET3 ERES-AP-GROUP ET700
ERES-CODE
ERES-ID
|
