PROCESS_INSTANCEA=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
GL_ESS_LOAD_AET(SQL Table) |
Index Back |
|---|---|
GL_ESS_LOAD State RecordGL_ESS_LOAD State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | RUN_CNTL_ID2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 6 | REQUEST_CTR | Number(4,0) | SMALLINT NOT NULL | Request Number counter |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 9 | CUB_OUTLINEID | Character(30) | VARCHAR2(30) NOT NULL | Outline Name (see PSCUBOUTLINE). |
| 10 | CUB_CONNECTID | Character(30) | VARCHAR2(30) NOT NULL | Essbase Connection ID (see PSCUBCONNECTID). |
| 11 | CUB_LOGLEVEL | Number(3,0) | SMALLINT NOT NULL | Log level |
| 12 | ANALYSIS_DB_APP | Character(8) | VARCHAR2(8) NOT NULL | Application Name |
| 13 | ANALYSIS_DB_NAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 14 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 15 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 16 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 17 | DTTM_FROM | DateTime(26) | TIMESTAMP | From Date/Time |
| 18 | RQSTDTTM | DateTime(26) | TIMESTAMP | Request Date/Time |
| 19 | DTTM_TO | DateTime(26) | TIMESTAMP | To Date/Time |
| 20 | GL_ESS_LOAD_INCR | Character(1) | VARCHAR2(1) NOT NULL | Incremental Load |
| 21 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 22 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 23 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 24 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 25 | SKIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Skip Flag |
| 26 | SQL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | SQL Text |
| 27 | ROWCOUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | Row Count |