RdsDiagram
HUB_AGENCY
AGENCY_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
AGENCY: VARCHAR(768)
HUB_INTERVENTION
INTERVENTION_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
INTERVENTION_NM: VARCHAR(100)
CONTRACT_YR: VARCHAR(9)
HUB_STRATEGY_MODEL
STRATEGY_MODEL_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
STRATEGY_MODEL_NM: VARCHAR(50)
HUB_COMMUNITY
COMMUNITY_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
COMMUNITY_NM: VARCHAR(100)
COMMUNITY_ZIP_CD: VARCHAR(10)
HUB_REPORT_PERIOD
REPORT_PERIOD_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
REPORT_PERIOD: VARCHAR(30)
HUB_SERVICE_TYPE
SERVICE_TYPE_HKEY: DATETIME
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
SERVICE_TYPE: VARCHAR(50)
HUB_STRATEGY_TYPE
STRATEGY_TYPE_HKEY: DATETIME
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
STRATEGY_TYPE: VARCHAR(50)
HUB_SERVICE_GROUP
SERVICE_GROUP_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
SERVICE_GROUP: VARCHAR(100)
HUB_LOCATION
LOC_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
LOC_NM: VARCHAR(50)
HUB_LOC_PE_FORMAT
FORMAT_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
FORMAT: VARCHAR(30)
HUB_CLUBHOUSE
CLUBHOUSE_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
CLUBHOUSE: VARCHAR(30)
HUB_REGION
REGION_HKEY: BINARY(18)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)
REGION: VARCHAR(768)
SAT_INTERVENTION
FILLER_FULL_NM: VARCHAR(100)
FILLER_LAST_NM: VARCHAR(50)
FILLER_FIRST_NM: VARCHAR(50)
FILLER_EMAIL: VARCHAR(100)
FILLER_PH: VARCHAR(11)
STATE_LVL_MGR_NM: VARCHAR(100)
STATE_LVL_MGR_EMAIL: VARCHAR(100)
STATE_LVL_MGR_PH: VARCHAR(11)
TARGET_ISSUE: VARCHAR(255)
APPROVED_STATE_PRIORITY: VARCHAR(50)
IOM_CATG: INTEGER
EVIDENCE_BASED_PROG_IND: VARCHAR(1)
DELETE_IND: VARCHAR(1)
CREATE_USER_ID: INTEGER
CREATE_DT: DATE
UPDT_USER_ID: INTEGER
UPDT_DT: DATE
LNK_AGENCY_INTERVENTION
AGCY_CMNTY_INTRVNTN_HKEY: BINARY(18)
INTERVENTION_HKEY: BINARY(18)
AGENCY_HKEY: BINARY(18)
INTERVENTION_NM: VARCHAR(100)
CONTRACT_YR: VARCHAR(9)
LOAD_DTS: DATETIME
REC_SRC: VARCHAR(20)