EMPLIDCONTRACT_NUMA=Active
I=Inactive
Default Value: A
Default Value: %Date
HR_OWS_CONTR_VW(SQL View) |
Index Back |
|---|---|
OWS Contract DataOracle Workforce Scheduling Contract Data |
| SELECT A.EMPLID , A.CONTRACT_NUM , A.CONTRACT_STATUS , CASE WHEN A.CONTRACT_BEGIN_DT IS NULL THEN %DateIn('1902-02-02') ELSE A.CONTRACT_BEGIN_DT END , CASE WHEN A.CONTRACT_END_DT IS NULL THEN %DateIn('1902-02-02') ELSE A.CONTRACT_END_DT END , A.CNT_MIN_HRS , A.CNT_MAX_HRS FROM PS_CONTRACT_DATA 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 | 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 Default Value: A |
| 4 | CONTRACT_BEGIN_DT | Date(10) | DATE |
Contract Begin Date
Default Value: %Date |
| 5 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 6 | CNT_MIN_HRS | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Hours Per Contract |
| 7 | CNT_MAX_HRS | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Hours Per Contract |