CAL_RUN_IDPTAI_LIST_IDPTAI_ITEM_ID0=Not Assigned
1=Assigned
2=In Progress
4=Completed
N=No
Y=Yes
N=No
Y=Yes
GP_WC_AG_TBL(SQL Table) |
Index Back |
|---|---|
GP WorkcenterGP Workcenter - Activity Guide |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | PTAI_LIST_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
| 3 | PTAI_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | PTAI_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Action Items - Label |
| 6 | GP_WC_PTAI_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Action Items - Status
0=Not Assigned 1=Assigned 2=In Progress 4=Completed |
| 7 | PTAI_PERC_COMPL | Number(3,0) | SMALLINT NOT NULL | Percent Complete |
| 8 | PTAI_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Required
N=No Y=Yes |
| 9 | PTAI_SEQ | Number(4,0) | SMALLINT NOT NULL | Sequence |
| 10 | PTAI_SUMMARY | Character(1) | VARCHAR2(1) NOT NULL |
Summary
N=No Y=Yes |
| 11 | PTAI_ITEM_ID_COPY | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 12 | PTCS_SERVICEID | Character(30) | VARCHAR2(30) NOT NULL | Services ID (see PSPTCSSRVDEFN). |
| 13 | URLS | Long Character(2000) | VARCHAR2(2000) | URLs |
| 14 | COMMENTS | Long Character | CLOB | Comment |
| 15 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |