SETIDPrompt Table: SET_VLD_HR_09
CONTRACT_TYPECNT_TEMPLATE_IDEFFDTDefault Value: %date
A=Active
I=Inactive
01=Regular
02=Temporary
CNT_TMPL_ESP_VW(SQL View) |
Index Back |
|---|---|
Contract template view for ESPContract template view for ESP |
| SELECT CT.SETID ,CT.CONTRACT_TYPE ,CT.CNT_TEMPLATE_ID ,CT.EFFDT ,CT.EFF_STATUS ,CT.DESCR ,CT.CONTRACT_FAMILY ,CT.COMMENTS FROM PS_CNT_TEMPLATE CT WHERE CT.SETID = 'ESP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_09 |
| 2 | CONTRACT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Contract Type |
| 3 | CNT_TEMPLATE_ID |
Character(11) | VARCHAR2(11) NOT NULL | Contract Template ID |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | CONTRACT_FAMILY | Character(2) | VARCHAR2(2) NOT NULL |
Contract Family
01=Regular 02=Temporary |
| 8 | COMMENTS | Long Character | CLOB | Comment |