Table Detail Report

DRR_RESTRICT_LOG



Column Section Top of Page


Table-level Detail

Description: DRR_RESTRICT_LOG
Definition: Activity table that stores DRR Restrict/delete_restrict DML statement for persons. It will use drr_table_stmt/drr_custom_plsql to gernate dml statements for persons in dm_process_queue
Table Type: ACTIVITY





Column Detail - DRR_RESTRICT_LOG


Column Name Type Null? Definition
AUDIT_COUNT DOUBLE Y store number of rows found during audit
AUDIT_DURATION DOUBLE Y store how long audit takes from start to complete or fail in seconds
AUDIT_END_DT_TM DATETIME Y ending audit datetime
AUDIT_START_DT_TM DATETIME Y starting audit datetime
AUDIT_STATUS VARCHAR(50) Y store audit status like IN PROCESS, SUCCESS, FAILED
CHILD_COL_STR VARCHAR(200) Y child column names
CHILD_TABLE VARCHAR(30) Y child table name
COLUMN_LIST LONGTEXT Y A CLOB field containing the column list
CUSTOM_PLSQL_IND DOUBLE N indicator for custom restrict type. 1 - zero type. 2 - custom pl/sql inserted by solution team
CUST_RESTRICT_STMT VARCHAR(200) Y statement execute for custom restrict
DRR_CHILD_TABLE VARCHAR(30) Y drr shadow child table name
DRR_IDENT_ID DOUBLE Y Unique sequence generated to identify each person being restricted. In combine scenario, one unique value is used for both combined away person and the combined to person.
DRR_PARENT_TABLE VARCHAR(30) Y drr shadow parent table name
DRR_PROCESS_PLAN_ID DOUBLE N drr_process_plan_id generated on DRR_PROCESS_PLAN table.
DRR_RESTRICT_LOG_ID DOUBLE N PRIMARY KEY.
DRR_ZERO_RESTORE_IND DOUBLE Y indicator use for ZERO type. 1 - Unrestrict restore column value. 0 - Unrestrict not restore column value
ERROR_MSG VARCHAR(4000) Y store error message
PARENT_TABLE VARCHAR(30) Y parent table name
PAR_COL_STR VARCHAR(200) Y parent column names
PERSON_ID DOUBLE N person ID being restricted.
PRIMARY_PERSON_ID DOUBLE Y When person_id column stores combined away person, this column will store the final combined to person_id. In other cases, primary_person_id will be same as person_id.
RESTRICT_COUNT DOUBLE Y store number of rows being restricted
RESTRICT_DUP_IND DOUBLE N indicator for duplicate restrict statements
RESTRICT_DURATION DOUBLE Y store how long audit takes from start to complete or fail in seconds
RESTRICT_END_DT_TM DATETIME Y ending restrict datetime
RESTRICT_ORDER DOUBLE Y restrict execution order
RESTRICT_START_DT_TM DATETIME Y starting restrict datetime
RESTRICT_STATUS VARCHAR(50) Y like NOT STARTED, IN PROCESS, COMPLETED
RESTRICT_STMT VARCHAR(4000) Y statement execute for restrict
RETRY_COUNT DOUBLE Y number of times retried
SELECT_STMT VARCHAR(4000) Y statement execute for audit
SESSIONID DOUBLE Y store process sessionid to_number(sys_context('USERENV','SESSIONID'))
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


DRR_TABLE_STMT



Column Section Top of Page


Table-level Detail

Description: DRR_TABLE_STMT
Definition: Reference table to store DRR statement for domain specific schema. It is populated from metadata stored in dm_table_relationships
Table Type: ACTIVITY





Column Detail - DRR_TABLE_STMT


Column Name Type Null? Definition
CHILD_COL_STR VARCHAR(200) Y CHILD COLUMN NAMES
CHILD_TABLE VARCHAR(30) Y child table name
CUSTOM_PLSQL_IND DOUBLE N indicator for custom pl/sql. 1 - custom zero type, 2 -custom pl/sql written by solution team
DELETE_DUP_IND DOUBLE N indicator for duplicate delete statements. 1 - duplicate not execute , 0 - not duplicate execute
DELETE_ORDER DOUBLE Y store delete execution order
DELETE_STMT VARCHAR(4000) Y store statement for delete process
DRR_CHILD_TABLE VARCHAR(30) Y drr shadow child table name
DRR_PARENT_TABLE VARCHAR(30) Y drr shadow parent table name
DRR_TABLE_STMT_ID DOUBLE N PRIMARY KEY.
DRR_ZERO_RESTORE_IND DOUBLE Y when custom_plsql_ind set to 1, this is populated with 1 or 0. 1 - Unrestrict restore column value, 0 - Unrestrict not restore column value
HIER_LEVEL DOUBLE Y relationship hierarchy level
HIER_PATH VARCHAR(2000) Y relationship hierarchy path
PARENT_TABLE VARCHAR(30) Y parent table name
PAR_COL_STR VARCHAR(200) Y parent column names
RESTRICT_DUP_IND DOUBLE N indicator for duplicate restrict statements. 1 - duplicate not execute , 0 - not duplicate execute
RESTRICT_ORDER DOUBLE Y store restrict execution order
RESTRICT_STMT VARCHAR(4000) Y store statement used for restrict process
SELECT_STMT VARCHAR(4000) Y store statement for audit process
UNRESTRICT_DUP_IND DOUBLE N indicator for duplicate unrestrict statements. 1 - duplicate not execute , 0 - not duplicate execute
UNRESTRICT_ORDER DOUBLE Y store unrestrict execution order
UNRESTRICT_STMT VARCHAR(4000) Y store statement used for unrestrict process
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


DRR_TABLE_STMT_STG



Column Section Top of Page


Table-level Detail

Description: DRR TABLE STATEMENT STAGING
Definition: Stage table used to facilitate loading table DRR_TABLE_STMT
Table Type: ACTIVITY





Column Detail - DRR_TABLE_STMT_STG


Column Name Type Null? Definition
CHILD_COL_STR VARCHAR(200) Y See colmn definition for table DRR_TABLE_STMT
CHILD_TABLE VARCHAR(30) Y See colmn definition for table DRR_TABLE_STMT
CUSTOM_PLSQL_IND DOUBLE N See colmn definition for table DRR_TABLE_STMT
DELETE_DUP_IND DOUBLE N See colmn definition for table DRR_TABLE_STMT
DELETE_ORDER DOUBLE Y See colmn definition for table DRR_TABLE_STMT
DELETE_STMT VARCHAR(4000) Y See colmn definition for table DRR_TABLE_STMT
DRR_CHILD_TABLE VARCHAR(30) Y See colmn definition for table DRR_TABLE_STMT
DRR_PARENT_TABLE VARCHAR(30) Y See colmn definition for table DRR_TABLE_STMT
DRR_TABLE_STMT_ID DOUBLE N PRIMARY KEY
DRR_ZERO_RESTORE_IND DOUBLE Y See colmn definition for table DRR_TABLE_STMT
HIER_LEVEL DOUBLE Y See colmn definition for table DRR_TABLE_STMT
HIER_PATH VARCHAR(2000) Y See colmn definition for table DRR_TABLE_STMT
PARENT_TABLE VARCHAR(30) Y See colmn definition for table DRR_TABLE_STMT
PAR_COL_STR VARCHAR(200) Y See colmn definition for table DRR_TABLE_STMT
RESTRICT_DUP_IND DOUBLE N See colmn definition for table DRR_TABLE_STMT
RESTRICT_ORDER DOUBLE Y See colmn definition for table DRR_TABLE_STMT
RESTRICT_STMT VARCHAR(4000) Y See colmn definition for table DRR_TABLE_STMT
SELECT_STMT VARCHAR(4000) Y See colmn definition for table DRR_TABLE_STMT
UNRESTRICT_DUP_IND DOUBLE N See colmn definition for table DRR_TABLE_STMT
UNRESTRICT_ORDER DOUBLE Y See colmn definition for table DRR_TABLE_STMT
UNRESTRICT_STMT VARCHAR(4000) Y See colmn definition for table DRR_TABLE_STMT
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


DRR_UNRESTRICT_LOG



Column Section Top of Page


Table-level Detail

Description: DRR_UNRESTRICT_LOG
Definition: Activity table that stores DRR Unrestrict DML statement for persons. It will use drr_table_stmt/drr_custom_plsql to gernate dml statements for persons in dm_process_queue
Table Type: ACTIVITY





Column Detail - DRR_UNRESTRICT_LOG


Column Name Type Null? Definition
AUDIT_COUNT DOUBLE Y store number of rows found during audit
AUDIT_DURATION DOUBLE Y store how long audit takes from start to complete or fail in seconds
AUDIT_END_DT_TM DATETIME Y ending audit datetime
AUDIT_START_DT_TM DATETIME Y starting audit datetime
AUDIT_STATUS VARCHAR(50) Y store audit status like IN PROCESS, SUCCESS, FAILED
CHILD_COL_STR VARCHAR(200) Y child column names
CHILD_TABLE VARCHAR(30) Y child table name
CUSTOM_PLSQL_IND DOUBLE N indicator for custom unrestrict type. 1 - zero type. 2 - custom pl/sql inserted by solution team
CUST_UNRESTRICT_STMT VARCHAR(200) Y statement execute for custom unrestrict
DRR_CHILD_TABLE VARCHAR(30) Y drr shadow child table name
DRR_IDENT_ID DOUBLE Y Unique sequence generated to identify each person being restricted. In combine scenario, one unique value is used for both combined away person and the combined to person.
DRR_PARENT_TABLE VARCHAR(30) Y drr shadow parent table name
DRR_PROCESS_PLAN_ID DOUBLE N drr_process_plan_id generated for unrestrict on DRR_PROCESS_PLAN table.
DRR_RESTRICT_PLAN_ID DOUBLE N drr_process_plan_id generated for restrict on DRR_PROCESS_PLAN table.
DRR_UNRESTRICT_LOG_ID DOUBLE N PRIMARY KEY.
ERROR_MSG VARCHAR(4000) Y store error message
PARENT_TABLE VARCHAR(30) Y parent table name
PAR_COL_STR VARCHAR(200) Y parent column names
PERSON_ID DOUBLE N person_id being unrestricted.
PRIMARY_PERSON_ID DOUBLE Y When person_id column stores combined away person, this column will store the final combined to person_id. In other cases, primary_person_id will be same as person_id.
RETRY_COUNT DOUBLE Y number of times retried
SELECT_STMT VARCHAR(4000) Y statement execute for audit
SESSIONID DOUBLE Y store process sessionid to_number(sys_context('USERENV','SESSIONID'))
UNRESTRICT_COUNT DOUBLE Y store number of rows being unrestricted
UNRESTRICT_DURATION DOUBLE Y store how long audit takes from start to complete or fail in seconds
UNRESTRICT_END_DT_TM DATETIME Y ending unrestrict datetime
UNRESTRICT_ORDER DOUBLE Y unrestrict execution order
UNRESTRICT_START_DT_TM DATETIME Y starting unrestrict datetime
UNRESTRICT_STATUS VARCHAR(50) Y store unrestrict status like IN PROCESS, SUCCESS, FAILED
UNRESTRICT_STMT VARCHAR(4000) Y statement execute for unrestrict
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.