EMPLIDPrompt Table: EMPLMT_SRCH_GBL
CONTRACT_NUMCONTRACT_BEGIN_DTCONTRACT_END_DTCONTRACT_STATUSA=Active
I=Inactive
CNT_DTA_BRA_VW(SQL View) |
Index Back |
|---|---|
Contract Data SearchCNT_DTA_BRA_VW is an Contract Data and Employment Search record. |
| SELECT DISTINCT C.EMPLID ,C.CONTRACT_NUM ,C.CONTRACT_BEGIN_DT ,C.CONTRACT_END_DT ,C.CONTRACT_STATUS FROM PS_CONTRACT_DATA C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: EMPLMT_SRCH_GBL |
| 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_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 |