DM_ADS_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_ACTIVITY_DATA_SAMPLER_CONFIGURATION
Definition: Stores a client specific sampling configuration by name.
Table Type: ACTIVITY





Column Detail - DM_ADS_CONFIG


Column Name Type Null? Definition
CONFIG_NAME VARCHAR(120) N Client supplied name (AK1)
CONFIG_STATUS VARCHAR(30) Y The status of the Client's sample configuration. Valid values = COMPLETE, NEEDSBUILD, FAILED, INCOMPLETE, EXECUTING
DM_ADS_CONFIG_ID DOUBLE N Unique Identifier. Sequence based unique identifier for table.
SAMPLE_METHOD VARCHAR(30) Y The sampling method for the Clients sample configuration. Valid values are: RECENT, EVERYNTH, CUSTOM
SAMPLE_PERCENT_NBR DOUBLE Y The sampling percent for the client's sample configuration. Valid values are (.01 - 100).
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_ADS_CONFIG




Parent Column in DM_ADS_CONFIG (PK) Child Table Name Child Column Name
Children: DM_ADS_CONFIG_ID DM_ADS_CONFIG_DRIVER DM_ADS_CONFIG_ID
DM_ADS_CONFIG_EXTRACT DM_ADS_CONFIG_ID


DM_ADS_CONFIG_DRIVER



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_ACTIVITY_DATA_SAMPLER_CONFIGURATION_DRIVER
Definition: Stores the driver keys for a client sample configuration. These driver keys control what data is replicated for the driver tables. All other activity tables will build on top of the driver table sample.
Table Type: ACTIVITY





Column Detail - DM_ADS_CONFIG_DRIVER


Column Name Type Null? Definition
CUSTOM_IND DOUBLE Y Indicates the driver key was manually loaded by a client (vs. being auto-generated)
DM_ADS_CONFIG_DRIVER_ID DOUBLE N Unique Identifier. Sequence based unique identifier for table.
DM_ADS_CONFIG_ID DOUBLE N Config_id the driver key belongs to.
DM_ADS_EXTRACT_ID DOUBLE N The extract_id (driver_table) the driver_key belongs to
DRIVER_KEY_ID DOUBLE N The key for the driver table (e.g. person_id for person, product_id for product). dm_ads_extract_id (back to dm_ads_extract) gives a mapping back to what type of driver_key_id it is. (e.g. dm_ads_extract, extract_id=5, table_name = PERSON, driver_keycol_name = PERSON_ID).
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_ADS_CONFIG_DRIVER


Child Column in DM_ADS_CONFIG_DRIVER(FK) Parent Table Name Parent Column Name
Parents: DM_ADS_CONFIG_ID DM_ADS_CONFIG DM_ADS_CONFIG_ID
DM_ADS_EXTRACT_ID DM_ADS_EXTRACT DM_ADS_EXTRACT_ID


DM_ADS_CONFIG_EXTRACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_ACTIVITY_DATA_SAMPLER_CONFIGURATION_EXTRACT
Definition: Stores the result of a driver key generation process initiated for an ADS config (client defined method/pct).
Table Type: ACTIVITY





Column Detail - DM_ADS_CONFIG_EXTRACT


Column Name Type Null? Definition
BEGIN_DT_TM DATETIME Y The date/time the driver key generation process started for the driver table.
DM_ADS_CONFIG_EXTRACT_ID DOUBLE N Unique Identifier. Sequence based unique identifier for table.
DM_ADS_CONFIG_ID DOUBLE N Config_id for the driver_table
DM_ADS_EXTRACT_ID DOUBLE N Extract_id for the driver table
DM_PROCESS_QUEUE_ID DOUBLE N The related id from DM_PROCESS_QUEUE row that the driver key generation process also generated for the driver table.
END_DT_TM DATETIME Y The date/time the driver key generation process ended for the driver table.
MESSAGE_TXT VARCHAR(4000) Y Holds any error messages that may have occurred from the driver key generation process.
ROW_SAMPLE_NBR DOUBLE Y The number of sample keys generated.
STATUS_TXT VARCHAR(15) Y The status of the driver key generation process for the driver key extract.
TARGET_SAMPLE_METHOD VARCHAR(30) Y The client requested sample method for the driver table (RECENT | EVERYNTH | CUSTOM)
TARGET_SAMPLE_PERCENT_NBR DOUBLE Y The client requested sample percent when the driver table keys were last generated.
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_ADS_CONFIG_EXTRACT


Child Column in DM_ADS_CONFIG_EXTRACT(FK) Parent Table Name Parent Column Name
Parents: DM_ADS_CONFIG_ID DM_ADS_CONFIG DM_ADS_CONFIG_ID
DM_ADS_EXTRACT_ID DM_ADS_EXTRACT DM_ADS_EXTRACT_ID
DM_PROCESS_QUEUE_ID DM_PROCESS_QUEUE DM_PROCESS_QUEUE_ID


DM_ADS_EXTRACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_ACTIVITY_DATA_SAMPLER - Extract
Definition: Stores how data should be replicated, with particular focus on how activity tables are related to each other and the queries used to replicate a referentially intact set of activity data based on a client supplied set of keys for driver level tables.
Table Type: ACTIVITY





Column Detail - DM_ADS_EXTRACT


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.
APPLY_WHERE_IND DOUBLE Y Indicates if the where_clause will be performed during an ADS replicate. Should be set to 1 when: Extract_method in 'BYCONFIG','STATIC'
DATA_CLASS_TYPE VARCHAR(30) Y Indicates the type of extract, values: ACTIVITY, ACTIVITY-MIXED, MIXED, REFERENCE, REFERENCE-MIXED
DM_ADS_EXTRACT_ID DOUBLE N Unique Identifier. Sequence based unique identifier for table.
DRIVER_KEYCOL_NAME VARCHAR(30) Y There driver column name used to retrieve the sample keys.
DRIVER_RANKCOL_NAME VARCHAR(30) Y The column by which columns should be ranked. Future use, in case the config_method of CURRENT is chosen and we want to rank on a column that is not the unique key for the table. (e.g. Get Current person_ids by highest updt_dt_tm vs. by highest person_id).
DRIVER_TABLE_IND DOUBLE Y Indicates if the table is an Activity driver table.
DRIVER_TABLE_NAME VARCHAR(30) Y The Ultimate driver parent table name for the extract. For activity data, it will be a table in this table where driver_table_ind =1. For reference data, this field will be null. For Activity extracts where the extract_method = ALL, the driver table may be also be blank (if increasing driver keys cannot impact the data for the extract).
DUPDEL_SKIP_IND DOUBLE Y Dupe Delete. - Indicate where we may not want to perform a duplicate row cleanup for tables with multiple extracts.
EXPIMP_LEVEL_NBR DOUBLE Y The logical order/level/priority in which the extract should be performed, such that any and all parent tables are extracted to ensure data is properly extracted.
EXPIMP_PARENT_TABLE_NAME VARCHAR(30) Y The table's immediate parent table on which the extract is driven.
EXTRACT_METHOD VARCHAR(30) Y Indicates the method of extraction during replicates:ALL: The entire table is moved. BYCONFIG: The table is moved by the clients specified configuration method and pct values (Clients will have METHODs of RECENT, EVERYNTH) and can specify how much activity data to move by pct (10%, 20% etc.). Typically, this means the where clause for this will reference the immediate parent table. EVERYNTHPCT: The table will sample every nth row based on the client's configuration pct. These are typicall
OWNER_NAME VARCHAR(30) N Owner of the table being extracted
TABLE_COMMENT VARCHAR(2000) Y Any information useful to describe / document how the extract is related to the Millennium data model. May be used by Cerner support organizations to better understand, use the data for clients.
TABLE_EXTRACT_INSTANCE_NBR DOUBLE N Instance/Version of the extract for a table (in case we want to ship multiple versions that can be active).
TABLE_EXTRACT_NBR DOUBLE N Extract number for a table
TABLE_NAME VARCHAR(30) N Table being extracted
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.
WHERE_CLAUSE VARCHAR(4000) Y The where_clause the extract will use to get the intended data, either for an activity based sample, referenced-mixed data,etc..



Relationship Detail - DM_ADS_EXTRACT




Parent Column in DM_ADS_EXTRACT (PK) Child Table Name Child Column Name
Children: DM_ADS_EXTRACT_ID DM_ADS_CONFIG_DRIVER DM_ADS_EXTRACT_ID
DM_ADS_CONFIG_EXTRACT DM_ADS_EXTRACT_ID


DM_ADS_EXTRACT_GTTP



Column Section Top of Page


Table-level Detail

Description: ACTIVITY DATA SAMPLER EXTRACT - GLOBAL TEMP TABLE
Definition: GLOBAL TEMPORARY TABLE FOR ADS EXTRACT
Table Type: ACTIVITY





Column Detail - DM_ADS_EXTRACT_GTTP


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.
APPLY_WHERE_IND DOUBLE Y Indicates if the where_clause will be performed during an ADS replicate. Should be set to 1 when: Extract_method in 'BYCONFIG','STATIC'
DATA_CLASS_TYPE VARCHAR(30) Y Indicates the type of extract, values: ACTIVITY, ACTIVITY-MIXED, MIXED, REFERENCE, REFERENCE-MIXED
DM_ADS_EXTRACT_ID DOUBLE N Sequence based unique identifier for table.
DRIVER_KEYCOL_NAME VARCHAR(30) Y There driver column name used to retrieve the sample keys.
DRIVER_RANKCOL_NAME VARCHAR(30) Y The column by which columns should be ranked. Future use, in case the config_method of CURRENT is chosen and we want to rank on a column that is not the unique key for the table. (e.g. Get Current person_ids by highest updt_dt_tm vs. by highest person_id).
DRIVER_TABLE_IND DOUBLE Y Indicates if the table is an Activity driver table.
DRIVER_TABLE_NAME VARCHAR(30) Y The Ultimate driver parent table name for the extract. For activity data, it will be a table in this table where driver_table_ind =1. For reference data, this field will be null. For Activity extracts where the extract_method = ALL, the driver table may be also be blank (if increasing driver keys cannot impact the data for the extract).
DUPDEL_SKIP_IND DOUBLE Y Dupe Delete. - Indicate where we may not want to perform a duplicate row cleanup for tables with multiple extracts.
EXPIMP_LEVEL_NBR DOUBLE Y The logical order/level/priority in which the extract should be performed, such that any and all parent tables are extracted to ensure data is properly extracted.
EXPIMP_PARENT_TABLE_NAME VARCHAR(30) Y The table's immediate parent table on which the extract is driven.
EXTRACT_METHOD VARCHAR(30) Y Indicates the method of extraction during replicates:ALL: The entire table is moved. BYCONFIG: The table is moved by the clients specified configuration method and pct values (Clients will have METHODs of RECENT, EVERYNTH) and can specify how much activity data to move by pct (10%, 20% etc.). Typically, this means the where clause for this will reference the immediate parent table. EVERYNTHPCT: The table will sample every nth row based on the client's configuration pct. These are typicall
OWNER_NAME VARCHAR(30) N Owner of the table being extracted
TABLE_COMMENT VARCHAR(2000) Y Any information useful to describe / document how the extract is related to the Millennium data model. May be used by Cerner support organizations to better understand, use the data for clients.
TABLE_EXTRACT_INSTANCE_NBR DOUBLE N Instance/Version of the extract for a table (in case we want to ship multiple versions that can be active).
TABLE_EXTRACT_NBR DOUBLE N Extract number for a table
TABLE_NAME VARCHAR(30) N Table being extracted
WHERE_CLAUSE VARCHAR(4000) Y The where_clause the extract will use to get the intended data, either for an activity based sample, referenced-mixed data,etc..