GPES_TC_EECCC_V

(SQL View)
Index Back

FAN CCCs

CCCs by employee in FAN file

SELECT DISTINCT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , SLICE_BGN_DT , SLICE_END_DT , SSN_EMPLOYER FROM PS_GPES_SSTC_RS_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
9 SLICE_END_DT Date(10) DATE Element Slice End Date
10 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number