SCC_TM_ITEM_IDSCC_TM_PTAITMVW(SQL View) |
Index Back |
|---|---|
Items View |
| SELECT ptai_item_id , ptai_list_id ,ptai_field1 FROM %Table(PTAI_ITEM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TM_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Item ID |
| 2 | SCC_TM_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Template ID |
| 3 | PTAI_FIELD1 | Character(100) | VARCHAR2(100) NOT NULL | PTAI_FIELD1 |