AHCCCS Contractor Resources Home Page > TIG Table of Contents > Behavioral Health Interface > This Page

Technical Interface Guidelines

Behavioral Health Interface

BHS Quarterly Management Reports
Introduction The BHS Quarterly Management Reports are created once every three months by AHCCCS. These reports contain summarized data on all active BHS records. 
Schedules The following table outlines schedules for the BHS Quarterly Management Reports.

Processing requirement

Schedule
BHS Quarterly Management Reports Run on the first day of every January, April, July and October.
Ethnicity by Rate Code File is named ccyymm.Q91 and is available in the BHS folder under /AZ/BHS/PROD/OUT folder
Ethnicity by Age File is named ccyymm.Q92 and is available in the BHS folder under /AZ/BHS/PROD/OUT folder
Children’s Population File is named ccyymm.Q93 and is available in the BHS folder under /AZ/BHS/PROD/OUT folder
SMI Population File is named ccyymm.Q94 and is available in the BHS folder under /AZ/BHS/PROD/OUT folder
Non-SMI Population File is named ccyymm.Q95 and is available in the BHS folder under /AZ/BHS/PROD/OUT folder
Entire Population File is named ccyymm.Q96 and is available in the BHS folder under /AZ/BHS/PROD/OUT folder

Media BHS Quarterly Management reports file will be sent to the AHCCCS FTP server and will be used to run the BHS Recon process.
Reporting This process produces the BHS Enrolled Quarterly Demographic reports for Ethnicity by Rate Code, Ethnicity by Age Group, Children's Population, SMI Population, Non-SMI Population and Entire Population. 

The reports created in this process will be sent to the AHCCCS FTP server and will be available for download and printing by ADHS.
Reference documents Enrolled Quarterly Demographic Report Ethnicity by Rate Code
Enrolled Quarterly Demographic Report Ethnicity by Age Group
Enrolled Quarterly Demographic Report Children's Population
Enrolled Quarterly Demographic Report SMI Population
Enrolled Quarterly Demographic Report Non-SMI Population
Enrolled Quarterly Demographic Report Entire Population

 
Back To Top  
   

Enrolled Quarterly Demographic Report Ethnicity by Rate Code


REPORT ID: RP90Q391                          ARIZONA HEALTH CARE COST CONTAINMENT SYSTEM                            PAGE:      1    
PROGRAM #: RP90L390                              ADHS ENROLLED DEMOGRAPHICS QUARTERLY                                RUN:01/01/04   
 

                                ETHNICITY BY RATE CODE FOR YUMA BEHAVIORAL HEALTH SERVICE AS OF: 01/01/04                    12:17   
 

ETHNICITY                AFDC    SSI W/MED      SSI W/O SOBRA CHILD SOBRA WOMEN    KIDS CARE      AZ CARE     MED CARE    TOTALS  
 

CAUCASIAN                 313          150          235          111            4           27          268            0     1,108  
HISPANIC                  625           84          157          226            1           54          200            1     1,348  
BLACK                      24            5           22           13            0            1           16            0        81  
NATIVE AMERICAN            24            2           15           30            0            3           17            0        91  
OTHER/UNKNOWN               1            6            3            0            0            5            0            0        15  
TOTAL                     987          247          432          380            5           90          501            1     2,643  

Back To Reference Documents
Back To Top

 

 

Enrolled Quarterly Demographic Report Ethnicity by Age Group


REPORT ID: RP90Q392                          ARIZONA HEALTH CARE COST CONTAINMENT SYSTEM                            PAGE:      1     
PROGRAM #: RP90L390                              ADHS ENROLLED DEMOGRAPHICS QUARTERLY                                RUN:01/01/04    
                                ETHNICITY BY AGE GROUP FOR YUMA BEHAVIORAL HEALTH SERVICE AS OF: 01/01/04                    12:17ETHNICITY                    0-4           5-9         10-14         15-17         18-20         21-64       65-OVER      ALL AGES  
CAUCASIAN                     11            71           141            70            22           772            21         1,108  
HISPANIC                      11           196           282           125            36           670            28         1,348  
BLACK                          0             8            12             7             1            51             2            81  
NATIVE AMERICAN                1            11            25            14             4           36             0            91  
OTHER/UNKNOWN                  0             3             2             0             0            10             0            15  
TOTAL                         23           289           462           216            63         1,539            51         2,643 
 
Back To Reference Documents
Back To Top
 

 

Enrolled Quarterly Demographic Report Children's Population



REPORT ID: RP90Q393                          ARIZONA HEALTH CARE COST CONTAINMENT SYSTEM                            PAGE:      1     
PROGRAM #: RP90L390                              ADHS ENROLLED DEMOGRAPHICS QUARTERLY                                RUN:01/01/04    
 
                                 CHILDREN POPULATION FOR YUMA BEHAVIORAL HEALTH SERVICE AS OF: 01/01/04                     12:17    
  NON-SED
              <- AFDC-> <SSI W/M> <SSI W/O> <SOB CH > <KDSCARE> <AZ CARE> <MED CARE> <-SOBRA WOMEN-> <-----TOTAL----->                    
   AGE     MAL FEM MAL FEM MAL FEM MAL FEM MAL FEM MAL FEM MAL   FEM                   MAL   FEM TOTAL                    
                                                                                                                                   

0-4         5    4    0    0    1    1    8    3    0    1    0    0    0     0          0         14     9    23                    
5-9        80   53    0    0   17    6   69   32   13    6    0    0    0     0          0        179    97   276                    
10-14     124   83    0    0   22   10   92   59   21   14    0    0    0     0          0        259   166   425                    
15-17      47   41    0    0   11    1   38   40   12   14    0    0    0     0          0        108    96   204                    
TOTAL     256 181    0    0   51   18 207 134   46   35    0    0    0     0          0        560   368   928   
Back To Reference Documents
Back To Top
 

Enrolled Quarterly Demographic Report SMI Population



REPORT ID: RP90Q394                          ARIZONA HEALTH CARE COST CONTAINMENT SYSTEM                            PAGE:      1     
PROGRAM #: RP90L390                              ADHS ENROLLED DEMOGRAPHICS QUARTERLY                                RUN:01/01/04    
                                   SMI POPULATION FOR YUMA BEHAVIORAL HEALTH SERVICE AS OF: 01/01/04                        12:17    
 

SMI 
          <--- AFDC ---> <- SSI W/MED -> <-- SSI W/O --> <--KIDS CARE--> <- AZ CARE -> <- MED CARE -> <SB/WM > <-----TOTAL----->  
   AGE     MAL FEM TOTAL MAL FEM TOTAL MAL FEM TOTAL MAL FEM TOTAL MAL FEM TOTAL MAL FEM TOTAL           MALE FEMAL TOTAL
18-20       0    3     3    1    0     1    2    1     3    0    0     0    2    2     4    0    0     0      0       5     6    11  
21-64      12   72    84   64   70   134   95 137   232    0    0     0   54   59   113    0    0     0      0     225   338   563  
65+         0    0     0    5   12    17    1    0     1    0    0     0    0    0     0    0    0     0      0       6    12    18  
TOTAL      12   75    87   70   82   152   98 138   236    0    0     0   56   61  117    0    0     0      0     236   356   592  
Back To Reference Documents
Back To Top
 

Monthly BHS HIFA II Capitation Summary Report



REPORT ID: HP07M274-E                         ARIZONA HEALTH CARE COST CONTAINMENT SYSTEM                              PAGE:   1    
PROGRAM #: HP07L274                             MONTHLY HIFA II                  SUMMARY                                RUN:11/30/03
                                                            AS OF 12/01/03                                                     02:00
PLAN: 079999 DHS BEHAVIORAL HEALTH                                                                                                  
COUNTY: 01 APACHE                                                                                                                   
                      NA CHILDREN       CHILDREN       NA ADULTS        ADULTS                        NA GMH/ADULT     GMH/ADULT    
MEMBER COUNT           0-17 YRS         0-17 YRS       18 & OVER       18 & OVER           TOTAL       18 & OVER       18 & OVER    
__________________ ______________ ______________ ______________ ______________ ______________ ______________ ______________  
HIFA II                          0               0             179              34             213             179              34  
                    -------------- -------------- -------------- -------------- -------------- -------------- --------------  
  COUNTY TOTAL                   0               0             179              34             213             179              34  
                    -------------- -------------- -------------- -------------- -------------- -------------- --------------  
CAPITATION RATE              $0.00           $0.00          $27.13          $27.13                          $11.02          $11.02  
                    -------------- --------------  -------------- -------------- -------------- -------------- --------------  
CAPITATION PAYMENT            $.00            $.00       $4,856.27         $922.42       $5,778.69       $1,972.58         $374.68  
                    -------------- -------------- -------------- -------------- -------------- -------------- --------------  
                                                                                         $2,347.26       $1,972.58         $374.68  
                    ============== ============== ============== ============== ============== ============== ==============  
TOTAL CAPITATION                                                                         $8,125.95                                  
                    ============== ============== ============== ============== ============== ============== ==============  
Back To Reference Documents
Back To Top
 

Enrolled Quarterly Demographic Report Non-SMI Population



REPORT ID: RP90Q395                          ARIZONA HEALTH CARE COST CONTAINMENT SYSTEM                            PAGE:      1     
PROGRAM #: RP90L390                              ADHS ENROLLED DEMOGRAPHICS QUARTERLY                                RUN:01/01/04    
                                   NON-SMI (GMH/SA) FOR YUMA BEHAVIORAL HEALTH SERVICE AS OF: 01/01/04                      12:17 

7400 - GMH 

          <--- AFDC ---> <- SSI W/MED -> <-- SSI W/O --> <--KIDS CARE--> <- AZ CARE -> <- MED CARE -> <SB/WM > <-----TOTAL----->  
   AGE     MAL FEM TOTAL MAL FEM TOTAL MAL FEM TOTAL MAL FEM TOTAL MAL FEM TOTAL MAL FEM TOTAL            MAL   FEM TOTAL

18-20       1    2     3    0    0     0    2    2     4    1    0     1    7    7    14    0    0     0      1      11    12    23  
21-64      78 273   351   25   33    58   31   58    89    0    0     0 121 109   230    1    0    1      3     256   476   732  
65+         0    0     0    7   18    25    1    2     3    0    0     0    0    0     0    0    0     0      0       8    20    28  
TOTAL      79 275   354   32   51    83   34   62    96    1    0     1 128 116   244    1    0     1      4     275   508   783

 
Back To Reference Documents
Back To Top

Enrolled Quarterly Demographic Report Entire Population


REPORT ID: RP90Q396                          ARIZONA HEALTH CARE COST CONTAINMENT SYSTEM                            PAGE:      1     
PROGRAM #: RP90L390                              ADHS ENROLLED DEMOGRAPHICS QUARTERLY                                RUN:01/01/04    
                ENTIRE ADHS T19 & T21 POPULATION BY SMI/CHILDR EN/GMH FOR YUMA BEHAVIORAL HEALTH SERVICE AS OF: 01/01/04    12:17    
 

            <- AFDC -> <SSI W/MED> <-SSI W/O-> < SOBRA CH> < KIDSCARE> < AZ CARE > < MED CARE> <- SOBRA WOMAN->   <---- TOTAL ---->  
 CATEGORY     MALE FEMAL MALE FEMAL MALE FEMAL MALE FEMAL MALE FEMAL MALE FEMAL MALE FEMAL                     MALE FEMAL TOTAL  
                                                                                                                                   

NON-SED       256   181     0     0    51    18   207   134    46    35     0     0     0     0          0           560   368   928  
SED            14     4     0     0    12     4    13     9     4     2     0     0     0     0          0            43    19    62  
TOTAL CHILD   270   185     0     0    63    22   220   143    50    37     0     0     0     0          0           603   387   990  
                                                                                                                                   

                                                                                                                                      
SMI            12    75    70    82    98   138     0     0     0     0    56    61     0     0          0           236   356   592  
GMH/SA        128   310    44    51    42    68     0     0     1     0   231   153     1     0          5           447   587 1034  
TOTAL ADULT   140   385   114   133   140   206     0     0     1     0   287   214     1     0          5           683   943 1626  
                                                                                                                                    

                                                                                                                                     
TOTAL TOTAL   410   570   114   133   203   228   220   143    51    37   287   214     1     0          5          1286 1330 2616  
 

Back To Reference Documents
Back To Top