Customer

Entity Relationship Diagram

Tip:	Right click the attachment to view Entity Relationship Diagram for Customer in a new tab.

List of Objects

Table Schema Name	DB Object Name	Object Business Name	Object Description	DB Attribute Name	Attribute Business Name	Ordinal Position	Data Type Name	Data Type Size	Numeric Scale	Is Identity	Is Nullable	Primary Key	Mandatory
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	ACCOUNT_ID	ACCOUNT_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	TYPE_CODE	TYPE_CODE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NAME	NAME	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	DOING_BUSINESS_AS_NAME	DOING_BUSINESS_AS_NAME	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	OFFICIAL_NAME	OFFICIAL_NAME	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SREP_ACCESS	SREP_ACCESS	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	GROUP_PRACTICE_ID	GROUP_PRACTICE_ID	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	ACCEPT_MEDICARE	ACCEPT_MEDICARE	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	ACCEPT_MEDICAID	ACCEPT_MEDICAID	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	PERCENT_MEDICAID	PERCENT_MEDICAID	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	HEALTH_SYSTEM_NAME	HEALTH_SYSTEM_NAME	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	GPO_MEMBERSHIP	GPO_MEMBERSHIP	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	ACADEMIC	ACADEMIC	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	BUSINESS_ENTITY_TYPE	BUSINESS_ENTITY_TYPE	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	PRIMARY_GPO	PRIMARY_GPO	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	MKT_SEGMENT_CODE	MKT_SEGMENT_CODE	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_LICENSE_BEDS	TOTAL_LICENSE_BEDS	19	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_CENSUS_BEDS	TOTAL_CENSUS_BEDS	20	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_PATIENTS	NUM_PATIENTS	21	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_STAFFED_BEDS	TOTAL_STAFFED_BEDS	22	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_SURGERIES	TOTAL_SURGERIES	23	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_PROCEDURES	TOTAL_PROCEDURES	24	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	OR_SURGERIES	OR_SURGERIES	25	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	RESIDENT_PROGRAM	RESIDENT_PROGRAM	26	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	RESIDENT_COUNT	RESIDENT_COUNT	27	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUMS_OF_PROVIDERS	NUMS_OF_PROVIDERS	28	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	FORMULARY	FORMULARY	29	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CMS_COVERED_FOR_TEACHING	CMS_COVERED_FOR_TEACHING	30	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	COMM_HOSP	COMM_HOSP	31	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	EMAIL_DOMAIN	EMAIL_DOMAIN	32	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	STATUS	STATUS	33	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	COMPANY_TYPE	COMPANY_TYPE	34	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	FOUNDED_YEAR	FOUNDED_YEAR	35	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	LEGAL_DOMICILE	LEGAL_DOMICILE	36	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	OWNERSHIP_STATUS	OWNERSHIP_STATUS	37	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	PROFIT_STATUS	PROFIT_STATUS	38	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CMI	CMI	39	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_UPDATE_DATE	STATUS_UPDATE_DATE	40	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_REASON_CODE	STATUS_REASON_CODE	41	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	COMMENTERS	COMMENTERS	42	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_STATUS	VALIDATION_STATUS	43	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_REASON	VALIDATION_CHANGE_REASON	44	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_DATE	VALIDATION_CHANGE_DATE	45	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CREATE_DATE	CREATE_DATE	46	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	UPDATE_DATE	UPDATE_DATE	47	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CHECK_DATE	CHECK_DATE	48	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	STATE_CODE	STATE_CODE	49	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_CHANGE_REASON	STATUS_CHANGE_REASON	50	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_EMPLOYEES	NUM_EMPLOYEES	51	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_MED_EMPLOYEES	NUM_MED_EMPLOYEES	52	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_BEDS_INTENSIVE_CARE	TOTAL_BEDS_INTENSIVE_CARE	53	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_EXAMINATION_ROOM	NUM_EXAMINATION_ROOM	54	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_AFFILIATED_SITES	NUM_AFFILIATED_SITES	55	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_ENROLLED_MEMBERS	NUM_ENROLLED_MEMBERS	56	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_IN_PATIENTS	NUM_IN_PATIENTS	57	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_OUT_PATIENTS	NUM_OUT_PATIENTS	58	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_OPERATING_ROOMS	NUM_OPERATING_ROOMS	59	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_PATIENTS_X_WEEK	NUM_PATIENTS_X_WEEK	60	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	ACT_TYPE_CODE	ACT_TYPE_CODE	61	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	DISPENSE_DRUGS	DISPENSE_DRUGS	62	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	NUM_PRESCRIBERS	NUM_PRESCRIBERS	63	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	PATIENTS_X_YEAR	PATIENTS_X_YEAR	64	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	ACCEPTS_NEW_PATIENTS	ACCEPTS_NEW_PATIENTS	65	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_PRIORITY	CLASS_OF_TRADE_PRIORITY	66	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_CLASSIFICATION	CLASS_OF_TRADE_CLASSIFICATION	67	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_FACILITY_TYPE	CLASS_OF_TRADE_FACILITY_TYPE	68	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_SPECIALTY	CLASS_OF_TRADE_SPECIALTY	69	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_SUB_CATEGORY	CLASS_OF_TRADE_SUB_CATEGORY	70	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SUB_SOURCE_NAME	SUB_SOURCE_NAME	71	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CORP_PARENT_NAME	CORP_PARENT_NAME	72	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	OWNER_SUBNAME	OWNER_SUBNAME	73	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SUBTYPE_CODE	SUBTYPE_CODE	74	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	MANAGER_HCO_NAME	MANAGER_HCO_NAME	75	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	76	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	77	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	78	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	79	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	80	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	81	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	82	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ACCOUNT	CUSTOMER MASTER	CUSTOMER MASTER	BF_ID	BF_ID	83	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	ACO_DETAILS_ID	ACO_DETAILS_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	ACO_TYPE_CODE	ACO_TYPE_CODE	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	ACO_TYPE_CATG	ACO_TYPE_CATG	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	ACO_TYPE_MODEL	ACO_TYPE_MODEL	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_ACO_DETAILS_ID	SRC_ACO_DETAILS_ID	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	ACO_DETAIL_CODE	ACO_DETAIL_CODE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	ACO_DETAIL_GROUP_CODE	ACO_DETAIL_GROUP_CODE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	ACO_VAL	ACO_VAL	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	10	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	11	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	12	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	13	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	14	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ACO_DETAILS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	15	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	ADDITIONAL_ATTRIBUTES_ID	ADDITIONAL_ATTRIBUTES_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	SRC_ADDITIONAL_ATTRIBUTES_ID	SRC_ADDITIONAL_ATTRIBUTES_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	ATTRIBUTE_NAME	ATTRIBUTE_NAME	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	ATTRIBUTE_TYPE	ATTRIBUTE_TYPE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	ATTRIBUTE_CODE_VALUE	ATTRIBUTE_CODE_VALUE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	ATTRIBUTE_VALUE	ATTRIBUTE_VALUE	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	ATTRIBUTE_RANK	ATTRIBUTE_RANK	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	ADDITIONAL_INFO	ADDITIONAL_INFO	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	12	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	13	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	14	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	15	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	16	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ADDITIONAL_ATTRIBUTES	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	17	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_BRICK_ID	ADDRESS_BRICK_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	SRC_ADDRESS_BRICK_ID	SRC_ADDRESS_BRICK_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ADDRESS_ID	CUSTOMER_ADDRESS_ID	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	BRICK_TYPE	BRICK_TYPE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	BRICK_VALUE	BRICK_VALUE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	SORT_ORDER	SORT_ORDER	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	10	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	11	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	12	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	13	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	14	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ADDRESS_BRICK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	15	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SRC_AFFILIATION_ID	SRC_AFFILIATION_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	RELATION_TYPE	RELATION_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	START_CUSTOMER_ID	START_CUSTOMER_ID	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	START_OBJECT_TYPE	START_OBJECT_TYPE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	END_CUSTOMER_ID	END_CUSTOMER_ID	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	END_OBJECT_TYPE	END_OBJECT_TYPE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	REL_GROUP	REL_GROUP	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	REL_ORDER	REL_ORDER	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_REASON_CODE	STATUS_REASON_CODE	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_UPDATE_DATE	STATUS_UPDATE_DATE	12	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_REASON	VALIDATION_CHANGE_REASON	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_DATE	VALIDATION_CHANGE_DATE	14	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_STATUS	VALIDATION_STATUS	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_STATUS	AFFILIATION_STATUS	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	TITLE	TITLE	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PREF_OR_ACTIVE	PREF_OR_ACTIVE	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	RANK	RANK	19	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	COMMENTERS	COMMENTERS	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	RELATIONSHIP_CREATE_DATE	RELATIONSHIP_CREATE_DATE	21	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	RELATIONSHIP_START_DATE	RELATIONSHIP_START_DATE	22	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	RELATIONSHIP_END_DATE	RELATIONSHIP_END_DATE	23	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	UPDATE_DATE	UPDATE_DATE	24	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	CHECKED_DATE	CHECKED_DATE	25	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PREFERRED_MAIL_INDICATOR	PREFERRED_MAIL_INDICATOR	26	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PREFERRED_VISIT_INDICATOR	PREFERRED_VISIT_INDICATOR	27	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	COMMITTEE_MEMBER	COMMITTEE_MEMBER	28	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	APPOINTMENT_REQUIRED	APPOINTMENT_REQUIRED	29	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	WORKING_STATUS	WORKING_STATUS	30	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	31	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PRIMARY_AFFILIATION_INDICATOR	PRIMARY_AFFILIATION_INDICATOR	32	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	MDM_URI	MDM_URI	33	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_STATUS	LOAD_STATUS	34	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PLUGIN_PROCESS_DT	PLUGIN_PROCESS_DT	35	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_DETAILS	LOAD_DETAILS	36	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SUB_ENTITY_INDICATOR	SUB_ENTITY_INDICATOR	37	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_ORIGIN_CODE	PERMISSION_ORIGIN_CODE	38	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_CHANNEL_CODE	PERMISSION_CHANNEL_CODE	39	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PERMITTED_USE_TYPE_CODE	PERMITTED_USE_TYPE_CODE	40	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_DATE	PERMISSION_DATE	41	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_REFERENCE	PERMISSION_REFERENCE	42	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	START_CUSTOMER_MDM_URI	START_CUSTOMER_MDM_URI	41	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	END_CUSTOMER_MDM_URI	END_CUSTOMER_MDM_URI	42	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SRC_CRT_DT	SRC_CRT_DT	43	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SRC_END_DT	SRC_END_DT	44	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	45	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	46	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	47	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	48	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	49	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	50	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION_GIF_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	BATCH_STATUS	BATCH_STATUS	1	VARIANT			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_GIF_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	LAST_UPD_DT	LAST_UPD_DT	2	TIMESTAMP_NTZ			NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION_OK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	BATCH_STATUS	BATCH_STATUS	1	VARIANT			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_OK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	LAST_UPD_DT	LAST_UPD_DT	2	TIMESTAMP_NTZ			NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ROLE_ID	AFFILIATION_ROLE_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	SRC_AFFILIATION_ROLE_ID	SRC_AFFILIATION_ROLE_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	RELATION_TYPE	RELATION_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	ROLE_NAME	ROLE_NAME	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	ROLE_RANK	ROLE_RANK	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	ROLE_ATTRIBUTE	ROLE_ATTRIBUTE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	ROLE_TYPE_ATTRIBUTE	ROLE_TYPE_ATTRIBUTE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	9	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	10	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	11	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	12	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	13	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_AFFILIATION_ROLE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	14	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	BED_FACTS_ID	BED_FACTS_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_BED_FACTS_ID	SRC_BED_FACTS_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	BED_TYPE	BED_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	BED_SUB_TYPE	BED_SUB_TYPE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	BED_COUNT	BED_COUNT	6	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	7	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	8	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	9	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	10	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	11	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_BED_FACTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	12	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	BUSINESS_HOURS_ID	BUSINESS_HOURS_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_BUSINESS_HOURS_ID	SRC_BUSINESS_HOURS_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ADDRESS_ID	CUSTOMER_ADDRESS_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	DAY	DAY	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	PERIOD	PERIOD	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	TIME_SLOT	TIME_SLOT	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	START_TIME	START_TIME	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	END_TIME	END_TIME	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	APPOINTMENT_ONLY	APPOINTMENT_ONLY	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	PERIOD_START	PERIOD_START	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	PERIOD_END	PERIOD_END	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	PERIOD_OF_DAY	PERIOD_OF_DAY	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SORT_ORDER	SORT_ORDER	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	17	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	18	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	19	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	20	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	21	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_BUSINESS_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	22	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	COMM_ID	COMM_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	SRC_COMM_ID	SRC_COMM_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	VALUE	VALUE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	TYPE	TYPE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	STD_CODE	STD_CODE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	ACTIVE	ACTIVE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ADDRESS_ID	CUSTOMER_ADDRESS_ID	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	AREA_CODE	AREA_CODE	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY_CODE	COUNTRY_CODE	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	DIGIT_COUNT	DIGIT_COUNT	13	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	EXTENSION	EXTENSION	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	FORMAT_MASK	FORMAT_MASK	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	FORMATTED_NUMBER	FORMATTED_NUMBER	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	GEO_AREA	GEO_AREA	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	GEO_COUNTRY	GEO_COUNTRY	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	LINE_TYPE	LINE_TYPE	19	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	LOCAL_NUMBER	LOCAL_NUMBER	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	RANK	RANK	21	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_STATUS	VALIDATION_STATUS	22	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	MEDIA_PREFERRED	MEDIA_PREFERRED	23	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	MEDIA_DOMAIN	MEDIA_DOMAIN	24	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_ORIGIN_CODE	PERMISSION_ORIGIN_CODE	25	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_CHANNEL_CODE	PERMISSION_CHANNEL_CODE	26	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	PERMITTED_USE_TYPE_CODE	PERMITTED_USE_TYPE_CODE	27	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_DATE	PERMISSION_DATE	28	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_REFERENCE	PERMISSION_REFERENCE	29	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	30	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	31	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	32	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	33	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	34	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_COMM	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	35	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	INACTIVATION_REASON	INACTIVATION_REASON	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	MDM_URI	MDM_URI	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_STATUS	LOAD_STATUS	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	PLUGIN_PROCESS_DT	PLUGIN_PROCESS_DT	6	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_DETAILS	LOAD_DETAILS	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_ID	SOURCE_ID	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SUB_SOURCE_ID	SUB_SOURCE_ID	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SUB_SOURCE_NAME	SUB_SOURCE_NAME	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SRC_CRT_DT	SRC_CRT_DT	10	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SRC_END_DT	SRC_END_DT	11	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SRC_UPDT_DT	SRC_UPDT_DT	12	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	13	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	14	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	15	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	16	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	17	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	18	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ADDRESS_ID	CUSTOMER_ADDRESS_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_ADDRESS_ID	SRC_ADDRESS_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_CUSTOMER_ADDRESS_ID	SRC_CUSTOMER_ADDRESS_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	DERIVED_ADDRESS	DERIVED_ADDRESS	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	HCO_NAME	HCO_NAME	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_TYPE	ADDRESS_TYPE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	PRIMARY	PRIMARY	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_RANK	ADDRESS_RANK	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	LOC_CONF_IND	LOC_CONF_IND	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	BEST_RECORD	BEST_RECORD	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	STATUS	STATUS	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_LINE1	ADDRESS_LINE1	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_LINE2	ADDRESS_LINE2	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_LINE3	ADDRESS_LINE3	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_LINE4	ADDRESS_LINE4	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	CITY	CITY	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	STATE_PROVINCE	STATE_PROVINCE	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	STATE_PROVINCE_CODE	STATE_PROVINCE_CODE	19	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	STREET	STREET	21	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	FLOOR	FLOOR	22	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	BUILDING	BUILDING	23	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SUB_BUILDING	SUB_BUILDING	23	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	PO_BOX	PO_BOX	24	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	CBSA_CODE	CBSA_CODE	25	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	FIPS_COUNTY_CODE	FIPS_COUNTY_CODE	26	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	FIPS_STATE_CODE	FIPS_STATE_CODE	27	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	MSA	MSA	28	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	MULTIUNIT	MULTIUNIT	29	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	DPV	DPV	30	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	VERIFICATION_STATUS	VERIFICATION_STATUS	31	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_CHANGE_DATE	STATUS_CHANGE_DATE	32	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_STATUS	ADDRESS_STATUS	33	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	POSTAL_CITY	POSTAL_CITY	34	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	AVC	AVC	35	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	PREMISE	PREMISE	36	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SUB_ADMINISTRATIVE_AREA	SUB_ADMINISTRATIVE_AREA	37	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_VALUE1	UNIT_VALUE1	38	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_NAME1	UNIT_NAME1	39	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_VALUE2	UNIT_VALUE2	40	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_NAME2	UNIT_NAME2	41	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ZIP_5	ZIP_5	42	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ZIP_4	ZIP_4	43	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	RELATION_STATUS_CHANGE_DATE	RELATION_STATUS_CHANGE_DATE	44	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_STATUS	VALIDATION_STATUS	45	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_REASON	VALIDATION_REASON	46	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_REASON_CODE	STATUS_REASON_CODE	47	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_DATE	VALIDATION_CHANGE_DATE	48	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	OFFICE_INFORMATION_BEST_TIMES	OFFICE_INFORMATION_BEST_TIMES	49	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	OFFICE_INFORMATION_APPT_REQUIRED	OFFICE_INFORMATION_APPT_REQUIRED	50	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	OFFICE_INFORMATION_OFFICE_NOTES	OFFICE_INFORMATION_OFFICE_NOTES	51	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	BUILD_LABEL	BUILD_LABEL	52	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	LOCALITY	LOCALITY	53	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	NEIGHBORHOOD	NEIGHBORHOOD	54	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	LATITUDE	LATITUDE	55	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	LONGITUDE	LONGITUDE	56	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	GEO_CODING_SYSTEM	GEO_CODING_SYSTEM	57	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	GEOACCURACY	GEOACCURACY	58	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	59	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	60	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	61	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	62	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	63	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	64	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	BF_ID	BF_ID	65	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	HCO_NAME_X	HCO_NAME_X	66	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_LINE1_X	ADDRESS_LINE1_X	67	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	ADDRESS_LINE2_X	ADDRESS_LINE2_X	68	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	CITY_X	CITY_X	69	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	POSTAL_CITY_X	POSTAL_CITY_X	70	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_TYPE2	UNIT_TYPE3	71	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_OFFICIAL_CODE2	UNIT_OFFICIAL_CODE3	72	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_VALUE1_X	UNIT_VALUE1_X	73	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	STATE_PROVINCE_X	STATE_PROVINCE_X	74	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_TYPE3	UNIT_TYPE4	75	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_OFFICIAL_CODE3	UNIT_OFFICIAL_CODE4	76	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	UNIT_VALUE2_X	UNIT_VALUE2_X	77	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	CBSA_DESCRIPTION	CBSA_DESCRIPTION	78	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	CBSA_DESCRIPTION_X	CBSA_DESCRIPTION_X	79	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_ADDRESS	CUSTOMER MASTER	CUSTOMER MASTER	SUB_ADMINISTRATIVE_AREA_X	SUB_ADMINISTRATIVE_AREA_X	80	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_GIF_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	BATCH_STATUS	BATCH_STATUS	1	VARIANT			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_GIF_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	LAST_UPD_DT	LAST_UPD_DT	2	TIMESTAMP_NTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_HARDLINK	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	1	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK	CUSTOMER MASTER	CUSTOMER MASTER	CROSSWALK	CROSSWALK	2	ARRAY			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	5	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_HARDLINK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	6	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	7	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_HARDLINK	CUSTOMER MASTER	CUSTOMER MASTER	CLIENT_CODE_INDICATOR	CLIENT_CODE_INDICATOR	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	1	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	CROSSWALK	CROSSWALK	2	ARRAY			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	CLIENT_CODE_INDICATOR	CLIENT_CODE_INDICATOR	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	6	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_HARDLINK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	7	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_HARDLINK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	8	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOMER_OK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	BATCH_STATUS	BATCH_STATUS	1	VARIANT			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOMER_OK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	LAST_UPD_DT	LAST_UPD_DT	2	TIMESTAMP_NTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	OBJECT_ID	OBJECT_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	JSON	JSON	2	VARIANT			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	OBJECT_TYPE	OBJECT_TYPE	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	MDM_URI	MDM_URI	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_STATUS	LOAD_STATUS	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	PLUGIN_PROCESS_DT	PLUGIN_PROCESS_DT	7	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_DETAILS	LOAD_DETAILS	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	PROCESS_NAME	PROCESS_NAME	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	10	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	11	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	12	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	13	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	14	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOM_DATA	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	15	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	DATA_USAGE_RESTRICTIONS_ID	DATA_USAGE_RESTRICTIONS_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_DATA_USAGE_RESTRICTIONS_ID	SRC_DATA_USAGE_RESTRICTIONS_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ADDRESS_ID	CUSTOMER_ADDRESS_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	COMM_ID	COMM_ID	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	DATA_TYPE_CODE	DATA_TYPE_CODE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	DATA_TYPE_RANK	DATA_TYPE_RANK	8	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	DATA_USAGE_CODE	DATA_USAGE_CODE	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	DATA_USAGE_FLAG	DATA_USAGE_FLAG	10	BOOLEAN			NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_CRT_DT	SRC_CRT_DT	11	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_END_DT	SRC_END_DT	12	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	13	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	14	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	15	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	16	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	17	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_DATA_USAGE_RESTRICTIONS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	18	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	DCR_ID	DCR_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_ID	SOURCE_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	MDM_URI	MDM_URI	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	JSON	JSON	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_STATUS	LOAD_STATUS	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_DETAILS	LOAD_DETAILS	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	PLUGIN_PROCESS_DT	PLUGIN_PROCESS_DT	9	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	RETRY_COUNT	RETRY_COUNT	10	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_START_TIME	LOAD_START_TIME	11	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_END_TIME	LOAD_END_TIME	12	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SRC_CRT_DT	SRC_CRT_DT	13	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SRC_END_DT	SRC_END_DT	14	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SRC_UPDT_DT	SRC_UPDT_DT	15	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	16	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	17	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	18	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	19	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	20	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_DCR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	21	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DCR_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	BATCH_STATUS	BATCH_STATUS	1	VARIANT			NO	YES	NO	NO
MDM_CANONICAL	C_DCR_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	LAST_UPD_DT	LAST_UPD_DT	2	TIMESTAMP_NTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	DEGREE_ID	DEGREE_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	SRC_DEGREE_ID	SRC_DEGREE_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	TYPE	TYPE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	DEGREE	DEGREE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	GRADUATED	GRADUATED	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	GPA	GPA	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	YEAR_OF_GRADUATION	YEAR_OF_GRADUATION	9	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	YEARS_IN_PROGRAM	YEARS_IN_PROGRAM	10	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	START_YEAR	START_YEAR	11	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	END_YEAR	END_YEAR	12	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	FIELD_OF_STUDY	FIELD_OF_STUDY	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	MEDICAL_SCHOOL	MEDICAL_SCHOOL	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	RANK	RANK	15	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	16	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	17	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	18	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	19	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	20	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_DEGREE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	21	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	GDPR_ID	GDPR_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	TYPE	TYPE	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE	SOURCE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	SYSTEM_ID	SYSTEM_ID	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	START_DATE	START_DATE	7	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	END_DATE	END_DATE	8	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	9	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	10	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	11	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	12	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	13	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_GDPR	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	14	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	MANAGER_HCO_ID	MANAGER_HCO_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TYPE_CODE	TYPE_CODE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NAME	NAME	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	DOING_BUSINESS_AS_NAME	DOING_BUSINESS_AS_NAME	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	OFFICIAL_NAME	OFFICIAL_NAME	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	INTERNATIONAL_NAME	INTERNATIONAL_NAME	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SHORT_NAME	SHORT_NAME	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SREP_ACCESS	SREP_ACCESS	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	GROUP_PRACTICE_ID	GROUP_PRACTICE_ID	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	ACCEPT_MEDICARE	ACCEPT_MEDICARE	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	ACCEPT_MEDICAID	ACCEPT_MEDICAID	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PERCENT_MEDICAID	PERCENT_MEDICAID	14	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	HEALTH_SYSTEM_NAME	HEALTH_SYSTEM_NAME	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	GPO_MEMBERSHIP	GPO_MEMBERSHIP	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	ACADEMIC	ACADEMIC	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	BUSINESS_ENTITY_TYPE	BUSINESS_ENTITY_TYPE	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PRIMARY_GPO	PRIMARY_GPO	19	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	MKT_SEGMENT_CODE	MKT_SEGMENT_CODE	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_LICENSE_BEDS	TOTAL_LICENSE_BEDS	21	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_CENSUS_BEDS	TOTAL_CENSUS_BEDS	22	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_PATIENTS	NUM_PATIENTS	23	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_STAFFED_BEDS	TOTAL_STAFFED_BEDS	24	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_SURGERIES	TOTAL_SURGERIES	25	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_PROCEDURES	TOTAL_PROCEDURES	26	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	OR_SURGERIES	OR_SURGERIES	27	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	RESIDENT_PROGRAM	RESIDENT_PROGRAM	28	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	RESIDENT_COUNT	RESIDENT_COUNT	29	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUMS_OF_PROVIDERS	NUMS_OF_PROVIDERS	30	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	FORMULARY	FORMULARY	31	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CMS_COVERED_FOR_TEACHING	CMS_COVERED_FOR_TEACHING	32	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	COMM_HOSP	COMM_HOSP	33	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	EMAIL_DOMAIN	EMAIL_DOMAIN	34	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	STATUS	STATUS	35	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	COMPANY_TYPE	COMPANY_TYPE	36	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	FOUNDED_YEAR	FOUNDED_YEAR	37	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	LEGAL_DOMICILE	LEGAL_DOMICILE	38	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	OWNER	OWNER	39	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	OWNERSHIP_STATUS	OWNERSHIP_STATUS	40	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PROFIT_STATUS	PROFIT_STATUS	41	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CMI	CMI	42	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_UPDATE_DATE	STATUS_UPDATE_DATE	43	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_REASON_CODE	STATUS_REASON_CODE	44	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	COMMENTERS	COMMENTERS	45	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_STATUS	VALIDATION_STATUS	46	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_REASON	VALIDATION_CHANGE_REASON	47	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_DATE	VALIDATION_CHANGE_DATE	48	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CREATE_DATE	CREATE_DATE	49	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	UPDATE_DATE	UPDATE_DATE	50	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CHECK_DATE	CHECK_DATE	51	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	STATE_CODE	STATE_CODE	52	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	STATE_DATE	STATE_DATE	53	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_CHANGE_REASON	STATUS_CHANGE_REASON	54	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_EMPLOYEES	NUM_EMPLOYEES	55	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_MED_EMPLOYEES	NUM_MED_EMPLOYEES	56	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TOTAL_BEDS_INTENSIVE_CARE	TOTAL_BEDS_INTENSIVE_CARE	57	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_EXAMINATION_ROOM	NUM_EXAMINATION_ROOM	58	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_AFFILIATED_SITES	NUM_AFFILIATED_SITES	59	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_ENROLLED_MEMBERS	NUM_ENROLLED_MEMBERS	60	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_IN_PATIENTS	NUM_IN_PATIENTS	61	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_OUT_PATIENTS	NUM_OUT_PATIENTS	62	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_OPERATING_ROOMS	NUM_OPERATING_ROOMS	63	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_PATIENTS_X_WEEK	NUM_PATIENTS_X_WEEK	64	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	ACT_TYPE_CODE	ACT_TYPE_CODE	65	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	DISPENSE_DRUGS	DISPENSE_DRUGS	66	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NUM_PRESCRIBERS	NUM_PRESCRIBERS	67	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PATIENTS_X_YEAR	PATIENTS_X_YEAR	68	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	ACCEPTS_NEW_PATIENTS	ACCEPTS_NEW_PATIENTS	69	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_PRIORITY	CLASS_OF_TRADE_PRIORITY	70	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_CLASSIFICATION	CLASS_OF_TRADE_CLASSIFICATION	71	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_FACILITY_TYPE	CLASS_OF_TRADE_FACILITY_TYPE	72	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_SPECIALTY	CLASS_OF_TRADE_SPECIALTY	73	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_SUB_CATEGORY	CLASS_OF_TRADE_SUB_CATEGORY	74	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CLASS_OF_TRADE_CODE	CLASS_OF_TRADE_CODE	75	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SUB_SOURCE_NAME	SUB_SOURCE_NAME	76	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CORP_PARENT_NAME	CORP_PARENT_NAME	77	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	OWNER_SUB_NAME	OWNER_SUB_NAME	78	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SUBTYPE_CODE	SUBTYPE_CODE	79	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	MANAGER_HCO_NAME	MANAGER_HCO_NAME	80	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	81	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	EMEDICAL_RECORD	EMEDICAL_RECORD	82	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	EPRESCRIBE	EPRESCRIBE	83	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PAY_PER_FORM	PAY_PER_FORM	84	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	GEN_FIRST	GEN_FIRST	85	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TAXONOMY_VALUE	TAXONOMY_VALUE	86	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TAXONOMY_TYPE	TAXONOMY_TYPE	87	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TAXONOMY_STR_TYPE	TAXONOMY_STR_TYPE	88	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TAXONOMY_PROVIDER_TYPE	TAXONOMY_PROVIDER_TYPE	89	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TAXONOMY_CLASSIFICATION	TAXONOMY_CLASSIFICATION	90	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TAXONOMY_SPECIALIZATION	TAXONOMY_SPECIALIZATION	91	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	TAXONOMY_PRIORITY	TAXONOMY_PRIORITY	92	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_ORIGIN_CODE	PERMISSION_ORIGIN_CODE	93	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_CHANNEL_CODE	PERMISSION_CHANNEL_CODE	94	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PERMITTED_USE_TYPE_CODE	PERMITTED_USE_TYPE_CODE	95	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_DATE	PERMISSION_DATE	96	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_REFERENCE	PERMISSION_REFERENCE	97	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	98	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	99	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	100	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	101	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	102	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	103	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	BF_ID	BF_ID	104	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	NAME_X	NAME_X	105	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_HCO	CUSTOMER MASTER	CUSTOMER MASTER	OFFICIAL_NAME_X	OFFICIAL_NAME_X	106	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	TYPE_CODE	TYPE_CODE	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SUBTYPE_CODE	SUBTYPE_CODE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	NAME	NAME	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	FIRST_NAME	FIRST_NAME	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	LAST_NAME	LAST_NAME	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	MIDDLE_NAME	MIDDLE_NAME	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SUFFIX_NAME	SUFFIX_NAME	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PREFERRED_NAME	PREFERRED_NAME	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	NICK_NAME	NICK_NAME	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	GENDER	GENDER	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	DOB	DOB	13	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	YOB	YOB	14	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	DOD	DOD	15	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	YOD	YOD	16	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PREFIX	PREFIX	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	KAISER_PROVIDER	KAISER_PROVIDER	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	MAJOR_PROFESSIONAL_ACTIVITY	MAJOR_PROFESSIONAL_ACTIVITY	19	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PRESENT_EMPLOYMENT	PRESENT_EMPLOYMENT	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	TYPE_OF_PRACTICE	TYPE_OF_PRACTICE	21	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	FORMER_FIRST_NAME	FORMER_FIRST_NAME	22	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	FORMER_LAST_NAME	FORMER_LAST_NAME	23	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	FORMER_MIDDLE_NAME	FORMER_MIDDLE_NAME	24	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	FORMER_SUFFIX_NAME	FORMER_SUFFIX_NAME	25	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	TITLE	TITLE	26	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	STATUS	STATUS	27	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_UPDATE_DATE	STATUS_UPDATE_DATE	28	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_REASON_CODE	STATUS_REASON_CODE	29	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	STATE_CODE	STATE_CODE	30	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	STATE_DATE	STATE_DATE	31	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	CATEGORY	CATEGORY	32	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	DEGREE_CODE	DEGREE_CODE	33	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SALUTATION_NAME	SALUTATION_NAME	34	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	TRAINING_HOSPITAL	TRAINING_HOSPITAL	35	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	INITIALS	INITIALS	36	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	ACRONYM_NAME	ACRONYM_NAME	37	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	FIRST_SET_DATE	FIRST_SET_DATE	38	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	CREATE_DATE	CREATE_DATE	39	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	UPDATE_DATE	UPDATE_DATE	40	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	CHECK_DATE	CHECK_DATE	41	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_STATUS	VALIDATION_STATUS	42	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_REASON	VALIDATION_CHANGE_REASON	43	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_DATE	VALIDATION_CHANGE_DATE	44	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	APPOINTMENT_REQUIRED	APPOINTMENT_REQUIRED	45	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PREFERRED_LANGUAGE	PREFERRED_LANGUAGE	46	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	POLITICAL_AFFILIATION	POLITICAL_AFFILIATION	47	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	KOL_TITLE	KOL_TITLE	48	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SUB_SOURCE_NAME	SUB_SOURCE_NAME	49	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	NUM_OF_PATIENTS	NUM_OF_PATIENTS	50	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	ADMINISTRATIVE_NAME	ADMINISTRATIVE_NAME	51	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	IS_BLACK_LISTED	IS_BLACK_LISTED	52	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_ORIGIN_CODE	PERMISSION_ORIGIN_CODE	53	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_CHANNEL_CODE	PERMISSION_CHANNEL_CODE	54	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PERMITTED_USE_TYPE_CODE	PERMITTED_USE_TYPE_CODE	55	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_DATE	PERMISSION_DATE	56	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PERMISSION_REFERENCE	PERMISSION_REFERENCE	57	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PROVIDER_IDENTIFIER_TYPE	PROVIDER_IDENTIFIER_TYPE	57	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	WEBSITE_URL	WEBSITE_URL	57	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	58	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	59	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	60	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	61	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	62	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	63	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	PROVIDER_IDENTIFIER_TYPE	PROVIDER_IDENTIFIER_TYPE	64	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	WEBSITE_URL	WEBSITE_URL	65	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	BF_ID	BF_ID	66	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	FIRST_NAME_X	FIRST_NAME_X	67	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	MIDDLE_NAME_X	MIDDLE_NAME_X	68	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	LAST_NAME_X	LAST_NAME_X	69	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	FORMER_LAST_NAME_X	FORMER_LAST_NAME_X	70	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_HCP	CUSTOMER MASTER	CUSTOMER MASTER	ACCREDITATIONS	ACCREDITATIONS	71	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	IDENTIFIER_ID	IDENTIFIER_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SRC_IDENTIFIER_ID	SRC_IDENTIFIER_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ADDRESS_ID	CUSTOMER_ADDRESS_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	ID_TYPE	ID_TYPE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	ID	ID	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	TYPE	TYPE	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	STATE	STATE	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	IDENTIFIER_ORDER	IDENTIFIER_ORDER	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	CATEGORY	CATEGORY	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	AUTHORIZATION_STATUS	AUTHORIZATION_STATUS	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	STATUS	STATUS	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	BIRTH_CITY	BIRTH_CITY	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	BIRTH_STATE	BIRTH_STATE	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	BIRTH_COUNTRY	BIRTH_COUNTRY	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	EMPLOYMENT_TYPE_CODE	EMPLOYMENT_TYPE_CODE	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	GRADUATION_YEAR	GRADUATION_YEAR	19	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	AMA_MD_DO_FLAG	AMA_MD_DO_FLAG	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	MEDICAL_SCHOOL	MEDICAL_SCHOOL	21	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	MAJOR_PROF_ACT	MAJOR_PROF_ACT	22	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	PRACTICE_TYPE_CODE	PRACTICE_TYPE_CODE	23	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	AMA_HOSPITAL_ID	AMA_HOSPITAL_ID	24	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	HOSPITAL_HOURS	HOSPITAL_HOURS	25	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	NUM_OF_PYSICIANS	NUM_OF_PYSICIANS	26	NUMBER		0	NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	DEACTIVATION_REASON_CODE	DEACTIVATION_REASON_CODE	27	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	DEACTIVATION_DATE	DEACTIVATION_DATE	28	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	REACTIVATION_DATE	REACTIVATION_DATE	29	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	NATIONAL_ID	NATIONAL_ID	30	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	EXPIRATION_DATE	EXPIRATION_DATE	31	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	BUSINESS_ACTIVITY_CODE	BUSINESS_ACTIVITY_CODE	32	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SUB_BUSINESS_ACTIVITY_CODE	SUB_BUSINESS_ACTIVITY_CODE	33	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	DRUG_SCHEDULE	DRUG_SCHEDULE	34	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	DEA_CHANGE_REASON_CODE	DEA_CHANGE_REASON_CODE	35	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	36	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	37	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	38	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	39	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	40	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	41	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	ACTIVATION_DATE	ACTIVATION_DATE	42	DATE			NO	NO	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	LOCAL_STATUS	LOCAL_STATUS	43	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_IDENTIFIER	CUSTOMER MASTER	CUSTOMER MASTER	SUB_CATEGORY	SUB_CATEGORY	44	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	LICENSE_ID	LICENSE_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	IDENTIFIER_ID	IDENTIFIER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	CATEGORY	CATEGORY	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	NUMBER	NUMBER	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	STATUS	STATUS	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	AUTHORIZATION_STATUS	AUTHORIZATION_STATUS	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	LICENSE_NUMBER_KEY	LICENSE_NUMBER_KEY	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	TYPE	TYPE	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	STATE	STATE	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	AUTHORITY_NAME	AUTHORITY_NAME	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	ISO_COUNTRY_CODE	ISO_COUNTRY_CODE	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	BOARD_EXTERNAL_ID	BOARD_EXTERNAL_ID	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	TYPE_ID	TYPE_ID	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	TYPE_NAME	TYPE_NAME	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRIVILEGE_RANK	PRIVILEGE_RANK	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRIVILEGE_NAME	PRIVILEGE_NAME	19	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	DEACTIVATION_REASON_CODE	DEACTIVATION_REASON_CODE	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	BOARD_CODE	BOARD_CODE	21	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	DEGREE	DEGREE	22	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PROFESSION_CODE	PROFESSION_CODE	23	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRIVILEGE_ID	PRIVILEGE_ID	24	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	EXPIRATION_DATE	EXPIRATION_DATE	25	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	ISSUE_DATE	ISSUE_DATE	26	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	BOARD_DATE	BOARD_DATE	27	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SAMPLE_ELIGIBILITY	SAMPLE_ELIGIBILITY	28	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_CD	SOURCE_CD	29	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	RANK	RANK	30	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	CERTIFICATION	CERTIFICATION	31	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	REQ_SAMPL_NON_CTRL	REQ_SAMPL_NON_CTRL	32	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	REQ_SAMPL_CTRL	REQ_SAMPL_CTRL	33	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	RECV_SAMPL_NON_CTRL	RECV_SAMPL_NON_CTRL	34	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	RECV_SAMPL_CTRL	RECV_SAMPL_CTRL	35	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	DISTR_SAMPL_NON_CTRL	DISTR_SAMPL_NON_CTRL	36	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	DISTR_SAMPL_CTRL	DISTR_SAMPL_CTRL	37	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SAMP_DRUG_SCHED_I_FLAG	SAMP_DRUG_SCHED_I_FLAG	38	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SAMP_DRUG_SCHED_II_FLAG	SAMP_DRUG_SCHED_II_FLAG	39	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SAMP_DRUG_SCHED_III_FLAG	SAMP_DRUG_SCHED_III_FLAG	40	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SAMP_DRUG_SCHED_IV_FLAG	SAMP_DRUG_SCHED_IV_FLAG	41	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SAMP_DRUG_SCHED_V_FLAG	SAMP_DRUG_SCHED_V_FLAG	42	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SAMP_DRUG_SCHED_VI_FLAG	SAMP_DRUG_SCHED_VI_FLAG	43	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_NON_CTRL_FLAG	PRESCR_NON_CTRL_FLAG	44	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_APP_REQ_NON_CTRL_FLAG	PRESCR_APP_REQ_NON_CTRL_FLAG	45	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_CTRL_FLAG	PRESCR_CTRL_FLAG	46	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_APP_REQ_CTRL_FLAG	PRESCR_APP_REQ_CTRL_FLAG	47	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_DRUG_SCHED_I_FLAG	PRESCR_DRUG_SCHED_I_FLAG	48	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_DRUG_SCHED_II_FLAG	PRESCR_DRUG_SCHED_II_FLAG	49	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_DRUG_SCHED_III_FLAG	PRESCR_DRUG_SCHED_III_FLAG	50	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_DRUG_SCHED_IV_FLAG	PRESCR_DRUG_SCHED_IV_FLAG	51	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_DRUG_SCHED_V_FLAG	PRESCR_DRUG_SCHED_V_FLAG	52	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	PRESCR_DRUG_SCHED_VI_FLAG	PRESCR_DRUG_SCHED_VI_FLAG	53	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SUPERVISORY_REL_CD_NON_CTRL	SUPERVISORY_REL_CD_NON_CTRL	54	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SUPERVISORY_REL_CD_CTRL	SUPERVISORY_REL_CD_CTRL	55	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	COLLABORATIVE_NONCTRL	COLLABORATIVE_NONCTRL	56	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	COLLABORATIVE_CTRL	COLLABORATIVE_CTRL	57	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	INCLUSIONARY	INCLUSIONARY	58	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	EXCLUSIONARY	EXCLUSIONARY	59	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	DELEGATION_NON_CTRL	DELEGATION_NON_CTRL	60	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	DELEGATION_CTRL	DELEGATION_CTRL	61	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	DISCIPLINARY_ACTION_STATUS	DISCIPLINARY_ACTION_STATUS	62	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	63	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	64	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	65	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	66	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	67	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	68	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_LICENSE	CUSTOMER MASTER	CUSTOMER MASTER	AUTHORIZATION_STATUS_DATE	AUTHORIZATION_STATUS_DATE	69	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	MERGE_ID	MERGE_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	SRC_MERGE_ID	SRC_MERGE_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	LOSER_CUSTOMER_ID	LOSER_CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	WINNER_CUSTOMER_ID	WINNER_CUSTOMER_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	MERGE_TYPE	MERGE_TYPE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	MDM_URI	MDM_URI	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_STATUS	LOAD_STATUS	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	PLUGIN_PROCESS_DT	PLUGIN_PROCESS_DT	8	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_DETAILS	LOAD_DETAILS	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	10	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	11	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	12	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	13	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	14	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_MERGE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	15	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_MERGE_GIF_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	BATCH_STATUS	BATCH_STATUS	1	VARIANT			NO	YES	NO	NO
MDM_CANONICAL	C_MERGE_GIF_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	LAST_UPD_DT	LAST_UPD_DT	2	TIMESTAMP_NTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MERGE_OK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	BATCH_STATUS	BATCH_STATUS	1	VARIANT			NO	YES	NO	NO
MDM_CANONICAL	C_MERGE_OK_PROCESSING	CUSTOMER MASTER	CUSTOMER MASTER	LAST_UPD_DT	LAST_UPD_DT	2	TIMESTAMP_NTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	PRIVACY_PREFERENCE_ID	PRIVACY_PREFERENCE_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	SRC_PRIVACY_PREFERENCE_ID	SRC_PRIVACY_PREFERENCE_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	OPT_OUT	OPT_OUT	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	OPT_OUT_START_DATE	OPT_OUT_START_DATE	7	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	ALLOWED_TO_CONTACT	ALLOWED_TO_CONTACT	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	PHONE_OPT_OUT	PHONE_OPT_OUT	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	VISIT_OPT_OUT	VISIT_OPT_OUT	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	EMAIL_OPT_OUT	EMAIL_OPT_OUT	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	MAIL_OPT_OUT	MAIL_OPT_OUT	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	FAX_OPT_OUT	FAX_OPT_OUT	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	REMOTE_OPT_OUT	REMOTE_OPT_OUT	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	WEB_OPT_OUT	WEB_OPT_OUT	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	OPT_OUT_ONE_KEY	OPT_OUT_ONE_KEY	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	ALLOW_SAFE_HARBOR	ALLOW_SAFE_HARBOR	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	AMA_NO_CONTACT	AMA_NO_CONTACT	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	PDRP	PDRP	19	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	PDRP_DATE	PDRP_DATE	20	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	TEXT_MESSAGE_OPT_OUT	TEXT_MESSAGE_OPT_OUT	21	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	OPT_OUT_CHANGE_DATE	OPT_OUT_CHANGE_DATE	22	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	OPT_OUT_SAFE_HARBOR	OPT_OUT_SAFE_HARBOR	23	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	24	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	25	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	26	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	27	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	28	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_PRIVACY_PREFERENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	29	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	PROFESSION_ID	PROFESSION_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	SRC_PROFESSION_ID	SRC_PROFESSION_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	CODE	CODE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	RANK	RANK	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	6	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	7	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	8	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	9	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	10	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_PROFESSION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	11	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	PROGRAM_PARTICIPATION_ID	PROGRAM_PARTICIPATION_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	SRC_PROGRAM_PARTICIPATION_ID	SRC_PROGRAM_PARTICIPATION_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	CODE	CODE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	IDENTIFIER_TYPE	IDENTIFIER_TYPE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	IDENTIFIER_ID	IDENTIFIER_ID	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	CATEGORY_CODE	CATEGORY_CODE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	LEVEL_CODE	LEVEL_CODE	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	AGENCY_CODE	AGENCY_CODE	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	START_DATE	START_DATE	11	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	END_DATE	END_DATE	12	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	OPT_OUT_INDICATOR	OPT_OUT_INDICATOR	13	BOOLEAN			NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	14	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	15	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	16	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	17	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	18	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_PROGRAM_PARTICIPATION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	19	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	RECEPTION_HOURS_ID	RECEPTION_HOURS_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_RECEPTION_HOURS_ID	SRC_RECEPTION_HOURS_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ADDRESS_ID	CUSTOMER_ADDRESS_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	MONDAY	MONDAY	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	TUESDAY	TUESDAY	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	WEDNESDAY	WEDNESDAY	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	THURSDAY	THURSDAY	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	FRIDAY	FRIDAY	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SATURDAY	SATURDAY	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SUNDAY	SUNDAY	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	14	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	15	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	16	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	17	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	18	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_RECEPTION_HOURS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	19	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SANCTION_ID	SANCTION_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SRC_SANCTION_ID	SRC_SANCTION_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	IDENTIFIER_TYPE	IDENTIFIER_TYPE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	IDENTIFIER_ID	IDENTIFIER_ID	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	TYPE_CODE	TYPE_CODE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	DEACTIVATION_REASON_CODE	DEACTIVATION_REASON_CODE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	DISPOSITION_CATEGORY_CODE	DISPOSITION_CATEGORY_CODE	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	EXCLUSION_CODE	EXCLUSION_CODE	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	DESCRIPTION	DESCRIPTION	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	URL	URL	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	ISSUED_DATE	ISSUED_DATE	13	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	EFFECTIVE_DATE	EFFECTIVE_DATE	14	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	REINSTATEMENT_DATE	REINSTATEMENT_DATE	15	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	IS_STATE_WAIVER	IS_STATE_WAIVER	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_CODE	STATUS_CODE	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_CODE	SOURCE_CODE	18	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	PUBLICATION_DATE	PUBLICATION_DATE	19	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	GOVERNMENT_LEVEL_CODE	GOVERNMENT_LEVEL_CODE	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	21	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	22	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	23	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	24	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	25	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_SANCTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	26	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SPECIALTY_ID	SPECIALTY_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SRC_SPECIALTY_ID	SRC_SPECIALTY_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SPECIALTY_TYPE	SPECIALTY_TYPE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SPECIALTY	SPECIALTY	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	DESCRIPTION	DESCRIPTION	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SPECIALTY_GROUP	SPECIALTY_GROUP	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ADDRESS_ID	CUSTOMER_ADDRESS_ID	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	AFFILIATION_ID	AFFILIATION_ID	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SPECIALTY_DETAIL	SPECIALTY_DETAIL	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	RANK	RANK	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	PRIMARY_SPECIALTY_FLAG	PRIMARY_SPECIALTY_FLAG	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	PROFESSION_CODE	PROFESSION_CODE	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SUB_SPECIALTY	SUB_SPECIALTY	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SUB_SPECIALTY_RANK	SUB_SPECIALTY_RANK	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SORT_ORDER	SORT_ORDER	17	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	18	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	19	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	20	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	21	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	22	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_SPECIALTY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	23	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	AI_ID	AI_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	SRC_AI_ID	SRC_AI_ID	2	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	AITYPE	AITYPE	4	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	INSIGHTTYPE	INSIGHTTYPE	5	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	INSIGHTVALUE	INSIGHTVALUE	6	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	RANK	RANK	7	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	8	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	9	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	10	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	11	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	12	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_ACCELERATED_INSIGHTS	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	13	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	MCO_ID	MCO_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	1	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	NAME	NAME	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	CATEGORY	CATEGORY	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	COMPANY_TYPE	COMPANY_TYPE	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SUB_TYPE	SUB_TYPE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_IMS	STATUS_IMS	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_UPDATE_DATE	STATUS_UPDATE_DATE	10	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	STATUS_REASON_CODE	STATUS_REASON_CODE	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_STATUS	VALIDATION_STATUS	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	VALIDATION_CHANGE_REASON	VALIDATION_CHANGE_REASON	13	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	ALTERNATE_NAME	ALTERNATE_NAME	14	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	OPERATING_STATE_CODE	OPERATING_STATE_CODE	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	WEBSITE_URL	WEBSITE_URL	16	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	START_DATE	START_DATE	17	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	END_DATE	END_DATE	18	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SUM_OF_LIVES	SUM_OF_LIVES	19	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	MANAGED_CARE_PLAN_MODEL_TYPE_CODE	MANAGED_CARE_PLAN_MODEL_TYPE_CODE	20	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	LOCAL_MANAGED_CARE_PLAN_MODEL_TYPE_CODE	LOCAL_MANAGED_CARE_PLAN_MODEL_TYPE_CODE	21	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	MANAGED_CARE_PLAN_HQ_CITY_NAME	MANAGED_CARE_PLAN_HQ_CITY_NAME	22	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	MANAGED_CARE_PLAN_HQSTATE_PROVINCECODE	MANAGED_CARE_PLAN_HQSTATE_PROVINCECODE	23	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	NO_OF_TIERS	NO_OF_TIERS	24	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	PREFERRED_BRAND_TIER_ID	PREFERRED_BRAND_TIER_ID	25	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	PLAN_CATEGORY	PLAN_CATEGORY	26	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	PAYMENT_TYPE	PAYMENT_TYPE	27	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	ENROLLMENT_TYPE	ENROLLMENT_TYPE	28	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	IS_PBM_CONTROLLED	IS_PBM_CONTROLLED	29	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	IS_DISTRIBUTION_LIMIATION_ENFORCED	IS_DISTRIBUTION_LIMIATION_ENFORCED	30	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SIZE_OF_PHARMACY_NETWORK	SIZE_OF_PHARMACY_NETWORK	31	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SIZE_OF_MAIL_ORDER_PHARMACY	SIZE_OF_MAIL_ORDER_PHARMACY	32	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SIZE_OF_SPECIALTY_PHARMACY	SIZE_OF_SPECIALTY_PHARMACY	33	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	CORE_SERVICES	CORE_SERVICES	34	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	UTILIZATION_MANGEMENT_PROGRAMS	UTILIZATION_MANGEMENT_PROGRAMS	35	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	PLAN_ENROLLMENT	PLAN_ENROLLMENT	36	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	DOING_BUSINESS_AS_NAME	DOING_BUSINESS_AS_NAME	37	VARCHAR		0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	98	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	99	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	100	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	101	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	102	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	103	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_MCO	CUSTOMER MASTER	CUSTOMER MASTER	BF_ID	BF_ID	104	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	PLAN_TRANSACTION_ID	PLAN_TRANSACTION_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	SRC_PLAN_TRANSACTION_ID	SRC_PLAN_TRANSACTION_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	TRANSACTION_ID	TRANSACTION_ID	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	STATE	STATE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	BENEFIT_TYPE	BENEFIT_TYPE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	NO_OF_LIVES	NO_OF_LIVES	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	NO_OF_POLICIES	NO_OF_POLICIES	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	NO_OF_PATIENTS	NO_OF_PATIENTS	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	NO_OF_CLAIMS	NO_OF_CLAIMS	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	PRESCRIPTION_COUNT	PRESCRIPTION_COUNT	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	DATA_MONTH	DATA_MONTH	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	QUANTITY	QUANTITY	13	VARCHAR	16777216	0	NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE	SOURCE	14	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	15	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	CREATE_DATE	CREATE_DATE	16	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	UPDATE_DATE	UPDATE_DATE	17	DATE			NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	30	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	31	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	32	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	33	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	34	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_MCO_PLAN_TRANSACTION	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	35	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	FORMULARY_ID	FORMULARY_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	BRAND_NAME	BRAND_NAME	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	TIER_CODE	TIER_CODE	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	RESTRICTION	RESTRICTION	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	REASON_FOR_CHANGE	REASON_FOR_CHANGE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	REASON_FOR_CHANGE_DETAILS	REASON_FOR_CHANGE_DETAILS	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	TIER_NOMENCLATURE	TIER_NOMENCLATURE	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	COMPARATOR_ID	COMPARATOR_ID	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	COMPARATOR_NAME	COMPARATOR_NAME	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	30	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	31	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	32	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	33	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	34	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_FORMULARY	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	35	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOM_API_ID	CUSTOM_API_ID	1	VARCHAR	16777216		NO	NO	YES	NO
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOM_API_TYPE	CUSTOM_API_TYPE	2	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOM_API_URL	CUSTOM_API_URL	3	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOM_API_BODY	CUSTOM_API_BODY	4	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_ID	SOURCE_ID	5	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SOURCE_NAME	SOURCE_NAME	6	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	MDM_URI	MDM_URI	7	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	COUNTRY	COUNTRY	8	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_STATUS	LOAD_STATUS	9	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	LOAD_DETAILS	LOAD_DETAILS	10	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	RESP_STATUS_LABEL	RESP_STATUS_LABEL	11	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	RESP_DETAILS_LABEL	RESP_DETAILS_LABEL	12	VARCHAR	16777216		NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	PLUGIN_PROCESS_DT	PLUGIN_PROCESS_DT	13	TIMESTAMP_LTZ			NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SRC_CRT_DT	SRC_CRT_DT	14	TIMESTAMP_LTZ			NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SRC_END_DT	SRC_END_DT	15	TIMESTAMP_LTZ			NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SRC_UPDT_DT	SRC_UPDT_DT	16	TIMESTAMP_LTZ			NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	17	TIMESTAMP_LTZ			NO	NO	NO	NO
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	18	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	19	TIMESTAMP_LTZ			NO	NO	NO	NO
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	20	TIMESTAMP_LTZ			NO	YES	NO	YES
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	21	VARCHAR	16777216		NO	NO	NO	NO
MDM_CANONICAL	C_CUSTOM_API	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	22	TIMESTAMP_LTZ			NO	NO	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	DP_PRESENCE_ID	DP_PRESENCE_ID	1	VARCHAR	16777216		NO	NO	YES	YES
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	SRC_DP_PRESENCE_ID	SRC_PROFESSION_ID	2	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_ID	CUSTOMER_ID	3	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	CUSTOMER_TYPE	CUSTOMER_TYPE	4	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	CHANNEL_CODE	CHANNEL_CODE	5	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	CHANNEL_NAME	CHANNEL_NAME	6	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	CHANNEL_URL	CHANNEL_URL	7	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	PRESENCE_TYPE_CODE	PRESENCE_TYPE_CODE	8	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	ACTIVITY_CODE	ACTIVITY_CODE	9	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	AUDIENCE_CODE	AUDIENCE_CODE	10	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	ACTIVITY_SCORE	ACTIVITY_SCORE	11	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	AUDIENCE_SCORE	AUDIENCE_SCORE	12	VARCHAR	16777216		NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_DT	SYS_CRT_DT	13	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_DT	SYS_UPDT_DT	14	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_EFF_DT	SYS_EFF_DT	15	TIMESTAMP_LTZ			NO	NO	NO	YES
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_END_DT	SYS_END_DT	16	TIMESTAMP_LTZ			NO	YES	NO	NO
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_CRT_BY	SYS_CRT_BY	17	VARCHAR	16777216		NO	NO	NO	YES
MDM_CANONICAL	C_DP_PRESENCE	CUSTOMER MASTER	CUSTOMER MASTER	SYS_UPDT_BY	SYS_UPDT_BY	18	VARCHAR	16777216		NO	NO	NO	YES