SETIDPrompt Table: SET_VLD_HR_09
CNT_TEMPLATE_IDA=Active
I=Inactive
01=Regular
02=Temporary
CNT_TEMPL_VW1(SQL View) |
Index Back |
|---|---|
Contract Template ViewContract Template view is used to store display default Contract information |
| SELECT CT.SETID ,CT.CNT_TEMPLATE_ID ,CT.EFFDT ,CT.EFF_STATUS ,CT.DESCR ,CT.CONTRACT_FAMILY ,CT.CONTRACT_TYPE ,CT.COMMENTS FROM PS_CNT_TEMPLATE CT |
| # | 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 | CNT_TEMPLATE_ID |
Character(11) | VARCHAR2(11) NOT NULL | Contract Template ID |
| 3 | EFFDT_USED | Date(10) | DATE | Date driving 'processed' code |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | CONTRACT_FAMILY | Character(2) | VARCHAR2(2) NOT NULL |
Contract Family
01=Regular 02=Temporary |
| 7 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |
| 8 | COMMENTS | Long Character | CLOB | Comment |