EORC_TASK_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | TASK_ID | Character(18) | VARCHAR2(18) NOT NULL |
Task Identification
Prompt Table: EORC_TASKID_VW |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 6 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 7 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 8 | GL_RCM_TASKSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Task Status
E=Error N=Created P=Processed S=Submitted U=Updated |
| 9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 10 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 11 | FIELDUSEDAS | Character(2) | VARCHAR2(2) NOT NULL |
Field Used As
AO=As Of Date ED=Effective Date FD=From Date FP=From Period FY=From Year OP=Request Date Option PF=Process Frequency TD=To Date TP=To Period YF=From Year YT=To Year |
| 12 | OPTIONALDATE | Character(18) | VARCHAR2(18) NOT NULL | Optional Date Field |