GPES_CRT_DTB_VW

(SQL View)
 Index Back

CRT Inquiry EE Concepts VW

Employee Concepts View for Creta Inquiry

SELECT SSN_EMPLOYER , GPES_SSTC_PAYMNT , GPES_YEAR , GPES_MONTH , GPES_MONTH_RECALC , GPES_YEAR_RECALC , EMPLID , GPES_CRT_STATUS_EE , GPES_CRT_STAT_RSN , GPES_CRT_DATA_TYPE , SLICE_BGN_DT , GPES_CRT_CODE , %NumToChar(SUM(GPES_CRT_NUM_RSLT)) , MAX(GPES_CRT_CHAR_RSLT) , %NumToChar(SUM(GPES_CRT_NUM_RSLT)) , 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' GROUP BY SSN_EMPLOYER , GPES_SSTC_PAYMNT , GPES_YEAR , GPES_MONTH , GPES_MONTH_RECALC , GPES_YEAR_RECALC , EMPLID , GPES_CRT_DATA_TYPE , SLICE_BGN_DT , GPES_CRT_STATUS_EE , GPES_CRT_STAT_RSN , GPES_CRT_CODE , SLICE_END_DT , GPES_CRT_BRK_LQ , GPES_REUSE_PRV_BS

# 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/Surch. Base Incr.
L91=Retro w/Surch. New Slices
V03=Retro wo/ Surcharge Vacations
V90=Retro w/ Surcharge Vacations
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 GPES_CRT_STATUS_EE Character(1) VARCHAR2(1) NOT NULL CRET@ Employee reporting status
0=No Reported
1=Reported
E=With Errors
M=Manually Selected
V=Validated
X=Excluded
9 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
10 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
11 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
12 GPES_CRT_CODE Character(3) VARCHAR2(3) NOT NULL Code for Creta reporting
13 GPES_CRT_NUM_RSLT Signed Number(10,2) DECIMAL(8,2) NOT NULL Numeric result
14 GPES_CRT_CHAR_RSLT Character(2) VARCHAR2(2) NOT NULL Chart Result
15 GPES_CRT_DATA Character(11) VARCHAR2(11) NOT NULL Data for Creta reporting
16 SLICE_END_DT Date(10) DATE Element Slice End Date
17 GPES_CRT_BRK_LQ Number(9,0) DECIMAL(9) NOT NULL Breaking Point
18 GPES_REUSE_PRV_BS Character(1) VARCHAR2(1) NOT NULL Reuse Previous Month Bases for Creta reporting