FP_CNT_TYP_SETIDFP_CNTTYP_SETID(SQL View) |
Index Back |
|---|---|
Contract Type Setid View |
| SELECT DISTINCT SETID , CONTRACT_TYPE FROM PS_PERS_CNTRCT_TYP WHERE EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FP_CNT_TYP_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Setid field for contract type |
| 2 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |