CRM MIRF

Entity Relationship Diagram

Tip:   

Right click the attachment to view Entity Relationship Diagram for CRM MIRF 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
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request MIRF_SYS_KEY_C MIRF SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request MIRF_BUS_KEY_C MIRF BUS KEY C 25 VARCHAR 16777216   NO NO TRUE TRUE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SRC_REC_ID_C SRC REC ID C 2 VARCHAR 20   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request NM_C NM C 3 VARCHAR 100   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request BP_SYS_KEY_C BP SYS KEY C 4 VARCHAR 16777216   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request EMAIL_C EMAIL C 5 VARCHAR 100   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request INQ_TYPE_C INQ TYPE C 6 VARCHAR 100   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request INQ_CHNL_C INQ CHNL C 7 VARCHAR 100   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request OFF_LABEL_IND_C OFF LABEL IND C 8 VARCHAR 16777216   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request PH_NBR_C PH NBR C 9 VARCHAR 20   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request PRTY_C PRTY C 10 VARCHAR 20   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request PSET_SYS_KEY_C PSET SYS KEY C 11 VARCHAR 16777216   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request HCP_RESP_HELPFUL_C HCP RESP HELPFUL C 12 VARCHAR 100   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request RESP_DT_TM_C RESP DT TM C 13 DATE     NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request RESP_PREF_C RESP PREF C 14 VARCHAR 20   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SUBMIT_DT_TM_C SUBMIT DT TM C 15 DATE     NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SGNTR_DT_C SGNTR DT C 16 DATE     NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SGNTR_TM_C SGNTR TM C 17 TIMESTAMP_LTZ     NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SYS_EFF_DTT_C SYS EFF DTT C 18 DATE     NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SYS_END_DTT_C SYS END DTT C 19 DATE     NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SYS_LAST_UPD_BY_C SYS LAST UPD BY C 20 VARCHAR 255   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 21 DATE     NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SYS_CRT_BY_C SYS CRT BY C 22 VARCHAR 255   NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request SYS_CRT_DTT_C SYS CRT DTT C 23 DATE     NO YES FALSE FALSE
MED_INQ_REQ_C Medical Inquiry Request Medical Inquiry Request CTRY_CD_C CTRY CD C 24 VARCHAR 20   NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product MIRF_PROD_SYS_KEY_C MIRF PROD SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
MIRF_PROD_C MIRF Product MIRF Product SRC_REC_ID_C SRC REC ID C 2 VARCHAR 20   NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product MIRF_SYS_KEY_C MIRF SYS KEY C 3 VARCHAR 16777216   NO YES FALSE TRUE
MIRF_PROD_C MIRF Product MIRF Product PSET_SYS_KEY_C PSET SYS KEY C 4 VARCHAR 16777216   NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product CTRY_CD_C CTRY CD C 5 VARCHAR 20   NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product MIRF_SRC_ID_C MIRF SRC ID C 6 NUMERIC 10 0 NO NO FALSE TRUE
MIRF_PROD_C MIRF Product MIRF Product MIRF_PROD_BUS_KEY_C MIRF PROD BUS KEY C 7 VARCHAR 16777216   NO NO FALSE TRUE
MIRF_PROD_C MIRF Product MIRF Product SYS_LAST_UPD_BY_C SYS LAST UPD BY C 8 VARCHAR 20   NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product SYS_EFF_DTT_C SYS EFF DTT C 9 DATE     NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product SYS_END_DTT_C SYS END DTT C 10 DATE     NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 11 DATE     NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product SYS_CRT_BY_C SYS CRT BY C 12 VARCHAR 255   NO YES FALSE FALSE
MIRF_PROD_C MIRF Product MIRF Product SYS_CRT_DTT_C SYS CRT DTT C 13 DATE     NO YES FALSE FALSE