PTAI_LISTCTX_VW(SQL View) |
Index Back |
---|
SELECT PTAI_LIST_ID , FIELDNAME FROM %Table(PTAI_CONTEXT) WHERE FIELDNAME<>'PTAIFIELD' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |