Key Activity: Review Medicaid Policies for Impacts of NPI Compliance (RFP 3.2.2.1)
Key Activity: Review Medicaid Policies for impacts of NPI compliance
Contractor Responsibilities:
-
Review Medicaid policies
-
Identify specific impacts of NPI on policies
-
Identify gaps within policies relative to NPI
Deliverables:
-
Create a matrix listing each Medicaid policy and the NPI impacts on each policy
-
Create a report identifying any gaps in the Medicaid policies relative to NPI
Performance Measures:
-
Deliverables will be due based on dates in the Department approved work plan
Key Activities
The IME has done significant work as a result of implementing MITA principles in the enterprise. IME’s business process model addresses IME operational procedures manuals, which will aide in FOX’s assessment in the development of the matrix which lists each Medicaid policy and the NPI impact on that policy. Because DHS is the single State agency responsible for the administration of the Iowa Medicaid program, and the responsibilities are dispersed within several Divisions, policies related to these Divisions will be reviewed for NPI impact. Policies will also be reviewed for NPI impacts related to the MMIS vendors and system/application interfaces between the many partners in IME. In addition, IME may want take into consideration the Medicaid policies that deal with select Medicaid-related contractors, such as the Iowa Foundation for Medical Care (IFMC), who provides prior authorization for transplantation and other medical procedures, and conducts long-term care facility utilization and quality reviews, and supports the SURS member analysis functions. There may be NPI impacts relative to the use of the 278 prior authorization and referral transaction and reports generated by the Fiscal Agent to IFMC containing monthly paid claims files to support its research and analysis.
Contractor Responsibilities
FOX has extensive experience in reviewing policies and conducting gap analyses. The FOX team will review Medicaid policies, identify specific impacts of the NPI on those policies, and identify gaps within the policies relative to the NPI.
Deliverables
FOX will create a matrix listing each Medicaid policy and the NPI impacts on each for the following:
-
Financial, Health and Work Supports divisions
-
Data Management division
-
Medical Services division
-
Fiscal Management division
-
Other policies as identified by IME as having Medicaid-related NPI impacts
FOX also will develop a Gap Analysis Report that identifies any gaps in the Medicaid policies relative to NPI.
Performance Measures
These deliverables will be submitted in accordance with the dates in the Department approved work plan.
Key Activity: Identify and Review Medicaid Systems for Impacts of NPI compliance (Attachment 8) (RFP 3.2.2.2)
Key Activity: Identify and review Medicaid Systems for impacts of NPI compliance (Attachment 8). Systems include:
-
Medicaid Management Information System (MMIS)
-
Title XIX Eligibility System (TXIX)
-
Medicare Buy-in System
-
Individualized Services Information System (ISIS)
-
Iowa Automated Benefits Calculator System (IABC)
-
IME Eligibility Verification System (ELVS)
-
Dakota Imaging System
-
IME Web Portal
-
Medicaid Quality Utilization Improvement Data System (MQUIDS)
-
Medicaid Data Warehouse
-
OnBase Workflow Process Management System
Contractor Responsibilities:
-
Review Medicaid systems and validate completeness of identified systems
-
Validate most recent version of MMIS business rules
-
Complete list of systems as necessary
-
Identify specific impacts of NPI to systems at code level
-
Identify gaps within systems relative to NPI at code level
Deliverables:
-
Create a matrix listing each Medicaid system and the NPI impacts to that system
-
Create a report identifying any gaps in the Medicaid systems relative to NPI
Performance Measures:
-
Deliverables will be due based on dates in the Department approved work plan
Key Activities
FOX recognizes that IME has gone to great length to begin the journey toward “MITA-sizing” the IME in configuring the technical environment according to business needs for operational efficiency, and using flexible, adaptable modularity. FOX will undoubtedly find the IME’s MITA self assessment helpful in examining the documentation of the various Medicaid Systems for impacts of NPI compliance. FOX will review each system, validate its completeness, and validate the most recent version of the MMIS business rules. Specific impacts of NPI to each system, as well as gaps within each system, will be identified at the code level.
Figure 8: Health Plan Impact Assessment Methodology
The Inventory Systems Survey determines all of the systems in use at IME by having each subsystem owner complete the survey. For IME, NPI will impact the MMIS, TXIX, Medicare Buy-in System, ISIS, IABC, ELVS, Dakota Imaging System, IME Web Portal, MQUIDS, Medicaid Data Warehouse, and OnBase Workflow Process Management System. FOX then compiles the surveys into a single spreadsheet that populates the NPI Inventory Report. Care must be taken to ensure that IME identifies all of the systems/applications that are applicable to provider identification, including those that are small, homegrown, or specific use only. This inventory may have been completed to comply with Security provisions of HIPAA, but if not, this is a critical opportunity. Excessive use of non-traditional systems/applications may present business process re-engineering opportunities. Once the Inventory Systems Survey is completed, it is necessary for FOX systems to collaborate with IME staff to determine which of these identified systems are necessary to search for potential remediation.
Contractor Responsibilities
FOX understands that this key activity requires a review of Medicaid systems, including a validation of the completeness of identified systems, a validation of the most recent version of MMIS business rules, the compilation of systems as necessary, and identification of specific impacts of NPI to the systems at the code level, as well as a gap analysis within the systems relative to NPI at the code level.
FOX may advise that all systems should be searched; however, the IME staff may determine that some do not require search or remediation, or they may determine to conduct this operation internally for some of the systems. The result of this process is an inventory of essential systems/applications determined by the IME staff to be part of the scope of the engagement.
An example of what an inventory might look like for an MMIS system is found in the figure below:
Figure 9: Sample of System Inventory Results Survey for MMIS
Program: Name:
Email: Phone:
System
|
Sub-system
|
Title
|
Responsible person
|
Type
|
Language
|
Count of programs
|
MMIS
|
SURS
|
Surveillance and Utilization Review
|
SURS SME
|
PROG
|
COBOL
|
125
|
|
|
|
|
COPY
|
COBOL
|
34
|
|
|
|
|
JCL
|
|
54
|
|
|
|
|
EZT
|
|
67
|
|
|
|
|
SYSIN
|
|
76
|
|
|
|
|
PROG
|
JAVA
|
22
|
MMIS
|
MARS
|
MARS – Reporting subsystem
|
MARS SME
|
PROG
|
COBOL
|
76
|
|
|
|
|
COPY
|
COBOL
|
12
|
|
|
|
|
JCL
|
|
18
|
|
|
|
|
SYSIN
|
|
10
|
|
|
|
|
PROG
|
JAVA
|
09
|
MMIS
|
CLAIMFE
|
Claims - Front-end editing
|
Claims IT Manager / Claims SME
|
PROG
|
COBOL
|
42
|
|
|
|
|
COPY
|
COBOL
|
08
|
|
|
|
|
JCL
|
|
12
|
|
|
|
|
EZT
|
|
06
|
|
|
|
|
SYSIN
|
|
06
|
MMIS
|
CLAIMAU
|
Claims – Auditing
|
Claims IT Manager / Claims SME
|
PROG
|
COBOL
|
31
|
|
|
|
|
COPY
|
COBOL
|
09
|
|
|
|
|
JCL
|
|
11
|
|
|
|
|
EZT
|
|
08
|
|
|
|
|
SYSIN
|
|
04
|
MMIS
|
CLAIMFN
|
Claims - Financial
|
Claims IT Manager / Claims SME
|
PROG
|
COBOL
|
31
|
|
|
|
|
JCL
|
|
11
|
|
|
|
|
EZT
|
|
08
|
|
|
|
|
SYSIN
|
|
04
|
MMIS
|
PROV
|
Provider Subsystem
|
Provider SME
|
PROG
|
COBOL
|
15
|
|
|
|
|
PROG
|
JAVA
|
25
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The systems and applications identified as impacted by NPI must be defined further by the use of the Application Survey. This survey is completed by the individual responsible for the named system or application, or during interviews with these people. It determines the platform for the system, the uses of the system, the use of historical data, and the existence of interfaces or Commercial Off The Shelf (COTS) products involved with the system/application. The last few questions of the application survey are intended to prompt the IME staff regarding potential new issues soon to confront IME, such as alignment with the Medicaid Information Technology Architecture (MITA) vision and strategic planning, as well as compliance efforts related to the potential mandates of the National Plan Identifier, ICD-10, or Claims Attachments. While none of these new issues are required at this point, IME must plan for their arrival and may choose to address certain key issues while they conduct their NPI Impact process. There is one survey for each application that the IME staff and FOX identify as needing in-depth review from the System Inventory. A very brief example of the Application Survey is provided on the following page.
Figure 10: Application Survey Sample
General
2. What is the status of this application?
(a) The application is slated to be ELIMINATED before May 27, 2007
(b) The application will be REPLACED with a new package or re- written before May 27, 2007
(c) The application is critical and must be prioritized for NPI remediation
2.1. If (b) or (c), what Platform (e.g. Mainframe/Client-Server) and Programming Language (e.g. COBOL/390/C++/Java) are used in this application?
____________________________________________________________
____________________________________________________________
2.2. Is this application a COTS product? YES NO
2.2.1 What is the COTS product? ___________________________________
2.3 Are there any COTS products integrated into this application?
YES NO
2.3.1 What is the COTS product? ___________________________________
3. If this application is a COTS product, is the source code available for all programs in the application? YES NO
Processing Logic
1. Does this application currently handle the processing of HIPAA Transactions?
YES NO
2. Does the application execute a SORT on the Provider ID field(s)?
YES NO
2.1. If YES, is the SORT internal to the programs or an External Process step? Internal External
2.1.1. If External, what SORT package is used? _______________________
3. Are there any special processing that is done by the application based on any portion of the Provider ID field? YES NO
3.1. If YES, describe:
__________________________________________________________________ __________________________________________________________________
The results of the Inventory Systems Survey and Application Survey are compiled into the FOX NPI Inventory report listing the systems and subsystems considered as part of the scope of the project and the specifics of the systems. This information will go into the Matrix and Gap Report as fulfillment of the deliverables for this Key Activity. The text of the report may indicate some descriptions of the systems represented and begins a look at the breadth and complexity of the issue. This report also depicts the impending new requirements and IME’s preparedness to address those issues.
The Inventory Report may be represented graphically, as depicted in the figure below, or in tabular format as depicted in the sample Inventory Report on the following page.
Figure 11: System by Component and Count
Figure 12: NPI Inventory Report
|
COMPONENT TYPE & COUNT
|
OTHER INFO
|
OTHER IMPENDING ISSUES
|
SUB-SYSTEM
|
COBOL
|
COPY-BOOK
|
JCL
|
EZT
|
SYSIN
|
TOTAL
|
Any COTS Prod integrated?
|
Process Hx Data?
|
Use of Partial PROV ID?
|
Use of Hardcoded PROV ID?
|
MITA?
|
PART-D?
|
ICD-10?
|
Health Plan ID?
|
Claim Attac?
|
CLM
|
454
|
54
|
54
|
67
|
54
|
683
|
Y
|
Y
|
Y
|
Y
|
N
|
N
|
N
|
N
|
N
|
SUR
|
125
|
34
|
54
|
67
|
76
|
356
|
N
|
Y
|
N
|
N
|
N
|
N
|
N
|
N
|
N
|
PROV
|
243
|
32
|
22
|
19
|
17
|
333
|
N
|
Y
|
Y
|
Y
|
N
|
N
|
N
|
N
|
N
|
MISCELLANEOUS
|
79
|
54
|
2
|
54
|
87
|
276
|
N
|
N
|
N
|
N
|
N
|
N
|
N
|
N
|
N
|
TOTAL
|
901
|
174
|
132
|
207
|
234
|
1648
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
NOTE:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This is just a Sample Report
|
|
|
|
|
|
|
|
|
The numbers are not real and the component types are not limited to those listed here.
|
|
|
|
|
|
|
|
After completion of the Systems Inventory Survey and the Application Survey, a more intense search is conducted.
Data Dictionary
The data dictionary is critical to locating all iterations of the provider number within all of the systems identified by IME. Preliminary work on determining the identification of provider number indicates that many systems use many forms of the provider locator. Some examples include: provider number, prov no, prov num, prov id, phys no, etc. Each search of systems will encounter some new versions which will be added to the IP (Intellectual Property). IME system subject matter experts will also have ideas of how the concept of provider identifier is displayed within their systems. The data dictionary may vary from IME Division to IME Division. The best places to start collecting the keywords are:
-
Learn the naming standards (if any) used at the IME site. From this document, FOX consultant would be able to know how the IME system uses the terms ‘Provider’, ‘Identification’, ‘Number’ etc. This would help FOX to identify all the potential key words and build our Data dictionary for the system search/scan. If there is no naming standards at the IME site, FOX will rely on the next option.
-
Some of the key copybooks/record layouts – Refer the Provider Master file copybook/layout, Claims activity file copybook/layout etc. This gives the basic information to identify the potential keywords.
-
IME site Data Dictionary(ies) – IME site Data Dictionaries provides all the details (like filed name, size, level, data type etc). Once the potential keywords are collected from the key copybooks, refer the appropriate Data Dictionary to confirm the keywords.
Based upon the IP from FOX and the interviews with the various IME staff, a Data Dictionary is developed for use to search the IME systems/applications for instances of ‘Provider Identifiers’. Using automated search tools, each system/application is searched for all occurrences of provider identifiers. This search may need to occur several times in order to capture all of the modifications and nuances of the IME system’s coding of provider identifiers. Concurrently, FOX conducts a manual search of the Copy Books to determine how occurrences of provider identifiers have been altered over time or migrated to other systems. Any new iterations of ‘provider identifier’ are added to the Data Dictionary for use in scanning systems and will be considered part of the intellectual property for this project
Table 2: Partial Sample Data Dictionary
010-CNTLD010-RECORD
|
040-CNTLD010-FOOTER
|
13-BYTES-IN
|
13-BYTES-OUT
|
16-BYTES-IN
|
16-BYTES-OUT
|
220-CPO51-DETAIL
|
ACT-CCIC-DATA
|
ACT-COMMON-DATA
|
ACT-DENTAL-DATA
|
ACT-HOSPITAL-DATA
|
ACT-PHARMACY-DATA
|
ACT-PROF-SERV-DATA
|
ACT-XOVER-DATA
|
ADMIN-DATA-REC-77-A
|
ADMIT-PHYS
|
ASSIGNED-PROVIDER-SEGMENT
|
ATNDG-PHYS
|
ATTENDING-PHYS
|
ATTEND-PHYS
|
BILL-PROV-1-5
|
BILL-PROV-6-10
|
BLUE-SHD-NUM
|
CHAMP-NUM
| Use the Data Dictionary to Search Applications
The search/scan tool is one of the most important tools to assess the NPI Impact. Using the Data Dictionary developed so far, the initial search of the systems/applications is conducted using an automated search tool. Each system may need to be searched more than one time, since each search will produce more variations on the provider number concept. The system/application search will determine the systems impacted, the number of data names impacted, and the lines of code impacted by provider number.
FOX then examines the impacted codes listed by the search tool and verifies whether the data has been moved TO or FROM the keyword to some other keywords. Those words are also included in the Data dictionary (e.g. MOVE WS-HOLD-PROV-NO TO PR-REFER-PROV. Here, include PROV-NO as well as REFER-PROV to the Data dictionary).
FOX assures that the keyword contains enough characters to uniquely identify the Legacy Provider ID (e.g.: If we use just PROV, the search tool might extract PROV-NAME or PROV-ADDR1 or DATE-APPROVED). FOX uses a keyword like PROV-NO or PROV-NUM to extract Provider ID. There is no need to include all the different field names as keywords that contain a string to uniquely identify a key word (e.g. instead of listing WS-PROV-NO or A-PROV-NO or A-PAY-TO-PROV-NO, just include PROV-NO).
Alternatively, FOX may also utilize the following tools that are already at the IME site (options 1 thru 4 below) to scan all of the mainframe libraries:
-
TSO option 3.14 (or SuperSearch) -
-
search option in ‘Endeavor’
-
search option in ‘FileAid’
-
OWL
In addition, other options may be exercised using existing options at the IME site:
-
Write simple search tools using REXX/PERL/Shell Script/CLIST
-
Manual Scan of the programs (search inside each program).
-
GREP – one of the most powerful and useful commands in UNIX. Windows GREP is a tool for searching files on disks for occurrences of text strings that are specified.
-
COPERNIK - desktop search product, Copernic Desktop Search (CDS)
Manually Search the Copy Books for Processes that Reference Provider Identifiers
Manually searching the copy books for processes that reference various provider identifiers is labor intensive, but is necessary to ascertain whether the provider identifiers have migrated to different locations under different names. This process may also determine the interrelatedness of various systems. One system may seek information regarding providers from another system, but may reference the identifier differently. Similarly, one system may transfer data to another system using terms not previously located in the data dictionary. The result of this process will be details of processes affected by provider identifiers.
FOX also searches the copybooks for ‘Redefine’d field names. It is a common to practice to initially define a field name or set of field names, and in the following line ‘Redefine’ the initially defined fields and use it to store some other data. If the Provider ID field was expanded, then FOX searches whether those fields were redefined in a later version of a previous line. If so, then FOX expands the redefined fields accordingly.
In addition, rather than listing the Provider Id fields alone, FOX documents the record name defined in the copybook (that uses Provider Identifier). In certain cases, instead of writing commands to move fields one by one, sometimes the program moves all the fields at once by moving the entire record. Again, if FOX decided to expand the Provider Id field, and the program moves the record, FOX documents the record name(s) that receives data and make to sure to expand that record too.
Based on the gathered information through ‘Application Inventory’ and ‘Application Survey’ and system search/scan, FOX prepares the following reports:
-
'Impact - Hi-lvl' tab of the 'NPI Inventory Report' spread sheet. This report shows the total number of various components in each sub-system as well as the number of impacted components and lines.
-
NPI Processes Impacted - This gives more details about the each component under each sub-system. Since it takes lot of time to list the component name plus description, we need to decide whether to include this as a deliverable or not.
-
'NPI - Scan list' - This is the list of all the components plus the impacted line of source codes.
NPI Impact Analysis
All systems identified by IME will be scanned using the Data Dictionary and search tools that are part of the FOX resources. The IME will be provided the full scope of the scan conducted, and will be included in the NPI Impact Analysis. This analysis indicates the number of systems impacted by provider identifier issues as well as the number of lines of code contained in those systems and the number of lines of code impacted by provider identifier. This analysis establishes the depth of the problem and supports recommendations for the resources required to remediate the problem. The NPI Impact Analysis will be represented in tabular and graphic format and will be presented to the IME as a prelude to recommendations for remediation.
Table 3: Sample NPI Impact Summary
System/
Sub-system
|
Description
|
Total # components
|
# of Impacted components
|
% of Impacted components
|
Total # of lines
|
Total # of impacted lines
|
% of Impacted lines
|
CLM
|
Claims
|
223
|
201
|
90%
|
35756
|
24387
|
68%
|
SUR
|
SURS
|
100
|
75
|
75%
|
13567
|
9987
|
74%
|
PROV
|
Provider
|
56
|
48
|
86%
|
15234
|
12543
|
82%
|
RECIP
|
Recipient
|
100
|
7
|
7%
|
23453
|
2345
|
10%
|
ELIG
|
Eligibility
|
89
|
76
|
85%
|
12345
|
9876
|
80%
|
MARS
|
MARS
|
75
|
65
|
87%
|
21234
|
16543
|
78%
|
TOTALS
|
643
|
472
|
73%
|
121589
|
75681
|
62%
|
|
|
|
|
|
|
|
|
NOTE:
|
|
|
|
|
|
|
|
This is just a Sample Report
|
The numbers are not real and the sub-system names are not limited to those listed here.
|
|
|
|
Figure 13: Sample Impact by Subsystem Graph - Number of Lines
Deliverables
FOX will develop a matrix listing each Medicaid system and the NPI impacts to that system. In addition, FOX will create a report that identifies any gaps in the Medicaid systems relative to NPI.
Performance Measures
These deliverables will be submitted in accordance to the Department approved work plan.
The next section describes the remainder of the systems review methodology. FOX’s methodology for system review encompasses both system review as well as the inclusion of interface review.
|