GPFR_CNTRCT_VW(SQL View) |
Index Back |
|---|---|
Contract ViewGPFR Contract View. Gets value from Contracte and Workforce Contract Type record. |
| SELECT DISTINCT A.EMPLID , A.CONTRACT_NUM , A.CONTRACT_BEGIN_DT , A.CONTRACT_END_DT , B.CONTRACT_TYPE FROM PS_CONTRACT_DATA A , PS_WKF_CNT_TYPE B WHERE A.CONTRACT_NUM = B.CONTRACT_NUM AND A.EMPLID = B.EMPLID AND B.CONTRACT_TYPE = 'CDD' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 4 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 5 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |