Payer & Plan
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for Payer & Plan 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_SYS_KEY_C | PLN SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_BUS_KEY_C | PLN BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | SRC_SYS_CD_C | SRC SYS CD C | 3 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_SRC_ENT_ID_C | PLN SRC ENT ID C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_NM_C | PLN NM C | 5 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_MODEL_TYP_CD_C | PLN MODEL TYP CD C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_MODEL_GRP_NM_C | PLN MODEL GRP NM C | 7 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PAY_TYPE_CD_C | PAY TYPE CD C | 8 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_STAT_CD_C | PLN STAT CD C | 9 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_ST_CD_C | PLN ST CD C | 10 | VARCHAR | 12 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | CTRY_CD_C | CTRY CD C | 11 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | HQ_CITY_CD_C | HQ CITY CD C | 12 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | HQ_ST_CD_C | HQ ST CD C | 13 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | ADDR_LN1_TXT_C | ADDR LN1 TXT C | 14 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | ADDR_LN2_TXT_C | ADDR LN2 TXT C | 15 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PSTL_CD_C | PSTL CD C | 16 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PSTL_EXTN_SD_C | PSTL EXTN SD C | 17 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | OPRG_ST_CD_C | OPRG ST CD C | 18 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | NB_TIERS_C | NB TIERS C | 19 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | NBR_LIVES_C | NBR LIVES C | 20 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | NBR_POLICIES_C | NBR POLICIES C | 21 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | NBR_PATS_C | NBR PATS C | 22 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | NBR_CLAIMS_C | NBR CLAIMS C | 23 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_STRT_DT_C | PLN STRT DT C | 24 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | PLN_END_DT | PLN END DT | 25 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | IMS_PAYER_SRC_ID_C | IMS PAYER SRC ID C | 26 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | IMS_PAYER_SRC_NM_C | IMS PAYER SRC NM C | 27 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | IMS_PBM_SRC_ID_C | IMS PBM SRC ID C | 28 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | IMS_PBM_SRC_NM_C | IMS PBM SRC NM C | 29 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 30 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | SYS_CRT_BY_C | SYS CRT BY C | 31 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 32 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 33 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 34 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REF_C | Managed Care Plan Reference | Managed Care Plan Reference | SYS_END_DTT_C | SYS END DTT C | 35 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | PLN_REL_SYS_KEY_C | PLN REL SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | PLN_REL_BUS_KEY_C | PLN REL BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | FRM_PLN_SYS_KEY_C | FRM PLN SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | TO_BP_SYS_KEY_C | TO BP SYS KEY C | 4 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | TO_BP_TYPE_CD_C | TO BP TYPE CD C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | REL_TYPE_CD_C | REL TYPE CD C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | SYS_CRT_DTT_C | SYS CRT DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | SYS_CRT_BY_C | SYS CRT BY C | 8 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | SYS_EFF_DTT_C | SYS EFF DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | SYS_UPDT_DTT_C | SYS UPDT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | SYS_UPDT_BY_C | SYS UPDT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_REL_C | Managed Care Plan Relation | Managed Care Plan Relation | SYS_END_DTT_C | SYS END DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | PLN_XIDNTY_SYS_KEY_C | PLN XIDNTY SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | PLN_XIDNTY_BUS_KEY_C | PLN XIDNTY BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | PLN_SYS_KEY_C | PLN SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | EXTL_IDNTY_TYPE_CD_C | EXTL IDNTY TYPE CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | EXTL_IDNTY_VAL_C | EXTL IDNTY VAL C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | SYS_CRT_DTT_C | SYS CRT DTT C | 6 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | SYS_CRT_BY_C | SYS CRT BY C | 7 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | SYS_EFF_DTT_C | SYS EFF DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | SYS_UPDT_DTT_C | SYS UPDT DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | SYS_UPDT_BY_C | SYS UPDT BY C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_XIDNTY_C | Managed Care Plan Cross Identify | Managed Care Plan Cross Identify | SYS_END_DTT_C | SYS END DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | PLN_XREF_SYS_KEY_C | PLN XREF SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | PLN_XREF_BUS_KEY_C | PLN XREF BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | PLN_SYS_KEY_C | PLN SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | PLN_XREF_SRC_NM_C | PLN XREF SRC NM C | 4 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | PLN_XREF_SRC_VAL_C | PLN XREF SRC VAL C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SRC_EFF_DTT_C | SRC EFF DTT C | 6 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SRC_END_DTT_C | SRC END DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SRC_UPDT_DTT_C | SRC UPDT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SYS_CRT_BY_C | SYS CRT BY C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 13 | VARCHAR | 25 | NO | YES | FALSE | FALSE | |
| MNGDCARE_PLN_XREF_C | Managed Care Plan Cross Reference | Managed Care Plan Cross Reference | SYS_END_DTT_C | SYS END DTT C | 14 | DATE | NO | YES | FALSE | FALSE |