GPES_CRT_EE_ERR

(SQL Table)
Index Back

CRT Employee VW

Employee View for Creta Reporting

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
2 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
3 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
4 GPES_SSTC_PAYMNT Character(3) VARCHAR2(3) NOT NULL Payment Type. This field is used to populate the GP Write Array, which is used to generate the FAN File.
L00=Regular
L02=Litigation Salary
L03=Retroactivity wo/Surcharge
L04=Reductions Payback
L09=Retroactivity w/Surcharge
L13=Vacations
L90=Retro w/Surch. Base Incr.
L91=Retro w/Surch. New Slices
V03=Retro wo/ Surcharge Vacations
V90=Retro w/ Surcharge Vacations
5 GPES_YEAR_RECALC Number(4,0) SMALLINT NOT NULL Retro year
6 GPES_MONTH_RECALC Number(2,0) SMALLINT NOT NULL Retro month
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
9 GPES_SSTC_CNTRL_DT Date(10) DATE Social Security TCs control date
10 GPES_ERROR_KEY Character(12) VARCHAR2(12) NOT NULL Error Code
11 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
12 GPES_ERROR_CODE Character(5) VARCHAR2(5) NOT NULL Error Code
13 GPES_ERROR_DESC Character(50) VARCHAR2(50) NOT NULL Error Code
14 SLICE_END_DT Date(10) DATE Element Slice End Date
15 GPES_CRT_DATA_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Data for Creta reporting: C-concept, H-hours, I-Identifier
C=Amount
H=Hour
I=Indicator
16 GPES_CRT_CODE Character(3) VARCHAR2(3) NOT NULL Code for Creta reporting
17 GPES_CRT_VALUE Character(11) VARCHAR2(11) NOT NULL Value for Creta reporting
18 GPES_FILE_NAME Character(250) VARCHAR2(250) NOT NULL Name of a file, according to the process scheduler server.