Business Party
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for Business Party in a new tab. |
List of Objects
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | BP_AFFLN_SYS_KEY_C | BP AFFLN SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | BP_AFFLN_BUS_KEY_C | BP AFFLN BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SRC_SYS_CD_C | SRC SYS CD C | 3 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | CTRY_CD_C | CTRY CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | BP_AFFLN_SRC_ENTY_ID_C | BP AFFLN SRC ENTY ID C | 5 | VARCHAR | 200 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | FRM_BP_SYS_KEY_C | FRM BP SYS KEY C | 6 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | FRM_BP_TYP_CD_C | FRM BP TYP CD C | 7 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | TO_BP_SYS_KEY_C | TO BP SYS KEY C | 8 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | TO_BP_TYP_CD_C | TO BP TYP CD C | 9 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | AFFLN_TYPE_CD_C | AFFLN TYPE CD C | 10 | VARCHAR | 200 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | AFFLN_ROLE_CD_C | AFFLN ROLE CD C | 11 | VARCHAR | 200 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | BST_AFFLN_IND_C | BST AFFLN IND C | 12 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | AFFLN_RANK_NUM_C | AFFLN RANK NUM C | 13 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | AFFLN_STAT_CD_C | AFFLN STAT CD C | 14 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SRC_EFF_DTT_C | SRC EFF DTT C | 15 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SRC_END_DTT_C | SRC END DTT C | 16 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SRC_UPDT_DTT_C | SRC UPDT DTT C | 17 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SYS_CRT_DTT_C | SYS CRT DTT C | 18 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SYS_CRT_BY_C | SYS CRT BY C | 19 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SYS_EFF_DTT_C | SYS EFF DTT C | 20 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SYS_UPDT_DTT_C | SYS UPDT DTT C | 21 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SYS_UPDT_BY_C | SYS UPDT BY C | 22 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_C | Business PartyAffiliation | Business PartyAffiliation | SYS_END_DTT_C | SYS END DTT C | 23 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | BP_AFFLN_COMM_MHSM_SYS_KEY_C | BP AFFLN COMM MHSM SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | BP_AFFLN_COMM_MHSM_BUS_KEY_C | BP AFFLN COMM MHSM BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | BP_AFFLN_SYS_KEY_C | BP AFFLN SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | COMM_MHSM_TYPE_CD_C | COMM MHSM TYPE CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | COMM_VAL_TXT_C | COMM VAL TXT C | 5 | VARCHAR | 500 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | COMM_MHSM_RANK_C | COMM MHSM RANK C | 6 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | ACTV_IND_C | ACTV IND C | 7 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | SYS_CRT_DTT_C | SYS CRT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | SYS_CRT_BY_C | SYS CRT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | SYS_EFF_DTT_C | SYS EFF DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | SYS_UPDT_DTT_C | SYS UPDT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | SYS_UPDT_BY_C | SYS UPDT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_COMM_MHSM_C | Business PartyAffiliation MHSM Communication | Business PartyAffiliation MHSM Communication | SYS_END_DTT_C | SYS END DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | BP_AFFLN_PRVCY_SYS_KEY_C | BP AFFLN PRVCY SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | BP_AFFLN_PRVCY_BUS_KEY_C | BP AFFLN PRVCY BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | BP_AFFLN_SYS_KEY_C | BP AFFLN SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | BP_AFFLN_BUS_KEY_C | BP AFFLN BUS KEY C | 4 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | BP_AFFLN_PRVCY_TYPE_TXT_C | BP AFFLN PRVCY TYPE TXT C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | BP_AFFLN_PRVCY_IND_C | BP AFFLN PRVCY IND C | 6 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | BP_AFFLN_PRVCY_IND_DT_C | BP AFFLN PRVCY IND DT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | SRC_STRT_DT_C | SRC STRT DT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | SRC_UPDT_DT_C | SRC UPDT DT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | SYS_CRT_DTT_C | SYS CRT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | SYS_CRT_BY_C | SYS CRT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | SYS_EFF_DTT_C | SYS EFF DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | SYS_UPDT_DTT_C | SYS UPDT DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | SYS_UPDT_BY_C | SYS UPDT BY C | 14 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_PRVCY_C | Business PartyAffiliation Privacy | Business PartyAffiliation Privacy | SYS_END_DTT_C | SYS END DTT C | 15 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | BP_AFFLN_XREF_SYS_KEY_C | BP AFFLN XREF SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | BP_AFFLN_XREF_BUS_KEY_C | BP AFFLN XREF BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | BP_AFFLN_SYS_KEY_C | BP AFFLN SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | BP_AFFLN_XREF_SRC_NM_C | BP AFFLN XREF SRC NM C | 4 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | BP_AFFLN_XREF_SRC_VAL_C | BP AFFLN XREF SRC VAL C | 5 | VARCHAR | 200 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SRC_EFF_DTT_C | SRC EFF DTT C | 6 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SRC_END_DTT_C | SRC END DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SRC_UPDT_DTT_C | SRC UPDT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SYS_CRT_BY_C | SYS CRT BY C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 13 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_AFFLN_XREF_C | Business PartyAffiliation Cross Reference | Business PartyAffiliation Cross Reference | SYS_END_DTT_C | SYS END DTT C | 14 | DATE | NO | YES | FALSE | FALSE | ||
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | BP_COMM_MHSM_SYS_KEY_C | BP COMM MHSM SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | BP_COMM_MHSM_BUS_KEY_C | BP COMM MHSM BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | BP_SYS_KEY_C | BP SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | COMM_MHSM_TYPE_CD_C | COMM MHSM TYPE CD C | 4 | VARCHAR | 200 | NO | YES | FALSE | FALSE | |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | COMM_VAL_TXT_C | COMM VAL TXT C | 5 | VARCHAR | 200 | NO | YES | FALSE | FALSE | |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | COMM_MHSM_RANK_C | COMM MHSM RANK C | 6 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | ACTV_IND_C | ACTV IND C | 7 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | SYS_CRT_DTT_C | SYS CRT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | SYS_CRT_BY_C | SYS CRT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | SYS_EFF_DTT_C | SYS EFF DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | SYS_UPDT_DTT_C | SYS UPDT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | SYS_UPDT_BY_C | SYS UPDT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_COMM_MHSM_C | Business Party MHSM Communication | Business Party MHSM Communication | SYS_END_DTT_C | SYS END DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | BP_EDU_SYS_KEY_C | BP EDU SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | BP_EDU_BUS_KEY_C | BP EDU BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | BP_SYS_KEY_C | BP SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | EDU_INST_NM_C | EDU INST NM C | 4 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | EDU_DEG_NM_C | EDU DEG NM C | 5 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | EDU_GRAD_YR_C | EDU GRAD YR C | 6 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | SYS_CRT_DTT_C | SYS CRT DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | SYS_CRT_BY_C | SYS CRT BY C | 8 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | SYS_EFF_DTT_C | SYS EFF DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | SYS_UPDT_DTT_C | SYS UPDT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | SYS_UPDT_BY_C | SYS UPDT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_EDU_DTL_C | Business Party Education Detail | Business Party Education Detail | SYS_END_DTT_C | SYS END DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | BP_EXT_ATTR_SYS_KEY_C | BP EXT ATTR SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | BP_EXT_ATTR_BUS_KEY_C | BP EXT ATTR BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | BP_SYS_KEY_C | BP SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | EXT_ATTR_TYPE_TXT_C | EXT ATTR TYPE TXT C | 4 | VARCHAR | 1000 | NO | YES | FALSE | FALSE | |
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | EXT_ATTR_TYPE_VAL_C | EXT ATTR TYPE VAL C | 5 | VARCHAR | 2000 | NO | YES | FALSE | FALSE | |
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | ACTV_IND_C | ACTV IND C | 6 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | SYS_CRT_DTT_C | SYS CRT DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | SYS_CRT_BY_C | SYS CRT BY C | 8 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | SYS_EFF_DTT_C | SYS EFF DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | SYS_UPDT_DTT_C | SYS UPDT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | SYS_UPDT_BY_C | SYS UPDT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_EXT_ATTR_C | Business Party External Attribute | Business Party External Attribute | SYS_END_DTT_C | SYS END DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | BP_LIC_DTL_SYS_KEY_C | BP LIC DTL SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | BP_LIC_DTL_BUS_KEY_C | BP LIC DTL BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | BP_SYS_KEY_C | BP SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_CATG_CD_C | LIC CATG CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_TYPE_C | LIC TYPE C | 5 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_BOARD_NM_C | LIC BOARD NM C | 6 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_STATE_NM_C | LIC STATE NM C | 7 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_DEGR_NM_C | LIC DEGR NM C | 8 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_PROF_NM_C | LIC PROF NM C | 9 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_NUM_C | LIC NUM C | 10 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | ACTV_IND_C | ACTV IND C | 11 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_DACTV_RESN_CD_C | LIC DACTV RESN CD C | 12 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_RANK_NUM_C | LIC RANK NUM C | 13 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_EXP_DT_C | LIC EXP DT C | 14 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | LIC_ISSUE_DTT_C | LIC ISSUE DTT C | 15 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | SYS_CRT_DTT_C | SYS CRT DTT C | 16 | DATE | NO | YES | FALSE | FALSE | ||
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | SYS_CRT_BY_C | SYS CRT BY C | 17 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | SYS_EFF_DTT_C | SYS EFF DTT C | 18 | DATE | NO | YES | FALSE | FALSE | ||
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | SYS_UPDT_DTT_C | SYS UPDT DTT C | 19 | DATE | NO | YES | FALSE | FALSE | ||
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | SYS_UPDT_BY_C | SYS UPDT BY C | 20 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_LIC_DTL_C | Business Party License Detail | Business Party License Detail | SYS_END_DTT_C | SYS END DTT C | 21 | DATE | NO | YES | FALSE | FALSE | ||
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | BP_MDCL_SPTY_SYS_KEY_C | BP MDCL SPTY SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | BP_MDCL_SPTY_BUS_KEY_C | BP MDCL SPTY BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | BP_SYS_KEY_C | BP SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | CTRY_CD_C | CTRY CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | SRC_SYS_CD_C | SRC SYS CD C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | MDCL_SPTY_TYPE_CD_C | MDCL SPTY TYPE CD C | 6 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | MDCL_SPTY_SYS_KEY_C | MDCL SPTY SYS KEY C | 7 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | MDCL_PROF_CD_C | MDCL PROF CD C | 8 | VARCHAR | 50 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | MDCL_SPTY_CD_C | MDCL SPTY CD C | 9 | VARCHAR | 50 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | MDCL_SPTY_RNK_C | MDCL SPTY RNK C | 10 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | MDCL_PROF_RNK_C | MDCL PROF RNK C | 11 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | ACTV_IND_C | ACTV IND C | 12 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | SYS_CRT_DTT_C | SYS CRT DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | SYS_CRT_BY_C | SYS CRT BY C | 14 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | SYS_EFF_DTT_C | SYS EFF DTT C | 15 | DATE | NO | YES | FALSE | FALSE | ||
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | SYS_UPDT_DTT_C | SYS UPDT DTT C | 16 | DATE | NO | YES | FALSE | FALSE | ||
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | SYS_UPDT_BY_C | SYS UPDT BY C | 17 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_MDCL_SPTY_C | Business Party Medical Specialty | Business Party Medical Specialty | SYS_END_DTT_C | SYS END DTT C | 18 | DATE | NO | YES | FALSE | FALSE | ||
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | BP_PROF_ASSOC_SYS_KEY_C | BP PROF ASSOC SYS KEY C | 1 | VARCHAR | 20 | NO | NO | TRUE | TRUE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | PROF_ASSOC_NM_C | PROF ASSOC NM C | 2 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | COMM_NM_C | COMM NM C | 3 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | BP_SYS_KEY_C | BP SYS KEY C | 4 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | ROLE_NM_C | ROLE NM C | 5 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | REF_URL1_C | REF URL1 C | 6 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | REF_URL2_C | REF URL2 C | 7 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | START_YR_C | START YR C | 8 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | END_YR_C | END YR C | 9 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | SYS_CRT_BY_C | SYS CRT BY C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | SYS_CRT_DTT_C | SYS CRT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | SYS_LAST_UPD_BY_C | SYS LAST UPD BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | SYS_LAST_UPD_DTT_C | SYS LAST UPD DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | SYS_EFF_DTT_C | SYS EFF DTT C | 14 | DATE | NO | YES | FALSE | FALSE | ||
| BP_PROF_ASSOC_C | Business Party Professional Association | Business Party Professional Association | SYS_END_DTT_C | SYS END DTT C | 15 | DATE | NO | YES | FALSE | FALSE | ||
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | BP_PRVCY_SYS_KEY_C | BP PRVCY SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | BP_PRVCY_BUS_KEY_C | BP PRVCY BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | BP_SYS_KEY_C | BP SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | BP_PRVC_TYPE_TXT_C | BP PRVC TYPE TXT C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | CTRY_CD_C | CTRY CD C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | BP_PRVC_IND_C | BP PRVC IND C | 6 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | BP_PRVC_IND_DT_C | BP PRVC IND DT C | 7 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | SRC_STRT_DT_C | SRC STRT DT C | 8 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | SRC_UPDT_DT_C | SRC UPDT DT C | 9 | TIMESTAMP_LTZ | NO | YES | FALSE | FALSE | ||
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | SYS_CRT_DTT_C | SYS CRT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | SYS_CRT_BY_C | SYS CRT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | SYS_EFF_DTT_C | SYS EFF DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | SYS_UPDT_DTT_C | SYS UPDT DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | SYS_UPDT_BY_C | SYS UPDT BY C | 14 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_PRVCY_C | Business Party Privacy | Business Party Privacy | SYS_END_DTT_C | SYS END DTT C | 15 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | BP_SYS_KEY_C | BP SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BP_BUS_KEY_C | BP BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_REF_C | Business Party Reference | Business Party Reference | SRC_SYS_CD_C | SRC SYS CD C | 3 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BP_SRC_ENT_ID_C | BP SRC ENT ID C | 4 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BP_TYP_CD_C | BP TYP CD C | 5 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | CTRY_CD_C | CTRY CD C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | PRTY_NM_C | PRTY NM C | 7 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BP_FULL_NM_C | BP FULL NM C | 8 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | FRST_NM_C | FRST NM C | 9 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | MID_NM_C | MID NM C | 10 | VARCHAR | 200 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | MID_INIT_C | MID INIT C | 11 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | LST_NM_C | LST NM C | 12 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | NM_PRFX_CD_C | NM PRFX CD C | 13 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | NM_SFX_CD_C | NM SFX CD C | 14 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BP_TITL_TXT_C | BP TITL TXT C | 15 | VARCHAR | 50 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | ALT_BUS_NM_C | ALT BUS NM C | 16 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BP_CLSFN_CD_C | BP CLSFN CD C | 17 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BP_SUB_CLSFN_CD_C | BP SUB CLSFN CD C | 18 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | GNDR_CD_C | GNDR CD C | 19 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BRTH_DT_C | BRTH DT C | 20 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | BRTH_YR_C | BRTH YR C | 21 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_REF_C | Business Party Reference | Business Party Reference | DTH_DT_C | DTH DT C | 22 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | DTH_YR_C | DTH YR C | 23 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_REF_C | Business Party Reference | Business Party Reference | PROF_DSG_CD_C | PROF DSG CD C | 24 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | TOT_LIC_BED_NUM_C | TOT LIC BED NUM C | 25 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_REF_C | Business Party Reference | Business Party Reference | TOT_CENS_BED_NUM_C | TOT CENS BED NUM C | 26 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_REF_C | Business Party Reference | Business Party Reference | TOT_STFD_BED_NUM_C | TOT STFD BED NUM C | 27 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_REF_C | Business Party Reference | Business Party Reference | STAT_CD_C | STAT CD C | 28 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | ACTV_IND_C | ACTV IND C | 29 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | BP_PROF_ASSOC_SYS_KEY_C | BP PROF ASSOC SYS KEY C | 30 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | ACCT_PLAN_SYS_KEY_C | ACCT PLAN SYS KEY C | 31 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | AMA_PROF_CD_C | AMA PROF CD C | 32 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | WHERE_PRAC_CD_C | WHERE PRAC CD C | 33 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | CERT_CD_C | CERT CD C | 34 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | TYP_PRAC_CD_C | TYP PRAC CD C | 35 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | FRMLRY_STAT_CD_C | FRMLRY STAT CD C | 36 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | WEBSITE_URL_C | WEBSITE URL C | 37 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | NBR_PROVIDERS_C | NBR PROVIDERS C | 38 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| BP_REF_C | Business Party Reference | Business Party Reference | OWNSHP_STAT_CD_C | OWNSHP STAT CD C | 39 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | PROFIT_STAT_CD_C | PROFIT STAT CD C | 40 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | COMMCL_HOSP_IND_C | COMMCL HOSP IND C | 41 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | CORP_PAR_NM_C | CORP PAR NM C | 42 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | OWN_SUBS_NM_C | OWN SUBS NM C | 43 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | SRC_EFF_DTT_C | SRC EFF DTT C | 44 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | SRC_END_DTT_C | SRC END DTT C | 45 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | SRC_UPDT_DTT_C | SRC UPDT DTT C | 46 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 47 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | SYS_CRT_BY_C | SYS CRT BY C | 48 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 49 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 50 | DATE | NO | YES | FALSE | FALSE | ||
| BP_REF_C | Business Party Reference | Business Party Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 51 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_REF_C | Business Party Reference | Business Party Reference | SYS_END_DTT_C | SYS END DTT C | 52 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | BP_XIDNTY_SYS_KEY_C | BP XIDNTY SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | BP_XIDNTY_BUS_KEY_C | BP XIDNTY BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | BP_SYS_KEY_C | BP SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | EXTL_IDNTY_TYPE_CD_C | EXTL IDNTY TYPE CD C | 4 | VARCHAR | 500 | NO | YES | FALSE | FALSE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | EXTL_IDNTY_VAL_C | EXTL IDNTY VAL C | 5 | VARCHAR | 1000 | NO | YES | FALSE | FALSE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | EXTL_IDNTY_SORT_ORDER_CD_C | EXTL IDNTY SORT ORDER CD C | 6 | VARCHAR | 200 | NO | YES | FALSE | FALSE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | EXTL_IDNTY_CATG_VAL_C | EXTL IDNTY CATG VAL C | 7 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | SYS_CRT_DTT_C | SYS CRT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | SYS_CRT_BY_C | SYS CRT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | SYS_EFF_DTT_C | SYS EFF DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | SYS_UPDT_DTT_C | SYS UPDT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | SYS_UPDT_BY_C | SYS UPDT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_XIDNTY_C | Business Party Cross Identity | Business Party Cross Identity | SYS_END_DTT_C | SYS END DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | BP_XREF_SYS_KEY_C | BP XREF SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | BP_XREF_BUS_KEY_C | BP XREF BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SRC_CTRY_CD_C | SRC CTRY CD C | 3 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | BP_XREF_SRC_TYPE_C | BP XREF SRC TYPE C | 4 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | BP_SYS_KEY_C | BP SYS KEY C | 5 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | BP_XREF_SRC_NM_C | BP XREF SRC NM C | 6 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | BP_XREF_SRC_VAL_C | BP XREF SRC VAL C | 7 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SRC_EFF_DTT_C | SRC EFF DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SRC_END_DTT_C | SRC END DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SRC_UPDT_DTT_C | SRC UPDT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SYS_CRT_BY_C | SYS CRT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 14 | DATE | NO | YES | FALSE | FALSE | ||
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 15 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| BP_XREF_C | Business Party Cross Reference | Business Party Cross Reference | SYS_END_DTT_C | SYS END DTT C | 16 | DATE | NO | YES | FALSE | FALSE | ||
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | MDCL_SPTY_HIER_SYS_KEY_C | MDCL SPTY HIER SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | MDCL_SPTY_HIER_BUS_KEY_C | MDCL SPTY HIER BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | PRNT_MDCL_SPTY_SYS_KEY_C | PRNT MDCL SPTY SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | CHLD_MDCL_SPTY_SYS_KEY_C | CHLD MDCL SPTY SYS KEY C | 4 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | SYS_CRT_DTT_C | SYS CRT DTT C | 5 | DATE | NO | YES | FALSE | FALSE | ||
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | SYS_CRT_BY_C | SYS CRT BY C | 6 | VARCHAR | 255 | NO | NO | FALSE | TRUE | |
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | SYS_EFF_DTT_C | SYS EFF DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | SYS_UPDT_DTT_C | SYS UPDT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | SYS_UPDT_BY_C | SYS UPDT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_HIER_C | Medical SpecialtyHierarchy | Medical SpecialtyHierarchy | SYS_END_DTT_C | SYS END DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | MDCL_SPTY_SYS_KEY_C | MDCL SPTY SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | MDCL_SPTY_BUS_KEY_C | MDCL SPTY BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | MDCL_SPTY_CD_C | MDCL SPTY CD C | 3 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | MDCL_SPTY_NM_C | MDCL SPTY NM C | 4 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | MDCL_SPTY_DESC_C | MDCL SPTY DESC C | 5 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | SRC_SYS_CD_C | SRC SYS CD C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | CTRY_CD_C | CTRY CD C | 7 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | ACTV_IND_C | ACTV IND C | 8 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | SYS_CRT_BY_C | SYS CRT BY C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 13 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MDCL_SPTY_REF_C | Medical Specialty Reference | Medical Specialty Reference | SYS_END_DTT_C | SYS END DTT C | 14 | DATE | NO | YES | FALSE | FALSE |