PCMBeingSeenMH_7234 by mudoc123

VIEWS: 0 PAGES: 20

									Facility Name : MENWITH HILL MEDICAL CENTER (7234)


  CYCM      DMIS            FacilityName               PROVIDER GROUP   MEPRS4


 May-2011   7234   MENWITH HILL MEDICAL CENTER   MENWITH HILL           BGAH
                                                   # of Appts where the PT saw their
   Clinic Name (Place of Care)               PCM
                                                             assigned PCM

FAMILY PRACTICE/MENWITH          PLEWI1306                       133
                                                                                  # of Appointments where the Enrollee saw a P

% of Appts where the PT saw their
                                                                  % of Appointments
         assigned PCM               PCM was seeing Patients
                                                              (Column J / Column T)*100
   (Column H / Column T)*100

             39.12%                          164                       48.24%
# of Appointments where the Enrollee saw a Provider in the same group as their assigned PCM

                                                      % of Appointments           Enrollee saw their PCM or PCM in
             PCM was NOT seeing Patients
                                                  (Column L / Column T)*100                the same group

                          36                               10.59%                               333
                                                   # of Appointments where the Enrollee did NOT see a Provider in the same group as the

       % of Appointments
                                                                         % of Appointments
((Column H + Column J + Column L)   PCM was seeing Patients
                                                                     (Column P / Column T)*100
         / Column T)*100

             97.94%                           5                                 1.47%
e did NOT see a Provider in the same group as their assigned PCM

                                                          % of Appointments       Total # of
                 PCM was NOT seeing Patients
                                                      (Column R / Column T)*100    Appts

                               2                                   0.59%             340
Table reflects the total number of appointments for the CYCM



      CYCM            DMIS                   PCM Team          MEPRS4      Clinic Name (Place of Care)
    May-2011          7234                 MENWITH HILL        BGAH     FAMILY PRACTICE/MENWITH
                                     Table reflects the number of appointment where the Enrollee saw their assigned PCM



            PCM   Total # of Appts        CYCM             DMIS                   PCM Team
PLEWI1306               340              May-2011          7234                MENWITH HILL
llee saw their assigned PCM                                                                         Table reflects the number of appointme



                MEPRS4           Clinic Name (Place of Care)               PCM   Total # of Appts        CYCM
                  BGAH        FAMILY PRACTICE/MENWITH          PLEWI1306               133              May-2011
le reflects the number of appointments where the Enrollee saw a Provider(PRV) in the same group as their assigned PCM and their PCM was on Duty



                  DMIS                   PCM Team                  MEPRS4          Clinic Name (Place of Care)
                  7234                MENWITH HILL                   BGAH      FAMILY PRACTICE/MENWITH
assigned PCM and their PCM was on Duty                      Table reflects the number of appointments where the Enrollee saw a Provider(PRV) in the sa



                             PCM         Total # of Appts         CYCM            DMIS                   PCM Team
              PLEWI1306                        164              May-2011          7234                 MENWITH HILL
ollee saw a Provider(PRV) in the same group as their assigned PCM and their PCM was NOT on Duty                      Table reflects the number of appointme



                MEPRS4          Clinic Name (Place of Care)                     PCM               Total # of Appts        CYCM
                  BGAH     FAMILY PRACTICE/MENWITH               PLEWI1306                              36               May-2011
le reflects the number of appointments where the Enrollee did NOT see a Provider(PRV) in the same group as their assigned PCM and their PCM was on Duty



                  DMIS                   PCM Team                  MEPRS4          Clinic Name (Place of Care)
                  7234                MENWITH HILL                   BGAH     FAMILY PRACTICE/MENWITH
p as their assigned PCM and their PCM was on Duty                      Table reflects the number of appointments where the Enrollee did NOT see a Provider(PRV)



                               PCM                  Total # of Appts        CYCM             DMIS                  PCM Team
               PLEWI1306                                   5               May-2011          7234                MENWITH HILL
ollee did NOT see a Provider(PRV) in the same group as their assigned PCM and their PCM was NOT on Duty



                MEPRS4          Clinic Name (Place of Care)                     PCM                       Total # of Appts
                 BGAH      FAMILY PRACTICE/MENWITH              PLEWI1306                                        2
This report reflects the ratio of appointments in Primary Care clinics that enrollees have with their assigned PCM to the total number of appo
To determine the rate, an extract from the Patient Appointment run against all CHCS hosts daily. There are no filters applied
to the data at this point other than a
timeframe of T-90 to T-1.

There are three filters applied to the total number of appointments:
1. Only Primary Care Clinics are included. Primary Care clinics are defined using the business planning logic (i.e., MEPRS3 code is one of:
2. Appointment statuses included are Pending, Kept, Walk-in, Sick Call and LWOBS.
3. Appointment types included are ACUT, ACUT$, OPAC, OPAC$, WELL, WELL$, EST, EST$, ROUT, ROUT$, PCM and PCM$.


Data Source: Composite Health Card System (CHCS)
Adhocs ran: TOCWHO_SORT/TOCWHO_PRINT and TOCPCA_SORT/TOCPCA_PRINT ( *** NOTE *** Please do NOT
modify these adhocs in anyway. If saved under another User's IEN the adhoc will not run automatically and your
Time of Harvest: Shortly after midnight at each 106 CHCS hosts around the world

Points of Contact: Brian Kennedy at brian.kennedy@tma.osd.mil or Glenn Webb at glenn.webb.ctr@tma.osd.mil


        Percent of Visits                                                                                                                                    FromMain                                         MNO P Q
           Patient See                                                                                                                                        logic and                                  Tablerf ctshenumberofapointme swher t Patien(PT)saw
        Assigned PCM?                                                                                                                                        PTCM=N
         (lowest level))                                                                                                                                                                                 Provider(PRV)inthesamgroupastheirasgnedPCMandtheirPCM
                                                                                                                                                                                                         wasonDuty
                                                                                                                                                                                                           CYM DMIS EPRS4 Clinc Total#ofApts

         Is Appointment                                                                                                                                  DetrminesPCMwas
                                   Next       If provider is not a                                                                                        ondutyandwher to
        Date/Time within      N   Record
        previous month?                       PCM, drop the record.                                                                                      placeth Nrecods n                                                                        Creat QueryTo
                                                                                                                                                            thespradshet                                                                          GroupA tsfor
                                                                                                                                                                                                                                                  MonthTimefra
                                                                                                                                                                                                                                                    (numerato)

                Y

                                                                                                                                                                                        Creat QueryTo S T U V W
                                                                                                                                                                          DoesTMAWHO
                                              BAA, BDA(=BDAA,                                                                                             Doesth PRVIEN GroupA tsfor Tablerf ctshenumberofapointme swher t Patien(PT)saw
                                                                                                                                                                         PCMIENfield=to MonthTimefra
                                              =BDAN), BDZA,                                                                                                 andPCMIEN Y Y
                                                                                                                                                                         TMAENCPRVIEN
                                              BGA(<>BGAZ), BHA,                                                                                           GRPIEN(s)equal? (numerato) Provider(PRV)inthesam groupastheiras gnedPCMandtheirPCM
       Does MEPRS begin            Next                                                                                                                                       filed
                              N
        with one listed?          Record      BHH, BJA, BGZ, BDZ,                                                                                                                                        wasNOTonDuty
                                              BAZ, BKA and MEPRS
                                              ENDING <> 0, 1, 2, 5,                                                                                                                                       CYM DMIS EPRS4 Clinc Total#ofApts
                                              6, 7
                                                                                                                                                                                                 Next
                                                                                                                                                                                      N         Record
                Y
                                                                                                                                                                                Creat QueryTo                                                     Creat QueryTo
                                                                                                                                                                                GroupA tsfor                                                      GroupA tsfor
                                                                                                                                                                                MonthTimefra                                                      MonthTimefra
                                                                                                                                                                                  (numerato)                                                        (numerato)
                                                                                                                                                                 N
          Does the Appt            Next       Pending, Kept, Walk-in,
                              N   Record
       Status = one listed?                   Sick Call and LWOBS


                                                                                                                                                                                     Next
                                                                                                                                                                                                              Y Z A AB AC
                                                                                                                                                                                    Record               Tablerf ctshenumberofapointme swher t Patien(PT)diNOT
                Y
                                                                                                                                                                                                         se aProvider(PRV)inthesamgroupastheirasgnedPCMandtheir
                                                                                                                                                                                                         PCMwasonDuty

                                                                                                                                                                           Creat QueryTo                   CYM DMIS EPRS4 Clinc Total#ofApts
                                                                                                                                                           DoesTMAWHO GroupA tsfor
                                              ACUT, ACUT$, OPAC,                                                                                          PCMIENfield=to MonthTimefra
                                              OPAC$, WELL,                                                                                                               Y
       Does the Appt Type           Next                                                                                                                  TMAENCPRVIEN (numerato)
                              N               WELL$, EST, EST$,
          = one listed?            Record                                                                                                                      filed
                                              ROUT, ROUT$, PCM                                                                                                                                                                                     Creat QueryTo
                                              and PCM$                                                                                                                                                                                             GroupA tsfor
                                                                                                                                                                                                                                                   MonthTimefra
                                                                                                                                                                                                                                                     (numerato)
                                                                                                                                                                 N Next
                Y                                                                                                                                                                Record

                                                                              A              B           C             D                    E
                                                                                                                                                          Creat QueryTo
                                                                        T a b le r e f le c ts th e to ta l n u m b e r o f a p p o in tm e n ts f o r                                                       AE AF AG AH AI
                                                                                                                                                          GroupA tsfor
                                                                        th e C Y C M                                                                      MonthTimefra
                                                                                                                                                            (numerato)
                                                                                                                                                                                                         Tablerf ctshenumberofapointmeswher t Patien(PT)diNOT
       Does ENR2TXDMIS
                              N
                                   Next                                  C YC M         D M IS M EP R S 4 C lin ic             T o tal # o f A p p ts                                                    seaProvider(PRV)inthesamgroupastheirasgnedPCMandtheir
             = Y?                 Record
                                                                                                                                                                                                         PCMwasNOTonDuty
                                                                                                                                                                                                           CYM DMIS EPRS4 Clinc Total#ofApts
                                                                                                                                This is total records           Next
                                                                                                                                before analyzing if            Record
                                                                                                                                 Patient saw PCM.
                                                                               ACUT, ACUT$, OPAC,                                                                                                                           GroupA tsfor
                                                                                                                                                                                                           PCMIENfield=to MonthTimefra
                                                                               OPAC$, WELL,                                                                                                                               Y
            Does the Appt Type                   Next                                                                                                                                                      TMAENCPRVIEN (numerato)
                                        N                                      WELL$, EST, EST$,
               = one listed?                    Record                                                                                                                                                          filed
                                                                               ROUT, ROUT$, PCM                                                                                                                                                                                     Creat QueryTo
                                                                               and PCM$                                                                                                                                                                                             GroupA tsfor
                                                                                                                                                                                                                                                                                    MonthTimefra
                                                                                                                                                                                                                                                                                      (numerato)
                                                                                                                                                                                                                 N Next
                     Y                                                                                                                                                                                                           Record

                                                                                                             A              B           C             D                    E
                                                                                                                                                                                                           Creat QueryTo
                                                                                                       T a b le r e f le c ts th e to ta l n u m b e r o f a p p o in tm e n ts f o r                                                          AE AF AG AH AI
                                                                                                                                                                                                           GroupA tsfor
                                                                                                       th e C Y C M                                                                                        MonthTimefra
                                                                                                                                                                                                             (numerato)
                                                                                                                                                                                                                                           Tablerf ctshenumberofapointmeswher t Patien(PT)diNOT
            Does ENR2TXDMIS
                                       N
                                                Next                                                     C YC M        D M IS M EP R S 4 C lin ic             T o tal # o f A p p ts                                                       seaProvider(PRV)inthesamgroupastheirasgnedPCMandtheir
                  = Y?                         Record
                                                                                                                                                                                                                                           PCMwasNOTonDuty
                                                                                                                                                                                                                                             CYM DMIS EPRS4 Clinc Total#ofApts
                                                                                                                                                               This is total records                            Next
                                                                                                                                                               before analyzing if                             Record
                                                                                                                                                                Patient saw PCM.
                                                                                                                                                               (PTPCM = Y or N)
            This is total records                                                                                                                                [denominator]                                                                                                      Creat QueryTo
            before analyzing if                                                                                                                                                                                                                                                     GroupA tsfor
             Patient saw PCM.                                                PTPCM = N
                                                                                logic                                                                                                                                                                                               MonthTimefra
            (PTPCM = Y or N)                  Does PTPCM = Y?          N                                                                                                                                                                                                              (numerato)
              [denominator]
                                                                                                              G               H           I                     J                           K
                                                                                                       T a b le r e f le c ts th e n u m b e r o f a p p o in tm e n t w h e r e th e Pa tie n t( PT )
                                                                                                       s a w th e ir a s s ig n e d PC M

                                                         Y
                                                                                                          C YC M         D M IS M EP R S 4                  C lin ic              T o tal # o f A p p ts

                                               Create Query To
                                               Group Appts for
                                               Month Timeframe                                                                                                                          Create Query To
                                                 [numerator]                                                                                                                            Group Appts for
                                                                                                                                                                                        Month Timeframe
                                                                                                                                                                                          (numerator)




The logic applied to the record while the harvest is processing on the CHCS host(s) performs the following to determine the PTPCM variable:
1 - Null the variables of PTPCM, PCMIEN and PRVIEN
2 - Set PCMIEN to current assigned PCMs Internal Entry Number within the PROVIDER table
3 - Set PRVIEN to the Treatment Providers Internal Entry Number within the PROVIDER table
4 - Perform $Select statement on PCMIEN and PRVIEN variables to check if they match or not using the following Fileman code:

SETPARAM($S(PARAM("PCMIEN")=PARAM("PRVIEN"):"Y",1:"N"),"PTPCM");X - If they EQUAL PTPCM is set to Y if not PTPCM is set to N
M to the total number of appointments when the PCM is working at that facility.




e., MEPRS3 code is one of: BAA, BDA(=BDAA, =BDAN), BDZ(=BDZA), BGA(<>BGAZ), BHA, BHH, BJA, BGZ, BDZ, BAZ, BKA and MEPRS ENDING <> 0

  PCM and PCM$.
DZ, BAZ, BKA and MEPRS ENDING <> 0, 1, 2, 5, 6, 7).

								
To top