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.. |