EMPLIDCONTRACT_BEGIN_DTEFFDTDefault Value: %date
XML_CTPRRESP_VW(SQL View) |
Index Back |
|---|---|
Contract Printing Vw ESPContract Printing Vw ESP |
| SELECT CD.EMPLID , CD.CONTRACT_BEGIN_DT , JB.EFFDT , CD.CONTRACT_NUM , CD.RESPONSIBLE_ID , NM.NAME , PN.NATIONAL_ID , JC.DESCR FROM PS_CONTRACT_DATA CD , PS_JOB JB , PS_JOBCODE_TBL JC , PS_PERS_NID PN , PS_NAMES NM WHERE JB.EMPLID = CD.EMPLID AND JB.CONTRACT_NUM = CD.CONTRACT_NUM AND CD.EMPLID = JB.EMPLID AND JB.JOBCODE = JC.JOBCODE AND JB.SETID_JOBCODE = JC.SETID AND JB.HR_STATUS = 'A' AND JB.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE JB.EMPLID = A_ED.EMPLID AND JB.EMPL_RCD = A_ED.EMPL_RCD AND A_ED.HR_STATUS = 'A' AND (A_ED.EFFDT <= CD.CONTRACT_BEGIN_DT OR (A_ED.EFFDT <= %CurrentDateIn AND CD.CONTRACT_BEGIN_DT IS NULL)) AND JB.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES WHERE JB.EMPLID = A_ES.EMPLID AND JB.EMPL_RCD = A_ES.EMPL_RCD AND A_ES.HR_STATUS = 'A' AND JB.EFFDT = A_ES.EFFDT) ) AND CD.EMPLID = JB.EMPLID AND NM.EMPLID = CD.RESPONSIBLE_ID AND NM.NAME_TYPE = 'PRI' AND NM.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_NAMES B WHERE B.EMPLID = NM.EMPLID AND B.NAME_TYPE = 'PRI' AND B.EFFDT <= JB.EFFDT) AND PN.COUNTRY = 'ESP' AND PN.NATIONAL_ID_TYPE = 'DNI' AND PN.EMPLID = CD.RESPONSIBLE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CONTRACT_BEGIN_DT |
Date(10) | DATE | Contract Begin Date |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 5 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL | Responsible ID |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 8 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |