OPRIDRUN_CNTL_IDSSN_EMPLOYEREMPLIDEFFDTDefault Value: %date
GPES_CC_XEE_VW(SQL View) |
Index Back |
|---|---|
Comp Certif EE Data VW ESPCompany Certificate Employee Data. |
| SELECT A.OPRID , A.RUN_CNTL_ID , A.SSN_EMPLOYER , A.EMPLID , A.EFFDT FROM PS_GPES_CC_EE_DTA A , PS_GPES_RC_FNQ1_EE B , PS_GPES_RC_FNQ1 C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.OPRID = C.OPRID AND B.RUN_CNTL_ID = C.RUN_CNTL_ID AND ((C.GPES_EMPLOYEE_TYPE = 'I' AND A.EFFDT = B.TERMINATION_DT ) OR C.GPES_EMPLOYEE_TYPE = 'A') AND B.GENERATE_REPORT = 'Y' AND B.GPES_REASON IN ('INE', 'ERE') AND B.OPRID = A.OPRID AND B.RUN_CNTL_ID = A.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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |