GPES_CRT_SS_TRM (SQL Table)	Index Back
CRET@ SS Slices Response Social Security CRET@ employee slices response file.

GPES_CRT_SS_TRM

(SQL Table)

CRET@ SS Slices Response

Social Security CRET@ employee slices response file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number

4 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year

5 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month

6 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

7 GPES_YEAR_RECALC Number(4,0) SMALLINT NOT NULL Retro year

8 GPES_MONTH_RECALC Number(2,0) SMALLINT NOT NULL Retro month

9 GPES_SSTC_CNTRL_DT Date(10) DATE Social Security TCs control date

10 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date

11 SLICE_END_DT Date(10) DATE Element Slice End Date

12 SOC_SEC_WRK_GRP_CD Character(2) VARCHAR2(2) NOT NULL Social Security Work Group
01=01-Engineers
02=02-Technicals
03=03-Administrative
04=04-Assistants
05=05-White Collar
06=06-Subordinates
07=07-Administrative assistants
08=08-1st and 2nd degree
09=09-3rd degree
10=10-Over 18 years
11=11-Under 18 years

13 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

14 PART_TIME_PERC_ESP Number(3,0) SMALLINT NOT NULL Percentage of Part Time

15 INDSTRY_CD_ESP Character(5) VARCHAR2(5) NOT NULL Industry Activity Code

16 SOC_SEC_RISK_CODE Character(3) VARCHAR2(3) NOT NULL Social Security Risk Code

17 GPES_FILENAME Character(8) VARCHAR2(8) NOT NULL FDI File Name or EFT File Name

18 GPES_CRT_SOURCE Character(3) VARCHAR2(3) NOT NULL CRET@ source calculation type file
C=Calculation
S=Slices of Employees

19 GPES_CRT_STAT_VAL Character(1) VARCHAR2(1) NOT NULL CRET@ Social Security calculation verification status.
0=Matched
1=Mismatch
3=Not Verified
Default Value: 3

20 GPES_CRT_STAT_TRM Character(1) VARCHAR2(1) NOT NULL CRET@ Social Security employee slice verification status.
0=Matched
1=Mismatch
3=Not Verified
Default Value: 3

21 GPES_CRT_STAT_VRF Character(1) VARCHAR2(1) NOT NULL CRET@ Social Security employee slice verification status.
0=Matched
1=Mismatch
3=Not Verified
Default Value: 3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
4	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
5	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
6	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
7	GPES_YEAR_RECALC	Number(4,0)	SMALLINT NOT NULL	Retro year
8	GPES_MONTH_RECALC	Number(2,0)	SMALLINT NOT NULL	Retro month
9	GPES_SSTC_CNTRL_DT	Date(10)	DATE	Social Security TCs control date
10	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
11	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
12	SOC_SEC_WRK_GRP_CD	Character(2)	VARCHAR2(2) NOT NULL	Social Security Work Group 01=01-Engineers 02=02-Technicals 03=03-Administrative 04=04-Assistants 05=05-White Collar 06=06-Subordinates 07=07-Administrative assistants 08=08-1st and 2nd degree 09=09-3rd degree 10=10-Over 18 years 11=11-Under 18 years
13	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
14	PART_TIME_PERC_ESP	Number(3,0)	SMALLINT NOT NULL	Percentage of Part Time
15	INDSTRY_CD_ESP	Character(5)	VARCHAR2(5) NOT NULL	Industry Activity Code
16	SOC_SEC_RISK_CODE	Character(3)	VARCHAR2(3) NOT NULL	Social Security Risk Code
17	GPES_FILENAME	Character(8)	VARCHAR2(8) NOT NULL	FDI File Name or EFT File Name
18	GPES_CRT_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	CRET@ source calculation type file C=Calculation S=Slices of Employees
19	GPES_CRT_STAT_VAL	Character(1)	VARCHAR2(1) NOT NULL	CRET@ Social Security calculation verification status. 0=Matched 1=Mismatch 3=Not Verified Default Value: 3
20	GPES_CRT_STAT_TRM	Character(1)	VARCHAR2(1) NOT NULL	CRET@ Social Security employee slice verification status. 0=Matched 1=Mismatch 3=Not Verified Default Value: 3
21	GPES_CRT_STAT_VRF	Character(1)	VARCHAR2(1) NOT NULL	CRET@ Social Security employee slice verification status. 0=Matched 1=Mismatch 3=Not Verified Default Value: 3