DEM_XTRCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Extract Management - Extract
Definition: Contains report extract meta-data information.
Table Type: REFERENCE





Column Detail - DEM_XTRCT


Column Name Type Null? Definition
DEM_XTRCT_ID DOUBLE N Uniquely identifies a row of report extract meta-data information.
DLMTR_CHAR VARCHAR(100) Y The type of character delimiter to be used in the extract expression: "|", ",", etc.
FILENAME_PREFIX VARCHAR(100) Y The path and file name prefix for a given extract type.
FORMAT_OBJ_NAME VARCHAR(30) Y Name of the extract format script.
QLFCTN_OBJ_NAME VARCHAR(100) Y Name of the qualification service to be executed to retrieve data to extract.
REXTRCT_DAYS DOUBLE N Identifies the number of days to re-extract to validate that the data warehouse reflects any updates that have occurred in Millennium since the original extraction of an extract entity.
SLICE_SIZE_CNT DOUBLE N The number of Extract Instance Slice Items Per Slice
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.
XTRCT_OBJ_NAME VARCHAR(100) Y Name of the Extract service to be executed to retrieve the entity being extracted.
XTRCT_TYPE_CD DOUBLE N Type of entity to be extracted ( revenue, ATB, Payment/Adjustments, etc.)



Relationship Detail - DEM_XTRCT




Parent Column in DEM_XTRCT (PK) Child Table Name Child Column Name
Children: DEM_XTRCT_ID DEM_XTRCT_NSTNC DEM_XTRCT_ID


DEM_XTRCT_NSTNC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Extract Management - Extract Instance
Definition: Contains an instance of an entity type to be extracted fro reporting purposes. an extract instance is type of an entity (Revuenue, ATB, etc.) for a given day.
Table Type: ACTIVITY





Column Detail - DEM_XTRCT_NSTNC


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME Y The data and time the extract represents.
ACTIVITY_TZ DOUBLE Y TIME ZONE FOR THE ACTIVITY_DT_TM FIELD
DEM_XTRCT_ID DOUBLE N Uniquely identifies the extract related to this instance.
DEM_XTRCT_NSTNC_ID DOUBLE N Uniquely identifies an instance of an entity type to be extracted for reporting purposes. an extract instance is the type of an entity (revenue, ATB, etc.) for a given day.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
QLFCTN_CMPLTN_DT_TM DATETIME Y Contains the date and time the qualification was completed.
SLICE_CNT DOUBLE N The number of slices for this extract instance.
SLICE_ITEM_CNT DOUBLE N Contains the number of slice items for this extract instance.
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 - DEM_XTRCT_NSTNC


Child Column in DEM_XTRCT_NSTNC(FK) Parent Table Name Parent Column Name
Parents: DEM_XTRCT_ID DEM_XTRCT DEM_XTRCT_ID
MILL_LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in DEM_XTRCT_NSTNC (PK) Child Table Name Child Column Name
Children: DEM_XTRCT_NSTNC_ID DEM_XTRCT_NSTNC_SLC DEM_XTRCT_NSTNC_ID


DEM_XTRCT_NSTNC_SLC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Extract Management - Extract Instance Slice
Definition: Contains the slices for an extract instance. The slice size is based on the slice size from the extract table.
Table Type: ACTIVITY





Column Detail - DEM_XTRCT_NSTNC_SLC


Column Name Type Null? Definition
DEM_XTRCT_NSTNC_ID DOUBLE N Uniquely identifies the extract instance related to this slice.
DEM_XTRCT_NSTNC_SLC_ID DOUBLE N Uniquely identifies a slice for an extract instance. The slice size is based on the slice size from the extract table.
NSTNCE_SLC_STATUS_FLAG DOUBLE N Contains the status of the extract instance slice.1 = Qualification in Process2 = Ready for Extraction
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 - DEM_XTRCT_NSTNC_SLC


Child Column in DEM_XTRCT_NSTNC_SLC(FK) Parent Table Name Parent Column Name
Parents: DEM_XTRCT_NSTNC_ID DEM_XTRCT_NSTNC DEM_XTRCT_NSTNC_ID




Parent Column in DEM_XTRCT_NSTNC_SLC (PK) Child Table Name Child Column Name
Children: DEM_XTRCT_NSTNC_SLC_ID DEM_XTRCT_NSTNC_SLC_ITEM DEM_XTRCT_NSTNC_SLC_ID


DEM_XTRCT_NSTNC_SLC_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Extract Management - Extract Instance Slice Item
Definition: Contains the individual IDs for an entity that are to be extracted fro a given extract instance slice.
Table Type: ACTIVITY





Column Detail - DEM_XTRCT_NSTNC_SLC_ITEM


Column Name Type Null? Definition
DEM_XTRCT_NSTNC_SLC_ID DOUBLE N Uniquely identifies a specific extract instance slice related to this item.
DEM_XTRCT_NSTNC_SLC_ITEM_ID DOUBLE N Uniquely identifies an individual id for an entity that is to be extracted for a given extract instance slice.
PARENT_ENTITY_ID DOUBLE N Uniquely identifies the id of the entity identifying the type of item that is to be extracted.
PARENT_ENTITY_NAME VARCHAR(30) N Contains the name of the entity identifying the type of item that is to be 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.



Relationship Detail - DEM_XTRCT_NSTNC_SLC_ITEM


Child Column in DEM_XTRCT_NSTNC_SLC_ITEM(FK) Parent Table Name Parent Column Name
Parents: DEM_XTRCT_NSTNC_SLC_ID DEM_XTRCT_NSTNC_SLC DEM_XTRCT_NSTNC_SLC_ID