TLOGPROCESS Table Definition Reference

Table B-3 TLOGPROCESS Table Definition Reference

TLOGPROCESS Column TLOGPROCESS 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 FDMEE 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 LogProcessStates
LOADID NUMBER(15,0)

Load ID.