SCC_TM_ITEM_ID0=Not Assigned
1=Assigned
2=In Progress
3=On Hold
4=Completed
5=Cancelled
SCC_TM_PTAIITEM(SQL View) |
Index Back |
|---|---|
ptai item view |
| SELECT ptai_item_id , ptai_list_id , ptai_label , ptai_descrlong , ptai_status , PTAI_SEQ , ptai_due_date , ptai_start_dt , ptai_origin_id ,ptai_summary , last_update_dttm , lastupdoprid , createoprid , created_dttm 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 | SCC_TM_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Title |
| 4 | SCC_TM_DESCRLONG | Long Character | CLOB | Description |
| 5 | SCC_TM_PTAI_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
0=Not Assigned 1=Assigned 2=In Progress 3=On Hold 4=Completed 5=Cancelled |
| 6 | SCC_TM_PTAI_SEQ | Number(4,0) | SMALLINT NOT NULL | Sequence |
| 7 | SCC_TM_DUE_DATE | Date(10) | DATE | Due Date |
| 8 | SCC_TM_START_DATE | Date(10) | DATE | Start Date |
| 9 | SCC_TM_ORIGIN_ID | Character(31) | VARCHAR2(31) NOT NULL | Origin Item ID |
| 10 | SCC_TM_PTAI_SUMARY | Character(1) | VARCHAR2(1) NOT NULL | Summary |
| 11 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 12 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 13 | CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 14 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Datetime |