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 |