Table B-3 TLOGPROCESS-Tabellendefinitionsreferenz
TLOGPROCESS-Spalte | TLOGPROCESS-Beschreibung |
---|---|
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) |