CRM CLM

Entity Relationship Diagram

Tip:   

Right click the attachment to view Entity Relationship Diagram for CRM CLM 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
CALL_PRSNT_C Call Presentation Call Presentation CALL_PRSNT_SYS_KEY_C CALL PRSNT SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
CALL_PRSNT_C Call Presentation Call Presentation CALL_PRSNT_BUS_KEY_C CALL PRSNT BUS KEY C 18 VARCHAR 16777216   NO NO TRUE TRUE
CALL_PRSNT_C Call Presentation Call Presentation CALL_PRSNT_NM_C CALL PRSNT NM C 2 VARCHAR 100   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation BP_SYS_KEY_C BP SYS KEY C 3 VARCHAR 16777216   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation CALL_SYS_KEY_C CALL SYS KEY C 4 VARCHAR 16777216   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation SORG_BP_ALIGN_SYS_KEY_C SORG BP ALIGN SYS KEY C 5 VARCHAR 16777216   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation MT_D_C MT D C 6 VARCHAR 20   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation PRSNT_SYS_KEY_C PRSNT SYS KEY C 7 VARCHAR 16777216   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation CTRY_CD_C CTRY CD C 8 VARCHAR 20   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation SRC_REC_ID_C SRC REC ID C 9 VARCHAR 20   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation CALL_ID_C CALL ID C 10 VARCHAR 20   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation SYS_EFF_DTT_C SYS EFF DTT C 12 DATE     NO NO FALSE TRUE
CALL_PRSNT_C Call Presentation Call Presentation SYS_END_DTT_C SYS END DTT C 13 DATE     NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation SYS_CRT_BY_C SYS CRT BY C 14 VARCHAR 255   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation SYS_CRT_DTT_C SYS CRT DTT C 15 DATE     NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation SYS_LAST_UPD_BY_C SYS LAST UPD BY C 16 VARCHAR 255   NO YES FALSE FALSE
CALL_PRSNT_C Call Presentation Call Presentation SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 17 DATE     NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CALL_SYS_KEY_C CALL SYS KEY C 1 VARCHAR 16777216   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CALL_STRM_MTRC_SYS_KEY_C CALL STRM MTRC SYS KEY C 2 VARCHAR 16777216   NO NO TRUE TRUE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric SRC_REC_ID_C SRC REC ID C 3 VARCHAR 20   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CLK_STRM_MTRC_NM_C CLK STRM MTRC NM C 4 VARCHAR 100   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric BP_SYS_KEY_C BP SYS KEY C 5 VARCHAR 16777216   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric SORG_BP_ALIGN_SYS_KEY_C SORG BP ALIGN SYS KEY C 6 VARCHAR 16777216   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CALL_DTL_SYS_KEY_C CALL DTL SYS KEY C 7 VARCHAR 16777216   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CALL_MSG_SYS_KEY_C CALL MSG SYS KEY C 8 VARCHAR 16777216   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CALL_PRSNT_SYS_KEY_C CALL PRSNT SYS KEY C 9 VARCHAR 16777216   NO YES FALSE TRUE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric MT_SYS_KEY_C MT SYS KEY C 10 VARCHAR 16777216   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric PRSNT_ID_C PRSNT ID C 11 VARCHAR 20   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric PRSNT_NM_C PRSNT NM C 12 VARCHAR 100   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric PROD_MSG_C PROD MSG C 13 VARCHAR 100   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric USAGE_STRT_TM_C USAGE STRT TM C 14 DATE     NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric USAGE_END_TM_C USAGE END TM C 15 DATE     NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric DUR_C DUR C 16 NUMERIC 6 0 NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CURR_CD_C CURR CD C 17 VARCHAR 20   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CALL_STRM_MTRC_BUS_KEY_C CALL STRM MTRC BUS KEY C 18 VARCHAR 16777216   NO NO FALSE TRUE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CALL_ID_C CALL ID C 19 VARCHAR 20   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CALL_DTL_ID_C CALL DTL ID C 20 VARCHAR 20   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric SYS_EFF_DTT_C SYS EFF DTT C 21 DATE     NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric SYS_END_DTT_C SYS END DTT C 22 DATE     NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric SYS_CRT_BY_C SYS CRT BY C 23 VARCHAR 255   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric SYS_CRT_DT_C SYS CRT DT C 24 DATE     NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric SYS_LAST_UPD_BY_C SYS LAST UPD BY C 25 VARCHAR 255   NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 26 DATE     NO YES FALSE FALSE
CALL_STREAM_METRIC_C Call Stream Metric Call Stream Metric CTRY_CD_C CTRY CD C 27 VARCHAR 20   NO YES FALSE FALSE
PRSNT_C Presentation Presentation PRSNT_SYS_KEY_C PRSNT SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
PRSNT_C Presentation Presentation PRSNT_BUS_KEY_C PRSNT BUS KEY C 19 VARCHAR 16777216   NO NO TRUE TRUE
PRSNT_C Presentation Presentation SRC_REC_ID_C SRC REC ID C 2 VARCHAR 20   NO YES FALSE FALSE
PRSNT_C Presentation Presentation PRSNT_NM_C PRSNT NM C 3 VARCHAR 100   NO YES FALSE FALSE
PRSNT_C Presentation Presentation AVAIL_IND_C AVAIL IND C 4 VARCHAR 12   NO YES FALSE FALSE
PRSNT_C Presentation Presentation END_DT_C END DT C 5 DATE     NO YES FALSE FALSE
PRSNT_C Presentation Presentation ISLOCKED_C ISLOCKED C 6 VARCHAR 12   NO YES FALSE FALSE
PRSNT_C Presentation Presentation STRT_DT_C STRT DT C 7 DATE     NO YES FALSE FALSE
PRSNT_C Presentation Presentation STAT_C STAT C 8 VARCHAR 20   NO YES FALSE FALSE
PRSNT_C Presentation Presentation TERR_SYS_KEY_C TERR SYS KEY C 9 VARCHAR 16777216   NO YES FALSE FALSE
PRSNT_C Presentation Presentation TYP_C TYP C 10 VARCHAR 12   NO YES FALSE FALSE
PRSNT_C Presentation Presentation SEQ_SYS_KEY_C SEQ SYS KEY C 11 VARCHAR 16777216   NO NO FALSE TRUE
PRSNT_C Presentation Presentation SYS_CRT_BY_C SYS CRT BY C 12 VARCHAR 255   NO YES FALSE FALSE
PRSNT_C Presentation Presentation SYS_EFF_DTT_C SYS EFF DTT C 13 DATE     NO YES FALSE FALSE
PRSNT_C Presentation Presentation SYS_CRT_DTT_C SYS CRT DTT C 14 DATE     NO YES FALSE FALSE
PRSNT_C Presentation Presentation SYS_END_DTT_C SYS END DTT C 15 DATE     NO YES FALSE FALSE
PRSNT_C Presentation Presentation SYS_LAST_UPD_BY_C SYS LAST UPD BY C 16 VARCHAR 255   NO YES FALSE FALSE
PRSNT_C Presentation Presentation SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 17 DATE     NO YES FALSE FALSE
PRSNT_C Presentation Presentation CTRY_CD_C CTRY CD C 18 VARCHAR 20   NO YES FALSE FALSE
SEQ_C Sequence Sequence SEQ_SYS_KEY_C SEQ SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
SEQ_C Sequence Sequence SEQ_BUS_KEY_C SEQ BUS KEY C 16 VARCHAR 16777216   NO NO TRUE TRUE
SEQ_C Sequence Sequence SRC_REC_ID_C SRC REC ID C 2 VARCHAR 20   NO YES FALSE FALSE
SEQ_C Sequence Sequence IS_ASSET_C IS ASSET C 3 VARCHAR 12   NO YES FALSE FALSE
SEQ_C Sequence Sequence IS_MAND_C IS MAND C 4 VARCHAR 12   NO YES FALSE FALSE
SEQ_C Sequence Sequence NM_NUM_VAL_C NM NUM VAL C 5 NUMERIC 6 0 NO YES FALSE FALSE
SEQ_C Sequence Sequence PRSNT_SYS_KEY_C PRSNT SYS KEY C 6 VARCHAR 16777216   NO YES FALSE FALSE
SEQ_C Sequence Sequence TYP_C TYP C 7 VARCHAR 20   NO YES FALSE FALSE
SEQ_C Sequence Sequence SYS_EFF_DTT_C SYS EFF DTT C 8 DATE     NO YES FALSE FALSE
SEQ_C Sequence Sequence SYS_END_DTT_C SYS END DTT C 9 DATE     NO YES FALSE FALSE
SEQ_C Sequence Sequence SYS_CRT_BY_C SYS CRT BY C 10 VARCHAR 255   NO YES FALSE FALSE
SEQ_C Sequence Sequence SYS_CRT_DTT_C SYS CRT DTT C 11 DATE     NO YES FALSE FALSE
SEQ_C Sequence Sequence SYS_LAST_UPD_BY_C SYS LAST UPD BY C 12 VARCHAR 255   NO YES FALSE FALSE
SEQ_C Sequence Sequence SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 13 DATE     NO YES FALSE FALSE
SEQ_C Sequence Sequence CTRY_CD_C CTRY CD C 14 VARCHAR 20   NO YES FALSE FALSE
SEQ_C Sequence Sequence LAST_MOD_DT_C LAST MOD DT C 15 DATE     NO YES FALSE FALSE