EORD_TASK_TMP(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 | EORD_DEL_SET | Character(18) | VARCHAR2(18) NOT NULL | Delete Request |
| 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 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 11 | EORD_DELOPT | Character(1) | VARCHAR2(1) NOT NULL |
Delete Option
C=Complete Delete P=Partial Delete |
| 12 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 13 | 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 |
| 14 | OPTIONALDATE | Character(18) | VARCHAR2(18) NOT NULL | Optional Date Field |
| 15 | SQLROWS_LNS2 | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 16 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 17 | DELETE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Deletion Flag |