TLOGPROCESS Table Definition Reference
Table B-3 TLOGPROCESS Table Definition Reference
| TLOGPROCESS Column | TLOGPROCESS Description |
|---|---|
| PARTITIONKEY | NUMBER(10,0) NOT NULL ENABLE |
| CATKEY | NUMBER(10,0) NOT NULL ENABLE |
| PERIODKEY | DATE NOT NULL ENABLE |
| RULE_ID | NUMBER(15,0) NOT NULL ENABLE |
| PROCESSIMP | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSIMPNOTE | VARCHAR2(50 CHAR) DEFAULT NULL, |
| PROCESSVAL | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSVALNOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSEXP | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSEXPNOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSENTLOAD | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSENTLOADNOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSENTVAL | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSENTVALNOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSCERT | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSCERTNOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSASSES | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSASSESNOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSCHILDDONE | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSCHILDDONENOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSUD1 | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSUD1NOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSUD2 | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSUD2NOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSUD3 | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSUD3NOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSUD4 | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| PROCESSUD4NOTE | VARCHAR2(50 CHAR) DEFAULT NULL |
| PROCESSENDTIME | DATE DEFAULT TO_DATE('01/01/1900', 'MM/DD/YYYY') NOT NULL ENABLE |
| BLNWCDIRTY | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| BLNLOGICDIRTY | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE |
| BLNVALDIRTY | NUMBER(1,0) DEFAULT 1 NOT NULL ENABLE |
| INTLOCKSTATE | NUMBER(6,0) DEFAULT 50 NOT NULL ENABLE |
| PROCESSSTATUS | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE |
| LOADID | NUMBER(15,0) |