GPFR_CONTRCT_VW(SQL View) |
Index Back |
|---|---|
Active Contracts ViewView linking Contract Data and Type of Contract per effective date; Used as a prompt on JOB_DATA to get the Active Contracts per Emplid and to retrieve French data which are used in arrays. |
| SELECT A.EMPLID ,A.CONTRACT_NUM ,A.EFFDT ,A.CONTRACT_TYPE ,B.CONTRACT_BEGIN_DT ,B.CONTRACT_END_DT ,B.CONTRCT_EXP_END_DT ,B.CONTRACT_STATUS ,A.EE_PROF_STATUS_FRA ,A.CTG_STATUS_FRA FROM PS_WKF_CNT_TYPE A , PS_CONTRACT_DATA B WHERE A.EMPLID = B.EMPLID AND A.CONTRACT_NUM=B.CONTRACT_NUM AND B.CONTRACT_STATUS='A' |
| # | 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 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |
| 5 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 6 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 7 | CONTRCT_EXP_END_DT | Date(10) | DATE | Contract Expected End Date |
| 8 | CONTRACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status -
The values 'N - N/A' and 'P - Pending' are suppressed from release 8.
A=Active I=Inactive |
| 9 | EE_PROF_STATUS_FRA | Character(2) | VARCHAR2(2) NOT NULL | Employee Professional Status - FRA |
| 10 | CTG_STATUS_FRA | Character(2) | VARCHAR2(2) NOT NULL | Category Status - FRA |