TLOGPROCESS Table Reference

The TLOGPROCESS table is used to store the workflow process status for a location, category, and period.

Table 74. TLOGPROCESS Table Reference

Column NameDefinitionDescription
PARTITIONKEYNUMBER(10,0) NOT NULL ENABLELocation key. Join to TPOVPARTITION to retrieve location information.
CATKEY NUMBER(10,0) NOT NULL ENABLECategory Key. Join to TPOVCATEGORY to retrieve category information.
PERIODKEY DATE NOT NULL ENABLEPeriod Key. Join to TPOVPERIOD to retrieve FDMEE to EPM period mapping details.
RULE_ID NUMBER(15,0) NOT NULL ENABLEData Rule ID. Join to AIF_BALANCE_RULES for details.
PROCESSIMP NUMBER(1,0) DEFAULT 0 NOT NULL ENABLEStatus for Import step:

  • 0=Not started or failed

  • 1=Successful

PROCESSIMPNOTE VARCHAR2(50 CHAR) DEFAULT NULLTextual note on Validate status:

  • Import Successful

  • Recalculated OK

  • Import Error

  • Recalculate Failed

  • MultiLoad

  • BypassDataLoad

  • Logic Calc Err

  • Map Calc Err

PROCESSVAL NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, Status for Validate step:

  • 0=Not started or failed

  • 1=Successful

PROCESSVALNOTE VARCHAR2(50 CHAR) DEFAULT NULL, Textual note on Validate step:

  • Validate Successful

  • Error= x records (Where X = how many members did not have map rules)

  • BypassDataLoad

PROCESSEXP NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE,Status for Export step:

  • 0=Not started or failed

  • 1=Successful

PROCESSEXPNOTE VARCHAR2(50 CHAR) DEFAULT NULLTextual note on Export step:

  • Last successful export

  • Export -B Successful

  • Export Successful

  • BypassDataLoad

PROCESSENTLOAD NUMBER(1,0) DEFAULT 0 NOT NULL ENABLEStatus for Load step:

  • 0=Not started or failed

  • 1=Successful

PROCESSENTLOADNOTE VARCHAR2(50 CHAR) DEFAULT NULLTextual note on Load status:

  • Time Date stamp for success

  • Load Error

  • BypassDataLoad

PROCESSENTVAL NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, Status for Check step:

  • 0=Not started or failed

  • 1=Successful

PROCESSENTVALNOTE VARCHAR2(50 CHAR) DEFAULT NULLTextual note on Check step:

  • Check Successful

  • Check Error

  • BypassDataLoad

PROCESSCERT NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, Status for Certification step:

  • 0=Not started or unsubmitted

  • 1=Submitted

PROCESSCERTNOTE VARCHAR2(50 CHAR) DEFAULT NULL, Textual note on Load status:

  • Controls Submitted

  • Controls Cleared

  • Not Submitted

  • No Controls Found for Profile

  • No Controls Group Assigned

  • Error Setting Status

PROCESSASSES NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, Status for Assessment (process explorer) step:

  • 0=Not started or unsubmitted

  • 1=Submitted

PROCESSASSESNOTE VARCHAR2(50 CHAR) DEFAULT NULL, Textual note on Load status:

  • Controls Submitted

  • Controls Cleared

  • Not Submitted

  • No Controls Found for Profile

  • No Controls Group Assigned

  • Error Setting Status

PROCESSCHILDDONE NUMBER(1,0) DEFAULT 0 NOT NULL ENABLEStatus for Certification status for parent locations step:

  • 0=Not started or all children not complete

  • 1=All children complete

PROCESSCHILDDONENOTE VARCHAR2(50 CHAR) DEFAULT NULLTextual note on Certification status for parent location:

  • Children Submitted

  • No Children

PROCESSUD1 NUMBER(1,0) DEFAULT 0 NOT NULL ENABLENot used
PROCESSUD1NOTE VARCHAR2(50 CHAR) DEFAULT NULLNot used
PROCESSUD2 NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Not used
PROCESSUD2NOTE VARCHAR2(50 CHAR) DEFAULT NULLNot used
PROCESSUD3 NUMBER(1,0) DEFAULT 0 NOT NULL ENABLENot used
PROCESSUD3NOTE VARCHAR2(50 CHAR) DEFAULT NULLNot used
PROCESSUD4 NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Not used
PROCESSUD4NOTE VARCHAR2(50 CHAR) DEFAULT NULLNot used
PROCESSENDTIME DATE DEFAULT TO_DATE('01/01/1900', 'MM/DD/YYYY') NOT NULL ENABLELast update time/date
BLNWCDIRTY NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Flag used to indicate that maps (WC = WildCard) must be recalculated prior to validating:

  • 0=OK

  • 1=Re-caculate location

Map rules have changed after data was imported. This causes the Calculate flag to be displayed
BLNLOGICDIRTY NUMBER(1,0) DEFAULT 0 NOT NULL ENABLEFlag used to indicate the LOGIC must be recalculated prior to validating
BLNVALDIRTY NUMBER(1,0) DEFAULT 1 NOT NULL ENABLE Flag used to indicate when Validation workflow should be re-run:

  • 0=OK

  • 1=re-process validations

Map rules have changed after data was imported. This causes the Calculate flag to be displayed.
INTLOCKSTATE NUMBER(6,0) DEFAULT 50 NOT NULL ENABLELocation POV lock status:

  • 50=open

  • 60=locked

PROCESSSTATUS NUMBER(10,0) DEFAULT 0 NOT NULL ENABLECurrent state of workflow for location/category/per. Valid status from tLogProcessStates