PTIAAUOBJMRG_VW(SQL View) |
Index Back |
|---|
| SELECT PTIASPLOOKUPCODE , PTIASPINTVALUE , DESCR254 FROM PS_PTIASPINTCODES WHERE PTIASPLOOKUPCODE = 'OBJTYPE' AND PTIASPINTVALUE IN (8, 9,30, 39, 40, 41, 42, 43, 44, 45,46, 47, 48, 58 , 62, 66 ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPLOOKUPCODE | Character(15) | VARCHAR2(15) NOT NULL | Lookup |
| 2 | PTIASPINTVALUE | Number(3,0) | SMALLINT NOT NULL | Value |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |