GPES_CC_XCCC_VW

(SQL View)
 Index Back

Comp Certif CCC Data VW ESP

Company Certificate CCC Data.

SELECT DISTINCT B.OPRID , B.RUN_CNTL_ID , A.SSN_EMPLOYER , A.GPES_SCHEME_CCC , A.RESPONSIBLE_ID , A.JOBCODE_DESCR , C.FIRST_NAME , C.LAST_NAME , C.SECOND_LAST_NAME , A.FISCAL_ID_CD , C.NATIONAL_ID FROM PS_GPES_CC_EE_DTA A , PS_GPES_RC_FNQ1_EE B , PS_PERSDATA_ESP_VW C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.TERMINATION_DT AND GENERATE_REPORT = 'Y' AND A.RESPONSIBLE_ID = C.EMPLID AND A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
4 GPES_SCHEME_CCC Character(15) VARCHAR2(15) NOT NULL Scheme ID + SSN Employer.
5 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID
6 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
9 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
10 FISCAL_ID_CD Character(10) VARCHAR2(10) NOT NULL Fiscal Identification Code
11 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID