Table Detail Report

DM_REFCHG_PKW_PARM



Column 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_PK_WHERE__[1,2] functions. These values will be used to create the DM_CHG_LOG.PK_WHERE value.
Table Type: REFERENCE





Column Detail - DM_REFCHG_PKW_PARM


Column Name Type Null? Definition
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.


DM_REFCHG_PKW_VERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM REFCHG PKW VRS
Definition: Contains versions of RDDS PK_WHERE string for each table it tracks.
Table Type: REFERENCE





Column Detail - DM_REFCHG_PKW_VERS


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.
DM_REFCHG_PKW_VERS_ID DOUBLE N Unique identifier of table
PKW_FORMAT VARCHAR(1000) Y Format of what a RDDS PK_where should look like for an insert or update on the table_name.
TABLE_NAME VARCHAR(30) N Name of table that we are storing PK_where formats for.
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_PKW_VERS




Parent Column in DM_REFCHG_PKW_VERS (PK) Child Table Name Child Column Name
Children: DM_REFCHG_PKW_VERS_ID DM_CHG_LOG DM_REFCHG_PKW_VERS_ID


DM_REFCHG_PREFDIR_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Architecture Refchg Prefdir Data
Definition: Stores information used to correctly translate preferences that require custom logic
Table Type: REFERENCE





Column Detail - DM_REFCHG_PREFDIR_DATA


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.
DIST_NAME VARCHAR(2000) N Holds the reference string for the preference
DIST_NAME_SHORT VARCHAR(255) N Short version of DIST_NAME for building indexes on this field.
DM_REFCHG_PREFDIR_DATA_ID DOUBLE N Primary Key for table ( Sequence for PK will be controlled and shipped from Cerner - no sequence assigned )
ENTRY_DATA VARCHAR(2000) N Data associated to the DIST_NAME.
MERGE_ALG VARCHAR(10) N Holds the merge algorithm that should be used
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_PREFDIR_DATA




Parent Column in DM_REFCHG_PREFDIR_DATA (PK) Child Table Name Child Column Name
Children: DM_REFCHG_PREFDIR_DATA_ID DM_REFCHG_PREFDIR_DATA_EXCL DM_REFCHG_PREFDIR_DATA_ID


DM_REFCHG_PREFDIR_DATA_EXCL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Architecture Refchg Prefdir Data Exclusions
Definition: Stores information used to exclude certain overrides in DM_REFCHG_PREFDIR_DATA from certain preferences.
Table Type: REFERENCE





Column Detail - DM_REFCHG_PREFDIR_DATA_EXCL


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.
DIST_NAME_EXCLUDE VARCHAR(2000) N Holds the exclusion string
DM_REFCHG_PREFDIR_DATA_EXCL_ID DOUBLE N Primary Key for table. Does not use a standard Oracle sequence - Controlled and shipped from in-house (exception_flg = 1)
DM_REFCHG_PREFDIR_DATA_ID DOUBLE N Holds the reference back to the PK of the DM_REFCHG_PREFDIR_DATA Does not use a standard Oracle Sequence - Controlled and shipped from in-house (exception_flg = 1)
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_PREFDIR_DATA_EXCL


Child Column in DM_REFCHG_PREFDIR_DATA_EXCL(FK) Parent Table Name Parent Column Name
Parents: DM_REFCHG_PREFDIR_DATA_ID DM_REFCHG_PREFDIR_DATA DM_REFCHG_PREFDIR_DATA_ID


DM_REFCHG_PROCESS



Column Section Top of Page


Table-level Detail

Description: Data Management REFCHG Processes
Definition: This table will be used to track RDDS Processes
Table Type: ACTIVITY





Column Detail - DM_REFCHG_PROCESS


Column Name Type Null? Definition
DM_REFCHG_PROCESS_ID DOUBLE N Primary Key of table
ENV_SOURCE_ID DOUBLE N The source environment where the process is grabbing data from
LAST_ACTION_DT_TM DATETIME Y The last time/date that the process running hit a check point.
LOG_FILE VARCHAR(80) Y Log File of Process that is running
PROCESS_NAME VARCHAR(12) N Current Process value from V$Session
RDBHANDLE_VALUE DOUBLE N Current RDBHANDLE of session
REFCHG_STATUS VARCHAR(20) Y Status of Process. The status that the process is currently in (Starting, In Process, Finished, etc.)
REFCHG_TYPE VARCHAR(20) N The type of process that is being run (RDDS MOVER, RDDS CUTOVER, etc.)
SERIAL_NUMBER DOUBLE N SERIAL# from GV$SESSION for process
SESSION_SID DOUBLE N SID from GV$SESSION for process
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.