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- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record.	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.