TASK_IDOPRIDE=Error
N=Created
P=Processed
S=Submitted
U=Updated
Default Value: N
EORC_TASK_H(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TASK_ID |
Number(15,0) | DECIMAL(15) NOT NULL | TaskIID field. Key for RB_TSK record. Used by Task Management. |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | GL_RCM_TASKSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Task Status
E=Error N=Created P=Processed S=Submitted U=Updated Default Value: N |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | DATETIME_CREATED | DateTime(26) | TIMESTAMP | DateTime Created |
| 7 | DATETIME_UPDATED | DateTime(26) | TIMESTAMP | DateTime Updated |