IHS RPMS Dictionaries (Patient) (AUPN)

RESOURCE AND PATIENT MANAGEMENT SYSTEMIHS RPMS Dictionaries (Patient)(AUPN)Technical ManualVersion 99.1March 1999Division of Information ResourceAlbuquerque, New Mexico(505) 248-4371

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.1Table of Contents1.0Introduction. 12.0Implementation and Maintenance . 22.1General Information . 22.2System Requirements . 23.0Routine Descriptions . 33.1Callable Routines/Functions . 33.1.1 Routine - AUPNPAT . 33.1.2 Routine - AUPNPAT1 . 73.2Routines with Description . 84.0Files . 104.1File List . 104.2FILE: MEDICARE ELIGIBLE . 144.3FILE: MEDICARE CLAIMS . 144.4File: POLICY HOLDER . 154.5FILE: MEDICAID ELIGIBLE . 164.6File: MEDICAID CLAIMS . 164.7File: RAILROAD ELIGIBLE . 174.8FILE: RAILROAD CLAIMS . 184.9FILE: PRIVATE INSURANCE ELIGIBLE . 184.10FILE: PRIVATE INSURANCE CLAIMS . 194.11FILE: SCHEDULED ENCOUNTER . 204.12FILE: SURVEILLANCE . 204.13FILE: CLINICAL REMINDER . 214.14FILE: VISIT . 214.15FILE: V MEASUREMENT . 234.16FILE: V HOSPITALIZATION . 244.17FILE: V CHS . 254.18FILE: V EYE GLASS . 264.19FILE: V DENTAL. 274.20FILE: V PROVIDER . 284.21FILE: V POV . 294.22FILE: V PROCEDURE . 314.23FILE: V LAB . 324.24FILE: V IMMUNIZATION . 334.25FILE: V SKIN TEST . 344.26FILE: V EXAM. 354.27FILE: V MEDICATION . 364.28FILE: V TREATMENT . 374.29FILE: V PATIENT ED. 374.30FILE: V PHYSICAL THERAPY . 38Technical ManualMarch 1999Table of Contentsii

IHS RPMS Dictionaries (Patient) 544.554.564.574.584.59Version 99.1FILE: V CPT . 39FILE: V ACTIVITY TIME . 40FILE: V DIAGNOSTIC PROCEDURE RESULT . 41FILE: V RADIOLOGY . 41FILE: V HEALTH FACTORS . 42FILE: V PATHOLOGY . 43FILE: V MICROBIOLOGY . 44FILE: V NOTE . 45FILE: V EMERGENCY VISIT RECORD . 46FILE: V BLOOD BANK . 474.41 FILE: V PHN . 48FILE: V TRANSACTION CODES . 48FILE: V NARRATIVE TEXT . 49FILE: V VA MOBILE VISIT RELATED . 49FILE: V VA MOBILE VISIT TYPES . 50FILE: V VA MOBILE PRES ACTIONS . 50FILE: V VA MOBILE REFER FOR OUTPATIENT . 51FILE: V VA MOBILE SPECIALTY OF REFER . 51FILE: V VA MOBILE EXAMS ORDERED . 51FILE: V LINE ITEM (GOODS&SERVICES) . 52FILE: PROBLEM. 53FILE: OFFSPRING HISTORY . 54FILE: PERSONAL HISTORY . 55FILE: FAMILY HISTORY . 55FILE: *UNMET SURGICAL NEED . 56FILE: *HISTORY OF PROCEDURES . 56FILE: REPRODUCTIVE FACTORS. 56FILE: HEALTH STATUS . 57FILE: PT LAB RELATED DATA . 575.0Cross-References . 596.0Exported Options . 847.0Menu Diagram . 858.0Arching and Purging . 869.0External Relations . 8710.0Internal Relations . 9211.0How to Generate On-Line Documentation. 9311.1%INDEX . 9311.2Inquire Options . 9411.3Print Option File . 9411.3.1 List File Attributes . 9412.0SAC Requirements and Exemptions . 96Technical ManualMarch 1999Table of Contentsiii

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.1Glossary . 97Contact Information . 100Technical ManualMarch 1999Table of Contentsiv

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.1PrefaceThe AUPN Package contains all dictionaries that comprise the ‘clinical repository’ orPatient Care Component (PCC). The dictionaries in this package are the primary filesin which patient medical and registration data is housed. This package also containsvarious utilities and routines called from these dictionaries.This manual contains the technical documentation for the IHS DICTIONARIES(AUPN) package, V. 99.1. Included here are a system description, routinedescriptions, option descriptions, and a variety of other information necessary for useby IRM personnel to operate and maintain the PCC IHS Patient Medical Dictionariessoftware.Technical ManualMarch 1999Prefacev

IHS RPMS Dictionaries (Patient) (AUPN)1.0Version 99.1IntroductionThis package contains IHS Standard patient and medical dictionaries. It also containsthe following utilities: IHS Patient Lookup AUPNPAT utility routines that contain many function calls for retrieving patientdata, Other utility routines called by these dictionaries.Technical ManualMarch 1999Introduction1

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.12.0Implementation and Maintenance2.1General InformationThe AUPN package occupies the AUPN namespace. There are only data dictionariesand routines distributed with this package. There are no templates, options, or forms.This package is distributed in conjunction with V. 2.0 of PCC Data Entry. The twopackages must be installed together and should not be installed one without the other.2.2System Requirements Kernel V. 8.0 or higher FileMan V. 21 or higher PCC Data Entry V. 2.0Technical ManualMarch 1999Implementation and Maintenance2

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.13.0Routine Descriptions3.1Callable Routines/FunctionsThis package has many published entry points. They are described below:3.1.1Routine - AUPNPATData for the following function calls come from the PATIENT file, file 9000001, andfrom the Medicare Eligible, Medicaid Eligible, and Private Insurance Eligible files.SEX(p)Returns SEX of patient pargumentsp - patient ien (DFN)examplesW SEX AUPNPAT(234)DOB(p,f) FReturns DATE OF BIRTH of patient p in format fargumentsp - patient ien (DFN)f - optional format; if null, returns internal FileMan format of DOBE - external written-out format (MAR 05, 1995)examplesW DOB AUPNPAT(1234)W DOB AUPNPAT(1234,“E”)SSN(p) 2950305 MAR 05,1995Returns SSN of patientargumentsp - patient ien (DFN)examplesW SSN AUPNPAT(234) 123456789AGE(p,d,f) Returns AGE of patient p on date d in format fTechnical ManualMarch 1999Routine Descriptions3

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.1argumentsp - patient ien (DFN)d - optional date in internal FileMan format; if null, will default to DTf - optional format; if null, returns age in years null - age in yearsR - age in readable formatexamplesW AGE AUPNPAT(1234)W AGE AUPNPAT(1234,“R”)DOD(p,f) 32 32 YRSReturns DATE OF DEATH of patient p in format fargumentsp - patient ien (DFN)f - optional format; if null, returns internal FileMan format of DOD E - externalwritten-out format (MAR 05, 1995)examplesW DOD AUPNPAT(1234)W DOD AUPNPAT(1234,“E”) 2950305 MAR 05,1995TRIBE(p,f) Returns TRIBE OF MEMBERSHIP of patient p in format fargumentsp - patient ien (DFN)f - optional format; if null, returns tribe codeI - internal format of tribe (tribe ien)E - external written-out format of tribeC - tribe codeexamplesW TRIBE AUPNPAT(1234,“I”)W TRIBE AUPNPAT(1234,“E”)W TRIBE AUPNPAT(1234,“C”) 31 CHOCTAW NATION OF OK 031COMMRES(p,f) Returns COMMUNITY OF RESIDENCE of patient p in format fargumentsp - patient ien (DFN)f - optional format; if null, returns STCTYCOM COMMUNITY codeI - internal format of COMMUNITY (community ien)E - external written-out format of COMMUNITYC - STCTYCOM codeTechnical ManualMarch 1999Routine Descriptions4

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.1examplesW COMMRES AUPNPAT(1234,“I”)W COMMRES AUPNPAT(1234,“E”)W COMMRES AUPNPAT(1234,“C”) 31 PRINCESS BAY 0210019HRN(p,l,f) Returns HEALTH RECORD NUMBER of patient p at location l informat fargumentsp - patient ien (DFN)l - must be valid ien of locationf - optional, 2–HRN will have prefix of site abbreviationexamplesW HRN AUPNPAT(1234,4585)W HRN AUPNPAT(1234,4585,2) 3456 SE3456ELIGSTAT(p,f) Returns ELIGIBILITY STATUS of patient p in format fargumentsp - patient ien (DFN)f - optional format; if null, returns internal formatI - internal format of eligibility status (set of codes)E - external written-out format of eligibility statusexamplesW ELIGSTAT AUPNPAT(1234,“I”)W ELIGSTAT AUPNPAT(1234,“E”)BEN(p,f) D DIRECT ONLYReturns CLASSIFICATION/BENEFICIARY of patient p in format fargumentsp - patient ien (DFN)f - optional format; if null, returns classification/beneficiary codeI - internal format of classification/beneficiary (pointer value)E - external written-out format of classification/beneficiaryC - classification/beneficiary codeexamplesW BEN AUPNPAT(1234,“I”)W BEN AUPNPAT(1234,“E”)W BEN AUPNPAT(1234,“C”)Technical ManualMarch 1999 1 INDIAN/ALASKA NATIVE 01Routine Descriptions5

IHS RPMS Dictionaries (Patient) (AUPN)MCR(p,d)Version 99.1Returns 1 or 0: Is Patient p eligible for Medicare on date d?argumentsp - patient ien (DFN)d - required date in internal FileMan formatexamplesW MCR AUPNPAT(1234,2950601) 1Is patient 1234 eligible for Medicare on 6/1/95? yesPI(p,d)Returns 1 or 0: Is Patient p eligible for private insurance on date d?argumentsp - patient ien (DFN)d - required date in internal FileMan formatexamplesW PI AUPNPAT(1234,2950601) 1Is patient 1234 eligible for private insurance on 6/1/95? yesMCD(p,d)Returns 1 or 0: Is Patient p eligible for Medicaid on date d?argumentsp - patient ien (DFN)d - required date in internal FileMan formatexamplesW MCD AUPNPAT(1234,2950601)Is patient 1234 eligible for Medicaid on 6/1/95?MCDPN(p,d,f) 1 yesReturns Medicaid plan name for patient p on date d in format fargumentsp - patient ien (DFN)d - required date in internal FileMan formatf - format, optional; if null, returns internal ien of insurer IexamplesW MCDPN AUPNPAT(1234,2950601,“I”) 1W MCDPN AUPNPAT(1234,2950601,“E”) CARONDELETPIN(p,d,f)Returns private insurance plan name for patient p on date d in format fTechnical ManualMarch 1999Routine Descriptions6

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.1argumentsp - patient ien (DFN)d - required date in internal FileMan formatf - format, optional; if null, returns internal ien of insurerexamplesW PIN AUPNPAT(1234,2950601,“I”)W PIN AUPNPAT(1234,2950601,“E”) 1 BLUE CROSS/BLUE SHIELDCDEATH(p,f) Returns CAUSE OF DEATH of patient p in format fargumentsp - patient ien (DFN)f - optional format; if null, returns Cause of Death ICD9 codeI - internal format ICD9 ienE - external written-out format (ICD9 TEXT) C - ICD9 codeexamplesW CDEATH AUPNPAT(1234,“I”)W CDEATH AUPNPAT(1234,“E”)W CDEATH AUPNPAT(1234,“C”) 31 DIABETES MELLITUS 250.00ENC(p)Returns an encrypted patient identifier 12 bytes long. The entry-pointDEC reverses the process and returns the decoded output in a 27-byte-long string.argumentsp - patient ien (DFN)examplesW ENC AUPNPAT(1) V46332UMH763DEC(p)Reverses the process of ENC AUPNPAT and returns the decodedoutput in a 27-byte-long string.argumentsp - patient ien (DFN)examplesW DEC AUPNPAT(V46332UMH763) [THA,B JAN 01,1933 0001]3.1.2Routine - AUPNPAT1Data for the following functions comes from the PATIENT file, file 9000001.Technical ManualMarch 1999Routine Descriptions7

IHS RPMS Dictionaries (Patient) (AUPN)BEN(p)Version 99.1Returns Beneficiary/Non-Beneficiary Statusargumentsp - patient ien (DFN)examplesW BEN AUPNPAT1(1) 1OUTPUT:1 yes0 no-1 no/old tribe or unable3.2Routines with DescriptionGroupedRoutinesDescriptionAUPNCASEUpper cases a string - called from .01 of file 2.AUPNCIX*Sets/kills QMAN cross referencesAUPNCPTExtrinsic call to pass back array of all CPT codes available in PCCfor one visit.AUPNELIGInput transforms on insurer fields in eligibility files.AUPNHLPExecutable help call for railroad retirement.AUPNLBCKBack billing check.AUPNLK*Patient lookup routines.AUPNOHRWOffspring history birth weight calculation.AUPNPAT*Function calls to retrieve patient data. They are all describedfollowing this routine list.AUPNPCReturn HT or WT percentile based on sex and age.AUPNPCTCross reference on value field of V Measurement.AUPNPCTRCross reference trigger on #1117 of patient file.AUPNPEDEdits on fields in Patient file.AUPNPOSTPost init routine.AUPNPOUTOutput transforms on fields in Patient file.AUPNPREEnvironment check routine.AUPNPREIPre initialization routine.AUPNSICDScreen on .01 of V POV and other pointers to ICD Diagnosis.AUPNVDX*Called from V Diagnostic Procedure Result.AUPNVEYECalled from V EYEGLASS file.AUPNVLICalled from V Line Item file.Technical ManualMarch 1999Routine Descriptions8

IHS RPMS Dictionaries (Patient) (AUPN)Version 99.1GroupedRoutinesDescriptionAUPNVMS*Input transforms and help on measurement types/values.AUPNVSITCalled from cross references and input transforms on visit file.AUPNXFRCTrigger on #1117 on patient file.Technical ManualMarch 1999Routine Descriptions9