CCUBS_ERD_Tables_MAQCS.pdf
PDF 307 KB Posted
- Attached to
- Montana Access to Quality Childcare System MAQCS
- Solicitation number
- DPHHS-RFP-2024-0492KH
- Issued by
- Montana
About this file
This file appears to be an Entity Relationship Diagram (ERD) representing a comprehensive database schema for the Montana Access to Quality Childcare System (MAQCS), designed to support child care licensing, provider management, subsidy tracking, and related administrative functions. The database contains approximately 50-60 interconnected database tables covering detailed domains such as persons, organizations, workers, care providers, contracts, case events, authorizations, invoices, notifications, and multiple administrative and tracking mechanisms.
The database schema demonstrates extensive data tracking capabilities across multiple child care administrative processes, including provider licensing, quality rating, financial transactions, training and certification tracking, complaint management, eligibility determinations, and regional service area management. Key features include tracking of provider credentials, child care service types, rate calculations, financial authorizations, quality incentive payments, worker roles, regional assignments, and comprehensive auditing through created/modified timestamp and user tracking across most tables. The design suggests a robust, flexible system capable of supporting complex child care administrative workflows with granular data capture and extensive relational data integrity.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attach 8 - Technology Matrix.xlsx | XLSX spreadsheet | |
| 1175725-event.pdf | ||
| CCUBS_Production_Calendar_2023_MAQCS.pdf | ||
| Section_5_Cost_Sheet.xlsx | XLSX spreadsheet | |
| Output_Inventory_MAQCS.xlsx | XLSX spreadsheet | |
| Project_Management_Deliverables_MAQCS.xlsx | XLSX spreadsheet | |
| CCUBS_Data_Dictonary_MAQCS.xlsx | XLSX spreadsheet | |
| Attach 7 - Resource Allocation Schedules.xlsx | XLSX spreadsheet | |
| Acronyms_Definitions_and_Terms_MAQCS.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
CHCA.CHCA_INFORMATION_COMPLAINTS
*P COMP_ID_SEQ VARCHAR2 (14 BYTE)
* CMPLT_RECEIVED_DT DATE
CMPLT_SBJ_NM VARCHAR2 (100 BYTE)
CMPLT_TX VARCHAR2 (4000 BYTE)
*F CNTC_METH_CD VARCHAR2 (10 BYTE)
DEFICIENCY_LTTR_DT DATE
DIRECTED_PLN_OF_COR_SENT_DT DATE
PROV_RSPNS_RECEIVED_DT DATE
*F INFO_CMPLT_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CPS_INVLMNT VARCHAR2 (2 BYTE)
LE_INVLMNT VARCHAR2 (2 BYTE)
CHILD_DEATH VARCHAR2 (2 BYTE)
CHILD_INJURY VARCHAR2 (2 BYTE)
SELFT_RPT VARCHAR2 (2 BYTE)
NGTV_LCNS_ACTION VARCHAR2 (2 BYTE)
TTA_RQST VARCHAR2 (2 BYTE)
SUBSTN VARCHAR2 (1 BYTE)
COMP_PK
CHCA.CHCA_ZIP_CODES
*P ZIPC_ID_SEQ NUMBER (12)
* ZIP_CD VARCHAR2 (5 BYTE)
* CITY VARCHAR2 (30 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* PREFERRED_IND VARCHAR2 (1 BYTE)
VALIDATED_IND VARCHAR2 (1 BYTE)
F CNTY_FIPS_CD NUMBER (3)
F STT_CD VARCHAR2 (2 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
ZIPC_PK
CHCA.CHCA_ADDRESS_TYPES
*P ADDR_TYP_CD VARCHAR2 (10 BYTE)
*U ADDR_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
ADTY_PK
ADTY_ADTY_1_UK
CHCA.CHCA_WORKERS
*P WRKR_ID_SEQ NUMBER (12)
* WKR_LST_NM VARCHAR2 (40 BYTE)
* WKR_FST_NM VARCHAR2 (40 BYTE)
*U WKR_ID VARCHAR2 (20 BYTE)
* ACTIVE_IND VARCHAR2 (1 BYTE)
JOB_TTL VARCHAR2 (40 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
WRKR_PK
CONV_ONLY_WKR_ID_UK
CHCA.CHCA_PERSONS
*P PERS_ID_SEQ VARCHAR2 (14 BYTE)
PERS_BRTH_DT DATE
* PERS_UNBORN_IND VARCHAR2 (1 BYTE)
PERS_SSN VARCHAR2 (9 BYTE)
PERS_SSN_VRF_DT DATE
F CITSP_VRF_TYP_CD VARCHAR2 (10 BYTE)
DOB_VRF_DT DATE
PERS_CITSP_IND VARCHAR2 (1 BYTE)
CITSP_VRF_DT DATE
PERS_RESIDENCY_IND VARCHAR2 (1 BYTE)
RESIDENCY_VRF_DT DATE
DCS_PERS_DTH_DT DATE
BANK_EFT_ID VARCHAR2 (12 BYTE)
BANK_ACCT_ID VARCHAR2 (20 BYTE)
LST_PHYS_EXAM_DT DATE
LST_PHYS_EXAM_VRF_DT DATE
AWACS_ADDR_CD VARCHAR2 (1 BYTE)
AWACS_EFT_ID NUMBER (10)
CONVERTED_IND VARCHAR2 (1 BYTE)
F RESIDENCY_VRF_TYP_CD VARCHAR2 (10 BYTE)
F SSN_VRF_TYP_CD VARCHAR2 (10 BYTE)
F DOB_VRF_TYP_CD VARCHAR2 (10 BYTE)
EXPT_TO_GRADUATE_DT NUMBER (4)
F LST_GRADE_CMPLTD_CD VARCHAR2 (10 BYTE)
*F ETHN_AFFINITY_CD VARCHAR2 (10 BYTE)
*F PERS_SEX_CTG_CD VARCHAR2 (10 BYTE)
F PHYS_EXAM_DT_VRF_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
F STDNT_ATTENDANCE_CD VARCHAR2 (10 BYTE)
INTER_UNIT_FUND_PMTS VARCHAR2 (1 BYTE)
WEBSITE_PASSWORD VARCHAR2 (30 BYTE)
WEBSITE_EMAIL_ADDR VARCHAR2 (100 BYTE)
WEBSITE_SESSN_AUTH VARCHAR2 (30 BYTE)
WEBSITE_SESSN_TIME DATE
PORTAL_CNT NUMBER (1)
IMM_VRF_COMP_DT DATE
BKGD_INVSTG_VRF_COMP_DT DATE
TRAIN_30_DAY_COMP_DT DATE
TRAIN_60_DAY_COMP_DT DATE
TRAIN_90_DAY_COMP_DT DATE
PERS_PK
CHCA.CHCA_COUNTIES
*P CNTY_FIPS_CD NUMBER (3)
*PF STT_CD VARCHAR2 (2 BYTE)
U STT_CNTY_CD VARCHAR2 (10 BYTE)
*U CNTY_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CNTY_PK
CNTY_CNTY_1_UK
CNTY_CNTY_2_UK
CHCA.CHCA_ADDRESSES
*P ADDR_ID_SEQ NUMBER (12)
* ADDR_BGN_DT DATE
ADDR_END_DT DATE
* FRGN_DOM_IND VARCHAR2 (1 BYTE)
ADDR_LN_1 VARCHAR2 (40 BYTE)
ADDR_LN_2 VARCHAR2 (40 BYTE)
ZIP_PL_4 VARCHAR2 (4 BYTE)
CNTRY VARCHAR2 (30 BYTE)
FRGN_ADDR VARCHAR2 (35 BYTE)
ELECTRONIC_COMM_TXT VARCHAR2 (200 BYTE)
PHN_AREA_CD NUMBER (3)
PHN_PREFX NUMBER (3)
PHN_SUFX NUMBER (4)
PHN_EXT VARCHAR2 (10 BYTE)
RNT_OWN_IND VARCHAR2 (1 BYTE)
* RESIDES_ON_RESERVATION_IND VARCHAR2 (1 BYTE)
ADD_NTF_NM VARCHAR2 (40 BYTE)
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
F COMP_ID_SEQ VARCHAR2 (14 BYTE)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
*F ADDR_TYP_CD VARCHAR2 (10 BYTE)
F ZIPC_ID_SEQ NUMBER (12)
*F ADDR_USAGE_CD VARCHAR2 (10 BYTE)
F WRKR_ID_SEQ NUMBER (12)
F NOTI_ID_SEQ NUMBER (12)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
INTF_UPDT_DT DATE
ADDR_PK
CHCA.CHCA_ORGANIZATIONS
*P ORGS_ID_SEQ VARCHAR2 (14 BYTE)
F NAIC_CD VARCHAR2 (10 BYTE)
ORG_CNTC_NM VARCHAR2 (80 BYTE)
FEIN NUMBER (15)
BANK_EFT_ID VARCHAR2 (20 BYTE)
BANK_ACCT_ID VARCHAR2 (20 BYTE)
AWACS_ADDR_CD VARCHAR2 (1 BYTE)
AWACS_EFT_ID NUMBER (10)
VIEW_PAY_INFO VARCHAR2 (240 BYTE)
F ORG_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
INTER_UNIT_FUND_PMTS VARCHAR2 (1 BYTE)
ORGS_PK
CHCA.CHCA_ADDRESS_USAGE_TYPES
*P ADDR_USAGE_CD VARCHAR2 (10 BYTE)
*F ADDR_TYP_CD VARCHAR2 (10 BYTE)
*U ADDR_USAGE_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
AUTP_PK
AUTP_AUTP_1_UK
CHCA.CHCA_NOTIFICATION_ADDRESSEES
*PF NOTI_ID_SEQ NUMBER (12)
*P NOAD_APPL_SEQ_NO NUMBER (3)
*F NTF_ADDRESSEE_TYP_CD VARCHAR2 (10 BYTE)
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
F NOST_APPL_SEQ_NO NUMBER (3)
F NOBD_ID_SEQ NUMBER (9)
BLANK_PAGE_IND VARCHAR2 (1 BYTE)
MAILER_IND VARCHAR2 (1 BYTE)
PROCESS_IND VARCHAR2 (1 BYTE)
NOAD_PK
* CMPLT_RECEIVED_DT DATE
CMPLT_SBJ_NM VARCHAR2 (100 BYTE)
CMPLT_TX VARCHAR2 (4000 BYTE)
*F CNTC_METH_CD VARCHAR2 (10 BYTE)
DEFICIENCY_LTTR_DT DATE
DIRECTED_PLN_OF_COR_SENT_DT DATE
PROV_RSPNS_RECEIVED_DT DATE
*F INFO_CMPLT_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CPS_INVLMNT VARCHAR2 (2 BYTE)
LE_INVLMNT VARCHAR2 (2 BYTE)
CHILD_DEATH VARCHAR2 (2 BYTE)
CHILD_INJURY VARCHAR2 (2 BYTE)
SELFT_RPT VARCHAR2 (2 BYTE)
NGTV_LCNS_ACTION VARCHAR2 (2 BYTE)
TTA_RQST VARCHAR2 (2 BYTE)
SUBSTN VARCHAR2 (1 BYTE)
COMP_PK
CHCA.CHCA_WORKERS
*P WRKR_ID_SEQ NUMBER (12)
* WKR_LST_NM VARCHAR2 (40 BYTE)
* WKR_FST_NM VARCHAR2 (40 BYTE)
*U WKR_ID VARCHAR2 (20 BYTE)
* ACTIVE_IND VARCHAR2 (1 BYTE)
JOB_TTL VARCHAR2 (40 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
WRKR_PK
CONV_ONLY_WKR_ID_UK
CHCA.CHCA_CONTRACTS
*P CONA_ID_SEQ NUMBER (12)
*P CNTC_APPL_SEQ_NO NUMBER (3)
* CONTT_DIV_NO NUMBER (2)
* CONTT_FISC_YR NUMBER (4)
* CONTT_SEQ_NO NUMBER (4)
* CONTT_AMENDMENT_NO NUMBER (3)
*F CONTT_STS_CD VARCHAR2 (10 BYTE)
* CONTT_STS_DT DATE
F CONTT_DENIAL_TERMN_CD VARCHAR2 (10 BYTE)
* CONTT_EFF_BGN_DT DATE
* CONTT_EFF_END_DT DATE
CONTT_EXEC_DT DATE
SECD_CONTT_LIAISON_PHN VARCHAR2 (20 BYTE)
TRM_DT DATE
* RENEWAL_SEQ_NO NUMBER (12)
SECD_CONTT_LIAISON_NM VARCHAR2 (40 BYTE)
*F CONTT_TYP_CD VARCHAR2 (10 BYTE)
F CONA_ID_SEQ_REF NUMBER (12)
F CNTC_APPL_SEQ_NO_REF NUMBER (3)
CONTT_AMENDMENT_EFF_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
NO_OF_RENEWALS NUMBER (2)
CNTR_PK
CHCA.CHCA_ALERT_TYPES
*P ALRT_TYP_CD VARCHAR2 (10 BYTE)
*U ALRT_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
ALTY_PK
ALTY_ALTY_1_UK
CHCA.CHCA_WORKER_ALERTS
*PF WRKR_ID_SEQ NUMBER (12)
*P WRAL_APPL_SEQ_NO NUMBER (6)
* ALRT_DESCR VARCHAR2 (100 BYTE)
* ALRT_TEXT VARCHAR2 (2000 BYTE)
CLOSE_DT DATE
DUE_DT DATE
* DSPLY_IND VARCHAR2 (1 BYTE)
F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
F CNTC_APPL_SEQ_NO NUMBER (3)
F COMP_ID_SEQ VARCHAR2 (14 BYTE)
F CONA_ID_SEQ NUMBER (12)
F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*F ALRT_TYP_CD VARCHAR2 (10 BYTE)
F CEVP_APPL_SEQ_NO NUMBER (3)
F PHST_APPL_SEQ_NO NUMBER (3)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
NOTI_ID_SEQ NUMBER (12)
PDF_APPL_SEQ_NO NUMBER (3)
WRAL_PK
CHCA.CHCA_CASE_EVENTS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*P CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
* APPL_DT DATE
* SNGL_PAR_IND VARCHAR2 (1 BYTE)
* TRIBAL_TANF_IND VARCHAR2 (1 BYTE)
F TANF_STS_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CE_BGN_DT DATE
CE_END_DT DATE
MILITARY_STS VARCHAR2 (3 BYTE)
FMLY_HOMELESS_STS VARCHAR2 (2 BYTE)
FMLY_ASTS_EXC_MIL VARCHAR2 (1 BYTE)
CAEV_PK
CHCA.CHCA_PROVIDER_TYPE_HISTORIES
*PF CARE_ID_SEQ VARCHAR2 (14 BYTE)
*P PHST_APPL_SEQ_NO NUMBER (3)
* LIC_IND VARCHAR2 (1 BYTE)
LGL_OPERATION_BGN_DT DATE
LGL_OPERATION_END_DT DATE
* LIC_APPL_DT DATE
LIC_RENEWAL_DT DATE
LIC_RVW_DT DATE
IN_HM_IND VARCHAR2 (1 BYTE)
LICENSED_FOR VARCHAR2 (80 BYTE)
*F CARE_PROV_TYP_CD VARCHAR2 (10 BYTE)
*F LICENSING_ENTY_CD VARCHAR2 (10 BYTE)
F CARE_ID_SEQ_REF VARCHAR2 (14 BYTE)
F PHST_APPL_SEQ_NO_REF NUMBER (3)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
LIC_TRMN_DT DATE
F PRGM_TYP_CD VARCHAR2 (10 BYTE)
PHST_PK
CHCA.CHCA_CARE_PROVIDERS
*P CARE_ID_SEQ VARCHAR2 (14 BYTE)
* VIEW_PAY_INFO VARCHAR2 (1 BYTE)
FACIL_DIRECTIONS_TXT VARCHAR2 (2000 BYTE)
* TAX_EXMT_IND VARCHAR2 (1 BYTE)
* MNRTY_BUSN_IND VARCHAR2 (1 BYTE)
* NONPROFIT_IND VARCHAR2 (1 BYTE)
* SERV_AUTHRZTN_IND VARCHAR2 (1 BYTE)
CONVERTED_FR_PERS_ID VARCHAR2 (14 BYTE)
CONVERTED_FR_DT DATE
ACCREDITED_SRC VARCHAR2 (40 BYTE)
ACCREDITED_DT DATE
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
PASSWORD VARCHAR2 (10 BYTE)
INVALID_LOGON_COUNTER NUMBER (2)
PASSWORD_CHANGE_DT DATE
DL_LIC VARCHAR2 (1 BYTE)
F PROV_PAY_METH_CD VARCHAR2 (10 BYTE)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CAPS_MATCH VARCHAR2 (1 BYTE)
INTF_PROV_ID VARCHAR2 (10 BYTE)
LST_CAPS_INTF_DT DATE
PROV_AGRMNT_DT DATE
PROV_AGREED_BY VARCHAR2 (14 BYTE)
NIGHT_CARE_PROV VARCHAR2 (1 BYTE)
ARPV_NIGHT_CARE VARCHAR2 (2 BYTE)
NIGHT_CARE_APRV_DT DATE
BLCK_INVC_AR_PRCSG_IND VARCHAR2 (1 BYTE)
CARE_PK
CHCA.CHCA_FUND_ACCOUNTS
*P FUND_ACCT_ID VARCHAR2 (20 BYTE)
*U FUND_ACCT_NM VARCHAR2 (50 BYTE)
FUND_ACCT_DESCR VARCHAR2 (1024 BYTE)
* FUND_ACCT_EFF_BGN_DT DATE
FUND_ACCT_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
FUAC_PK
FUAC_FUAC_1_UK
CHCA.CHCA_AUTH_WORKSHEET_TYPES
*P AWST_WORKSHEET_TYPE_CD VARCHAR2 (10 BYTE)
* AWST_WORKSHEET_TYPE_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
AWST_PK
CHCA.CHCA_PROGRAM_FUND_ACCOUNTS
*PF FUND_ACCT_ID VARCHAR2 (20 BYTE)
*PF PGM_ID VARCHAR2 (12 BYTE)
* PFAC_EFF_BGN_DT DATE
PFAC_EFF_END_DT DATE
*F SPEEDCHART_CD VARCHAR2 (240 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
PFAC_PK
CHCA.CHCA_AUTH_WORKSHEET_DAILY_HRS
*PF AWSH_ID_SEQ NUMBER (12)
*P ORDINAL_WEEK_NO NUMBER (1)
*P ORDINAL_DAY_NO NUMBER (1)
* NUM_HRS NUMBER (6,2)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
AWDH_PK
CHCA.CHCA_CHILD_CARE_SERVICE_TYPES
*P CHILD_CARE_SERV_TYP_CD VARCHAR2 (2 BYTE)
*U CHILD_CARE_SERV_TYP_NM VARCHAR2 (80 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CCST_PK
CCST_CCST_1_UK
CHCA.CHCA_AUTHORIZATION_DETAILS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
*PF AUTH_ID_SEQ NUMBER (12)
*P AUTD_APPL_SEQ_NO NUMBER (3)
NO_OF_HR_PER_DD NUMBER (5,2)
NO_OF_HR_PER_WK NUMBER (6,2)
*F CHILD_CARE_SERV_TYP_CD VARCHAR2 (2 BYTE)
F WEEKDAY_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
NO_OF_DAYS_PER_WEEK NUMBER (6,2)
NO_OF_HOURS_PER_MONTH NUMBER (6,2)
NO_OF_DAYS_PER_MONTH NUMBER (6,2)
MONTH_INDEX NUMBER (3)
AUTH_MONTHLY_AMT NUMBER (18,2)
AUTD_PK
CHCA.CHCA_WEEKDAYS
*P WEEKDAY_CD VARCHAR2 (10 BYTE)
*U WEEKDAY_NM VARCHAR2 (50 BYTE)
* WEEKEND_IND_FLGS VARCHAR2 (1 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
WEDY_PK
WEDY_WEDY_1_UK
CHCA.CHCA_WORKERS
*P WRKR_ID_SEQ NUMBER (12)
* WKR_LST_NM VARCHAR2 (40 BYTE)
* WKR_FST_NM VARCHAR2 (40 BYTE)
*U WKR_ID VARCHAR2 (20 BYTE)
* ACTIVE_IND VARCHAR2 (1 BYTE)
JOB_TTL VARCHAR2 (40 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
WRKR_PK
CONV_ONLY_WKR_ID_UK
CHCA.CHCA_RATE_OVERRIDE_REASONS
*P RT_OVRRD_RSN_CD VARCHAR2 (10 BYTE)
*U RT_OVRRD_RSN_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
RAOR_PK
RAOR_RAOR_1_UK
CHCA.CHCA_AUTHORIZED_RATES
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
*PF AUTH_ID_SEQ NUMBER (12)
*P AURT_APPL_SEQ_NO NUMBER (3)
* OVRRD_RT_AMT NUMBER (18,2)
*F CHILD_CARE_SERV_TYP_CD VARCHAR2 (2 BYTE)
*F RT_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
AURT_PK
CHCA.CHCA_AUTH_STS_HISTS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
*PF AUTH_ID_SEQ NUMBER (12)
*P ASTS_APPL_SEQ_NO NUMBER (3)
*F AUTH_STS_CD VARCHAR2 (10 BYTE)
* AUTH_STS_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
ASTS_PK
CHCA.CHCA_CASE_EVENT_PERSONS
*P CEVP_APPL_SEQ_NO NUMBER (3)
* REQUESTING_CHILD_CARE_IND VARCHAR2 (1 BYTE)
*F CASE_EVNT_PERS_ASSO_CD VARCHAR2 (10 BYTE)
*UF PERS_ID_SEQ VARCHAR2 (14 BYTE)
F SCHL_ENRL_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
HEAD_OF_HOUSEHOLD VARCHAR2 (1 BYTE)
CHLD_SPRT_CMPL VARCHAR2 (1 BYTE)
CHLD_DSBLTY_STS VARCHAR2 (2 BYTE)
CEVP_PK
CEVP_UK_1
CHCA.CHCA_AUTH_PROV_MMY_FEES
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
*PF AUTH_ID_SEQ NUMBER (12)
*P APRF_APPL_SEQ_NO NUMBER (3)
AUTHORIZED_PROV_FEE NUMBER (18,2)
*F AUTHORIZED_PROV_FEE_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
COMT VARCHAR2 (2000 BYTE)
APRF_PK
CHCA.CHCA_AUTH_WORKSHEETS
*P AWSH_ID_SEQ NUMBER (12)
*F AUTH_ID_SEQ NUMBER (12)
*F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*F CEVP_APPL_SEQ_NO NUMBER (3)
*F AWST_WORKSHEET_TYPE_CD VARCHAR2 (10 BYTE)
F INVC_ID_SEQ NUMBER (12)
F INVC_HIST_NO NUMBER (3)
F IATL_APPL_SEQ_NO NUMBER (3)
* NUM_DAYS NUMBER (6,2)
* NUM_HRS NUMBER (6,2)
* ACTIVE_IND VARCHAR2 (1 BYTE)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
AWSH_PK
CHCA.CHCA_INVOICE_AUTH_TOTALS
*PF INVC_ID_SEQ NUMBER (12)
*PF INVC_HIST_NO NUMBER (3)
*P IATL_APPL_SEQ_NO NUMBER (3)
REQS_TOT NUMBER (18,2)
APRV_TOT NUMBER (18,2)
OVRRD_TOT NUMBER (18,2)
OVRRD_COMT VARCHAR2 (240 BYTE)
F AUTH_DOLLAR_AMT_OVRRD_RSN_CD VARCHAR2 (10 BYTE)
F CEVP_APPL_SEQ_NO NUMBER (3)
F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
F AUTH_ID_SEQ NUMBER (12)
F CONA_ID_SEQ NUMBER (12)
F CNTC_APPL_SEQ_NO NUMBER (3)
F CONB_APPL_SEQ_NO NUMBER (3)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_AMT NUMBER (18,2)
F MOD_RSN_CD VARCHAR2 (10 BYTE)
MOD_COMT VARCHAR2 (4000 BYTE)
INVC_REQS_AMT_TOT NUMBER (18,2)
REQS_AUTH_AMT_ADJ NUMBER (18,2)
REQS_NON_TRAD_BONUS_TOT NUMBER (18,2)
INVC_APRV_AMT_TOT NUMBER (18,2)
APRV_AUTH_AMT_ADJ NUMBER (18,2)
BONUS_AMT_TOT NUMBER (18,2)
SPL_NEED_AMT_TOT NUMBER (18,2)
APRV_NON_TRAD_BONUS_TOT NUMBER (18,2)
DAYS_ATTND_TOT NUMBER (3)
IATL_PK
CHCA.CHCA_AUTH_SERVICE_PERIOD_TYPES
*P AUSP_TYP_CD VARCHAR2 (10 BYTE)
* AUSP_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
AUSP_PK
CHCA.CHCA_CASE_EVENT_PROVIDERS
*PF CARE_ID_SEQ VARCHAR2 (14 BYTE)
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CEPR_PK
CHCA.CHCA_CARE_PROV_BY_TYPES
*P CAPB_TYP_CD VARCHAR2 (6 BYTE)
* CAPB_TYP_NM VARCHAR2 (20 BYTE)
* EFF_BGN_DT DATE
EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
CAPB_PK
CHCA.CHCA_CHILD_CARE_TYPES
*P CHILD_CARE_TYP_CD VARCHAR2 (10 BYTE)
*U CHILD_CARE_TYP_NM VARCHAR2 (80 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CCTP_PK
CCTP_CCTP_1_UK
CHCA.CHCA_AUTHORIZATION_TYPES
*P AUTH_TYP_CD VARCHAR2 (10 BYTE)
*U AUTH_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
AUTY_PK
AUTY_AUTY_1_UK
CHCA.CHCA_AUTHORIZATIONS
*P AUTH_ID_SEQ NUMBER (12)
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
* AUTH_BGN_DT DATE
* AUTH_END_DT DATE
* AUTHORIZED_DOLLAR_AMT NUMBER (18,2)
* HOH_PAY_IND VARCHAR2 (1 BYTE)
* PRI_PROV_IND VARCHAR2 (1 BYTE)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
*F CHILD_CARE_TYP_CD VARCHAR2 (10 BYTE)
F RT_OVRRD_RSN_CD VARCHAR2 (10 BYTE)
F WRKR_ID_SEQ NUMBER (12)
*F FUND_ACCT_ID VARCHAR2 (20 BYTE)
*F PGM_ID VARCHAR2 (12 BYTE)
*F AUTH_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CARE_RSN_CTG_CD VARCHAR2 (10 BYTE)
F CAPB_TYP_CD VARCHAR2 (6 BYTE)
NO_OF_HOURS_PER_PERIOD NUMBER (6,2)
NO_OF_DAYS_PER_PERIOD NUMBER (6,2)
F AUSP_TYP_CD VARCHAR2 (10 BYTE)
AUTH_PK
CHCA.CHCA_BKGD_INVSTG_SOURCE_CODES
*P BKGD_INVSTG_SRC_TYP_CD VARCHAR2 (10 BYTE)
*U BKGD_INVSTG_SRC_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
BIST_PK
BIST_BIST_1_UK
CHCA.CHCA_BKGD_INVSTG_TYPE_CODES
*P BKGD_INVSTG_TYP_CD VARCHAR2 (10 BYTE)
*U BKGD_INVSTG_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
BITC_PK
BITC_BITC_1_UK
CHCA.CHCA_BKGD_INVSTG_STT_RESLT_TPS
*P BKGD_INVSTG_STT_RSLT_CD VARCHAR2 (10 BYTE)
*U BKGD_INVSTG_STT_RSLT_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
BSRC_PK
BSRC_BSRC_1_UK
CHCA.CHCA_PERSONS
*P PERS_ID_SEQ VARCHAR2 (14 BYTE)
PERS_BRTH_DT DATE
* PERS_UNBORN_IND VARCHAR2 (1 BYTE)
PERS_SSN VARCHAR2 (9 BYTE)
PERS_SSN_VRF_DT DATE
F CITSP_VRF_TYP_CD VARCHAR2 (10 BYTE)
DOB_VRF_DT DATE
PERS_CITSP_IND VARCHAR2 (1 BYTE)
CITSP_VRF_DT DATE
PERS_RESIDENCY_IND VARCHAR2 (1 BYTE)
RESIDENCY_VRF_DT DATE
DCS_PERS_DTH_DT DATE
BANK_EFT_ID VARCHAR2 (12 BYTE)
BANK_ACCT_ID VARCHAR2 (20 BYTE)
LST_PHYS_EXAM_DT DATE
LST_PHYS_EXAM_VRF_DT DATE
AWACS_ADDR_CD VARCHAR2 (1 BYTE)
AWACS_EFT_ID NUMBER (10)
CONVERTED_IND VARCHAR2 (1 BYTE)
F RESIDENCY_VRF_TYP_CD VARCHAR2 (10 BYTE)
F SSN_VRF_TYP_CD VARCHAR2 (10 BYTE)
F DOB_VRF_TYP_CD VARCHAR2 (10 BYTE)
EXPT_TO_GRADUATE_DT NUMBER (4)
F LST_GRADE_CMPLTD_CD VARCHAR2 (10 BYTE)
*F ETHN_AFFINITY_CD VARCHAR2 (10 BYTE)
*F PERS_SEX_CTG_CD VARCHAR2 (10 BYTE)
F PHYS_EXAM_DT_VRF_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
F STDNT_ATTENDANCE_CD VARCHAR2 (10 BYTE)
INTER_UNIT_FUND_PMTS VARCHAR2 (1 BYTE)
WEBSITE_PASSWORD VARCHAR2 (30 BYTE)
WEBSITE_EMAIL_ADDR VARCHAR2 (100 BYTE)
WEBSITE_SESSN_AUTH VARCHAR2 (30 BYTE)
WEBSITE_SESSN_TIME DATE
PORTAL_CNT NUMBER (1)
IMM_VRF_COMP_DT DATE
BKGD_INVSTG_VRF_COMP_DT DATE
TRAIN_30_DAY_COMP_DT DATE
TRAIN_60_DAY_COMP_DT DATE
TRAIN_90_DAY_COMP_DT DATE
PERS_PK
CHCA.CHCA_MEETS_CRITERIA_TYPES
*P CRITERIA_CD VARCHAR2 (10 BYTE)
* CRITERIA_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
MECR_PK
CHCA.CHCA_BKGD_INVST_BASED_ON_TYPES
*P BASED_ON_CD VARCHAR2 (10 BYTE)
* BASED_ON_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
BIBO_PK
CHCA.CHCA_BKGD_INVSTG_STATE_RESULTS
*P BISR_APPL_SEQ_NO NUMBER (3)
STT_INVSTG_TX VARCHAR2 (60 BYTE)
*F BKGD_INVSTG_STT_RSLT_CD VARCHAR2 (10 BYTE)
*PF BCIN_APPL_SEQ_NO NUMBER (3)
*F STT_CD VARCHAR2 (2 BYTE)
*PF PERS_ID_SEQ VARCHAR2 (14 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
DATE_COMPLETED DATE
BISR_PK
CHCA.CHCA_BKGD_INVSTGT_STT_CODES
*P BKGD_INVSTG_STS_CD VARCHAR2 (10 BYTE)
*U BKGD_INVSTG_STS_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
BIGC_PK
BIGC_BIGC_1_UK
CHCA.CHCA_BKGD_INVSTGS
*PF PERS_ID_SEQ VARCHAR2 (14 BYTE)
*P BCIN_APPL_SEQ_NO NUMBER (3)
*F BKGD_INVSTG_STS_CD VARCHAR2 (10 BYTE)
*F BKGD_INVSTG_SRC_TYP_CD VARCHAR2 (10 BYTE)
BKGD_INVSTG_TX VARCHAR2 (4000 BYTE)
* BKGD_INVSTG_BGN_DT DATE
BKGD_INVSTG_END_DT DATE
*F BKGD_INVSTG_TYP_CD VARCHAR2 (10 BYTE)
CLEARED_BKGD_INVSTG_FLGS VARCHAR2 (1 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
PRVDR_CONDCTD VARCHAR2 (1 BYTE)
F BASED_ON_CD VARCHAR2 (10 BYTE)
F CRITERIA_CD VARCHAR2 (10 BYTE)
BCIN_PK
CHCA.CHCA_IMMUNIZATION_TYPES
*P IMM_TYP_CD VARCHAR2 (10 BYTE)
*U IMM_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
IMTY_PK
IMTY_IMTY_1_UK
CHCA.CHCA_CARE_APPROV_CRITER_TYPES
*P CARE_APPROV_CRITER_TYP_CD VARCHAR2 (10 BYTE)
* CARE_APPROV_CRITER_TYP_NM VARCHAR2 (50 BYTE)
* DERIVED_IND VARCHAR2 (1 BYTE)
F DOC_TYP_CD VARCHAR2 (10 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
CACT_PK
CHCA.CHCA_CAREER_PATH_STATUS_TYPES
*P CPAS_TYP_CD NUMBER (14)
* CPAS_TYP_NM VARCHAR2 (100 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
CPAS_PK
CHCA.CHCA_PERSON_DOCUMENTS
*PF PERS_ID_SEQ VARCHAR2 (14 BYTE)
*P PDOC_APPL_SEQ_NO NUMBER (5)
*F DOC_TYP_CD VARCHAR2 (10 BYTE)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
DOCUMENT_ID NUMBER (15)
FIRST_REQUEST_DT DATE
RECEIVED_DT DATE
PDOC_COMMENT VARCHAR2 (254 BYTE)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
PDOC_PK
CHCA.CHCA_CONTRACT_APPLICATIONS
*P CONA_ID_SEQ NUMBER (12)
* CONTT_FISC_YR NUMBER (4)
CONTT_APPL_DENIAL_DT DATE
CONTT_APPL_ACCEPTED_DT DATE
*F CONTT_APPL_STS_CD VARCHAR2 (10 BYTE)
CONTT_APPL_TX VARCHAR2 (254 BYTE)
* CONTT_APPL_STS_DT DATE
* APPL_RECEIVED_DT DATE
F CONTT_DENIAL_TERMN_CD VARCHAR2 (10 BYTE)
* CONTT_EFF_BGN_DT DATE
* CONTT_EFF_END_DT DATE
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
PROPOSAL_SCR NUMBER
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
*F CONTT_TYP_CD VARCHAR2 (10 BYTE)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CONA_PK
CHCA.CHCA_PRSN_CARE_APPROV_CRITER
*P PCAC_APPL_SEQ_NO NUMBER (5)
*F CARE_APPROV_CRITER_TYP_CD VARCHAR2 (10 BYTE)
DUE_DT DATE
COMPLETE_DT DATE
STRING_VAL VARCHAR2 (50 BYTE)
F CRITERIA_CD VARCHAR2 (10 BYTE)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
*PF PCAH_ID_SEQ NUMBER (12)
PCAC_PK
CHCA.CHCA_PERSON_TRAINING
*PF PERS_ID_SEQ VARCHAR2 (14 BYTE)
*P PETR_APPL_SEQ_NO NUMBER (5)
*F TRCO_TYP_CD NUMBER (14)
F TRQU_TYP_CD NUMBER (14)
*F TRSC_TYP_CD VARCHAR2 (10 BYTE)
EVENT_ID NUMBER (14)
HOURS NUMBER (8,2)
COMPLETED_DT DATE
FEE_AMT NUMBER (8,2)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
APP_EVENT_ID NUMBER (14)
EXPIRED_DT DATE
PETR_PK
CHCA.CHCA_INFO_COMPLAINT_PERSONS
*PF COMP_ID_SEQ VARCHAR2 (14 BYTE)
*P PCOM_APPL_SEQ_NO NUMBER (3)
PERS_NM_PREFX VARCHAR2 (5 BYTE)
PERS_FST_NM VARCHAR2 (40 BYTE)
PERS_MID_INT VARCHAR2 (1 BYTE)
PERS_LST_NM VARCHAR2 (40 BYTE)
PERS_NM_SUFX VARCHAR2 (10 BYTE)
PERS_DOB DATE
PHN_NO VARCHAR2 (20 BYTE)
F PERS_SEX_CTG_CD VARCHAR2 (10 BYTE)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
*F INFO_CMPLT_ROLE_CD VARCHAR2 (10 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
* CREATED_BY VARCHAR2 (30 BYTE)
PCOM_PK
CHCA.CHCA_TRAINING_COURSE_TYPES
*P TRCO_TYP_CD NUMBER (14)
* TRCO_TYP_NM VARCHAR2 (500 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
F TRQU_TYP_CD NUMBER (14)
TRCO_PK
CHCA.CHCA_PERSON_CERTIFICATIONS
*PF PERS_ID_SEQ VARCHAR2 (14 BYTE)
*P PECE_APPL_SEQ_NO NUMBER (5)
*F TRCE_TYP_CD NUMBER (14)
*F TRSC_TYP_CD VARCHAR2 (10 BYTE)
INSTITUTION_NM VARCHAR2 (250 BYTE)
EARNED_DT DATE
EXPIRED_DT DATE
APP_EDUCATION_ID NUMBER (14)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
HOURS NUMBER (8,2)
SCHEDULED_DT DATE
PECE_PK
CHCA.CHCA_CAREER_PATH_TYPES
*P CAPT_TYP_CD NUMBER (14)
* CAPT_TYP_NM VARCHAR2 (100 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
CAPT_PK
CHCA.CHCA_PERSONS
*P PERS_ID_SEQ VARCHAR2 (14 BYTE)
PERS_BRTH_DT DATE
* PERS_UNBORN_IND VARCHAR2 (1 BYTE)
PERS_SSN VARCHAR2 (9 BYTE)
PERS_SSN_VRF_DT DATE
F CITSP_VRF_TYP_CD VARCHAR2 (10 BYTE)
DOB_VRF_DT DATE
PERS_CITSP_IND VARCHAR2 (1 BYTE)
CITSP_VRF_DT DATE
PERS_RESIDENCY_IND VARCHAR2 (1 BYTE)
RESIDENCY_VRF_DT DATE
DCS_PERS_DTH_DT DATE
BANK_EFT_ID VARCHAR2 (12 BYTE)
BANK_ACCT_ID VARCHAR2 (20 BYTE)
LST_PHYS_EXAM_DT DATE
LST_PHYS_EXAM_VRF_DT DATE
AWACS_ADDR_CD VARCHAR2 (1 BYTE)
AWACS_EFT_ID NUMBER (10)
CONVERTED_IND VARCHAR2 (1 BYTE)
F RESIDENCY_VRF_TYP_CD VARCHAR2 (10 BYTE)
F SSN_VRF_TYP_CD VARCHAR2 (10 BYTE)
F DOB_VRF_TYP_CD VARCHAR2 (10 BYTE)
EXPT_TO_GRADUATE_DT NUMBER (4)
F LST_GRADE_CMPLTD_CD VARCHAR2 (10 BYTE)
*F ETHN_AFFINITY_CD VARCHAR2 (10 BYTE)
*F PERS_SEX_CTG_CD VARCHAR2 (10 BYTE)
F PHYS_EXAM_DT_VRF_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
F STDNT_ATTENDANCE_CD VARCHAR2 (10 BYTE)
INTER_UNIT_FUND_PMTS VARCHAR2 (1 BYTE)
WEBSITE_PASSWORD VARCHAR2 (30 BYTE)
WEBSITE_EMAIL_ADDR VARCHAR2 (100 BYTE)
WEBSITE_SESSN_AUTH VARCHAR2 (30 BYTE)
WEBSITE_SESSN_TIME DATE
PORTAL_CNT NUMBER (1)
IMM_VRF_COMP_DT DATE
BKGD_INVSTG_VRF_COMP_DT DATE
TRAIN_30_DAY_COMP_DT DATE
TRAIN_60_DAY_COMP_DT DATE
TRAIN_90_DAY_COMP_DT DATE
PERS_PK
CHCA.CHCA_PERSON_IMMUNIZATIONS
*PF PERS_ID_SEQ VARCHAR2 (14 BYTE)
*P PIMM_APPL_SEQ_NO NUMBER (3)
PERS_IMM_DT DATE
PERS_IMM_VRF_DT DATE
*F IMM_TYP_CD VARCHAR2 (10 BYTE)
*F IMM_VRF_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
PIMM_PK
CHCA.CHCA_IMMUNIZATION_VRF_TYPES
*P IMM_VRF_TYP_CD VARCHAR2 (10 BYTE)
*U IMM_VRF_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
IMVT_PK
IMVT_IMVT_1_UK
CHCA.CHCA_PRSN_CARE_APPROV_HIST
*F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* STATUS_DT DATE
APPLICATION_DT DATE
RENEWAL_DT DATE
EXPIRATION_DT DATE
F CARE_QUALIFY_LEVEL_TYP_CD VARCHAR2 (10 BYTE)
PCAH_COMMENT VARCHAR2 (254 BYTE)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
F CARE_APPROV_ROLE_TYP_CD VARCHAR2 (10 BYTE)
*F CARE_APPROV_STS_CD VARCHAR2 (10 BYTE)
*P PCAH_ID_SEQ NUMBER (12)
PCAH_PK
CHCA.CHCA_TRAINING_SOURCE_TYPES
*P TRSC_TYP_CD VARCHAR2 (10 BYTE)
* TRSC_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
TRSC_PK
CHCA.CHCA_PERSON_ORGANIZATIONS
* PERS_ORG_BGN_DT DATE
*F PERS_ID_SEQ VARCHAR2 (14 BYTE)
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
PERS_ORG_END_DT DATE
* PERS_RSRC_FINGERPRINT_IND VARCHAR2 (1 BYTE)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
*F PERS_ORG_PERS_ROLE_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
*P PEOR_ID_SEQ NUMBER (12)
CAREGIVER_APPR_DT DATE
HIRE_DT DATE
COMT_TXT VARCHAR2 (2000 BYTE)
PEOR_PK
CHCA.CHCA_CARE_APPROV_STS_CODES
*P CARE_APPROV_STS_CD VARCHAR2 (10 BYTE)
* CARE_APPROV_STS_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
CCAS_PK
CHCA.CHCA_TRAINING_CERT_TYPES
*P TRCE_TYP_CD NUMBER (14)
* TRCE_TYP_NM VARCHAR2 (100 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
TRCE_PK
CHCA.CHCA_TRAINING_QUAL_TYPES
*P TRQU_TYP_CD NUMBER (14)
* TRQU_TYP_NM VARCHAR2 (500 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
TRQU_PK
CHCA.CHCA_PERSON_CAREER_PATHS
*PF PERS_ID_SEQ VARCHAR2 (14 BYTE)
*P PECP_APPL_SEQ_NO NUMBER (5)
*F CAPT_TYP_CD NUMBER (14)
F CPAS_TYP_CD NUMBER (14)
*F TRSC_TYP_CD VARCHAR2 (10 BYTE)
SUBMIT_DT DATE
RECEIVED_DT DATE
FINALIZED_DT DATE
EXPIRED_DT DATE
HOURS NUMBER (8,2)
ECP_APP_ID NUMBER (14)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
ECP_APP_SUBMIT_ID NUMBER (14)
PECP_PK
CHCA.CHCA_CARE_APPROV_ROLE_TYPE
*P CARE_APPROV_ROLE_TYP_CD VARCHAR2 (10 BYTE)
* CARE_APPROV_ROLE_TYP_NM VARCHAR2 (50 BYTE)
ROLE_HIERARCHY NUMBER (3)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
CART_PK
CHCA.CHCA_DOCUMENT_TYPES
*P DOC_TYP_CD VARCHAR2 (10 BYTE)
* DOC_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
DOCT_PK
CHCA.CHCA_BKGD_INVSTGS
*PF PERS_ID_SEQ VARCHAR2 (14 BYTE)
*P BCIN_APPL_SEQ_NO NUMBER (3)
*F BKGD_INVSTG_STS_CD VARCHAR2 (10 BYTE)
*F BKGD_INVSTG_SRC_TYP_CD VARCHAR2 (10 BYTE)
BKGD_INVSTG_TX VARCHAR2 (4000 BYTE)
* BKGD_INVSTG_BGN_DT DATE
BKGD_INVSTG_END_DT DATE
*F BKGD_INVSTG_TYP_CD VARCHAR2 (10 BYTE)
CLEARED_BKGD_INVSTG_FLGS VARCHAR2 (1 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
PRVDR_CONDCTD VARCHAR2 (1 BYTE)
F BASED_ON_CD VARCHAR2 (10 BYTE)
F CRITERIA_CD VARCHAR2 (10 BYTE)
BCIN_PK
CHCA.CHCA_ELIGIBILITY_DETS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*P ELDT_APPL_SEQ_NO NUMBER (3)
ELIGIBILITY_DET_DT DATE
* SCHD_REDETERMINATION_DT DATE
* APL_DEADLINE_DT DATE
*F ELIGIBILITY_DET_RSN_CD VARCHAR2 (10 BYTE)
* FAM_ELIGIBILITY_IND VARCHAR2 (1 BYTE)
F OUT_OVRRD_RSN_CD VARCHAR2 (10 BYTE)
*F PGM_ID VARCHAR2 (12 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CARE_RSN_CTG_CD VARCHAR2 (10 BYTE)
DATE_ELIG_DET DATE
ELIG_DET_BY VARCHAR2 (20 BYTE)
ELDT_PK
CHCA.CHCA_PERSONS
*P PERS_ID_SEQ VARCHAR2 (14 BYTE)
PERS_BRTH_DT DATE
* PERS_UNBORN_IND VARCHAR2 (1 BYTE)
PERS_SSN VARCHAR2 (9 BYTE)
PERS_SSN_VRF_DT DATE
F CITSP_VRF_TYP_CD VARCHAR2 (10 BYTE)
DOB_VRF_DT DATE
PERS_CITSP_IND VARCHAR2 (1 BYTE)
CITSP_VRF_DT DATE
PERS_RESIDENCY_IND VARCHAR2 (1 BYTE)
RESIDENCY_VRF_DT DATE
DCS_PERS_DTH_DT DATE
BANK_EFT_ID VARCHAR2 (12 BYTE)
BANK_ACCT_ID VARCHAR2 (20 BYTE)
LST_PHYS_EXAM_DT DATE
LST_PHYS_EXAM_VRF_DT DATE
AWACS_ADDR_CD VARCHAR2 (1 BYTE)
AWACS_EFT_ID NUMBER (10)
CONVERTED_IND VARCHAR2 (1 BYTE)
F RESIDENCY_VRF_TYP_CD VARCHAR2 (10 BYTE)
F SSN_VRF_TYP_CD VARCHAR2 (10 BYTE)
F DOB_VRF_TYP_CD VARCHAR2 (10 BYTE)
EXPT_TO_GRADUATE_DT NUMBER (4)
F LST_GRADE_CMPLTD_CD VARCHAR2 (10 BYTE)
*F ETHN_AFFINITY_CD VARCHAR2 (10 BYTE)
*F PERS_SEX_CTG_CD VARCHAR2 (10 BYTE)
F PHYS_EXAM_DT_VRF_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
F STDNT_ATTENDANCE_CD VARCHAR2 (10 BYTE)
INTER_UNIT_FUND_PMTS VARCHAR2 (1 BYTE)
WEBSITE_PASSWORD VARCHAR2 (30 BYTE)
WEBSITE_EMAIL_ADDR VARCHAR2 (100 BYTE)
WEBSITE_SESSN_AUTH VARCHAR2 (30 BYTE)
WEBSITE_SESSN_TIME DATE
PORTAL_CNT NUMBER (1)
IMM_VRF_COMP_DT DATE
BKGD_INVSTG_VRF_COMP_DT DATE
TRAIN_30_DAY_COMP_DT DATE
TRAIN_60_DAY_COMP_DT DATE
TRAIN_90_DAY_COMP_DT DATE
PERS_PK
CHCA.CHCA_ELIG_CASE_MEMBER_INFO
*P ECMI_ID_SEQ NUMBER (12)
*F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*F CEVP_APPL_SEQ_NO NUMBER (3)
*F ELDT_APPL_SEQ_NO NUMBER (3)
*F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* PERS_BRTH_DT DATE
* RQST_CHILD_CARE VARCHAR2 (1 BYTE)
CHLD_DSBLTY_STS VARCHAR2 (3 BYTE)
PERS_CNTBL_INCOME NUMBER (9,2)
PERS_CNTBL_ACTV_HRS NUMBER (3)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
ECMI_PK
CHCA.CHCA_EVALUATIONS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF ELDT_APPL_SEQ_NO NUMBER (3)
*P EVAL_APPL_SEQ_NO NUMBER (3)
* EVAL_OUT_IND VARCHAR2 (1 BYTE)
F CEVP_APPL_SEQ_NO NUMBER (3)
F COFS_ID_SEQ NUMBER (12)
F EVAL_DET_RSN_CD VARCHAR2 (10 BYTE)
*F EVAL_TYP_CD VARCHAR2 (10 BYTE)
F OUT_OVRRD_RSN_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
EVAL_PK
CHCA.CHCA_WAITLIST_ASSOCIATIONS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF PGM_ID VARCHAR2 (12 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
WAIT_PK
CHCA.CHCA_SCHOOL_ENROLLMENT_TYPES
*P SCHL_ENRL_TYP_CD VARCHAR2 (10 BYTE)
*U SCHL_ENRL_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
SCEN_PK
SCEN_SCEN_1_UK
CHCA.CHCA_CASE_EVNT_PERS_TO_PRIMS
*P CASE_EVNT_PERS_ASSO_CD VARCHAR2 (10 BYTE)
*U CASE_EVNT_PERS_ASSO_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CPAR_PK
CPAR_CPAR_1_UK
CHCA.CHCA_WAITLIST_STATUSES
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF PGM_ID VARCHAR2 (12 BYTE)
*P WTST_APPL_SEQ_NO NUMBER (3)
* WAITLIST_STS_DT_TM DATE
*F WAITLIST_STS_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
* GROSS_INCM_AMT NUMBER (18,2)
* FAM_SIZE NUMBER (3)
WTST_PK
CHCA.CHCA_SERVICE_PAYMENT_CHILDREN
*PF SPST_ID_SEQ NUMBER (12)
*P SPCN_APPL_SEQ_NO NUMBER (3)
CHILD_ID VARCHAR2 (14 BYTE)
SERVICE_HOURS NUMBER (18,2)
PROGRAM VARCHAR2 (12 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
FUND_ACCT VARCHAR2 (20 BYTE)
SPCN_PK
CHCA.CHCA_CASE_EVNT_PERSON_PTCPS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*P CEPP_APPL_SEQ_NO NUMBER (3)
* PERS_PTCP_BGN_DT DATE
PERS_PTCP_END_DT DATE
*F PTCP_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CEPP_PK
CHCA.CHCA_PARTICIPATION_TYPES
*P PTCP_TYP_CD VARCHAR2 (10 BYTE)
*U PTCP_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
PATY_PK
PATY_PATY_1_UK
CHCA.CHCA_WAITLIST_STATUS_TYPES
*P WAITLIST_STS_TYP_CD VARCHAR2 (10 BYTE)
*U WAITLIST_STS_TYP_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
WSTP_PK
WSTP_WSTP_1_UK
CHCA.CHCA_CASE_EVENT_PERSONS
*P CEVP_APPL_SEQ_NO NUMBER (3)
* REQUESTING_CHILD_CARE_IND VARCHAR2 (1 BYTE)
*F CASE_EVNT_PERS_ASSO_CD VARCHAR2 (10 BYTE)
*UF PERS_ID_SEQ VARCHAR2 (14 BYTE)
F SCHL_ENRL_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
HEAD_OF_HOUSEHOLD VARCHAR2 (1 BYTE)
CHLD_SPRT_CMPL VARCHAR2 (1 BYTE)
CHLD_DSBLTY_STS VARCHAR2 (2 BYTE)
CEVP_PK
CEVP_UK_1
CHCA.CHCA_AUTHORIZATIONS
*P AUTH_ID_SEQ NUMBER (12)
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF CEVP_APPL_SEQ_NO NUMBER (3)
* AUTH_BGN_DT DATE
* AUTH_END_DT DATE
* AUTHORIZED_DOLLAR_AMT NUMBER (18,2)
* HOH_PAY_IND VARCHAR2 (1 BYTE)
* PRI_PROV_IND VARCHAR2 (1 BYTE)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
*F CHILD_CARE_TYP_CD VARCHAR2 (10 BYTE)
F RT_OVRRD_RSN_CD VARCHAR2 (10 BYTE)
F WRKR_ID_SEQ NUMBER (12)
*F FUND_ACCT_ID VARCHAR2 (20 BYTE)
*F PGM_ID VARCHAR2 (12 BYTE)
*F AUTH_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CARE_RSN_CTG_CD VARCHAR2 (10 BYTE)
F CAPB_TYP_CD VARCHAR2 (6 BYTE)
NO_OF_HOURS_PER_PERIOD NUMBER (6,2)
NO_OF_DAYS_PER_PERIOD NUMBER (6,2)
F AUSP_TYP_CD VARCHAR2 (10 BYTE)
AUTH_PK
CHCA.CHCA_NOTES
*P NOTE_ID_SEQ NUMBER (12)
*F NOTE_CTG_CD VARCHAR2 (10 BYTE)
*F NOTE_TYP_CD VARCHAR2 (10 BYTE)
*F WRKR_ID_SEQ NUMBER (12)
* NOTE_LBL VARCHAR2 (100 BYTE)
* NOTE_DT DATE
F COMP_ID_SEQ VARCHAR2 (14 BYTE)
F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
F CEVP_APPL_SEQ_NO NUMBER (3)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CNFIDNTL_IND VARCHAR2 (1 BYTE)
CONA_ID_SEQ NUMBER (12)
CNTC_APPL_SEQ_NO NUMBER (3)
CONTT_FISC_YR NUMBER (4)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
CON_MTHD_CD VARCHAR2 (10 BYTE)
CLNT_CONTACT VARCHAR2 (1 BYTE)
CNFIDNTL_WRKR_ID NUMBER (12)
CNFIDNTL_DT DATE
NOTE_PK
CHCA.CHCA_WORKER_ALERTS
*PF WRKR_ID_SEQ NUMBER (12)
*P WRAL_APPL_SEQ_NO NUMBER (6)
* ALRT_DESCR VARCHAR2 (100 BYTE)
* ALRT_TEXT VARCHAR2 (2000 BYTE)
CLOSE_DT DATE
DUE_DT DATE
* DSPLY_IND VARCHAR2 (1 BYTE)
F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
F CNTC_APPL_SEQ_NO NUMBER (3)
F COMP_ID_SEQ VARCHAR2 (14 BYTE)
F CONA_ID_SEQ NUMBER (12)
F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*F ALRT_TYP_CD VARCHAR2 (10 BYTE)
F CEVP_APPL_SEQ_NO NUMBER (3)
F PHST_APPL_SEQ_NO NUMBER (3)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
NOTI_ID_SEQ NUMBER (12)
PDF_APPL_SEQ_NO NUMBER (3)
WRAL_PK
CHCA.CHCA_CASE_EVENT_REASONS
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*P CEVR_APPL_SEQ_NO NUMBER (3)
*F CARE_RSN_CTG_CD VARCHAR2 (10 BYTE)
* CASE_EVNT_RSN_PRI_IND_CD VARCHAR2 (1 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CEVR_PK
CHCA.CHCA_FMLY_HMLSS_HSTRY
*P FAHH_ID_SEQ NUMBER (12)
*F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*F FMLY_HOMELESS_STS VARCHAR2 (2 BYTE)
* RPT_DT DATE
* EFF_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
FAHH_PK
CHCA.CHCA_PROGRAM_ELIGIBILITIES
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*PF PGM_ID VARCHAR2 (12 BYTE)
* BENEFITS_ELIGIBLE_IND VARCHAR2 (1 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
PREL_PK
CHCA.CHCA_CASE_EVNT_COPAY_ASMTS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*P CECA_APPL_SEQ_NO NUMBER (3)
* COPAY_EFF_DT DATE
TOT_MMY_FAM_COPAY_AMT NUMBER (18,2)
F COPAY_WV_RSN_CD VARCHAR2 (10 BYTE)
COPAY_WV_BGN_DT DATE
COPAY_WV_END_DT DATE
COPAY_WV_AMT NUMBER (18,2)
COPAY_WV_COMT VARCHAR2 (1000 BYTE)
F COFS_ID_SEQ NUMBER (12)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CECA_PK
CHCA.CHCA_ELIGIBILITY_DETS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*P ELDT_APPL_SEQ_NO NUMBER (3)
ELIGIBILITY_DET_DT DATE
* SCHD_REDETERMINATION_DT DATE
* APL_DEADLINE_DT DATE
*F ELIGIBILITY_DET_RSN_CD VARCHAR2 (10 BYTE)
* FAM_ELIGIBILITY_IND VARCHAR2 (1 BYTE)
F OUT_OVRRD_RSN_CD VARCHAR2 (10 BYTE)
*F PGM_ID VARCHAR2 (12 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CARE_RSN_CTG_CD VARCHAR2 (10 BYTE)
DATE_ELIG_DET DATE
ELIG_DET_BY VARCHAR2 (20 BYTE)
ELDT_PK
CHCA.CHCA_ONLINE_APPS
*P ONAP_ID_SEQ NUMBER (12)
* APP_DATE DATE
XML_DOC CLOB
PDF BLOB
WRKR_ID_SEQ NUMBER (12)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
F NOTI_ID_SEQ NUMBER (12)
* APP_STR_DT DATE
* APP_SUB_DT DATE
* APP_NO VARCHAR2 (100 BYTE)
F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
ONAP_PK
CHCA.CHCA_CE_STATUS_TYPES
*P CASE_EVNT_STS_CD VARCHAR2 (10 BYTE)
*U CASE_EVNT_STS_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CVST_PK
CVST_CVST_1_UK
CHCA.CHCA_CARE_REASON_CATEGORIES
*P CARE_RSN_CTG_CD VARCHAR2 (10 BYTE)
*U CARE_RSN_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CRCA_PK
CRCA_CRCA_1_UK
CHCA.CHCA_CHILD_CARE_CASES
*P CHCC_ID_SEQ VARCHAR2 (14 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CHCC_PK
CHCA.CHCA_CASE_EVENT_PROVIDERS
*PF CARE_ID_SEQ VARCHAR2 (14 BYTE)
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CEPR_PK
CHCA.CHCA_CASE_EVENTS
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*P CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
* APPL_DT DATE
* SNGL_PAR_IND VARCHAR2 (1 BYTE)
* TRIBAL_TANF_IND VARCHAR2 (1 BYTE)
F TANF_STS_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CE_BGN_DT DATE
CE_END_DT DATE
MILITARY_STS VARCHAR2 (3 BYTE)
FMLY_HOMELESS_STS VARCHAR2 (2 BYTE)
FMLY_ASTS_EXC_MIL VARCHAR2 (1 BYTE)
CAEV_PK
CHCA.CHCA_ELIG_CASE_MEMBER_INFO
*P ECMI_ID_SEQ NUMBER (12)
*F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*F CEVP_APPL_SEQ_NO NUMBER (3)
*F ELDT_APPL_SEQ_NO NUMBER (3)
*F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* PERS_BRTH_DT DATE
* RQST_CHILD_CARE VARCHAR2 (1 BYTE)
CHLD_DSBLTY_STS VARCHAR2 (3 BYTE)
PERS_CNTBL_INCOME NUMBER (9,2)
PERS_CNTBL_ACTV_HRS NUMBER (3)
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
ECMI_PK
CHCA.CHCA_CASE_EVENT_WORKERS
*PF WRKR_ID_SEQ NUMBER (12)
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CAEW_PK
CHCA.CHCA_FMLY_HMLSS_STS
*P FMLY_HOMELESS_STS VARCHAR2 (3 BYTE)
* FMLY_HOMELESS_DESCR VARCHAR2 (80 BYTE)
* EFF_BGN_DT DATE
EFF_END_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
FMLY_PK
CHCA.CHCA_CASE_EVENT_PERSONS
*P CEVP_APPL_SEQ_NO NUMBER (3)
* REQUESTING_CHILD_CARE_IND VARCHAR2 (1 BYTE)
*F CASE_EVNT_PERS_ASSO_CD VARCHAR2 (10 BYTE)
*UF PERS_ID_SEQ VARCHAR2 (14 BYTE)
F SCHL_ENRL_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
HEAD_OF_HOUSEHOLD VARCHAR2 (1 BYTE)
CHLD_SPRT_CMPL VARCHAR2 (1 BYTE)
CHLD_DSBLTY_STS VARCHAR2 (2 BYTE)
CEVP_PK
CEVP_UK_1
CHCA.CHCA_CE_STATUSES
*P CASE_EVNT_STS_DT_TM DATE
*PF CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*PF CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*F CASE_EVNT_STS_CD VARCHAR2 (10 BYTE)
F CLOSURE_RSN_TYP_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CLOSURE_DT DATE
CEVS_PK
CHCA.CHCA_MLRTY_HSTRY
*P MASH_ID_SEQ NUMBER (12)
*F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
*F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
*F MILITARY_STS VARCHAR2 (3 BYTE)
* RPT_DT DATE
* EFF_DT DATE
* DATETIME_CREATED DATE
* CREATED_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MOD_BY VARCHAR2 (30 BYTE)
CHCA_MASH_PK
CHCA.CHCA_NOTES
*P NOTE_ID_SEQ NUMBER (12)
*F NOTE_CTG_CD VARCHAR2 (10 BYTE)
*F NOTE_TYP_CD VARCHAR2 (10 BYTE)
*F WRKR_ID_SEQ NUMBER (12)
* NOTE_LBL VARCHAR2 (100 BYTE)
* NOTE_DT DATE
F COMP_ID_SEQ VARCHAR2 (14 BYTE)
F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
F CEVP_APPL_SEQ_NO NUMBER (3)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CNFIDNTL_IND VARCHAR2 (1 BYTE)
CONA_ID_SEQ NUMBER (12)
CNTC_APPL_SEQ_NO NUMBER (3)
CONTT_FISC_YR NUMBER (4)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
CON_MTHD_CD VARCHAR2 (10 BYTE)
CLNT_CONTACT VARCHAR2 (1 BYTE)
CNFIDNTL_WRKR_ID NUMBER (12)
CNFIDNTL_DT DATE
NOTE_PK
CHCA.CHCA_TANF_TYPES
*P TANF_STS_CD VARCHAR2 (10 BYTE)
*U TANF_STS_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
TATY_PK
TATY_TATY_1_UK
CHCA.CHCA_CHIMES_ED_LEVEL_CODES
*P ED_LVL_CD VARCHAR2 (2 BYTE)
* ED_LVL_DESC VARCHAR2 (80 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CECD_PK
CHCA.CHCA_CHIMES_RLTSHIP_CODES
*P RLT_CD VARCHAR2 (4 BYTE)
* RLT_DESC VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CRCD_PK
CHCA.CHCA_CONTRACT_APPLICATIONS
*P CONA_ID_SEQ NUMBER (12)
* CONTT_FISC_YR NUMBER (4)
CONTT_APPL_DENIAL_DT DATE
CONTT_APPL_ACCEPTED_DT DATE
*F CONTT_APPL_STS_CD VARCHAR2 (10 BYTE)
CONTT_APPL_TX VARCHAR2 (254 BYTE)
* CONTT_APPL_STS_DT DATE
* APPL_RECEIVED_DT DATE
F CONTT_DENIAL_TERMN_CD VARCHAR2 (10 BYTE)
* CONTT_EFF_BGN_DT DATE
* CONTT_EFF_END_DT DATE
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
PROPOSAL_SCR NUMBER
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
*F CONTT_TYP_CD VARCHAR2 (10 BYTE)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CONA_PK
CHCA.CHCA_CONTRACT_WORKERS
*PF CONA_ID_SEQ NUMBER (12)
*P ASSOC_EFF_BGN_DT DATE
ASSOC_EFF_END_DT DATE
*PF WRKR_ID_SEQ NUMBER (12)
* CREATED_BY VARCHAR2 (20 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (20 BYTE)
DATETIME_MOD DATE
CHLD_DMPL VARCHAR2 (2 BYTE)
CWRK_PK
CHCA.CHCA_QUARTERLY_REPORTS
*PF CONA_ID_SEQ NUMBER (12)
*PF CNTC_APPL_SEQ_NO NUMBER (3)
*P QTRP_APPL_SEQ_NO NUMBER (3)
* QUARTER NUMBER (2)
RECEIVED_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
QTRP_PK
CHCA.CHCA_CONTRACT_STATUS_CODES
*P CONTT_STS_CD VARCHAR2 (10 BYTE)
*U CONTT_STS_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CONS_PK
CONS_CONS_1_UK
CHCA.CHCA_CONTRACT_PARTICIPATIONS
*PF CONA_ID_SEQ NUMBER (12)
*PF CNTC_APPL_SEQ_NO NUMBER (3)
*P CNPT_APPL_SEQ_NO NUMBER (3)
* PTCP_MNTH DATE
DAYS_OF_OPERATION NUMBER
TWENTY_PCT_REQD NUMBER
HR_OF_STT_PD_CARE NUMBER
CERTIFIED_CAREGIVERS NUMBER
INFANTS_IN_CARE NUMBER
TODDLERS_IN_CARE NUMBER
F INVC_ID_SEQ NUMBER (12)
F INVC_HIST_NO NUMBER (3)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CNPT_PK
CHCA.CHCA_CONTRACT_BUDGET_ITEMS
*PF CONA_ID_SEQ NUMBER (12)
*PF CNTC_APPL_SEQ_NO NUMBER (3)
*PF CONB_APPL_SEQ_NO NUMBER (3)
*P CBIT_APPL_SEQ_NO NUMBER (3)
* BUDG_ITEM_AMT NUMBER
*F BUDG_ITEM_CD VARCHAR2 (10 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CBIT_PK
CHCA.CHCA_CURRENT_CONTRACTORS
*P CCON_APPL_SEQ_NO NUMBER (3)
* ASGN_BGN_DT DATE
ASGN_END_DT DATE
*PF CNTC_APPL_SEQ_NO NUMBER (3)
*PF CONA_ID_SEQ NUMBER (12)
F CARE_ID_SEQ VARCHAR2 (14 BYTE)
F ORGS_ID_SEQ VARCHAR2 (14 BYTE)
F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
CCON_PK
CHCA.CHCA_CONTRACTS
*P CONA_ID_SEQ NUMBER (12)
*P CNTC_APPL_SEQ_NO NUMBER (3)
* CONTT_DIV_NO NUMBER (2)
* CONTT_FISC_YR NUMBER (4)
* CONTT_SEQ_NO NUMBER (4)
* CONTT_AMENDMENT_NO NUMBER (3)
*F CONTT_STS_CD VARCHAR2 (10 BYTE)
* CONTT_STS_DT DATE
F CONTT_DENIAL_TERMN_CD VARCHAR2 (10 BYTE)
* CONTT_EFF_BGN_DT DATE
* CONTT_EFF_END_DT DATE
CONTT_EXEC_DT DATE
SECD_CONTT_LIAISON_PHN VARCHAR2 (20 BYTE)
TRM_DT DATE
* RENEWAL_SEQ_NO NUMBER (12)
SECD_CONTT_LIAISON_NM VARCHAR2 (40 BYTE)
*F CONTT_TYP_CD VARCHAR2 (10 BYTE)
F CONA_ID_SEQ_REF NUMBER (12)
F CNTC_APPL_SEQ_NO_REF NUMBER (3)
CONTT_AMENDMENT_EFF_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
NO_OF_RENEWALS NUMBER (2)
CNTR_PK
CHCA.CHCA_CONTRACT_REQUIRED_ITEMS
*P CNRI_APPL_SEQ_NO NUMBER (3)
* WORKMANS_COMP_VRF_EXEMPTION VARCHAR2 (1 BYTE)
WORKMANS_COMP_EXPR_DT DATE
F CNTC_APPL_SEQ_NO NUMBER (3)
*PF CONA_ID_SEQ NUMBER (12)
* DPHHS_ASSURANCES VARCHAR2 (1 BYTE)
* FS_424 VARCHAR2 (1 BYTE)
* INS_EXMT VARCHAR2 (1 BYTE)
* PROOF_OF_INS VARCHAR2 (1 BYTE)
INS_EXPR DATE
* LIC_REGIS_COPY VARCHAR2 (1 BYTE)
LIC_REGIS_EXPR_DT DATE
* SERV_PLN VARCHAR2 (1 BYTE)
* TRNG_PROJ_PLN VARCHAR2 (1 BYTE)
* MTCH_REQUIREMENT VARCHAR2 (1 BYTE)
MTCH_AMT NUMBER (18,2)
MTCH_RT VARCHAR2 (240 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
SELECTED_PROVIDER VARCHAR2 (14 BYTE)
NUM_WORKING_DAYS NUMBER (2)
CNRI_PK
CHCA.CHCA_BUDGET_ITEM_CODES
*P BUDG_ITEM_CD VARCHAR2 (10 BYTE)
*U BUDG_ITEM_NM VARCHAR2 (50 BYTE)
* CD_EFF_BGN_DT DATE
CD_EFF_END_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
BITM_PK
BITM_BITM_1_UK
CHCA.CHCA_CONTRACT_BUDGETS
*PF CONA_ID_SEQ NUMBER (12)
*PF CNTC_APPL_SEQ_NO NUMBER (3)
*P CONB_APPL_SEQ_NO NUMBER (3)
* TOT_BUDG_AMT NUMBER
REM_BUDG_ADV NUMBER
*F BUDG_SCTN_CD VARCHAR2 (10 BYTE)
F CNTC_APPL_SEQ_REF NUMBER (3)
F CONA_ID_SEQ_REF NUMBER (12)
F CONB_APPL_SEQ_REF NUMBER (3)
BUDG_ADJ_EFF_DT DATE
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
MIBS_SPRS VARCHAR2 (1 BYTE)
CONB_PK
CHCA.CHCA_ADJUSTMENTS
*P ADJT_ID_SEQ NUMBER (12)
RCVR_STR_DT DATE
ADJ_DRV_INT_AMT NUMBER (18,2)
ADJ_DRV_BAL NUMBER (18,2)
ADJ_EFF_DT DATE
RELEASED_IND VARCHAR2 (1 BYTE)
ADJ_BTCH_RUN_DT DATE
F CHCC_ID_SEQ VARCHAR2 (14 BYTE)
F CAEV_APPL_SEQ_NO VARCHAR2 (5 BYTE)
F CNTC_APPL_SEQ_NO NUMBER (3)
F CONA_ID_SEQ NUMBER (12)
F INVC_ID_SEQ NUMBER (12)
F INVC_HIST_NO NUMBER (3)
*F ADJ_TYP_CD VARCHAR2 (10 BYTE)
F IATL_APPL_SEQ_NO NUMBER (3)
* CREATED_BY VARCHAR2 (30 BYTE)
ADJT_PK
CHCA.CHCA_PROV_CONTRACT_LIAISONS
*PF CNTC_APPL_SEQ_NO NUMBER (3)
*PF CONA_ID_SEQ NUMBER (12)
*F PERS_ID_SEQ VARCHAR2 (14 BYTE)
* CREATED_BY VARCHAR2 (30 BYTE)
* DATETIME_CREATED DATE
MOD_BY VARCHAR2 (30 BYTE)
DATETIME_MOD DATE
*P PERS_LIAISON_BGN_DT DATE
PERS_LIAISON_END_DT DATE
PCLN_PK
CHCA.CHCA_CONTT_D…
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .