CRM Plan Cycle

Entity Relationship Diagram

Tip:   

Right click the attachment to view Entity Relationship Diagram for CRM Plan Cycle 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
ACCT_PLAN_C Account Plan Account Plan ACCT_PLAN_SYS_KEY_C ACCT PLAN SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
ACCT_PLAN_C Account Plan Account Plan BP_SYS_KEY_C BP SYS KEY C 2 VARCHAR 16777216   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan APPR_STAT_C APPR STAT C 3 VARCHAR 20   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan COMP_PERCENT_C COMP PERCENT C 4 VARCHAR 20   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan ACCT_PLAN_DESC_C ACCT PLAN DESC C 5 VARCHAR 255   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan END_DT_C END DT C 6 DATE     NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan IS_ACTV_C IS ACTV C 7 VARCHAR 20   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan OPP_C OPP C 8 VARCHAR 255   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan STR_C STR C 9 VARCHAR 255   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan STRT_DT_C STRT DT C 10 DATE     NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan THREAT_C THREAT C 11 VARCHAR 255   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan WEAKNESS_C WEAKNESS C 12 VARCHAR 255   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan SYS_EFF_DTT_C SYS EFF DTT C 13 DATE     NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan SYS_END_DTT_C SYS END DTT C 14 DATE     NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan SYS_CRT_BY_C SYS CRT BY C 15 VARCHAR 255   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan SYS_CRT_DTT_C SYS CRT DTT C 16 DATE     NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan SYS_LAST_UPD_BY_C SYS LAST UPD BY C 17 VARCHAR 255   NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 18 DATE     NO YES FALSE FALSE
ACCT_PLAN_C Account Plan Account Plan CTRY_CD_C CTRY CD C 19 VARCHAR 20   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan CALL_PLN_SYS_KEY_C CALL PLN SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
CALL_PLN_C Call Plan Call Plan CALL_PLN_BUS_KEY_C CALL PLN BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
CALL_PLN_C Call Plan Call Plan BP_SYS_KEY_C BP SYS KEY C 3 VARCHAR 16777216   NO NO FALSE TRUE
CALL_PLN_C Call Plan Call Plan SORG_SYS_KEY_C SORG SYS KEY C 4 VARCHAR 16777216   NO NO FALSE TRUE
CALL_PLN_C Call Plan Call Plan PLN_SYS_KEY_C PLN SYS KEY C 5 VARCHAR 16777216   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan CALL_PLN_NM_C CALL PLN NM C 6 VARCHAR 100   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan SRC_REC_ID_C SRC REC ID C 7 VARCHAR 20   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan ACTL_CALLS_C ACTL CALLS C 8 NUMERIC 6 0 NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan ACTL_CALL_IND_C ACTL CALL IND C 9 VARCHAR 16777216   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan CALL_ATMNT_C CALL ATMNT C 10 NUMERIC 6 0 NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan CALL_ATMNT_DIFF_C CALL ATMNT DIFF C 11 NUMERIC 6 0 NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan LST_CALL_DT_C LST CALL DT C 12 DATE     NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan CALL_PLN_WGT_C CALL PLN WGT C 13 VARCHAR 20   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan EXPC_PRORTD_ATMNT_C EXPC PRORTD ATMNT C 14 VARCHAR 20   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan NXT_CALL_DT_C NXT CALL DT C 15 DATE     NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan HQ_CALL_GOAL_C HQ CALL GOAL C 16 VARCHAR 20   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan POTN_CALLS_C POTN CALLS C 17 NUMERIC 6 0 NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan POTN_CALLS_IND_C POTN CALLS IND C 18 VARCHAR 16777216   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan PRORTD_ATMNT_C PRORTD ATMNT C 19 NUMERIC 6 0 NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan PRORTD_GOAL_C PRORTD GOAL C 20 VARCHAR 20   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan SCHED_CALLS_C SCHED CALLS C 21 NUMERIC 6 0 NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan SYS_EFF_DTT_C SYS EFF DTT C 22 DATE     NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan SYS_END_DTT_C SYS END DTT C 23 DATE     NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan SYS_CRT_BY_C SYS CRT BY C 24 VARCHAR 255   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan SYS_CRT_DTT_C SYS CRT DTT C 25 DATE     NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan SYS_LAST_UPD_BY_C SYS LAST UPD BY C 26 VARCHAR 255   NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 27 DATE     NO YES FALSE FALSE
CALL_PLN_C Call Plan Call Plan CTRY_CD_C CTRY CD C 28 VARCHAR 20   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle PLN_CYC_SYS_KEY_C PLN CYC SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
PLAN_CYC_C Plan Cycle Plan Cycle PLN_CYC_BUS_KEY_C PLN CYC BUS KEY C 2 VARCHAR 16777216   NO NO FALSE TRUE
PLAN_CYC_C Plan Cycle Plan Cycle SORG_SYS_KEY_C SORG SYS KEY C 3 VARCHAR 16777216   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle PLN_CYC_NM_C PLN CYC NM C 4 VARCHAR 100   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle CTRY_CD_C CTRY CD C 5 VARCHAR 20   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SRC_REC_ID_C SRC REC ID C 6 VARCHAR 20   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle ACTV_IND_C ACTV IND C 7 VARCHAR 16777216   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle ACT_CALLS_C ACT CALLS C 8 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle ACT_CALLS_ROLLEDUP_C ACT CALLS ROLLEDUP C 9 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle ATMNT_C ATMNT C 10 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle ATMNT_DIFF_C ATMNT DIFF C 11 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle CALL_GOAL_C CALL GOAL C 12 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle CALL_GOAL_ROLLEDUP_C CALL GOAL ROLLEDUP C 13 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle PAR_PLN_CYC_SYS_KEY_C PAR PLN CYC SYS KEY C 14 VARCHAR 16777216   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle PRORTD_ATMNT_C PRORTD ATMNT C 15 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle PRORTD_GOAL_C PRORTD GOAL C 16 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SCHED_CALLS_ROLLEDUP_C SCHED CALLS ROLLEDUP C 17 NUMERIC 6 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SRC_STAT_C SRC STAT C 18 VARCHAR 20   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle TOT_NBR_TGTS TOT NBR TGTS 19 NUMERIC 38 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle TOT_NBR_TGTS_RCHD TOT NBR TGTS RCHD 20 NUMERIC 38 0 NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SRC_EFF_DT_C SRC EFF DT C 21 DATE     NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SRC_END_DT_C SRC END DT C 22 DATE     NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SYS_EFF_DTT_C SYS EFF DTT C 23 DATE     NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SYS_END_DTT_C SYS END DTT C 24 DATE     NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SYS_CRT_BY_C SYS CRT BY C 25 VARCHAR 255   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SYS_CRT_DTT_C SYS CRT DTT C 26 DATE     NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SYS_LAST_UPD_BY_C SYS LAST UPD BY C 27 VARCHAR 255   NO YES FALSE FALSE
PLAN_CYC_C Plan Cycle Plan Cycle SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 28 DATE     NO YES FALSE FALSE
TACTIC_C Tactic Tactic TACTC_SYS_KEY_C TACTC SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
TACTIC_C Tactic Tactic SRC_REC_ID_C SRC REC ID C 2 VARCHAR 20   NO YES FALSE FALSE
TACTIC_C Tactic Tactic TACTC_NM_C TACTC NM C 3 VARCHAR 100   NO YES FALSE FALSE
TACTIC_C Tactic Tactic TACTC_DESC_C TACTC DESC C 4 VARCHAR 100   NO YES FALSE FALSE
TACTIC_C Tactic Tactic CURR_CD_C CURR CD C 5 VARCHAR 20   NO YES FALSE FALSE
TACTIC_C Tactic Tactic TODO_SYS_KEY_C TODO SYS KEY C 6 VARCHAR 16777216   NO NO FALSE TRUE
TACTIC_C Tactic Tactic TACTC_BUS_KEY_C TACTC BUS KEY C 7 VARCHAR 16777216   NO NO FALSE TRUE
TACTIC_C Tactic Tactic SYS_EFF_DTT_C SYS EFF DTT C 8 DATE     NO YES FALSE FALSE
TACTIC_C Tactic Tactic SYS_END_DTT_C SYS END DTT C 9 DATE     NO YES FALSE FALSE
TACTIC_C Tactic Tactic SYS_CRT_BY_C SYS CRT BY C 10 VARCHAR 255   NO YES FALSE FALSE
TACTIC_C Tactic Tactic SYS_CRT_DTT_C SYS CRT DTT C 11 DATE     NO YES FALSE FALSE
TACTIC_C Tactic Tactic SYS_LAST_UPD_BY_C SYS LAST UPD BY C 12 VARCHAR 255   NO YES FALSE FALSE
TACTIC_C Tactic Tactic SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 13 DATE     NO YES FALSE FALSE
TACTIC_C Tactic Tactic CTRY_CD_C CTRY CD C 14 VARCHAR 20   NO YES FALSE FALSE
TODO_C To Do To Do TODO_SYS_KEY_C TODO SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
TODO_C To Do To Do TODO_BUS_KEY_C TODO BUS KEY C 19 VARCHAR 16777216   NO NO FALSE TRUE
TODO_C To Do To Do SRC_REC_ID_C SRC REC ID C 2 VARCHAR 20   NO YES FALSE FALSE
TODO_C To Do To Do TODO_NM_C TODO NM C 3 VARCHAR 100   NO YES FALSE FALSE
TODO_C To Do To Do ASGN_TO_ID_C ASGN TO ID C 4 VARCHAR 20   NO YES FALSE FALSE
TODO_C To Do To Do DUE_DT_C DUE DT C 5 DATE     NO YES FALSE FALSE
TODO_C To Do To Do PAR_ACCT_ID_C PAR ACCT ID C 6 VARCHAR 20   NO YES FALSE FALSE
TODO_C To Do To Do TACTC_ID_C TACTC ID C 7 VARCHAR 20   NO YES FALSE FALSE
TODO_C To Do To Do TASK_DT_C TASK DT C 8 DATE     NO YES FALSE FALSE
TODO_C To Do To Do CTRY_CD_C CTRY CD C 9 VARCHAR 20   NO YES FALSE FALSE
TODO_C To Do To Do SYS_LAST_UPD_BY_C SYS LAST UPD BY C 10 VARCHAR 255   NO YES FALSE FALSE
TODO_C To Do To Do BP_SYS_KEY_C BP SYS KEY C 11 VARCHAR 16777216   NO YES FALSE FALSE
TODO_C To Do To Do ACCT_OBJ_C ACCT OBJ C 12 VARCHAR 100   NO YES FALSE FALSE
TODO_C To Do To Do TERR_SYS_KEY_C TERR SYS KEY C 13 VARCHAR 16777216   NO YES FALSE FALSE
TODO_C To Do To Do SYS_EFF_DTT_C SYS EFF DTT C 14 DATE     NO YES FALSE FALSE
TODO_C To Do To Do SYS_END_DTT_C SYS END DTT C 15 DATE     NO YES FALSE FALSE
TODO_C To Do To Do SYS_CRT_BY_C SYS CRT BY C 16 VARCHAR 255   NO YES FALSE FALSE
TODO_C To Do To Do SYS_CRT_DTT_C SYS CRT DTT C 17 DATE     NO YES FALSE FALSE
TODO_C To Do To Do SYS_LAST_UPD_DTT_C SYS LAST UPD DTT C 18 DATE     NO YES FALSE FALSE