1. Administrator's Guide
  2. Report Query Table Reference
  3. TLOGPROCESS Table Reference

TLOGPROCESS Table Reference

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

Table G-2 TLOGPROCESS Table Reference

Column Name Definition Description
PARTITIONKEY NUMBER(10,0) NOT NULL ENABLE Location key. Join to TPOVPARTITION to retrieve location information.
CATKEY NUMBER(10,0) NOT NULL ENABLE Category Key. Join to TPOVCATEGORY to retrieve category information.
PERIODKEY DATE NOT NULL ENABLE Period Key. Join to TPOVPERIOD to retrieve Oracle Hyperion Financial Data Quality Management, Enterprise Edition to EPM period mapping details.
RULE_ID NUMBER(15,0) NOT NULL ENABLE Data Rule ID. Join to AIF_BALANCE_RULES for details.
PROCESSIMP NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Status for Import step:

  • 0=Not started or failed

  • 1=Successful
PROCESSIMPNOTE VARCHAR2(50 CHAR) DEFAULT NULL Textual 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 NULL Textual note on Export step:

  • Last successful export

  • Export -B Successful

  • Export Successful

  • BypassDataLoad
PROCESSENTLOAD NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Status for Load step:

  • 0=Not started or failed

  • 1=Successful
PROCESSENTLOADNOTE VARCHAR2(50 CHAR) DEFAULT NULL Textual 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 NULL Textual 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 ENABLE Status for Certification status for parent locations step:

  • 0=Not started or all children not complete

  • 1=All children complete
PROCESSCHILDDONENOTE VARCHAR2(50 CHAR) DEFAULT NULL Textual note on Certification status for parent location:

  • Children Submitted

  • No Children
PROCESSUD1 NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Not used
PROCESSUD1NOTE VARCHAR2(50 CHAR) DEFAULT NULL Not used
PROCESSUD2 NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Not used
PROCESSUD2NOTE VARCHAR2(50 CHAR) DEFAULT NULL Not used
PROCESSUD3 NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Not used
PROCESSUD3NOTE VARCHAR2(50 CHAR) DEFAULT NULL Not used
PROCESSUD4 NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE Not used
PROCESSUD4NOTE VARCHAR2(50 CHAR) DEFAULT NULL Not used
PROCESSENDTIME DATE DEFAULT TO_DATE('01/01/1900', 'MM/DD/YYYY') NOT NULL ENABLE Last 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 ENABLE Flag 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 must 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 ENABLE Location POV lock status:

  • 50=open

  • 60=locked
PROCESSSTATUS NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE Current state of workflow for location/category/per. Valid status from tLogProcessStates