EMPLIDCONTRACT_BEGIN_DTEFFDTDefault Value: %date
LANGUAGE_CDXML_CTPRRVW_LNG(SQL View) |
Index Back |
|---|---|
Contract Printing Vw ESPContract Printing Vw ESP - Language Record |
| SELECT CD.EMPLID , CD.CONTRACT_BEGIN_DT , JB.EFFDT , JC.LANGUAGE_CD , JC.DESCR FROM PS_CONTRACT_DATA CD , PS_JOB JB , PS_JOBCODE_LANG JC 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_END_DT OR (A_ED.EFFDT <= %CurrentDateIn AND CD.CONTRACT_END_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 EXISTS ( SELECT 'X' FROM PS_XML_CTPRRESP_VW X WHERE CD.EMPLID = X.EMPLID AND CD.CONTRACT_BEGIN_DT = X.CONTRACT_BEGIN_DT AND JB.EFFDT = X.EFFDT) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |