MSC_ST_ZONE_REGIONS
This table stores staging data for MSC_ZONE_REGIONS
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
SR_PARENT_ZONE_ID | NUMBER | 18 | Source side value of the parent zone identifier. | Active | ||
SR_CHILD_ID | NUMBER | 18 | Source Child Id for the Parent Zone. This can be either a Region or a Zone | Active | ||
REGION_LEVEL | NUMBER | 2 | This value indicates the Region level specified for the geography. | Active | ||
START_DATE | DATE | This value indicates the Start date of the Region or zone . | Active | |||
END_DATE | DATE | Effective end date of the regions/zones. | Active | |||
PARENT_ZONE_NAME | VARCHAR2 | 360 | Parent zone name of the geography defined in zone/regions. | Active | ||
PARENT_ZONE_TYPE | VARCHAR2 | 30 | Name of zone type in which parent_zone_name belongs to. | |||
CHILD_NAME | VARCHAR2 | 360 | Region name of the geography as defined in TCA. | Active | ||
COUNTRY_CODE | VARCHAR2 | 2 | Country Code to which child region or zone belongs to. | Active | ||
PARENT_REGION_NAME_1 | VARCHAR2 | 360 | Name of the parent region in the hierarchy | Active | ||
PARENT_REGION_NAME_2 | VARCHAR2 | 360 | Name of the parent region in the hierarchy | Active | ||
PARENT_REGION_NAME_3 | VARCHAR2 | 360 | Name of the parent region in the hierarchy | Active | ||
PARENT_REGION_NAME_4 | VARCHAR2 | 360 | Name of the parent region in the hierarchy | Active | ||
PARENT_REGION_NAME_5 | VARCHAR2 | 360 | Name of the parent region in the hierarchy | Active | ||
PARENT_REGION_NAME_6 | VARCHAR2 | 360 | Name of the parent region in the hierarchy | Active | ||
PARENT_REGION_NAME_7 | VARCHAR2 | 360 | Name of the parent region in the hierarchy | Active | ||
PARENT_REGION_NAME_8 | VARCHAR2 | 360 | Name of the parent region in the hierarchy | Active | ||
REFRESH_NUMBER | NUMBER | 18 | Refresh Number is the Cycle id of collections | Active | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- New record from ODI | Active | |||
SR_INSTANCE_CODE | VARCHAR2 | 30 | The value indicates the source system code from where the data is collected. | Active | ||
ERROR_TEXT | VARCHAR2 | 2000 | Error text for functional validation errors in the record | Active | ||
ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | Active | ||
RETRY_COUNT | NUMBER | Retry count. Used during planning collection when the record fails to get loaded into ODS. | Active | |||
LOAD_REQUEST_ID | NUMBER | This stores the request id of the job that loaded the data. |