Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

M2 Ancillary

VIEWS: 2 PAGES: 8

									                        27 May 2011




  Ancillary Radiology
for the MHS Mart (M2)
   (Version 1.03.00)




 Future Specification
                                       Revision History

Version   Date         Originator      Para/Tbl/Fig     Description of Change
1.00.00                                                  Initial versioned document
1.01.00   03/25/2009   M. Weston                         Added TPR Eligibility Flag
1.01.01   01/15/2010   M. Weston        Table           Added Days Since Return from GWOT Depl
                                                         Other administrative changes
                                                         This update does not impact processing code.
1.02.00   04/26/2011   M. Weston        Table           Replaced Related Record ID with
                                                          Appointment Record ID to correspond with
                                                          CAPER
                                                         Added Inpatient Record ID to correspond
                                                          with SIDR
                                                         Renamed “GWOT” fields to “OCO”
1.03.00   05/27/2011   M. Weston        Table           Renamed Patient Registry Number to
                                                          Inpatient Record ID to correspond with SIDR.
                                                         Corrected field formats for OCO.




   Version 1.02.01                  M2 Radiology Ancillary - 2                      27 May 2011
                     Radiology Ancillary Record Feed for the MHS Mart (M2)


 I. File format: Regardless of the length specified, all fields are variable length and delimited
    by “!”. Immediately following the previous field’s end of field delimiter, a null field will
    have no blank before an end of field delimiter “!”, (e.g., “!!”).

II. Record Selection: Batches are by fiscal year. Original batches include all ancillary records
    with a Record Type=”R” that have not been cancelled.

III. Refresh Batches: Batches are by fiscal year with the Record ID (M2Key) the first element
     in the “new/updated” file. New/updated radiology ancillaries are kept separate (a
     different file) from a delete file. The delete file is used to purge the existing M2 database
     of records that are being updated or dropped PRIOR to loading the update file for the
     same FY. The record key for both files is the Record ID (M2Key) which is an encrypted
     numbering sequence continuing across fiscal years. The delete file contains only the
     record key, Record ID (M2Key).

       Frequency of updates:
           Current FY: Once per month.
           Prior FY: monthly for two months (October, November), then semi-annual (April).
           Second year prior to FY: Annually (October).
           No earlier years will be updated.

IV. M2-Inferred Fields: The radiology ancillary table as viewed in the M2 includes multiple
    fields that are not in the feed. These fields result from “joins” to other tables, sometimes
    with additional math, and are consequently not in the feed. M2-inferred fields include:

             M2 will create a Pseudo Sponsor ID to mask person-identifying data from
              unauthorized users.
             M2 will provide the following Market Area data by linking Beneficiary Zip Code,
              Sponsor Service, FY and FM to the Market Area Table: Catchment Area ID,
              PRISM Area ID, Market Area ID, Prime Service Area, TPR flag, Multi-Service
              Market Service, HSSC Region and Geo Concepts 2-8 (hide). Any records with a
              blank Beneficiary Zip Code will be transmitted from the MDR with a Beneficiary
              Zip Code “NONE”. If the join does not result in a match to the Market Area
              Table, the M2 Market Area data will be null.
             Linked attributes of DMIS IDs for the Enrollment Site DMIS ID, Ordering Site,
              and Treatment DMIS ID (DMIS Name, Parent DMIS ID, Parent DMIS Name,
              DMIS Command, DMIS Military Service and DMIS Region). These objects will be
              provided in M2 via a join to the “DMIS Table” feed (from the MDR’s Master
              Hierarchical Table, sometimes called “DMISID Index”), linking by the FY and
              DMIS ID objects. Any records with a blank DMIS ID will be transmitted from the
              MDR with a DMIS ID “NONE”.
             M2 will derive the following PPS fields for FY05 and forward:
               PPS Market Value: PPS RVU Market Value x non-facility RVU field (hide).
               PPS Earnings: PPS Market Value x PPS Earnings Factor (hide).
               PPS RVU Market Value: From merge to DMIS ID table, by treatment DMIS ID,
                  FY, and FM, and RVU value field (hide).
             Processing CY is set equal to the string defined by the first four characters of the
              service date.
             Processing CM is set equal to the string defined by the 5 th and 6th characters of
              the service date.



   Version 1.02.01                   M2 Radiology Ancillary - 3                      27 May 2011
                      Age Group Common is derived from age using the rules defined below.
                      The feed will be merged to the M2 Reservist table to add reservist status code
                       and special operations code.
                      Ordering MEPRS3, MEPRS2 and MEPRS1 clinic will be derived from the Ordering
                       MEPRS4 clinic sent from the MDR.

                  File Layout and Transformation Rules to Prepare the Feed to go to M2

                                     Type and                 MDR
 M2 Element Name &
                                      length                Element                  Comment or Transformation
 Label
                                     Indicator1             Name(s)
Record ID                                 $6           M2key             No transformation. This element will be the first
                                                                         element in the M2 feed.
ACV                                       $1           acv               No transformation. Note: ACV from LVM4 merge is
                                                                         replacing ACV1.
Age                                        3           patage            No transformation.

Beneficiary Category                      $3           bencat            No transformation.

Ben Cat Common                            $1           comben            No transformation.

Beneficiary Zip Code                      $5           patzip            No transformation.

Date of Birth                         yyyymmdd         dob               No transformation.

Diagnosis 1                               $6           dx1               No transformation. --- Hide

Diagnosis 2                               $6           dx2               No transformation. --- Hide

Diagnosis 3                               $6           dx3               No transformation. --- Hide

Diagnosis 4                               $6           dx4               No transformation. --- Hide

Enrollment Site                           $4           enrdmis           No transformation.

External Indicator                        $1           external          No transformation.

FMP                                       $2           fmp               No transformation.

Full Cost                                 8.2          fullcost          No transformation.

FY                                        $4           fy                Derived from Service Date.

FM                                        $2           fm                Derived from Service Date.

Gender                                    $1           sex               No transformation.

Inpatient Indicator                       $1           inpt              No transformation.

Privilege Code                            $1           privcode          No transformation.

Medicare Eligibility                      $1           Medelg            No transformation.

Number of Services                         2           drvcount          No transformation.

Ordering Site of Record                   $4           orddmis           No transformation.

MEPRS4 Code, Ordering                     $4           meprscd           No transformation.



       1
         A $ sign indicates a character variable; the absence of a dollar sign is a numeric variable. All numbers include
       decimals in the feed if not integers. The format is the total length in the first integer, with the number of decimal
       places in the feed following the decimal. Hence, format “6.2” allows for a number as big as “999.99”.



       Version 1.02.01                           M2 Radiology Ancillary - 4                                27 May 2011
                               Type and           MDR
 M2 Element Name &
                                length          Element                Comment or Transformation
 Label
                               Indicator1       Name(s)
Other Insurance                   $1          ohi            No transformation.

PCM ID                            $18         pcmid          No transformation.

Person ID                         $10         edipn          No transformation.

PPS Earnings Factor               5.3         ppsfac         No transformation.---Hide

Procedure Code                    $5          cpt            No transformation.

Procedure Code Modifier 1         $2          cptmod         No transformation.

Procedure Code Modifier 2         $2          mod            No transformation.

Related Record ID               $12 $10       apptno,prn     No transformation.
Appointment Record ID                         apptno         If inpt=”Y”, this is the prn, else it is the apptno
                                                             (trimmed to 10 characters), and which may be
                                                             empty. Remove leading and trailing blanks.
Relationship to Sponsor           $1          rel            No transformation.

RVU, Facility                     6.2         fprvu          No transformation.

RVU, Non-Facility                 6.2         nprvu          No transformation.

RVU, Total                        6.2         rvu            No transformation.

RVU, Work                         6.2         rvuwork        No transformation.

Space Available Flag              $1          spaflag        No transformation.

Service Date                   yyyymmdd       servdate       No transformation.

Sponsor ID                        $9          sponssn        No transformation.

Sponsor Service                   $1          svc            No transformation.

Sponsor Service, Aggregate        $1          svcagg         No transformation.

Tmt DMIS ID                       $4          tmtdmis        No transformation.

Variable Cost                     8.2         varcost        No transformation.

Number of Services of Record       2          count          No transformation

Underwritten Region               $1          Undflag        No transformation

Person Association Reason         $2          PARC           No transformation
Code
HCDP Code                         $3          hcdplvm4       No transformation

Exam Number                       $17         accessno       No transformation

TPR Eligibility Flag              $1          TPRelig        No transformation

Inpatient Record ID               $7          prn            Remove leading and trailing blanks.

   The following M2 elements are appended/calculated in M2 processing (are not part of the feed from
                                               MDR).




       Version 1.02.01                    M2 Radiology Ancillary - 5                         27 May 2011
                              Type and           MDR
 M2 Element Name &
                               length          Element                Comment or Transformation
 Label
                              Indicator1       Name(s)
ACV Group                         $                         If ACV = A, E, H, or J then “Prime”
                                                            Else if ACV = B or F then “Overseas Remote”
                                                            Else if ACV = G or L then “Plus”
                                                            Else if ACV = U then “Desig Prov”
                                                            Else if ACV = M or Q then “Reliant”
                                                            Else if ACV is any other value
                                                                (including blanks) and Ben Cat
                                                                Common = 4 then “Reliant”
                                                            Else “Other”
Age Group Common                 $1          patage         A = 0-4         G = 45-64
                                                            B = 5-14        H = 65-69
                                                            C = 15-17       I = 70-74
                                                            D = 18-24       J = 75-79
                                                            E = 25-34       K = 80-84
                                                            F = 35-44      L = 85+
Beneficiary Region               $2                         Join to the Market Table by FY, FM, Beneficiary Zip
                                                            Code, and Sponsor Service.
Beneficiary HSSC Region          $1                         Join to the Market Table by FY, FM, Beneficiary Zip
                                                            Code, and Sponsor Service.
Beneficiary Last Name            $26                        Join to MPI Table on upid

Beneficiary First Name           $20                        Join to MPI Table on upid

Beneficiary Name                 $70                        Join to MPI Table on upid displayed as LAST,
                                                            FIRST, MIDDLE, CADENCY
Case Management Acuity                                      Join to Case Management table. See the Case
                               Char(1)
Level                                                       Management Specification.
                                                            Join to Case Management table. See the Case
Case Manager ID 1              Char(14)
                                                            Management Specification.
                                                            Join to Case Management table. See the Case
Case Manager ID 2              Char(14)
                                                            Management Specification.
                                                            Join to Case Management table. See the Case
Case Manager ID 3              Char(14)
                                                            Management Specification.
                                                            Join to Case Management table. See the Case
Case Management DMIS ID        Char(4)
                                                            Management Specification.
Catchment Area Command           $6                         Join to the DMIS Table by FY and Catchment Area
                                                            ID.
Catchment Area ID                $4                         Join to the Market Area Table by FY and
                                                            Beneficiary Zip Code.
Catchment Area Military          $1                         Join to the DMIS Table by FY and Catchment Area
Service                                                     ID.
Catchment Area MSMA              $3                         Join to the DMIS Table by FY and Catchment Area
                                                            ID.
Catchment Area Name              $40                        Join to the DMIS Table by FY and Catchment Area
                                                            ID.
CM                               $2          servdate       Derived from Service Date.

CY                               $4          servdate       Derived from Service Date.

Enrollment Site Command          $6                         Join to the DMIS Table by FY and Enrollment Site.

Enrollment Site DHP Code         $1                         Join to the DMIS Table by FY and Enrollment Site.
Enrollment Site HSSC Region      $1                         Join to the DMIS Table by FY and Enrollment Site.




       Version 1.02.01                   M2 Radiology Ancillary - 6                       27 May 2011
                                      Type and              MDR
 M2 Element Name &
                                       length             Element                Comment or Transformation
 Label
                                      Indicator1          Name(s)
Enrollment Site Military                     $1                        Join to the DMIS Table by FY and Enrollment Site.
Service
Enrollment Site MSMA                         $3                        Join to the DMIS Table by FY and Enrollment Site.

Enrollment Site Name                         $40                       Join to the DMIS Table by FY and Enrollment Site.

Enrollment Site Parent                       $4                        Join to the DMIS Table by FY and Enrollment Site.

Enrollment Site Parent Name                  $40                       Join to the DMIS Table by FY and Enrollment Site
                                                                       Parent.
Enrollment Site Region                       $2                        Join to the DMIS Table by FY and Enrollment Site.

Ever Deployed Flag (OCO)                                               Join to Contingency Tracking table. See the
                                        Char(1)
(OCO formerly GWOT)                                                    Contingency Tracking System Specification.
Days Since Most Recent OCO                                             Join to Contingency Tracking. See the Contingency
Deployment                                   N(5)                      Tracking System Specification.
(OCO formerly GWOT)
Days Since Return from OCO                                             Join to Contingency Tracking. See the Contingency
Depl                                    Char(5)                        Tracking System Specification.
(OCO formerly GWOT)
Cumulative OCO Days                                                    Join to Contingency Tracking table. See the
Deployed                                Char(5)                        Contingency Tracking System Specification.
(OCO formerly GWOT)
OCO Deployed Flag                                                      Join to Contingency Tracking table. See the
                                        Char(1)
(OCO formerly GWOT)                                                    Contingency Tracking System Specification.
IIW Flag2                               Char(1)                        Join to IIW table.See the IIW Specification.

Geo Concepts (2-8)                           $3                        Join to Market Table.
                                                                       (Hide)
Market Area ID                               $4                        Join to the Market Table by FY, FM, Beneficiary Zip
                                                                       Code, and Sponsor Service.
MTF Service Area                             $4                        Join to the Market Table by FY, FM, Beneficiary Zip
                                                                       Code, and Sponsor Service.
MTF Service Area Name                        $40                       Join to the Market Table by FY, FM, Beneficiary Zip
                                                                       Code, and Sponsor Service.
Number of Records                             9                        Count of Record ID.

Ordering Site   of Record                    $6                        Join to the DMIS Table by FY and Ordering Site.
Command
Ordering Site   of Record DHP                                          Join to the DMIS Table by FY and Ordering Site of
                                             $1
Code                                                                   Record.
Ordering Site   of Record HSSC               $1                        Join to the DMIS Table by FY and Ordering Site of
Region                                                                 Record.
Ordering Site   of Record Mil                $1                        Join to the DMIS Table by FY and Ordering Site of
Svc                                                                    Record.
Ordering Site    of Record                   $3                        Join to the DMIS Table by FY and Ordering Site of
MSMA                                                                   Record.
Ordering Site   of Record Name               $40                       Join to the DMIS Table by FY and Ordering Site of
                                                                       Record.
Ordering Site of Record                      $2                        Join to the DMIS Table by FY and Ordering Site of
Region                                                                 Record.
MEPRS3 Code, Ordering                        $3         meprscd        MEPRS4 Code, Ordering is trimmed to 3rd level.



       2
           IIW = Injured, Ill, and Wounded



       Version 1.02.01                              M2 Radiology Ancillary - 7                       27 May 2011
                               Type and          MDR
 M2 Element Name &
                                length         Element                Comment or Transformation
 Label
                               Indicator1      Name(s)
MEPRS2 Code, Ordering             $2         meprscd        MEPRS4 Code, Ordering is trimmed to 2nd level.

MEPRS1 Code, Ordering             $1         meprscd        MEPRS4 Code, Ordering is trimmed to 1st level.

PPS Earnings                      10.2                      PPS Market Value x PPS Earnings Factor---Hide.

PPS Market Value                  10.2                      PPS RVU Market Value x non-facility RVU field---
                                                            Hide.
PPS RVU Market Value              8.2        PPS Rad RVU    From merge to DMIS ID table, by Tmt DMIS ID
                                             Market Value   and FY---Hide.
Prime Service Area                $1                        Join to the Market Table by FY, FM, Beneficiary Zip
                                                            Code, and Sponsor Service.
PRISM Area Command                $6                        Join to the DMIS Table by FY and PRISM Area ID.

PRISM Area ID                     $4                        Join to the Market Table by FY, FM, Beneficiary Zip
                                                            Code, and Sponsor Service.
PRISM Area Military Service       $1                        Join to the DMIS Table by FY and PRISM Area ID.

PRISM Area MSMA                   $3                        Join to the DMIS Table by FY and PRISM Area ID.

PRISM Area Name                   $40                       Join to the DMIS Table by FY and PRISM Area ID.


Pseudo Sponsor ID                 $9                        Scrambling algorithm applied to Sponsor ID.

Special HCDP Code                 $3                        Join to the Special HCDP table by Service Date.

Reservist Status Code             $1                        Join to Reservist Table by Sponsor SSN and
                                                            Service Date.
Special Operations Code           $2                        Join to Reservist Table by Sponsor SSN and
                                                            Service Date.
Tmt DMIS ID Command               $6                        Join to the DMIS Table by FY and Tmt DMIS ID.

Tmt DMIS ID DHP Code              $1                        Join to the DMIS Table by FY and Tmt DMIS ID.
Tmt DMIS ID HSSC Region           $1                        Join to the DMIS Table by FY and Tmt DMIS ID.

Tmt DMIS ID Military Service      $1                        Join to the DMIS Table by FY and Tmt DMIS ID.

Tmt DMIS ID MSMA                  $3                        Join to the DMIS Table by FY and Tmt DMIS ID.

Tmt DMIS ID Name                  $40                       Join to the DMIS Table by FY and Tmt DMIS ID.

Tmt Parent DMIS ID                $4                        Join to the DMIS Table by FY and Tmt DMIS ID.

Tmt Parent DMIS ID Name           $40                       Join to the DMIS Table by FY and Tmt DMIS
                                                            Parent.
Tmt DMIS ID Region                $2                        Join to the DMIS Table by FY and Tmt DMIS ID.

TPR Flag                          $1                        Join to the Market Area Table by FY, FM,
                                                            Beneficiary Zip Code, and Sponsor Service.




       Version 1.02.01                   M2 Radiology Ancillary - 8                       27 May 2011

								
To top