CRM Meetings

Entity Relationship Diagram

Tip:   

Right click the attachment to view Entity Relationship Diagram for CRM Meetings 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
MT_BUD_C Meeting Budget Meeting Budget MT_BUD_SYS_KEY_C MT BUD SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
MT_BUD_C Meeting Budget Meeting Budget MT_BUD_BUS_KEY_C MT BUD BUS KEY C 2 VARCHAR 16777216   NO YES FALSE TRUE
MT_BUD_C Meeting Budget Meeting Budget MT_SYS_KEY_C MT SYS KEY C 3 VARCHAR 16777216   NO NO FALSE TRUE
MT_BUD_C Meeting Budget Meeting Budget SRC_REC_ID_C SRC REC ID C 4 VARCHAR 20   NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget MT_BUD_NM_C MT BUD NM C 5 VARCHAR 20   NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget BUD_NM_C BUD NM C 6 VARCHAR 100   NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget ACT_AMT_C ACT AMT C 7 NUMERIC 6 0 NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget AVL_BUD_C AVL BUD C 8 NUMERIC 6 0 NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget EST_AMT_C EST AMT C 9 NUMERIC 6 0 NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget TOT_BUD_C TOT BUD C 10 NUMERIC 6 0 NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget CTRY_CD_C CTRY CD C 11 VARCHAR 20   NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget SYS_EFF_DTT_C SYS EFF DTT C 12 DATE     NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget SYS_END_DTT_C SYS END DTT C 13 DATE     NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget SYS_CRT_BY_C SYS CRT BY C 14 VARCHAR 255   NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget SYS_CRT_DTT_C SYS CRT DTT C 15 DATE     NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget SYS_LAST_UPD_BY_C SYS LAST UPD BY C 16 VARCHAR 255   NO YES FALSE FALSE
MT_BUD_C Meeting Budget Meeting Budget SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 17 DATE     NO YES FALSE FALSE
MT_C Meeting Meeting MT_SYS_KEY_C MT SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
MT_C Meeting Meeting MT_BUS_KEY_C MT BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
MT_C Meeting Meeting SORG_SYS_KEY_C SORG SYS KEY C 3 VARCHAR 16777216   NO YES FALSE FALSE
MT_C Meeting Meeting SRC_REC_ID_C SRC REC ID C 4 VARCHAR 20   NO YES FALSE FALSE
MT_C Meeting Meeting MT_ID_C MT ID C 5 VARCHAR 16777216   NO YES FALSE FALSE
MT_C Meeting Meeting MT_STRT_DTT_C MT STRT DTT C 6 DATE     NO YES FALSE FALSE
MT_C Meeting Meeting MT_END_DTT_C MT END DTT C 7 DATE     NO YES FALSE FALSE
MT_C Meeting Meeting MT_STAT_C MT STAT C 8 VARCHAR 20   NO YES FALSE FALSE
MT_C Meeting Meeting AVG_ACT_EXP_C AVG ACT EXP C 9 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting AVG_EST_EXP_C AVG EST EXP C 10 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting EST_PRTCPNT_C EST PRTCPNT C 11 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting FINAL_PRTCPNT_C FINAL PRTCPNT C 12 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting LOC_TYPE_C LOC TYPE C 13 VARCHAR 20   NO YES FALSE FALSE
MT_C Meeting Meeting LOC_NM_C LOC NM C 14 VARCHAR 100   NO YES FALSE FALSE
MT_C Meeting Meeting NBR_OF_ATND_C NBR OF ATND C 15 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting NBR_OF_SPKR_C NBR OF SPKR C 16 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting NBR_OF_ORGN_C NBR OF ORGN C 17 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting TOT_ACTL_EXP_C TOT ACTL EXP C 18 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting TOT_EST_EXP_C TOT EST EXP C 19 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting TOT_INVT_MT_MBR_C TOT INVT MT MBR C 20 NUMERIC 6 0 NO YES FALSE FALSE
MT_C Meeting Meeting CTRY_CD_C CTRY CD C 21 VARCHAR 20   NO YES FALSE FALSE
MT_C Meeting Meeting SYS_EFF_DTT_C SYS EFF DTT C 22 DATE     NO YES FALSE FALSE
MT_C Meeting Meeting SYS_END_DTT_C SYS END DTT C 23 DATE     NO YES FALSE FALSE
MT_C Meeting Meeting SYS_CRT_BY_C SYS CRT BY C 24 VARCHAR 255   NO YES FALSE FALSE
MT_C Meeting Meeting SYS_CRT_DTT_C SYS CRT DTT C 25 DATE     NO YES FALSE FALSE
MT_C Meeting Meeting SYS_LAST_UPD_BY_C SYS LAST UPD BY C 26 VARCHAR 255   NO YES FALSE FALSE
MT_C Meeting Meeting SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 27 DATE     NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense MT_EXP_SYS_KEY_C MT EXP SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
MT_EXP_C Meeting Expense Meeting Expense MT_EXP_BUS_KEY_C MT EXP BUS KEY C 2 VARCHAR 16777216   NO YES FALSE TRUE
MT_EXP_C Meeting Expense Meeting Expense MT_SYS_KEY_C MT SYS KEY C 3 VARCHAR 16777216   NO NO FALSE TRUE
MT_EXP_C Meeting Expense Meeting Expense SORG_SYS_KEY_C SORG SYS KEY C 4 VARCHAR 16777216   NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense SRC_REC_ID_C SRC REC ID C 5 VARCHAR 20   NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense MT_EXP_NM_C MT EXP NM C 6 VARCHAR 100   NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense EXP_CATG_TYP_NM_C EXP CATG TYP NM C 7 VARCHAR 100   NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense EXP_TYP_NM_C EXP TYP NM C 8 VARCHAR 100   NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense EXP_AMT_C EXP AMT C 9 NUMERIC 6 0 NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense NBR_OF_ALLOC_C NBR OF ALLOC C 10 NUMERIC 6 0 NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense PAID_IND_C PAID IND C 11 BOOLEAN     NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense CTRY_CD_C CTRY CD C 12 VARCHAR 20   NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense SYS_EFF_DTT_C SYS EFF DTT C 13 DATE     NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense SYS_END_DTT_C SYS END DTT C 14 DATE     NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense SYS_CRT_BY_C SYS CRT BY C 15 VARCHAR 255   NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense SYS_CRT_DTT_C SYS CRT DTT C 16 DATE     NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense SYS_LAST_UPD_BY_C SYS LAST UPD BY C 17 VARCHAR 255   NO YES FALSE FALSE
MT_EXP_C Meeting Expense Meeting Expense SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 18 DATE     NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location MT_LOC_SYS_KEY_C MT LOC SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
MT_LOC_C Meeting Location Meeting Location MT_LOC_BUS_KEY_C MT LOC BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
MT_LOC_C Meeting Location Meeting Location MT_SYS_KEY_C MT SYS KEY C 3 VARCHAR 16777216   NO NO FALSE TRUE
MT_LOC_C Meeting Location Meeting Location BPA_SYS_KEY_C BPA SYS KEY C 4 VARCHAR 16777216   NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location SRC_REC_ID_C SRC REC ID C 5 VARCHAR 20   NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location LOC_ADDR_C LOC ADDR C 6 VARCHAR 100   NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location CTRY_CD_C CTRY CD C 7 VARCHAR 20   NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location SYS_EFF_DTT_C SYS EFF DTT C 8 DATE     NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location SYS_END_DTT_C SYS END DTT C 9 DATE     NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location SYS_CRT_BY_C SYS CRT BY C 10 VARCHAR 255   NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location SYS_CRT_DTT_C SYS CRT DTT C 11 DATE     NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location SYS_LAST_UPD_BY_C SYS LAST UPD BY C 12 VARCHAR 255   NO YES FALSE FALSE
MT_LOC_C Meeting Location Meeting Location SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 13 DATE     NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member MT_MBR_SYS_KEY_C MT MBR SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
MT_MBR_C Meeting Member Meeting Member MT_MBR_BUS_KEY_C MT MBR BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
MT_MBR_C Meeting Member Meeting Member SORG_SYS_KEY_C SORG SYS KEY C 3 VARCHAR 16777216   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member BPA_SYS_KEY_C BPA SYS KEY C 4 VARCHAR 16777216   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member BP_SYS_KEY_C BP SYS KEY C 5 VARCHAR 16777216   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member MT_SYS_KEY_C MT SYS KEY C 6 VARCHAR 16777216   NO NO FALSE TRUE
MT_MBR_C Meeting Member Meeting Member SRC_REC_ID_C SRC REC ID C 7 VARCHAR 20   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member COLLEAGUE_EMP_SYS_KEY_C COLLEAGUE EMP SYS KEY C 8 VARCHAR 16777216   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member ATTND_STAT_C ATTND STAT C 9 VARCHAR 20   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member ATTND_RSVP_C ATTND RSVP C 10 VARCHAR 100   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member MT_STAT_C MT STAT C 11 VARCHAR 100   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member SPKR_BP_SYS_KEY_C SPKR BP SYS KEY C 12 VARCHAR 16777216   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member SPCL_TEXT_C SPCL TEXT C 13 VARCHAR 100   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member CTRY_CD_C CTRY CD C 14 VARCHAR 20   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member SYS_EFF_DTT_C SYS EFF DTT C 15 TIMESTAMP_LTZ     NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member SYS_END_DTT_C SYS END DTT C 16 DATE     NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member SYS_CRT_BY_C SYS CRT BY C 17 VARCHAR 255   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member SYS_CRT_DTT_C SYS CRT DTT C 18 DATE     NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member SYS_LAST_UPD_BY_C SYS LAST UPD BY C 19 VARCHAR 255   NO YES FALSE FALSE
MT_MBR_C Meeting Member Meeting Member SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 20 DATE     NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product MT_PROD_SYS_KEY_C MT PROD SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
MT_PROD_C Meeting Product Meeting Product MT_PROD_BUS_KEY_C MT PROD BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
MT_PROD_C Meeting Product Meeting Product MT_SYS_KEY_C MT SYS KEY C 3 VARCHAR 16777216   NO NO FALSE TRUE
MT_PROD_C Meeting Product Meeting Product PSET_SYS_KEY_C PSET SYS KEY C 4 VARCHAR 16777216   NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product TOPIC_SYS_KEY_C TOPIC SYS KEY C 5 VARCHAR 16777216   NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product SRC_REC_ID_C SRC REC ID C 6 VARCHAR 20   NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product CTRY_CD_C CTRY CD C 7 VARCHAR 20   NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product SYS_EFF_DTT_C SYS EFF DTT C 8 TIMESTAMP_LTZ     NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product SYS_END_DTT_C SYS END DTT C 9 DATE     NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product SYS_CRT_BY_C SYS CRT BY C 10 VARCHAR 255   NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product SYS_CRT_DTT_C SYS CRT DTT C 11 DATE     NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product SYS_LAST_UPD_BY_C SYS LAST UPD BY C 12 VARCHAR 20   NO YES FALSE FALSE
MT_PROD_C Meeting Product Meeting Product SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 13 DATE     NO YES FALSE FALSE