Table Detail Report

DM_REFCHG_FILTER_PARM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management reference change PK where function parameters
Definition: Stores the parameters which will be used in the REFCHG_FILTER__[1,2] functions. These values will be used to determine whether a row needs to be logged in DM_CHG_LOG.
Table Type: REFERENCE





Column Detail - DM_REFCHG_FILTER_PARM


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
COLUMN_NAME VARCHAR(30) N Name of the column that needs to be passed into the REFCHG_PK_WHERE* function.
PARM_NBR DOUBLE N Order that this column needs to be placed when call the REFCHG_PK_WHERE* function.
TABLE_NAME VARCHAR(30) N Name of the table which has a filter requirement on it.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DM_REFCHG_FILTER_PARM


Child Column in DM_REFCHG_FILTER_PARM(FK) Parent Table Name Parent Column Name
Parents: TABLE_NAME DM_REFCHG_FILTER TABLE_NAME


DM_REFCHG_FILTER_TEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management reference change filter tests
Definition: Stores the various tests that should be performed to see if a row for the given table should be recorded for RDDS. The tests could be simple comparison (like = 0 or in ('A','B','C') ) or it could be a statement - usually a Select.
Table Type: REFERENCE





Column Detail - DM_REFCHG_FILTER_TEST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
MOVER_STRING VARCHAR(1000) N A filter string the mover uses when interacting with the table.
STATEMENT_IND DOUBLE N Indicates if this test is a statement like a Select.
TABLE_NAME VARCHAR(30) N Name of the table which has a filter requirement on it.
TEST_NBR DOUBLE N Sequence number for PK
TEST_STR VARCHAR(2000) N Testing text to be used for filtering. Input variable will have :: around them.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DM_REFCHG_FILTER_TEST


Child Column in DM_REFCHG_FILTER_TEST(FK) Parent Table Name Parent Column Name
Parents: TABLE_NAME DM_REFCHG_FILTER TABLE_NAME


DM_REFCHG_INSTRUCTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Management Reference Change Instruction
Definition: This table will store instructions to aid in the RDDS process
Table Type: REFERENCE





Column Detail - DM_REFCHG_INSTRUCTION


Column Name Type Null? Definition
AUTHORIZED_IND DOUBLE N Indicates if the instruction was reviewed/tested by Cerner
DESCRIPTION VARCHAR(500) N Holds the description of what instruction does
DM_REFCHG_INSTRUCTION_ID DOUBLE N Primary Key for table
INSTRUCTION_TEXT_ID DOUBLE N Points to the LONG_TEXT_ID holding the instruction
INS_MEANING VARCHAR(50) N Name of instruction, and alternate key
RUN_ORDER DOUBLE Y Indicates the order in which instructions should run within a given run time.
RUN_TIME_FLAG DOUBLE N Indicates when the instruction runs
TABLE_NAME VARCHAR(30) Y Holds what table name is affected by instruction. Can be blank
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DM_REFCHG_INSTRUCTION


Child Column in DM_REFCHG_INSTRUCTION(FK) Parent Table Name Parent Column Name
Parents: INSTRUCTION_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


DM_REFCHG_INVALID_XLAT



Column Section Top of Page


Table-level Detail

Description: Database Management REFCHG Invalid Translations table
Definition: Table for RDDS to track deleted reference values
Table Type: REFERENCE





Column Detail - DM_REFCHG_INVALID_XLAT


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N Primary Key ID of the row deleted from table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Name of the table that had a row deleted.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


DM_REFCHG_OBJECT_CHECK



Column Section Top of Page


Table-level Detail

Description: Data Management reference change object checks
Definition: Stores the various dependency checks that should be performed to see if a pl/sql object is able to be compiled
Table Type: REFERENCE





Column Detail - DM_REFCHG_OBJECT_CHECK


Column Name Type Null? Definition
CHECK_COLUMN VARCHAR(30) N Represents the column name to check for
CHECK_TABLE VARCHAR(30) N Represents the table name to check for
DM_REFCHG_OBJECT_CHECK_ID DOUBLE N Primary Key for table
OBJECT_NAME VARCHAR(30) N Contains Object name to run checks on
OBJECT_NBR DOUBLE N Contest object number to run checks on
OBJECT_TYPE VARCHAR(30) N Displays the type of pl/sql object to check
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.