GPES_CRT_DTB_VW (SQL View)	Index Back
CRT Inquiry EE Concepts VW Employee Concepts View for Creta Inquiry

GPES_CRT_DTB_VW

(SQL View)

CRT Inquiry EE Concepts VW

Employee Concepts View for Creta Inquiry

SELECT DISTINCT SSN_EMPLOYER , GPES_SSTC_PAYMNT , GPES_YEAR , GPES_MONTH , GPES_MONTH_RECALC , GPES_YEAR_RECALC , EMPLID , EMPL_RCD , GPES_CRT_STATUS_EE , GPES_CRT_STAT_RSN , GPES_CRT_DATA_TYPE , SLICE_BGN_DT , GPES_CRT_CODE , GPES_CRT_NUM_RSLT , GPES_CRT_CHAR_RSLT , CASE WHEN GPES_CRT_DATA_TYPE = 'I' THEN GPES_CRT_CHAR_RSLT ELSE %NumToChar(GPES_CRT_NUM_RSLT) END , SLICE_END_DT , GPES_CRT_BRK_LQ , GPES_REUSE_PRV_BS FROM PS_GPES_CRT_LQ_EE D WHERE %Sql(GPES_CRT_MAX_VER_REV_NUM, PS_GP_PYE_PRC_STAT, D) AND GPES_CRT_DATA_TYPE = 'C'

# 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_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/Surcharge Bases Increa
L91=Retro w/Surchage new Slices

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

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

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

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

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

8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

9 GPES_CRT_STATUS_EE Character(1) VARCHAR2(1) NOT NULL Employee Status for Creta reporting
0=No Reported
1=Reported
E=With Errors
M=Manually Selected
V=Validated
X=Excluded
Default Value: 0

10 GPES_CRT_STAT_RSN Character(1) VARCHAR2(1) NOT NULL Check Box to select No Reported employees for Creta reporting
A=Data not Needed
N=Negative Bases
P=Reuse Previous Bases

11 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

12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date

13 GPES_CRT_CODE Character(3) VARCHAR2(3) NOT NULL Code for Creta reporting
01=Part Time Contract Hours
02=Complementary Hours
03=Presential Training Hours
04=Distance Training Hours
05=Part Time Coefficient in ERE
500=General Contingencies Base
501=Structural Overtime
502=Non-structural Overtime
509=CC Base for Maternity/Risk
51=Salary Modality
52=Option 126 Epigraph
535=CC Base for Maternity/Risk
536=CC Base for Maternity/Risk
537=Complementary Hours
563=IT Illness & Accident
601=Professional Contingences Base
603=CP Base for Maternity/Risk
611=Professional Contingences Base
613=Professional Contingences Base
634=CP Base for Maternity/Risk
635=CP Base for Maternity/Risk
636=CP Base for Maternity/Risk
637=CP Base for Maternity/Risk
663=IT by IA and PI
763=Bonif. INEM Cont. Form.

14 GPES_CRT_NUM_RSLT Signed Number(10,2) DECIMAL(8,2) NOT NULL Numeric result

15 GPES_CRT_CHAR_RSLT Character(2) VARCHAR2(2) NOT NULL Chart Result

16 GPES_CRT_DATA Character(11) VARCHAR2(11) NOT NULL Data for Creta reporting

17 SLICE_END_DT Date(10) DATE Element Slice End Date

18 GPES_CRT_BRK_LQ Number(6,0) INTEGER NOT NULL Breaking Point

19 GPES_REUSE_PRV_BS Character(1) VARCHAR2(1) NOT NULL Reuse Previous Month Bases 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_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/Surcharge Bases Increa L91=Retro w/Surchage new Slices
3	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
4	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
5	GPES_MONTH_RECALC	Number(2,0)	SMALLINT NOT NULL	Retro month
6	GPES_YEAR_RECALC	Number(4,0)	SMALLINT NOT NULL	Retro year
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
9	GPES_CRT_STATUS_EE	Character(1)	VARCHAR2(1) NOT NULL	Employee Status for Creta reporting 0=No Reported 1=Reported E=With Errors M=Manually Selected V=Validated X=Excluded Default Value: 0
10	GPES_CRT_STAT_RSN	Character(1)	VARCHAR2(1) NOT NULL	Check Box to select No Reported employees for Creta reporting A=Data not Needed N=Negative Bases P=Reuse Previous Bases
11	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
12	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
13	GPES_CRT_CODE	Character(3)	VARCHAR2(3) NOT NULL	Code for Creta reporting 01=Part Time Contract Hours 02=Complementary Hours 03=Presential Training Hours 04=Distance Training Hours 05=Part Time Coefficient in ERE 500=General Contingencies Base 501=Structural Overtime 502=Non-structural Overtime 509=CC Base for Maternity/Risk 51=Salary Modality 52=Option 126 Epigraph 535=CC Base for Maternity/Risk 536=CC Base for Maternity/Risk 537=Complementary Hours 563=IT Illness & Accident 601=Professional Contingences Base 603=CP Base for Maternity/Risk 611=Professional Contingences Base 613=Professional Contingences Base 634=CP Base for Maternity/Risk 635=CP Base for Maternity/Risk 636=CP Base for Maternity/Risk 637=CP Base for Maternity/Risk 663=IT by IA and PI 763=Bonif. INEM Cont. Form.
14	GPES_CRT_NUM_RSLT	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Numeric result
15	GPES_CRT_CHAR_RSLT	Character(2)	VARCHAR2(2) NOT NULL	Chart Result
16	GPES_CRT_DATA	Character(11)	VARCHAR2(11) NOT NULL	Data for Creta reporting
17	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
18	GPES_CRT_BRK_LQ	Number(6,0)	INTEGER NOT NULL	Breaking Point
19	GPES_REUSE_PRV_BS	Character(1)	VARCHAR2(1) NOT NULL	Reuse Previous Month Bases for Creta reporting