Healthcare
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for Healthcare 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 | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | INACTIVATION_REASON | INACTIVATION_REASON | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | MDM_URI | MDM_URI | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | LOAD_STATUS | LOAD_STATUS | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | PLUGIN_PROCESS_DT | PLUGIN_PROCESS_DT | 6 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | LOAD_DETAILS | LOAD_DETAILS | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SOURCE_ID | SOURCE_ID | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SOURCE_NAME | SOURCE_NAME | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_SOURCE_ID | SUB_SOURCE_ID | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_SOURCE_NAME | SUB_SOURCE_NAME | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_CRT_DT | SRC_CRT_DT | 12 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_END_DT | SRC_END_DT | 13 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_UPDT_DT | SRC_UPDT_DT | 14 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 15 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 16 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 17 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 18 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 19 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HEALTHCARE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 20 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ADDRESS_ID | HEALTHCARE_ADDRESS_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_ADDRESS_ID | SRC_ADDRESS_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_HEALTHCARE_ADDRESS_ID | SRC_HEALTHCARE_ADDRESS_ID | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DERIVED_ADDRESS | DERIVED_ADDRESS | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | HCO_NAME | HCO_NAME | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | HCO_NAME_X | HCO_NAME_X | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_TYPE | ADDRESS_TYPE | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIMARY | PRIMARY | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_RANK | ADDRESS_RANK | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | LOC_CONF_IND | LOC_CONF_IND | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | BEST_RECORD | BEST_RECORD | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS | STATUS | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_LINE1 | ADDRESS_LINE1 | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_LINE1_X | ADDRESS_LINE1_X | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_LINE2 | ADDRESS_LINE2 | 16 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_LINE2_X | ADDRESS_LINE2_X | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_LINE3 | ADDRESS_LINE3 | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_LINE4 | ADDRESS_LINE4 | 19 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | CITY | CITY | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | CITY_X | CITY_X | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_PROVINCE | STATE_PROVINCE | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_PROVINCE_X | STATE_PROVINCE_X | 23 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_PROVINCE_CODE | STATE_PROVINCE_CODE | 24 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | COUNTRY | COUNTRY | 25 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | STREET | STREET | 26 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | FLOOR | FLOOR | 27 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | PREMISE_NUMBER | PREMISE_NUMBER | 28 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | BUILDING | BUILDING | 29 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_BUILDING | SUB_BUILDING | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | PO_BOX | PO_BOX | 31 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | CBSA_CODE | CBSA_CODE | 32 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | FIPS_COUNTY_CODE | FIPS_COUNTY_CODE | 33 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | FIPS_STATE_CODE | FIPS_STATE_CODE | 34 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | MSA | MSA | 35 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | MULTIUNIT | MULTIUNIT | 36 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DPV | DPV | 37 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | VERIFICATION_STATUS | VERIFICATION_STATUS | 38 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_CHANGE_DATE | STATUS_CHANGE_DATE | 39 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_UPDATE_DATE | STATUS_UPDATE_DATE | 40 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_STATUS | ADDRESS_STATUS | 41 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | POSTAL_CITY | POSTAL_CITY | 42 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | POSTAL_CITY_X | POSTAL_CITY_X | 43 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | AVC | AVC | 44 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | PREMISE | PREMISE | 45 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_ADMINISTRATIVE_AREA | SUB_ADMINISTRATIVE_AREA | 46 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_ADMINISTRATIVE_AREA_X | SUB_ADMINISTRATIVE_AREA_X | 47 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_TYPE1 | UNIT_TYPE1 | 48 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_OFFICIAL_CODE1 | UNIT_OFFICIAL_CODE1 | 49 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_VALUE1 | UNIT_VALUE1 | 50 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_VALUE1_X | UNIT_VALUE1_X | 51 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_NAME1 | UNIT_NAME1 | 52 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_TYPE2 | UNIT_TYPE2 | 53 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_OFFICIAL_CODE2 | UNIT_OFFICIAL_CODE2 | 54 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_VALUE2 | UNIT_VALUE2 | 55 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_VALUE2_X | UNIT_VALUE2_X | 56 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_NAME2 | UNIT_NAME2 | 57 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ZIP_5 | ZIP_5 | 58 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ZIP_4 | ZIP_4 | 59 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | RELATION_STATUS_CHANGE_DATE | RELATION_STATUS_CHANGE_DATE | 60 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_STATUS | VALIDATION_STATUS | 61 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_REASON | VALIDATION_REASON | 62 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_REASON_CODE | STATUS_REASON_CODE | 63 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_DATE | VALIDATION_CHANGE_DATE | 64 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | OFFICE_INFORMATION_BEST_TIMES | OFFICE_INFORMATION_BEST_TIMES | 65 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | OFFICE_INFORMATION_APPT_REQUIRED | OFFICE_INFORMATION_APPT_REQUIRED | 66 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | OFFICE_INFORMATION_OFFICE_NOTES | OFFICE_INFORMATION_OFFICE_NOTES | 67 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | BUILD_LABEL | BUILD_LABEL | 68 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | LOCALITY | LOCALITY | 69 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | NEIGHBORHOOD | NEIGHBORHOOD | 70 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | LATITUDE | LATITUDE | 71 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | LONGITUDE | LONGITUDE | 72 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | GEO_CODING_SYSTEM | GEO_CODING_SYSTEM | 73 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | GEOACCURACY | GEOACCURACY | 74 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | BF_ID | BF_ID | 75 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | CBSA_DESCRIPTION | CBSA_DESCRIPTION | 76 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | CBSA_DESCRIPTION_X | CBSA_DESCRIPTION_X | 77 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_INPUT_NESTED | ADDRESS_INPUT_NESTED | 78 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | POSTAL_CODE | POSTAL_CODE | 79 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ISO3166_2 | ISO3166_2 | 80 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ISO3166_3 | ISO3166_3 | 81 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ISO3166_N | ISO3166_N | 82 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SUPER_ADMINISTRATIVE_AREA | SUPER_ADMINISTRATIVE_AREA | 83 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ADMINISTRATIVE_AREA | ADMINISTRATIVE_AREA | 84 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_NAME | UNIT_NAME | 85 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNIT_VALUE | UNIT_VALUE | 86 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DOUBLE_DEPENDENT_LOCALITY | DOUBLE_DEPENDENT_LOCALITY | 87 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DEPENDENT_THOROUGHFARE | DEPENDENT_THOROUGHFARE | 88 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ORGANIZATION | ORGANIZATION | 89 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DELIVERY_ADDRESS | DELIVERY_ADDRESS | 90 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DELIVERY_ADDRESS_1 | DELIVERY_ADDRESS_1 | 91 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | UNMATCHED | UNMATCHED | 92 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | AUTO_ZONE_INDICATOR | AUTO_ZONE_INDICATOR | 93 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | CARRIER_ROUTE | CARRIER_ROUTE | 94 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | CMRA_INDICATOR | CMRA_INDICATOR | 95 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | CONGRESSIONAL_DISTRICT | CONGRESSIONAL_DISTRICT | 96 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DEFAULT_FLAG | DEFAULT_FLAG | 97 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DELIVERY_POINT_BARCODE | DELIVERY_POINT_BARCODE | 98 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DPV_CONFIRMED_INDICATOR | DPV_CONFIRMED_INDICATOR | 99 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | DPV_FOOTNOTES | DPV_FOOTNOTES | 100 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ELOT_CODE | ELOT_CODE | 101 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ELOT_NUMBER | ELOT_NUMBER | 102 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | EWS_FLAG | EWS_FLAG | 103 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | FALSE_POSITIVE_INDICATOR | FALSE_POSITIVE_INDICATOR | 104 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | FOOTNOTES | FOOTNOTES | 105 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | LACS_LINK_CODE | LACS_LINK_CODE | 106 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | LACS_LINK_INDICATOR | LACS_LINK_INDICATOR | 107 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | LACS_STATUS | LACS_STATUS | 108 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | NO_STAT_INDICATOR | NO_STAT_INDICATOR | 109 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | PMBNUMBER | PMBNUMBER | 110 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | PMBTYPE | PMBTYPE | 111 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIMARY_ADDRESS_LINE | PRIMARY_ADDRESS_LINE | 112 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | RECORD_TYPE | RECORD_TYPE | 113 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | RETURN_CODE | RETURN_CODE | 114 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | RESIDENTIAL_DELIVERY | RESIDENTIAL_DELIVERY | 115 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SECONDARY_ADDRESS_LINE | SECONDARY_ADDRESS_LINE | 116 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SUITE_LINK_FOOTNOTE | SUITE_LINK_FOOTNOTE | 117 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | VACANT_INDICATOR | VACANT_INDICATOR | 118 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | ACTIVE | ACTIVE | 119 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | VERIFICATION_STATUS_DETAILS | VERIFICATION_STATUS_DETAILS | 120 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 121 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 122 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 123 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 124 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 125 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HEALTHCARE_ADDRESS | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 126 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | AFFILIATION_ID | AFFILIATION_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_AFFILIATION_ID | SRC_AFFILIATION_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SOURCE_NAME | SOURCE_NAME | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | RELATION_TYPE | RELATION_TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | START_HEALTHCARE_ID | START_HEALTHCARE_ID | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | START_OBJECT_TYPE | START_OBJECT_TYPE | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | END_HEALTHCARE_ID | END_HEALTHCARE_ID | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | END_OBJECT_TYPE | END_OBJECT_TYPE | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | REL_GROUP | REL_GROUP | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | REL_ORDER | REL_ORDER | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_REASON_CODE | STATUS_REASON_CODE | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_UPDATE_DATE | STATUS_UPDATE_DATE | 12 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_REASON | VALIDATION_CHANGE_REASON | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_DATE | VALIDATION_CHANGE_DATE | 14 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_STATUS | VALIDATION_STATUS | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | AFFILIATION_STATUS | AFFILIATION_STATUS | 16 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | TITLE | TITLE | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PREF_OR_ACTIVE | PREF_OR_ACTIVE | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | RANK | RANK | 19 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | COMMENTERS | COMMENTERS | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | RELATIONSHIP_CREATE_DATE | RELATIONSHIP_CREATE_DATE | 21 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | RELATIONSHIP_START_DATE | RELATIONSHIP_START_DATE | 22 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | RELATIONSHIP_END_DATE | RELATIONSHIP_END_DATE | 23 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | UPDATE_DATE | UPDATE_DATE | 24 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | CHECKED_DATE | CHECKED_DATE | 25 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFERRED_MAIL_INDICATOR | PREFERRED_MAIL_INDICATOR | 26 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFERRED_VISIT_INDICATOR | PREFERRED_VISIT_INDICATOR | 27 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | COMMITTEE_MEMBER | COMMITTEE_MEMBER | 28 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | APPOINTMENT_REQUIRED | APPOINTMENT_REQUIRED | 29 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | WORKING_STATUS | WORKING_STATUS | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | COUNTRY | COUNTRY | 31 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIMARY_AFFILIATION_INDICATOR | PRIMARY_AFFILIATION_INDICATOR | 32 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | MDM_URI | MDM_URI | 33 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | LOAD_STATUS | LOAD_STATUS | 34 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PLUGIN_PROCESS_DT | PLUGIN_PROCESS_DT | 35 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | LOAD_DETAILS | LOAD_DETAILS | 36 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_ENTITY_INDICATOR | SUB_ENTITY_INDICATOR | 37 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_ORIGIN_CODE | PERMISSION_ORIGIN_CODE | 38 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_CHANNEL_CODE | PERMISSION_CHANNEL_CODE | 39 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMITTED_USE_TYPE_CODE | PERMITTED_USE_TYPE_CODE | 40 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_DATE | PERMISSION_DATE | 41 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_REFERENCE | PERMISSION_REFERENCE | 42 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | START_HEALTHCARE_MDM_URI | START_HEALTHCARE_MDM_URI | 43 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | END_HEALTHCARE_MDM_URI | END_HEALTHCARE_MDM_URI | 44 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_CRT_DT | SRC_CRT_DT | 45 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_END_DT | SRC_END_DT | 46 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 47 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 48 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 49 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 50 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 51 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_AFFILIATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 52 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | ADDRESS_BRICK_ID | ADDRESS_BRICK_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_ADDRESS_BRICK_ID | SRC_ADDRESS_BRICK_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | AFFILIATION_ID | AFFILIATION_ID | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ADDRESS_ID | HEALTHCARE_ADDRESS_ID | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | BRICK_TYPE | BRICK_TYPE | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | BRICK_VALUE | BRICK_VALUE | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | SORT_ORDER | SORT_ORDER | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 10 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 11 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 12 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 13 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 14 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_ADDRESS_BRICK | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 15 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | COMM_ID | COMM_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_COMM_ID | SRC_COMM_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | VALUE | VALUE | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE | TYPE | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | STD_CODE | STD_CODE | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | ACTIVE | ACTIVE | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ADDRESS_ID | HEALTHCARE_ADDRESS_ID | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | AFFILIATION_ID | AFFILIATION_ID | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | AREA_CODE | AREA_CODE | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | COUNTRY_CODE | COUNTRY_CODE | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | DIGIT_COUNT | DIGIT_COUNT | 13 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | EXTENSION | EXTENSION | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMAT_MASK | FORMAT_MASK | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMATTED_NUMBER | FORMATTED_NUMBER | 16 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | GEO_AREA | GEO_AREA | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | GEO_COUNTRY | GEO_COUNTRY | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | LINE_TYPE | LINE_TYPE | 19 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | LOCAL_NUMBER | LOCAL_NUMBER | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | RANK | RANK | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_STATUS | VALIDATION_STATUS | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDIA_PREFERRED | MEDIA_PREFERRED | 23 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDIA_DOMAIN | MEDIA_DOMAIN | 24 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_ORIGIN_CODE | PERMISSION_ORIGIN_CODE | 25 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_CHANNEL_CODE | PERMISSION_CHANNEL_CODE | 26 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMITTED_USE_TYPE_CODE | PERMITTED_USE_TYPE_CODE | 27 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_DATE | PERMISSION_DATE | 28 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_REFERENCE | PERMISSION_REFERENCE | 29 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 30 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 31 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 32 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 33 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 34 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_COMM | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 35 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | EDUCATION_ID | EDUCATION_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_EDUCATION_ID | SRC_EDUCATION_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE | TYPE | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | DEGREE | DEGREE | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | GRADUATED | GRADUATED | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | GPA | GPA | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | YEAR_OF_GRADUATION | YEAR_OF_GRADUATION | 9 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | YEARS_IN_PROGRAM | YEARS_IN_PROGRAM | 10 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | START_YEAR | START_YEAR | 11 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | END_YEAR | END_YEAR | 12 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | FIELD_OF_STUDY | FIELD_OF_STUDY | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDICAL_SCHOOL | MEDICAL_SCHOOL | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SCHOOL_NAME | SCHOOL_NAME | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | RANK | RANK | 16 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 17 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 18 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 19 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 20 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 21 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_EDUCATION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 22 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | MANAGER_HCO_ID | MANAGER_HCO_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | COUNTRY | COUNTRY | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE_CODE | TYPE_CODE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NAME | NAME | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NAME_X | NAME_X | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | OFFICIAL_NAME_X | OFFICIAL_NAME_X | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | DOING_BUSINESS_AS_NAME | DOING_BUSINESS_AS_NAME | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | OFFICIAL_NAME | OFFICIAL_NAME | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | INTERNATIONAL_NAME | INTERNATIONAL_NAME | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SHORT_NAME | SHORT_NAME | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SREP_ACCESS | SREP_ACCESS | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | GROUP_PRACTICE_ID | GROUP_PRACTICE_ID | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | ACCEPT_MEDICARE | ACCEPT_MEDICARE | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | ACCEPT_MEDICAID | ACCEPT_MEDICAID | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PERCENT_MEDICAID | PERCENT_MEDICAID | 16 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTH_SYSTEM_NAME | HEALTH_SYSTEM_NAME | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | GPO_MEMBERSHIP | GPO_MEMBERSHIP | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | ACADEMIC | ACADEMIC | 19 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | BUSINESS_ENTITY_TYPE | BUSINESS_ENTITY_TYPE | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIMARY_GPO | PRIMARY_GPO | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | MKT_SEGMENT_CODE | MKT_SEGMENT_CODE | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_LICENSE_BEDS | TOTAL_LICENSE_BEDS | 23 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_CENSUS_BEDS | TOTAL_CENSUS_BEDS | 24 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_PATIENTS | NUM_PATIENTS | 25 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_STAFFED_BEDS | TOTAL_STAFFED_BEDS | 26 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_SURGERIES | TOTAL_SURGERIES | 27 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_PROCEDURES | TOTAL_PROCEDURES | 28 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | OR_SURGERIES | OR_SURGERIES | 29 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | RESIDENT_PROGRAM | RESIDENT_PROGRAM | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | RESIDENT_COUNT | RESIDENT_COUNT | 31 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUMS_OF_PROVIDERS | NUMS_OF_PROVIDERS | 32 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMULARY | FORMULARY | 33 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CMS_COVERED_FOR_TEACHING | CMS_COVERED_FOR_TEACHING | 34 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | COMM_HOSP | COMM_HOSP | 35 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | EMAIL_DOMAIN | EMAIL_DOMAIN | 36 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS | STATUS | 37 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | COMPANY_TYPE | COMPANY_TYPE | 38 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | FOUNDED_YEAR | FOUNDED_YEAR | 39 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | LEGAL_DOMICILE | LEGAL_DOMICILE | 40 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | OWNER | OWNER | 41 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | OWNERSHIP_STATUS | OWNERSHIP_STATUS | 42 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PROFIT_STATUS | PROFIT_STATUS | 43 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CMI | CMI | 44 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_UPDATE_DATE | STATUS_UPDATE_DATE | 45 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_REASON_CODE | STATUS_REASON_CODE | 46 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | COMMENTERS | COMMENTERS | 47 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_STATUS | VALIDATION_STATUS | 48 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_REASON | VALIDATION_CHANGE_REASON | 49 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_DATE | VALIDATION_CHANGE_DATE | 50 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CREATE_DATE | CREATE_DATE | 51 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | UPDATE_DATE | UPDATE_DATE | 52 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CHECK_DATE | CHECK_DATE | 53 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_CODE | STATE_CODE | 54 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_DATE | STATE_DATE | 55 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_CHANGE_REASON | STATUS_CHANGE_REASON | 56 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_EMPLOYEES | NUM_EMPLOYEES | 57 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_MED_EMPLOYEES | NUM_MED_EMPLOYEES | 58 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_BEDS_INTENSIVE_CARE | TOTAL_BEDS_INTENSIVE_CARE | 59 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_EXAMINATION_ROOM | NUM_EXAMINATION_ROOM | 60 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_AFFILIATED_SITES | NUM_AFFILIATED_SITES | 61 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_ENROLLED_MEMBERS | NUM_ENROLLED_MEMBERS | 62 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_IN_PATIENTS | NUM_IN_PATIENTS | 63 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_OUT_PATIENTS | NUM_OUT_PATIENTS | 64 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_OPERATING_ROOMS | NUM_OPERATING_ROOMS | 65 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_PATIENTS_X_WEEK | NUM_PATIENTS_X_WEEK | 66 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | ACT_TYPE_CODE | ACT_TYPE_CODE | 67 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | DISPENSE_DRUGS | DISPENSE_DRUGS | 68 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_PRESCRIBERS | NUM_PRESCRIBERS | 69 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PATIENTS_X_YEAR | PATIENTS_X_YEAR | 70 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | ACCEPTS_NEW_PATIENTS | ACCEPTS_NEW_PATIENTS | 71 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_PRIORITY | CLASS_OF_TRADE_PRIORITY | 72 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_CLASSIFICATION | CLASS_OF_TRADE_CLASSIFICATION | 73 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_FACILITY_TYPE | CLASS_OF_TRADE_FACILITY_TYPE | 74 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_SPECIALTY | CLASS_OF_TRADE_SPECIALTY | 75 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_SUB_CATEGORY | CLASS_OF_TRADE_SUB_CATEGORY | 76 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_CODE | CLASS_OF_TRADE_CODE | 77 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_SOURCE_NAME | SUB_SOURCE_NAME | 78 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | CORP_PARENT_NAME | CORP_PARENT_NAME | 79 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | OWNER_SUB_NAME | OWNER_SUB_NAME | 80 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SUBTYPE_CODE | SUBTYPE_CODE | 81 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | MANAGER_HCO_NAME | MANAGER_HCO_NAME | 82 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 83 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | EMEDICAL_RECORD | EMEDICAL_RECORD | 84 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | EPRESCRIBE | EPRESCRIBE | 85 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PAY_PER_FORM | PAY_PER_FORM | 86 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | GEN_FIRST | GEN_FIRST | 87 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_VALUE | TAXONOMY_VALUE | 88 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_TYPE | TAXONOMY_TYPE | 89 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_STR_TYPE | TAXONOMY_STR_TYPE | 90 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_PROVIDER_TYPE | TAXONOMY_PROVIDER_TYPE | 91 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_CLASSIFICATION | TAXONOMY_CLASSIFICATION | 92 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_SPECIALIZATION | TAXONOMY_SPECIALIZATION | 93 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_PRIORITY | TAXONOMY_PRIORITY | 94 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_ORIGIN_CODE | PERMISSION_ORIGIN_CODE | 95 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_CHANNEL_CODE | PERMISSION_CHANNEL_CODE | 96 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMITTED_USE_TYPE_CODE | PERMITTED_USE_TYPE_CODE | 97 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_DATE | PERMISSION_DATE | 98 | DATE | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_REFERENCE | PERMISSION_REFERENCE | 99 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | BF_ID | BF_ID | 100 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 101 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 102 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 103 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 104 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 105 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCO | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 106 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | MANAGER_HCO_ID | MANAGER_HCO_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | COUNTRY | COUNTRY | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE_CODE | TYPE_CODE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NAME | NAME | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NAME_X | NAME_X | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | OFFICIAL_NAME_X | OFFICIAL_NAME_X | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | DOING_BUSINESS_AS_NAME | DOING_BUSINESS_AS_NAME | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | OFFICIAL_NAME | OFFICIAL_NAME | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | INTERNATIONAL_NAME | INTERNATIONAL_NAME | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SHORT_NAME | SHORT_NAME | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SREP_ACCESS | SREP_ACCESS | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | GROUP_PRACTICE_ID | GROUP_PRACTICE_ID | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | ACCEPT_MEDICARE | ACCEPT_MEDICARE | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | ACCEPT_MEDICAID | ACCEPT_MEDICAID | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERCENT_MEDICAID | PERCENT_MEDICAID | 16 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTH_SYSTEM_NAME | HEALTH_SYSTEM_NAME | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | GPO_MEMBERSHIP | GPO_MEMBERSHIP | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | ACADEMIC | ACADEMIC | 19 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | BUSINESS_ENTITY_TYPE | BUSINESS_ENTITY_TYPE | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIMARY_GPO | PRIMARY_GPO | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | MKT_SEGMENT_CODE | MKT_SEGMENT_CODE | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_LICENSE_BEDS | TOTAL_LICENSE_BEDS | 23 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_CENSUS_BEDS | TOTAL_CENSUS_BEDS | 24 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_PATIENTS | NUM_PATIENTS | 25 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_STAFFED_BEDS | TOTAL_STAFFED_BEDS | 26 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_SURGERIES | TOTAL_SURGERIES | 27 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_PROCEDURES | TOTAL_PROCEDURES | 28 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | OR_SURGERIES | OR_SURGERIES | 29 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | RESIDENT_PROGRAM | RESIDENT_PROGRAM | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | RESIDENT_COUNT | RESIDENT_COUNT | 31 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUMS_OF_PROVIDERS | NUMS_OF_PROVIDERS | 32 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMULARY | FORMULARY | 33 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CMS_COVERED_FOR_TEACHING | CMS_COVERED_FOR_TEACHING | 34 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | COMM_HOSP | COMM_HOSP | 35 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | EMAIL_DOMAIN | EMAIL_DOMAIN | 36 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS | STATUS | 37 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | COMPANY_TYPE | COMPANY_TYPE | 38 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FOUNDED_YEAR | FOUNDED_YEAR | 39 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | LEGAL_DOMICILE | LEGAL_DOMICILE | 40 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | OWNER | OWNER | 41 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | OWNERSHIP_STATUS | OWNERSHIP_STATUS | 42 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PROFIT_STATUS | PROFIT_STATUS | 43 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CMI | CMI | 44 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_UPDATE_DATE | STATUS_UPDATE_DATE | 45 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_REASON_CODE | STATUS_REASON_CODE | 46 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | COMMENTERS | COMMENTERS | 47 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_STATUS | VALIDATION_STATUS | 48 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_REASON | VALIDATION_CHANGE_REASON | 49 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_DATE | VALIDATION_CHANGE_DATE | 50 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CREATE_DATE | CREATE_DATE | 51 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | UPDATE_DATE | UPDATE_DATE | 52 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CHECK_DATE | CHECK_DATE | 53 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_CODE | STATE_CODE | 54 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_DATE | STATE_DATE | 55 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_CHANGE_REASON | STATUS_CHANGE_REASON | 56 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_EMPLOYEES | NUM_EMPLOYEES | 57 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_MED_EMPLOYEES | NUM_MED_EMPLOYEES | 58 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TOTAL_BEDS_INTENSIVE_CARE | TOTAL_BEDS_INTENSIVE_CARE | 59 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_EXAMINATION_ROOM | NUM_EXAMINATION_ROOM | 60 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_AFFILIATED_SITES | NUM_AFFILIATED_SITES | 61 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_ENROLLED_MEMBERS | NUM_ENROLLED_MEMBERS | 62 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_IN_PATIENTS | NUM_IN_PATIENTS | 63 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_OUT_PATIENTS | NUM_OUT_PATIENTS | 64 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_OPERATING_ROOMS | NUM_OPERATING_ROOMS | 65 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_PATIENTS_X_WEEK | NUM_PATIENTS_X_WEEK | 66 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | ACT_TYPE_CODE | ACT_TYPE_CODE | 67 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | DISPENSE_DRUGS | DISPENSE_DRUGS | 68 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_PRESCRIBERS | NUM_PRESCRIBERS | 69 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PATIENTS_X_YEAR | PATIENTS_X_YEAR | 70 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | ACCEPTS_NEW_PATIENTS | ACCEPTS_NEW_PATIENTS | 71 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_PRIORITY | CLASS_OF_TRADE_PRIORITY | 72 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_CLASSIFICATION | CLASS_OF_TRADE_CLASSIFICATION | 73 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_FACILITY_TYPE | CLASS_OF_TRADE_FACILITY_TYPE | 74 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_SPECIALTY | CLASS_OF_TRADE_SPECIALTY | 75 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_SUB_CATEGORY | CLASS_OF_TRADE_SUB_CATEGORY | 76 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CLASS_OF_TRADE_CODE | CLASS_OF_TRADE_CODE | 77 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_SOURCE_NAME | SUB_SOURCE_NAME | 78 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CORP_PARENT_NAME | CORP_PARENT_NAME | 79 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | OWNER_SUB_NAME | OWNER_SUB_NAME | 80 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SUBTYPE_CODE | SUBTYPE_CODE | 81 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | MANAGER_HCO_NAME | MANAGER_HCO_NAME | 82 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 83 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | EMEDICAL_RECORD | EMEDICAL_RECORD | 84 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | EPRESCRIBE | EPRESCRIBE | 85 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PAY_PER_FORM | PAY_PER_FORM | 86 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | GEN_FIRST | GEN_FIRST | 87 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_VALUE | TAXONOMY_VALUE | 88 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_TYPE | TAXONOMY_TYPE | 89 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_STR_TYPE | TAXONOMY_STR_TYPE | 90 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_PROVIDER_TYPE | TAXONOMY_PROVIDER_TYPE | 91 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_CLASSIFICATION | TAXONOMY_CLASSIFICATION | 92 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_SPECIALIZATION | TAXONOMY_SPECIALIZATION | 93 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TAXONOMY_PRIORITY | TAXONOMY_PRIORITY | 94 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_ORIGIN_CODE | PERMISSION_ORIGIN_CODE | 95 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_CHANNEL_CODE | PERMISSION_CHANNEL_CODE | 96 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMITTED_USE_TYPE_CODE | PERMITTED_USE_TYPE_CODE | 97 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_DATE | PERMISSION_DATE | 98 | DATE | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_REFERENCE | PERMISSION_REFERENCE | 99 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | BF_ID | BF_ID | 100 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 101 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 102 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 103 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 104 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 105 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCO_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 106 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | COUNTRY | COUNTRY | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE_CODE | TYPE_CODE | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SUBTYPE_CODE | SUBTYPE_CODE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | NAME | NAME | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_NAME | FIRST_NAME | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_NAME_X | FIRST_NAME_X | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | LAST_NAME | LAST_NAME | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | LAST_NAME_X | LAST_NAME_X | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | MIDDLE_NAME | MIDDLE_NAME | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | MIDDLE_NAME_X | MIDDLE_NAME_X | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SUFFIX_NAME | SUFFIX_NAME | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFERRED_NAME | PREFERRED_NAME | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | NICK_NAME | NICK_NAME | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | GENDER | GENDER | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | DOB | DOB | 16 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | YOB | YOB | 17 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | DOD | DOD | 18 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | YOD | YOD | 19 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFIX | PREFIX | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | KAISER_PROVIDER | KAISER_PROVIDER | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | MAJOR_PROFESSIONAL_ACTIVITY | MAJOR_PROFESSIONAL_ACTIVITY | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESENT_EMPLOYMENT | PRESENT_EMPLOYMENT | 23 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE_OF_PRACTICE | TYPE_OF_PRACTICE | 24 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_FIRST_NAME | FORMER_FIRST_NAME | 25 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_LAST_NAME | FORMER_LAST_NAME | 26 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_LAST_NAME_X | FORMER_LAST_NAME_X | 27 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_MIDDLE_NAME | FORMER_MIDDLE_NAME | 28 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_SUFFIX_NAME | FORMER_SUFFIX_NAME | 29 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | TITLE | TITLE | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS | STATUS | 31 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_UPDATE_DATE | STATUS_UPDATE_DATE | 32 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_REASON_CODE | STATUS_REASON_CODE | 33 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_CODE | STATE_CODE | 34 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_DATE | STATE_DATE | 35 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | CATEGORY | CATEGORY | 36 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | DEGREE_CODE | DEGREE_CODE | 37 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SALUTATION_NAME | SALUTATION_NAME | 38 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | TRAINING_HOSPITAL | TRAINING_HOSPITAL | 39 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | INITIALS | INITIALS | 40 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | ACRONYM_NAME | ACRONYM_NAME | 41 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_SET_DATE | FIRST_SET_DATE | 42 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | CREATE_DATE | CREATE_DATE | 43 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | UPDATE_DATE | UPDATE_DATE | 44 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | CHECK_DATE | CHECK_DATE | 45 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_STATUS | VALIDATION_STATUS | 46 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_REASON | VALIDATION_CHANGE_REASON | 47 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_DATE | VALIDATION_CHANGE_DATE | 48 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | APPOINTMENT_REQUIRED | APPOINTMENT_REQUIRED | 49 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFERRED_LANGUAGE | PREFERRED_LANGUAGE | 50 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | POLITICAL_AFFILIATION | POLITICAL_AFFILIATION | 51 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | KOL_TITLE | KOL_TITLE | 52 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_SOURCE_NAME | SUB_SOURCE_NAME | 53 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_OF_PATIENTS | NUM_OF_PATIENTS | 54 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | ADMINISTRATIVE_NAME | ADMINISTRATIVE_NAME | 55 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | ACCREDITATIONS | ACCREDITATIONS | 56 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | IS_BLACK_LISTED | IS_BLACK_LISTED | 57 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_ORIGIN_CODE | PERMISSION_ORIGIN_CODE | 58 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_CHANNEL_CODE | PERMISSION_CHANNEL_CODE | 59 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMITTED_USE_TYPE_CODE | PERMITTED_USE_TYPE_CODE | 60 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_DATE | PERMISSION_DATE | 61 | DATE | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_REFERENCE | PERMISSION_REFERENCE | 62 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | PROVIDER_IDENTIFIER_TYPE | PROVIDER_IDENTIFIER_TYPE | 63 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | WEBSITE_URL | WEBSITE_URL | 64 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | BF_ID | BF_ID | 65 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 66 | TIMESTAMP_LTZ | NO | YES | NO | YES | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 67 | TIMESTAMP_LTZ | NO | YES | NO | YES | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 68 | TIMESTAMP_LTZ | NO | YES | NO | YES | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 69 | TIMESTAMP_LTZ | NO | YES | NO | YES | ||
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 70 | VARCHAR | 16777216 | NO | YES | NO | YES | |
| MDM_CANONICAL | HC_HCP | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 71 | VARCHAR | 16777216 | NO | YES | NO | YES | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | COUNTRY | COUNTRY | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE_CODE | TYPE_CODE | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SUBTYPE_CODE | SUBTYPE_CODE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NAME | NAME | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_NAME | FIRST_NAME | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_NAME_X | FIRST_NAME_X | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | LAST_NAME | LAST_NAME | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | LAST_NAME_X | LAST_NAME_X | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | MIDDLE_NAME | MIDDLE_NAME | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | MIDDLE_NAME_X | MIDDLE_NAME_X | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SUFFIX_NAME | SUFFIX_NAME | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFERRED_NAME | PREFERRED_NAME | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NICK_NAME | NICK_NAME | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | GENDER | GENDER | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | DOB | DOB | 16 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | YOB | YOB | 17 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | DOD | DOD | 18 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | YOD | YOD | 19 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFIX | PREFIX | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | KAISER_PROVIDER | KAISER_PROVIDER | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | MAJOR_PROFESSIONAL_ACTIVITY | MAJOR_PROFESSIONAL_ACTIVITY | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESENT_EMPLOYMENT | PRESENT_EMPLOYMENT | 23 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE_OF_PRACTICE | TYPE_OF_PRACTICE | 24 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_FIRST_NAME | FORMER_FIRST_NAME | 25 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_LAST_NAME | FORMER_LAST_NAME | 26 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_LAST_NAME_X | FORMER_LAST_NAME_X | 27 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_MIDDLE_NAME | FORMER_MIDDLE_NAME | 28 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FORMER_SUFFIX_NAME | FORMER_SUFFIX_NAME | 29 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TITLE | TITLE | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS | STATUS | 31 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_UPDATE_DATE | STATUS_UPDATE_DATE | 32 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_REASON_CODE | STATUS_REASON_CODE | 33 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_CODE | STATE_CODE | 34 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE_DATE | STATE_DATE | 35 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CATEGORY | CATEGORY | 36 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | DEGREE_CODE | DEGREE_CODE | 37 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SALUTATION_NAME | SALUTATION_NAME | 38 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | TRAINING_HOSPITAL | TRAINING_HOSPITAL | 39 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | INITIALS | INITIALS | 40 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | ACRONYM_NAME | ACRONYM_NAME | 41 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_SET_DATE | FIRST_SET_DATE | 42 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CREATE_DATE | CREATE_DATE | 43 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | UPDATE_DATE | UPDATE_DATE | 44 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | CHECK_DATE | CHECK_DATE | 45 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_STATUS | VALIDATION_STATUS | 46 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_REASON | VALIDATION_CHANGE_REASON | 47 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | VALIDATION_CHANGE_DATE | VALIDATION_CHANGE_DATE | 48 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | APPOINTMENT_REQUIRED | APPOINTMENT_REQUIRED | 49 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFERRED_LANGUAGE | PREFERRED_LANGUAGE | 50 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | POLITICAL_AFFILIATION | POLITICAL_AFFILIATION | 51 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | KOL_TITLE | KOL_TITLE | 52 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | DEACTIVATION_DATE | DEACTIVATION_DATE | 53 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_SOURCE_NAME | SUB_SOURCE_NAME | 54 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_OF_PATIENTS | NUM_OF_PATIENTS | 55 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | ADMINISTRATIVE_NAME | ADMINISTRATIVE_NAME | 56 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | ACCREDITATIONS | ACCREDITATIONS | 57 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | IS_BLACK_LISTED | IS_BLACK_LISTED | 58 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_ORIGIN_CODE | PERMISSION_ORIGIN_CODE | 59 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_CHANNEL_CODE | PERMISSION_CHANNEL_CODE | 60 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMITTED_USE_TYPE_CODE | PERMITTED_USE_TYPE_CODE | 61 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_DATE | PERMISSION_DATE | 62 | DATE | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PERMISSION_REFERENCE | PERMISSION_REFERENCE | 63 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | PROVIDER_IDENTIFIER_TYPE | PROVIDER_IDENTIFIER_TYPE | 64 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | WEBSITE_URL | WEBSITE_URL | 65 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | BF_ID | BF_ID | 66 | VARCHAR | 16777216 | NO | YES | NO | YES | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 67 | TIMESTAMP_LTZ | NO | YES | NO | YES | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 68 | TIMESTAMP_LTZ | NO | YES | NO | YES | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 69 | TIMESTAMP_LTZ | NO | YES | NO | YES | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 70 | TIMESTAMP_LTZ | NO | YES | NO | YES | ||
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 71 | VARCHAR | 16777216 | NO | YES | NO | YES | |
| MDM_CANONICAL | HC_HCP_PAYER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 72 | VARCHAR | 16777216 | NO | YES | NO | YES | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | IDENTIFIER_ID | IDENTIFIER_ID | 1 | VARCHAR | 16777216 | NO | YES | NO | YES | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_IDENTIFIER_ID | SRC_IDENTIFIER_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ADDRESS_ID | HEALTHCARE_ADDRESS_ID | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | AFFILIATION_ID | AFFILIATION_ID | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | ID_TYPE | ID_TYPE | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | ID | ID | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE | TYPE | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE | STATE | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | IDENTIFIER_ORDER | IDENTIFIER_ORDER | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | CATEGORY | CATEGORY | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | AUTHORIZATION_STATUS | AUTHORIZATION_STATUS | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS | STATUS | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | BIRTH_CITY | BIRTH_CITY | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | BIRTH_STATE | BIRTH_STATE | 16 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | BIRTH_COUNTRY | BIRTH_COUNTRY | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | EMPLOYMENT_TYPE_CODE | EMPLOYMENT_TYPE_CODE | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | GRADUATION_YEAR | GRADUATION_YEAR | 19 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | AMA_MD_DO_FLAG | AMA_MD_DO_FLAG | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDICAL_SCHOOL | MEDICAL_SCHOOL | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | MAJOR_PROF_ACT | MAJOR_PROF_ACT | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | PRACTICE_TYPE_CODE | PRACTICE_TYPE_CODE | 23 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | AMA_HOSPITAL_ID | AMA_HOSPITAL_ID | 24 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | HOSPITAL_HOURS | HOSPITAL_HOURS | 25 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | NUM_OF_PYSICIANS | NUM_OF_PYSICIANS | 26 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | DEACTIVATION_REASON_CODE | DEACTIVATION_REASON_CODE | 27 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | DEACTIVATION_DATE | DEACTIVATION_DATE | 28 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | REACTIVATION_DATE | REACTIVATION_DATE | 29 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | NATIONAL_ID | NATIONAL_ID | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | EXPIRATION_DATE | EXPIRATION_DATE | 31 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | BUSINESS_ACTIVITY_CODE | BUSINESS_ACTIVITY_CODE | 32 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_BUSINESS_ACTIVITY_CODE | SUB_BUSINESS_ACTIVITY_CODE | 33 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | DRUG_SCHEDULE | DRUG_SCHEDULE | 34 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | DEA_CHANGE_REASON_CODE | DEA_CHANGE_REASON_CODE | 35 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_CATEGORY | SUB_CATEGORY | 36 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | LOCAL_STATUS | LOCAL_STATUS | 37 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | ACTIVATION_DATE | ACTIVATION_DATE | 38 | DATE | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 39 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 40 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 41 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 42 | TIMESTAMP_LTZ | NO | NO | NO | NO | ||
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 43 | VARCHAR | 16777216 | NO | NO | NO | NO | |
| MDM_CANONICAL | HC_IDENTIFIER | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 44 | VARCHAR | 16777216 | NO | NO | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | LICENSE_ID | LICENSE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | IDENTIFIER_ID | IDENTIFIER_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | AFFILIATION_ID | AFFILIATION_ID | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | CATEGORY | CATEGORY | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | NUMBER | NUMBER | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS | STATUS | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | AUTHORIZATION_STATUS | AUTHORIZATION_STATUS | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | LICENSE_NUMBER_KEY | LICENSE_NUMBER_KEY | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE | TYPE | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | STATE | STATE | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | AUTHORITY_NAME | AUTHORITY_NAME | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | ISO_COUNTRY_CODE | ISO_COUNTRY_CODE | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | BOARD_EXTERNAL_ID | BOARD_EXTERNAL_ID | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | ID_TYPE | ID_TYPE | 16 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE_NAME | TYPE_NAME | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | REACTIVATION_DATE | REACTIVATION_DATE | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIVILEGE_RANK | PRIVILEGE_RANK | 19 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIVILEGE_NAME | PRIVILEGE_NAME | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | DEACTIVATION_REASON_CODE | DEACTIVATION_REASON_CODE | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | DEACTIVATION_DATE | DEACTIVATION_DATE | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | BOARD_CODE | BOARD_CODE | 23 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | DEGREE | DEGREE | 24 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PROFESSION_CODE | PROFESSION_CODE | 25 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIVILEGE_ID | PRIVILEGE_ID | 26 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | EXPIRATION_DATE | EXPIRATION_DATE | 27 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | ISSUE_DATE | ISSUE_DATE | 28 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | BOARD_DATE | BOARD_DATE | 29 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SAMPLE_ELIGIBILITY | SAMPLE_ELIGIBILITY | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SOURCE_CD | SOURCE_CD | 31 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | RANK | RANK | 32 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | CERTIFICATION | CERTIFICATION | 33 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | REQ_SAMPL_NON_CTRL | REQ_SAMPL_NON_CTRL | 34 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | REQ_SAMPL_CTRL | REQ_SAMPL_CTRL | 35 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | RECV_SAMPL_NON_CTRL | RECV_SAMPL_NON_CTRL | 36 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | RECV_SAMPL_CTRL | RECV_SAMPL_CTRL | 37 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | DISTR_SAMPL_NON_CTRL | DISTR_SAMPL_NON_CTRL | 38 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | DISTR_SAMPL_CTRL | DISTR_SAMPL_CTRL | 39 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SAMP_DRUG_SCHED_I_FLAG | SAMP_DRUG_SCHED_I_FLAG | 40 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SAMP_DRUG_SCHED_II_FLAG | SAMP_DRUG_SCHED_II_FLAG | 41 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SAMP_DRUG_SCHED_III_FLAG | SAMP_DRUG_SCHED_III_FLAG | 42 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SAMP_DRUG_SCHED_IV_FLAG | SAMP_DRUG_SCHED_IV_FLAG | 43 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SAMP_DRUG_SCHED_V_FLAG | SAMP_DRUG_SCHED_V_FLAG | 44 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SAMP_DRUG_SCHED_VI_FLAG | SAMP_DRUG_SCHED_VI_FLAG | 45 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_NON_CTRL_FLAG | PRESCR_NON_CTRL_FLAG | 46 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_APP_REQ_NON_CTRL_FLAG | PRESCR_APP_REQ_NON_CTRL_FLAG | 47 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_CTRL_FLAG | PRESCR_CTRL_FLAG | 48 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_APP_REQ_CTRL_FLAG | PRESCR_APP_REQ_CTRL_FLAG | 49 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_DRUG_SCHED_I_FLAG | PRESCR_DRUG_SCHED_I_FLAG | 50 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_DRUG_SCHED_II_FLAG | PRESCR_DRUG_SCHED_II_FLAG | 51 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_DRUG_SCHED_III_FLAG | PRESCR_DRUG_SCHED_III_FLAG | 52 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_DRUG_SCHED_IV_FLAG | PRESCR_DRUG_SCHED_IV_FLAG | 53 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_DRUG_SCHED_V_FLAG | PRESCR_DRUG_SCHED_V_FLAG | 54 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESCR_DRUG_SCHED_VI_FLAG | PRESCR_DRUG_SCHED_VI_FLAG | 55 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SUPERVISORY_REL_CD_NON_CTRL | SUPERVISORY_REL_CD_NON_CTRL | 56 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SUPERVISORY_REL_CD_CTRL | SUPERVISORY_REL_CD_CTRL | 57 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | COLLABORATIVE_NONCTRL | COLLABORATIVE_NONCTRL | 58 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | COLLABORATIVE_CTRL | COLLABORATIVE_CTRL | 59 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | INCLUSIONARY | INCLUSIONARY | 60 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | EXCLUSIONARY | EXCLUSIONARY | 61 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | DELEGATION_NON_CTRL | DELEGATION_NON_CTRL | 62 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | DELEGATION_CTRL | DELEGATION_CTRL | 63 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | DISCIPLINARY_ACTION_STATUS | DISCIPLINARY_ACTION_STATUS | 64 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 65 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 66 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 67 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 68 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 69 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_LICENSE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 70 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | MERGE_ID | MERGE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_MERGE_ID | SRC_MERGE_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | LOSER_HEALTHCARE_ID | LOSER_HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | WINNER_HEALTHCARE_ID | WINNER_HEALTHCARE_ID | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | MERGE_TYPE | MERGE_TYPE | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | MDM_URI | MDM_URI | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | LOAD_STATUS | LOAD_STATUS | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | PLUGIN_PROCESS_DT | PLUGIN_PROCESS_DT | 8 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | LOAD_DETAILS | LOAD_DETAILS | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 10 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 11 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 12 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 13 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 14 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_MERGE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 15 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIVACY_PREFERENCE_ID | PRIVACY_PREFERENCE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_PRIVACY_PREFERENCE_ID | SRC_PRIVACY_PREFERENCE_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | AFFILIATION_ID | AFFILIATION_ID | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | OPT_OUT | OPT_OUT | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | OPT_OUT_START_DATE | OPT_OUT_START_DATE | 7 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | ALLOWED_TO_CONTACT | ALLOWED_TO_CONTACT | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | PHONE_OPT_OUT | PHONE_OPT_OUT | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | VISIT_OPT_OUT | VISIT_OPT_OUT | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | EMAIL_OPT_OUT | EMAIL_OPT_OUT | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | MAIL_OPT_OUT | MAIL_OPT_OUT | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | FAX_OPT_OUT | FAX_OPT_OUT | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | REMOTE_OPT_OUT | REMOTE_OPT_OUT | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | WEB_OPT_OUT | WEB_OPT_OUT | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | OPT_OUT_ONE_KEY | OPT_OUT_ONE_KEY | 16 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | ALLOW_SAFE_HARBOR | ALLOW_SAFE_HARBOR | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | AMA_NO_CONTACT | AMA_NO_CONTACT | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | PDRP | PDRP | 19 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | PDRP_DATE | PDRP_DATE | 20 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | TEXT_MESSAGE_OPT_OUT | TEXT_MESSAGE_OPT_OUT | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | DELETE_ENTITY | DELETE_ENTITY | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | OPT_OUT_CHANGE_DATE | OPT_OUT_CHANGE_DATE | 23 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | OPT_OUT_SAFE_HARBOR | OPT_OUT_SAFE_HARBOR | 24 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 25 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 26 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 27 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 28 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 29 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_PRIVACY_PREFERENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 30 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | PROFESSION_ID | PROFESSION_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_PROFESSION_ID | SRC_PROFESSION_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | CODE | CODE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | RANK | RANK | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 6 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 7 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 8 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 9 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 10 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_PROFESSION | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 11 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SPECIALTY_ID | SPECIALTY_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_SPECIALTY_ID | SRC_SPECIALTY_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_TYPE | HEALTHCARE_TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SPECIALTY_TYPE | SPECIALTY_TYPE | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SPECIALTY | SPECIALTY | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | DESCRIPTION | DESCRIPTION | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SPECIALTY_GROUP | SPECIALTY_GROUP | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ADDRESS_ID | HEALTHCARE_ADDRESS_ID | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | AFFILIATION_ID | AFFILIATION_ID | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SPECIALTY_DETAIL | SPECIALTY_DETAIL | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | RANK | RANK | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIMARY_SPECIALTY_FLAG | PRIMARY_SPECIALTY_FLAG | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | PROFESSION_CODE | PROFESSION_CODE | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_SPECIALTY | SUB_SPECIALTY | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SUB_SPECIALTY_RANK | SUB_SPECIALTY_RANK | 16 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SORT_ORDER | SORT_ORDER | 17 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 18 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 19 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 20 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 21 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 22 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_SPECIALTY | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 23 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | NAME | NAME | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | MIDDLE_INITIAL | MIDDLE_INITIAL | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | LANGUAGE_PREFERENCE | LANGUAGE_PREFERENCE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SENTIMENT | SENTIMENT | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | DOB | DOB | 6 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | DAYOB | DAYOB | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | MOB | MOB | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | DAYOD | DAYOD | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | MOD | MOD | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SUBJECT_TYPE | SUBJECT_TYPE | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | MASTER_SUBJECT_ID | MASTER_SUBJECT_ID | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | CREDENTIAL | CREDENTIAL | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | COUNTRY | COUNTRY | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | MINOR | MINOR | 15 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | NO_OF_CHILDREN | NO_OF_CHILDREN | 16 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | HOUSEHOLD_COUNT | HOUSEHOLD_COUNT | 17 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | RACE | RACE | 18 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | RELIGION | RELIGION | 19 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | NATIONALITY | NATIONALITY | 20 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | LEGAL_SEX | LEGAL_SEX | 21 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFIX | PREFIX | 22 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_NAME | FIRST_NAME | 23 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | MIDDLE_NAME | MIDDLE_NAME | 24 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | LAST_NAME | LAST_NAME | 25 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SUFFIX_NAME | SUFFIX_NAME | 26 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFERRED_NAME | PREFERRED_NAME | 27 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | TITLE | TITLE | 28 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | NICK_NAME | NICK_NAME | 29 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | ROLE_TYPE | ROLE_TYPE | 30 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS | STATUS | 31 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_REASON_CODE | STATUS_REASON_CODE | 32 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | STATUS_UPDATE_DATE | STATUS_UPDATE_DATE | 33 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | YOB | YOB | 34 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | BIRTH_CITY | BIRTH_CITY | 35 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | BIRTH_STATE | BIRTH_STATE | 36 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | BIRTH_COUNTRY | BIRTH_COUNTRY | 37 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | DOD | DOD | 38 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | YOD | YOD | 39 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | PRESUMED_DEAD | PRESUMED_DEAD | 40 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | IMAGE_LINKS | IMAGE_LINKS | 41 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | VIDEO_LINKS | VIDEO_LINKS | 42 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | DOCUMENT_LINKS | DOCUMENT_LINKS | 43 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | WEBSITE_URL | WEBSITE_URL | 44 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | DESCRIPTION | DESCRIPTION | 45 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | MARITAL_STATUS | MARITAL_STATUS | 46 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | INCOME_BAND | INCOME_BAND | 47 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | AGE_BAND | AGE_BAND | 48 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | HAS_CHILDREN | HAS_CHILDREN | 49 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | GENDER | GENDER | 50 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | ETHNICITY | ETHNICITY | 51 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_CRT_DT | SRC_CRT_DT | 52 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_END_DT | SRC_END_DT | 53 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_UPDT_DT | SRC_UPDT_DT | 54 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 55 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 56 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 57 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 58 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 59 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_PATIENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 60 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | DEVICE_ID | DEVICE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_DEVICE_ID | SRC_DEVICE_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | DEVICEID | DEVICEID | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | IMAGE_LINKS | IMAGE_LINKS | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | DEVICE_TYPE | DEVICE_TYPE | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | OPERATING_SYSTEM | OPERATING_SYSTEM | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | WIFI_ENABLED | WIFI_ENABLED | 8 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | IS_4G_ENABLED | IS_4G_ENABLED | 9 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | APP_COMPLIANT | APP_COMPLIANT | 10 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | MANUAL_REFILL | MANUAL_REFILL | 11 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | AUTO_REFILL | AUTO_REFILL | 12 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 13 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 14 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 15 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 16 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 17 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_DEVICE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 18 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | APP_DATA_ID | APP_DATA_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_APP_DATA_ID | SRC_APP_DATA_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | USER_NAME | USER_NAME | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | APP_NAME | APP_NAME | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | APP_OS | APP_OS | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 7 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 8 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 9 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 10 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 11 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_APP_DATA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 12 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | APP_TRACKING_DETAIL_ID | APP_TRACKING_DETAIL_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_APP_TRACKING_DETAIL_ID | SRC_APP_TRACKING_DETAIL_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | APP_DATA_ID | APP_DATA_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | TIME_PERIOD_LENGTH | TIME_PERIOD_LENGTH | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | TIME_PERIOD | TIME_PERIOD | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | READING_TYPE | READING_TYPE | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | READING | READING | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | READING_ANALYSIS | READING_ANALYSIS | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 9 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 10 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 11 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 12 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 13 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_APP_TRACKING_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 14 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | DIGITAL_PRESENCE_ID | DIGITAL_PRESENCE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_DIGITAL_PRESENCE_ID | SRC_DIGITAL_PRESENCE_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE | TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | LINK | LINK | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | DESCRIPTION | DESCRIPTION | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | COMMENTERS | COMMENTERS | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 8 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 9 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 10 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 11 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 12 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_DIGITAL_PRESENCE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 13 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | ALTERNATE_CONTACT_ID | ALTERNATE_CONTACT_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_ALTERNATE_CONTACT_ID | SRC_ALTERNATE_CONTACT_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_NAME | FIRST_NAME | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | MIDDLE_NAME | MIDDLE_NAME | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | LAST_NAME | LAST_NAME | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | SUFFIX_NAME | SUFFIX_NAME | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFIX | PREFIX | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | RELATIONSHIPTOSUBJECT | RELATIONSHIPTOSUBJECT | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | PHONE | PHONE | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |||
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 12 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 13 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 14 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 15 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 16 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_ALTERNATE_CONTACT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 17 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SUBJECT_DETAIL_ID | SUBJECT_DETAIL_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_SUBJECT_DETAIL_ID | SRC_SUBJECT_DETAIL_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | CONDITIONTYPE | CONDITIONTYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | THERAPY | THERAPY | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | START_DATE | START_DATE | 6 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | STARRATING | STARRATING | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDDEVICE_TYPE | MEDDEVICE_TYPE | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDDEVICE_MODEL | MEDDEVICE_MODEL | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDDEVICE_SERIAL | MEDDEVICE_SERIAL | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDDEVICE_INSTALL_DATE | MEDDEVICE_INSTALL_DATE | 11 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | MEDDEVICE_REPL_DATE | MEDDEVICE_REPL_DATE | 12 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | PRIMARY_INSURANCE | PRIMARY_INSURANCE | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SECONDARY_INSURANCE | SECONDARY_INSURANCE | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 15 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 16 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 17 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 18 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 19 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_SUBJECT_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 20 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SUBJECT_MEASUREMENT_ID | SUBJECT_MEASUREMENT_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_SUBJECT_MEASUREMENT_ID | SRC_SUBJECT_MEASUREMENT_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE | TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | VALUE | VALUE | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | Date_Measured | Date_Measured | 6 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | Percentile | Percentile | 7 | INTEGER | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 8 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 9 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 10 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 11 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 12 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_SUBJECT_MEASUREMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 13 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | INSURANCE_DETAIL_ID | INSURANCE_DETAIL_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_INSURANCE_DETAIL_ID | SRC_INSURANCE_DETAIL_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE | TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | NAME | NAME | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | ID | ID | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | INSURANCE_GROUP | INSURANCE_GROUP | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | PHONE | PHONE | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | POLICY_HOLDER_NAME | POLICY_HOLDER_NAME | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | RELATIONSHIP_TO_SUBJECT | RELATIONSHIP_TO_SUBJECT | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | INSURANCE_ADDRESS | INSURANCE_ADDRESS | 11 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | POLICY_HOLDER_SSN | POLICY_HOLDER_SSN | 12 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | POLICY_HOLDER_DOB | POLICY_HOLDER_DOB | 13 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | POLICY_HOLDER_EMPLOYER | POLICY_HOLDER_EMPLOYER | 14 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | POLICY_HOLDER_EMPLOYER_PHONE | POLICY_HOLDER_EMPLOYER_PHONE | 15 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | POLICY_HOLDER_EMPLOYER_ADDRESS | POLICY_HOLDER_EMPLOYER_ADDRESS | 16 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 17 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 18 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 19 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 20 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 21 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_INSURANCE_DETAIL | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 22 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | ALTERNATE_NAME_ID | ALTERNATE_NAME_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_ALTERNATE_NAME_ID | SRC_ALTERNATE_NAME_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | TYPE | TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | DESCRIPTION | DESCRIPTION | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | FIRST_NAME | FIRST_NAME | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | LAST_NAME | LAST_NAME | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | MIDDLE_NAME | MIDDLE_NAME | 8 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | PREFIX | PREFIX | 9 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | SUFFIX | SUFFIX | 10 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 11 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 12 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 13 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 14 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 15 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_ALTERNATE_NAME | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 16 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | MULTI_CHANNEL_COMMUNICATION_CONSENT_ID | MULTI_CHANNEL_COMMUNICATION_CONSENT_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_MULTI_CHANNEL_COMMUNICATION_CONSENT_ID | SRC_MULTI_CHANNEL_COMMUNICATION_CONSENT_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | CHANNEL_TYPE | CHANNEL_TYPE | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | CHANNEL_VALUE | CHANNEL_VALUE | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | CHANNEL_CONSENT | CHANNEL_CONSENT | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | START_DATE | START_DATE | 7 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | EXPIRATION_DATE | EXPIRATION_DATE | 8 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | COMMUNICATION_TYPE | COMMUNICATION_TYPE | 9 | VARCHAR | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | COMMUNICATION_FREQUENCY | COMMUNICATION_FREQUENCY | 10 | VARCHAR | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | CHANNEL_PREFERENCE_FLAG | CHANNEL_PREFERENCE_FLAG | 11 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 12 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 13 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 14 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 15 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 16 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_MULTI_CHANNEL_COMMUNICATION_CONSENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 17 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | EMPLOYMENT_ID | EMPLOYMENT_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_EMPLOYMENT_ID | SRC_EMPLOYMENT_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | Organization | Organization | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | Title | Title | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | Summary | Summary | 6 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | Is_Current | Is_Current | 7 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 8 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 9 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 10 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 11 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 12 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_EMPLOYMENT | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 13 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | SOCIAL_MEDIA_ID | SOCIAL_MEDIA_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_SOCIAL_MEDIA_ID | SRC_SOCIAL_MEDIA_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | CHANNEL_NAME | CHANNEL_NAME | 4 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | IDENTIFIER | IDENTIFIER | 5 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | JOIN_DATE | JOIN_DATE | 6 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | ACTIVE_STATUS | ACTIVE_STATUS | 7 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 8 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 9 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 10 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 11 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 12 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_SOCIAL_MEDIA | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 13 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | TRIAL_ATTITUDE_ID | TRIAL_ATTITUDE_ID | 1 | VARCHAR | 16777216 | NO | NO | YES | YES | |
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | SRC_TRIAL_ATTITUDE_ID | SRC_TRIAL_ATTITUDE_ID | 2 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | HEALTHCARE_ID | HEALTHCARE_ID | 3 | VARCHAR | 16777216 | NO | YES | NO | NO | |
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | OK_FOR_TRIAL | OK_FOR_TRIAL | 4 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | CURRENTLY_ENGAGED | CURRENTLY_ENGAGED | 5 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | PAST_ENGAGED | PAST_ENGAGED | 6 | BOOLEAN | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | LAST_ENGAGED | LAST_ENGAGED | 7 | DATE | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_DT | SYS_CRT_DT | 8 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_DT | SYS_UPDT_DT | 9 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_EFF_DT | SYS_EFF_DT | 10 | TIMESTAMP_LTZ | NO | NO | NO | YES | ||
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_END_DT | SYS_END_DT | 11 | TIMESTAMP_LTZ | NO | YES | NO | NO | ||
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_CRT_BY | SYS_CRT_BY | 12 | VARCHAR | 16777216 | NO | NO | NO | YES | |
| MDM_CANONICAL | HC_TRIAL_ATTITUDE | HEALTHCARE MASTER | HEALTHCARE MASTER | SYS_UPDT_BY | SYS_UPDT_BY | 13 | VARCHAR | 16777216 | NO | NO | NO | YES |