# Presentation: 310692

## 202 - VistA Files – The Building Blocks of  CPRS

- Presented by
- Paul C. Young
- Columbia, MO

## VistA Files – The Building Blocks of  CPRS

- The VistA Files Behind CPRS
- Purpose
- Explore some of the VistA files that make up CPRS
- Specifically files used by HIMS

## CPRS – Computerized Patient Record System

- Graphical Presentation of VistA Files
- Examples of VistA Files
- New Person File
- TIU Document File
- PTF File
- Hospital Location File

## VistA Organization

- File Example
-  New Person File (File 200)
- Contains data on employees, users, practitioners, etc.
- Data is kept in Fields
- New Person File has over 250 different fields

## VistA Organization

- Fields –
- Name
- Sex
- DOB
- Division
- Title
- Signature Block
- Last Sign On
- Keys

## VistA Organization

- Some Fields are Divided into Multiples
- Keys
- Key
- Given By
- Date Given

## FILEMAN

- OUTPUT FROM WHAT FILE: PATIENT MOVEMENT//
- SORT BY: DATE/TIME// 'DATE/TIME
- START WITH DATE/TIME: FIRST// 7-1  (JUL 01, 2007)
- GO TO DATE/TIME: LAST// 7-15  (JUL 15, 2007)
-   WITHIN DATE/TIME, SORT BY: @TRANSACTION
-   START WITH TRANSACTION: FIRST// DISCHARGE
-   GO TO TRANSACTION: LAST// DISCHARGE
-     WITHIN TRANSACTION, SORT BY: +FACILITY TREATING SPECIALTY
-     START WITH FACILITY TREATING SPECIALTY: FIRST//
-       WITHIN FACILITY TREATING SPECIALTY, SORT BY:
- STORE IN 'SORT' TEMPLATE:
- FIRST PRINT FIELD: !PATIENT
- THEN PRINT FIELD: !FACILITY TREATING SPECIALTY
- THEN PRINT FIELD: PATIENT:1U4N;"SSN"

## FILEMAN

- VA FileMan is used to define, enter, and retrieve information from a set of computer-stored files.  It is a public domain software package that is developed and maintained by the Department of Veterans Affairs. It is widely used by VA medical centers and in clinical, administrative, and business settings in this country and abroad.
- It is the Database Management System of VistA dealing with Files and Fields. VA FileMan organizes your data, storing it in fields, records, and files, much as you might arrange and preserve information on paper

## FILEMAN

-    Options:
-    1      Enter or Edit File Entries
-    2      Print File Entries
-    3      Search File Entries
-    5      Inquire to File Entries
-    8      List File Attributes

## FILEMAN

- Uses of FILEMAN:
- Inquire into a specific File
- Example – check to see who closed a specific PTF Record
- Pull Data from Files when there is no Menu Option that will provide the specific Data needed
- Example – Signature Block Entries

## FILEMAN

**Extracting Data from Files – example**
- Signature Block is Free Text in New Person File
- Staff can enter whatever they want
- Review of Signature Blocks in New Person File
- My Users
- Current Users
- Providers

## SIGNATURE BLOCK REVIEW

- NEW PERSON FILE
- DIVISION
- SIGNATURE BLOCK TITLE
- PERSON CLASS
- TERMINATION DATE

## SIGNATURE BLOCK REVIEW

- NEW PERSON FILE
- DIVISION
- 	COLUMBIA, MO VAMC
- TERMINATION DATE
- 	Null
- PERSON CLASS
- Alphabetic
- SIGNATURE BLOCK TITLE
- 	Alphabetic

## SIGNATURE BLOCK REVIEW

- NEW PERSON FILE
- OUTPUT FROM WHAT FILE: NEW PERSON//
- SORT BY: NAME// DIVISION    (multiple)
- DIVISION SUB-FIELD: @.01  DIVISION
- START WITH DIVISION: FIRST// COLUMBIA, MO VAMC
- GO TO DIVISION: LAST// COLUMBIA, MO VAMC
-   WITHIN DIVISION, SORT BY: @TERMINATION DATE
-   START WITH TERMINATION DATE: FIRST// @
-   GO TO TERMINATION DATE: LAST// @
-     WITHIN TERMINATION DATE, SORT BY: PERSON CLASS    (multiple)
-     PERSON CLASS SUB-FIELD: .01  Person Class
-     START WITH Person Class: FIRST// AA
-     GO TO Person Class: LAST// ZY
-       WITHIN Person Class, SORT BY: @SIGNATURE BLOCK TITLE
-       START WITH SIGNATURE BLOCK TITLE: FIRST// AA
-       GO TO SIGNATURE BLOCK TITLE: LAST// ZY

## SIGNATURE BLOCK REVIEW

- NEW PERSON FILE
- PRINT
- PERSON CLASS
- SIGNATURE BLOCK TITLE
- SIGNATURE BLOCK PRINTED NAME

## SIGNATURE BLOCK REVIEW

- NEW PERSON FILE
- FIRST PRINT FIELD: PERSON CLASS    (multiple)
-   FIRST PRINT PERSON CLASS SUB-FIELD: .01;C1;L15  Person Class
-   THEN PRINT PERSON CLASS SUB-FIELD: SIGNATURE BLOCK TITLE;C18
-   THEN PRINT PERSON CLASS SUB-FIELD: SIGNATURE BLOCK PRINTED NAME;C50

## SIGNATURE BLOCK REVIEW

- NEW PERSON FILE
- Person Class     TITLE                                                     NAME
- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
- Allopathic and   ATTENDING PHYSICIAN                       CPRSPROV,O
- Allopathic and   ATTENDING PHYSICIAN                       CPRSPROV,T
- Allopathic and   ATTENDING PHYSICIAN/UROLOGY    CPRSPROV,T
- Allopathic and   ATTENDING RHEUMATOLOGIST        CPRSPROV,F
- Allopathic and   Attending Surgeon                                  CPRSPROV,F
- Allopathic and   CARDIOLOGIST                                     CPRSPROV,S
- Allopathic and   CHIEF OF OPHTHALMOLOGY             CPRSPROV,S
- Allopathic and   CHIEF OF STAFF                                  CPRSPROV,E
- Allopathic and   CHIEF, SURGICAL SECTION               CPRSPROV,N
- Allopathic and   Cardiologist                                             CPRSPROV,T
- Allopathic and   Cardiothoracic Surgery                           CPRSPROV,E
- Allopathic and   Chief, Cardiology Section                       CPRSPROV,T

## SIGNATURE BLOCK REVIEW

- Review for Appropriateness
- Review for Consistency

## VistA Files – The Building Blocks of  CPRS

**New Person File in CPRS**
- 	Signature Block Title and Signature Block Printed Name Fields specifically states in CPRS Documentation the name and type of provider

## VistA Files – The Building Blocks of  CPRS

- Session will include discussion of:
- Patient File
- TIU Document File
- PTF File
- Hospital Location File
- Patient Movement File
- V Files
- Surgical File

## VistA Files – The Building Blocks of  CPRS

- Within each of these will look at:
- 	Fields within the Files that are of interest to HIMS
- 	VistA Menu Options that use those Files and Fields
- 	Use of FILEMAN to extract specific Fields

## Patient File

- Contains all the Patients in the facility’s database
- Primarily Demographic Information
- Name
- DOB
- SSN
- Eligibility
- Over 475 Fields in the file

## Patient File

- Additional Fields of Interest
- Sex
- Date of Death
- Means Test
- Race/Ethnicity
- Who entered patient and when
- Appointments
- NOK
- Competency/Guardianship Information

## Patient File

- Menu Options
- Patient Inquiry
- View Registration
- Most other Files link to the Patient File to identify:
- Patient Name
- SSN
- Other Demographic info as needed

## Patient File

**Scenario:**
- 		Shelves in File Room are crowded even though you’ve recently completed record retirement process (patients not seen in three years).
- 		What data fields might you pull from the Patient File to alleviate crowding?

## Patient File

- Date of Death
- Facility
- PRINT
- Name
- Date of Death
- SSN

## Patient File

- NAME                         1U4N   DATE OF DEATH
- --------------------------------------------------------------------------------
-                 FACILITY: COLUMBIA, MO VAMC
- CPRSPT,O                  C0001 MAR 31,2007
- CPRSPT,T                  C0002  APR  1,2007
- CPRSPT,T                  C0003  APR  3,2007
- CPRSPT,F                  C0004  APR  4,2007
- CPRSPT,F                  C0005  APR  4,2007  19:45
- CPRSPT,S                  C0006  APR  5,2007  10:32
- CPRSPT,S                  C0007  APR  8,2007

## Patient File

**Search for OIF/OEF Female Patients**
- PATIENT FILE
- SEX
- 	FEMALE
- SERVICE
- 	OEF/OIF

## Patient File

**Search for OIF/OEF Female Patients**
- PATIENT FILE
**PRINT**
- 	Name
- 	Sex
- 	Location of Service
- 	Age
- 	Date Entered into File
- 	SC

## Patient File

**Search for OIF/OEF Female Patients**
- NAME                 SEX        LOC SVC           AGE  DATE ENTERED    SC?
-   --------------------------------------------------------------------------------
- CPRSPT,O         FEMALE     OIF                  31    DEC 17,2006           YES
- CPRSPT,T          FEMALE     OIF                  26    JAN 13,2007            NO
- CPRSPT,T          FEMALE     OIF                  41    FEB 11,2007           YES
- CPRSPT,F          FEMALE     OEF                 42    JUL 25,1991            NO
- CPRSPT,F,         FEMALE     OEF                 34    OCT 07,2005           NO
- CPRSPT,S          FEMALE     UNKOEF/OIF  53    OCT 16,1999          YES
- CPRSPT,S          FEMALE     UNK OEF/OIF 49    SEP 13,1995           YES

## VistA Files – The Building Blocks of  CPRS

**Patient File in CPRS**
- 	When CPRS Progress Note states:
- 		27 year old white female seen in clinic 	for complaint of ...
- 	This Demographic information is from the Patient file.

## TIU Document File

- Stores **Text** Information for the Clinical Record Database
- Over 75 Fields:
- Author/Dictator
- Hospital Location
- Entered by
- Signed by
- Cosigned by

## TIU Document File

- Menu Options:
- Text Integration Utilities (MIS Manager) Option
-    1      Individual Patient Document
-    2      Multiple Patient Documents
-    3      Print Document Menu ...
-    _**4      Search for Selected Documents**_
-    5      Statistical Reports ...
-    6      Unsigned/Uncosigned Report
-    7      Missing Text Report
-    8      Missing Text Cleanup
-    9      Signed/unsigned PN report and update
-   10     UNKNOWN Addenda Cleanup
-   11     Missing Expected Cosigner Report
-   12     Mark Document as 'Signed by Surrogate'
-   13     Mismatched ID Notes

## TIU Document File

- Menu Options:
- Search for Selected Documents
- Select **Status**:
- 1    undictated           5    unsigned             9    purged
- 2    untranscribed      _**6    uncosigned**_       10   deleted
- 3    unreleased          7    completed         11   retracted
- 4    unverified            8    amended

## TIU Document File

- Menu Options:
- Search for Selected Documents
- Select Status: uncosigned
- Select CLINICAL DOCUMENTS Type(s):
- 1  Progress Notes   3  Discharge Summaries  5   Laboratory
- 2  Addendum           4  Clinical Procedures      6   Surgical Reports
- Select CLINICAL DOCUMENTS Type(s): Progress Notes
- Select SEARCH CATEGORIES:

## TIU Document File

- Menu Options:
- Search for Selected Documents
- Select Status: unsigned
- Select CLINICAL DOCUMENTS Type(s): Progress Notes
- Select SEARCH CATEGORIES:
- 1    All Categories               8  Service
- 2    Author                           9  Subject
- 3    Division                       10  Title
_**4    Expected Cosigner**_   11  Transcriptionist
- 5    Hospital Location        12  Treating Specialty
- Patient                       13   Visit
- Problem

## TIU Document File

- Menu Options:
- Search for Selected Documents
- Select Status: uncosigned
- Select CLINICAL DOCUMENTS Type(s): Progress Notes
- Select SEARCH CATEGORIES:  Expected Cosigner
- Select Expected Cosigner: CPRSPROV,O
- Start Reference Date [Time]: T-7// 6-22  (JUN 22, 2007)
- Ending Reference Date [Time]: NOW// 6-29  (JUN 29, 2007)
- Searching for the documents.

## TIU Document File

- Menu Options:
- EXPECTED COSIGNER (CPRSPROV,O) from 06/22/07 to 06/29/07  6 doc
-  Patient                      Document                            Ref Date  Status
- CPRSPT,O  (C0001) CO-PC GEN MED (INPT)   06/28/07  uncosigned
- CPRSPT,T  (C0002) CO-MED STUDENT NOTE 06/28/07  uncosigned
- CPRSPT,T  (C0003) CO-H&P (D)                         06/28/07  uncosigned
- CPRSPT,F  (C0004) CO-H&P (T)                         06/28/07  uncosigned
- CPRSPT,F  (C0005) CO-DEATH NOTE (D)        06/27/07  uncosigned
- CPRSPT,S (C0006)  CO-PC GEN MED (INPT)   06/27/07  uncosigned

## TIU Document File

- Review for Unsigned Documents for a Date Range (Fileman)
- TIU DOCUMENT File
- DIVISION
- STATUS:
-    ACTIVE   				TEST
-    AMENDED 			             UNCOSIGNED
-    COMPLETED   			UNDICTATED
-    DELETED 				UNRELEASED
-    INACTIVE   			             _**UNSIGNED**_
-    PURGED   				UNTRANSCRIBED
-    RETRACTED   			UNVERIFIED
-    TEST

## TIU Document File

- Review for Unsigned Documents for a Date Range (Fileman)
- STATUS
- UNSIGNED
- ENTRY DATE/TIME

## TIU Document File

- Review for Unsigned Documents for a Date Range (Fileman)
- PRINT
- PATIENT
- AUTHOR/DICTATOR
- HOSPITAL LOCATION
- STATUS
- ENTRY DATE/TIME

## TIU Document File

- OUTPUT (Fileman)
- PATIENT  AUTHOR/DICT.  HOSP LOC.   STATUS     ENTRY DATE TIME
- CPRSPT, O   CPRSPROV, O   CLINIC 1      UNSIGNED     JUN 15, 2007 10:00
- CPRSPT, T    CPRSPROV, T   CLINIC  2     UNSIGNED     JUN 15, 2007  10:07

## TIU Document File

- OUTPUT – Fileman/Menu
- PATIENT  AUTHOR/DICT.  HOSP LOC.   STATUS    ENTRY DATE TIME
- CPRSPT, O   CPRSPROV, O   CLINIC 1      UNSIGNED     JUN 15, 2007 10:00
- CPRSPT, T    CPRSPROV, T   CLINIC  2     UNSIGNED     JUN 15, 2007  10:07
-  Patient                      Document                            Ref Date  Status
- CPRSPT,O  (C0001) CO-PC GEN MED (INPT)   06/28/07  uncosigned
- CPRSPT,T  (C0002) CO-MED STUDENT NOTE 06/28/07  uncosigned
- CPRSPT,T  (C0003) CO-H&P (D)                         06/28/07  uncosigned
- CPRSPT,F  (C0004) CO-H&P (T)                         06/28/07  uncosigned
- CPRSPT,F  (C0005) CO-DEATH NOTE (D)        06/27/07  uncosigned
- CPRSPT,S (C0006)  CO-PC GEN MED (INPT)   06/27/07  uncosigned

## TIU Document File

- Other Fields:
- .01 – Document Type
- Progress Note Titles
- Discharge Summaries
- Operative Reports

## TIU Document File

- Check for Discharge Summaries Status
- TIU DOCUMENT
- REFERENCE DATE
- DOCUMENT TYPE
- DISCHARGE SUMMARY

## TIU Document File

- Check for Discharge Summary Status:
- Output:	Reference Date
- 			Patient
- 			Entry Date/Time
- 			Author/Dictator
- 			Hospital Location
- 			Status
- 			Signed By
- 			Signature Date/Time
- 			Cosigned By
- 			Cosignature Date/Time
- 			Expected Cosigner

## TIU Document File

- Check for Discharge Summary Status:
**REFER DATE             PATIENT     ENTRY DATE/TIME   AUTHOR/DICT             HOSP LOC   **
**SIGNED BY    SIG DATE/TIME      COSIGNED BY           COSIGN DATE/TIME   EXP COSIGNER**
**STATUS**
**--------------------------------------------------------------------------------**
**JUN 22,2007  14:06     CPRSPT,O     JUN 22,2007  12:10   CPRSPROV,O         4 MED-CO**
**CPRSPROV,O  JUN 22,2007  13:02                                                                      CPRSATTD,O**
**UNCOSIGNED**
**JUN 22,2007  14:29     CPRSPT,T       JUN 21,2007  11:12  CPRSPROV,T            4 MED-CO**
**CPRSPROV,T  JUN 22,2007  11:59     CPRSATTD,T          JUN 22,2007  13:27     CPRSATT,T**
**COMPLETED**

## TIU Document File

- Text Integration Utilities (MIS Manager) Option:  Search for Selected Documents
- Select Status: UNVERIFIED//   Completed
- Select CLINICAL DOCUMENTS Type(s): Discharge Summaries//
- Select SEARCH CATEGORIES: AUTHOR//     All Categories
-  Start Reference Date [Time]: T-7// 6-22  (JUN 22, 2007)
- Ending Reference Date [Time]: NOW// 6-22

## TIU Document File

- TIU Menu Option for Completed Discharge Summary Status:
-  ALL CATEGORIES from 06/22/07 to 06/22/07
- Patient                       Document                                  Ref Date  Status
- CPRSPT,O  (C0001) CO-DISCHARGE SUMMARY    06/22/07  completed
- CPRSPT,T  (C0002) CO-DISCHARGE SUMMARY     06/22/07  completed
- CPRSPT,T  (C0003) CO-DISCHARGE SUMMARY     06/22/07  completed
- CPRSPT,F  (C0004) CO-DISCHARGE SUMMARY     06/22/07  completed

## TIU Document File

- Compare – Menu Option Data with Fileman Data
- Patient                       Document                                  Ref Date  Status
- CPRSPT,O  (C0001) CO-DISCHARGE SUMMARY    06/22/07  completed
- CPRSPT,T  (C0002) CO-DISCHARGE SUMMARY     06/22/07  completed
- CPRSPT,T  (C0003) CO-DISCHARGE SUMMARY     06/22/07  completed
- CPRSPT,F  (C0004) CO-DISCHARGE SUMMARY     06/22/07  completed
- =============================================================
**REFER DATE             PATIENT     ENTRY DATE/TIME   AUTHOR/DICT             HOSP LOC   **
**SIGNED BY    SIG DATE/TIME      COSIGNED BY           COSIGN DATE/TIME   EXP COSIGNER**
**STATUS**
**--------------------------------------------------------------------------------**
**JUN 22,2007  14:29     CPRSPT,T       JUN 21,2007  11:12  CPRSPROV,T            4 MED-CO**
**CPRSPROV,T  JUN 22,2007  11:59     CPRSATTD,T          JUN 22,2007  13:27     CPRSATT,T**
**COMPLETED**

## TIU Document File

- Another File to be aware of is:
**TIU MULTIPLE SIGNATURE**
- Fields
- 	.01         TIU DOCUMENT NUMBER
-    .02          COSIGNATURE NEEDED
-    .03          EXPECTED SIGNER
-    .04          COSIGNATURE DATE/TIME
-    .05          ACTUAL COSIGNER
-    .06          COSIGNER'S SIGNATURE BLOCK
-    .07          COSIGNER'S TITLE
-    .08          COSIGNATURE MODE
-    .09          SIGNED BY SURROGATE

## TIU Document File

**TIU MULTIPLE SIGNATURE**
- Can identify:
- Use of Additional Signer
- Additional Signer not signed

## VistA Files – The Building Blocks of  CPRS

**TIU Document File in CPRS**:
- Text
- Types of Documents
- Completion Status
- Entry and Signature Date/Time
- Amendments

## PTF FILE

- This file contains all PTF information generated from admissions, treating specialty transfers, and PTF screen edits
- 	93 Fields
- Patient
- Ward at Discharge
- Closed Out By
- Closed Out Date
- Discharge Date
- Status

## PTF FILE

- 	Fields (cont.)
- DRG
- 401
- 501
- 601
- Principle and Secondary Diagnoses (1-13)
- Transmission Date
- Discharge Specialty

## PTF FILE

- VistA Menu Option
- PTF Output Menu Option: Productivity Report by Clerk
- Print by [Close Out or [Release Date: C// CLOSED
- START WITH CODING CLERK: FIRST// CPRSCLK,O
- GO TO CODING CLERK: LAST// CPRSCLK,O
- START WITH CLOSE OUT DATE: FIRST// 6-22  (JUN 22, 2007)
-   GO TO CLOSE OUT DATE: LAST// 6-22  (JUN 22, 2007)

## PTF FILE

- VistA Menu Option
- PTF Output Menu Option: Productivity Report by Clerk
- PTF PRODUCTIVITY REPORT
- PATIENT               SSN          DATE                      # PM     SURG
-   CLOSED BY        ON            RELEASED BY      ON
- --------------------------------------------------------------------------------
- CODING CLERK: CPRSCLK,O
- CPRSPT,O       000-00-0001   JUN 21,2007          1          0
- CPRSCLK,O    JUN 22,2007   CPRSCLK,O         JUN 22,2007
- CPRSPT,T       000-00-0002   JUN 21,2007          1           0
- CPRSCLK,O   JUN 22,2007   CPRSCLK,O          JUN 22,2007

## PTF FILE

- Coder Productivity for Date Range (Fileman)
- Close Out Date
- Facility/Suffix/Ward at Discharge
- Coder
- Print
- Patient
- Ward at Discharge
- Facility/Suffix
- Discharge Date
- Close out Date
- Status
- Coder

## PTF FILE

- Additional fields might want to add:
- DRG
- Principal Diagnosis

## PTF FILE

**Scenario:**
- Coders are complaining about being overworked and how complex the cases are and how much time they take to complete.
- What could you run out of the PTF File to show them that it is not as bad as all that?

## PTF FILE

- ONE DAY STAY REPORT
- SORT BY: NUMBER// @DISCHARGE DATE
- START WITH DISCHARGE DATE: FIRST// 6-1  (JUN 01, 2007)
- GO TO DISCHARGE DATE: LAST// 6-1  (JUN 01, 2007)
-   WITHIN DISCHARGE DATE, SORT BY: @DISCHARGE DATE-(ADMISSION DATE)="0"

## PTF FILE

- ONE DAY STAY REPORT
- PRINT
- FIRST PRINT FIELD: PATIENT;C1!
- THEN PRINT FIELD: PATIENT:
-   THEN PRINT PATIENT FIELD: $E(SSN,6,9);"SSN";C30
-    By 'SSN', do you mean PATIENT 'SOCIAL SECURITY NUMBER'? Yes//   (Yes)
-   THEN PRINT PATIENT FIELD: ADMISSION DATE
-   THEN PRINT PATIENT FIELD: DISCHARGE DATE
-   THEN PRINT PATIENT FIELD: WARD AT DISCHARGE
-   THEN PRINT PATIENT FIELD: DISCHARGE SPECIALTY

## PTF FILE

- ONE DAY STAY REPORT
**PATIENT    SSN   ADM DATE            DC DATE          DC WARD  DC SPEC**
- CPRSPT,O 0001 JUN 1, 2007 0813  JUN 1, 20071645  MICU   GEN MED
- CPRSPT,T  0002 JUN 1, 2007 0653  JUN 1, 20071818  4 OBS  SUR OBS
- CPRSPT,TH  0003 JUN 1, 2007 1234  JUN 1, 20071851  4 MED  GEN MED
- ----------------------------
- COUNT  3

## PTF FILE

- FileMan Option:  Print File Entries
- OUTPUT FROM WHAT FILE: PTF//
- SORT BY: NUMBER// ?
-  Answer with FIELD NUMBER, or LABEL
-  Do you want the entire FIELD List? y  (Yes)
-    Choose from:
-    .001         NUMBER
-    .01          PATIENT
-    2            ADMISSION DATE
-    2.1          INTERNAL ADMISSION #
-    2.2          WARD AT DISCHARGE
-    3            FACILITY

- PTF Output Menu Option:
-  Diagnostic Code PTF Record Search
- Search by Range or Exact match: E// EXACT MATCH
- Enter Diagnosis Code to search for: 401.9
- Total by PTF record or ICD count: P// PTF record
- Searching the PTF file  Select fields to sort by
- SORT BY: NUMBER// ?
-  Answer with FIELD NUMBER, or LABEL
-  Do you want the entire FIELD List? y  (Yes)
-    Choose from:
-    .001         NUMBER
-    .01          PATIENT
-    2            ADMISSION DATE
-    2.1          INTERNAL ADMISSION #
-    2.2          WARD AT DISCHARGE
-    3            FACILITY

## PTF FILE

- FileMan Option:  Print File Entries
- OUTPUT FROM WHAT FILE: PTF//
- SORT BY: NUMBER// ?
-  Answer with FIELD NUMBER, or LABEL
-  Do you want the entire FIELD List? y  (Yes)
-    Choose from:
-    .001         NUMBER
-    .01          PATIENT
-    2            ADMISSION DATE
-    2.1          INTERNAL ADMISSION #
-    2.2          WARD AT DISCHARGE
-    3            FACILITY

- PTF Output Menu Option: Surgical Code PTF Record Search
- Search by Range or Exact match: E// EXACT MATCH
- Select ICD OP/PROC CODE NUMBER:    60.12   OPEN BIOPSY OF PROSTATE
- Total by PTF record or ICD count: P// PTF record
- Searching the PTF file  Select fields to sort by
- SORT BY: NUMBER// ?
-  Answer with FIELD NUMBER, or LABEL
-  Do you want the entire FIELD List? Y  (Yes)
-    Choose from:
-    .001         NUMBER
-    .01          PATIENT
-    2            ADMISSION DATE
-    2.1          INTERNAL ADMISSION #
-    2.2          WARD AT DISCHARGE
-    3            FACILITY

## VistA Files – The Building Blocks of  CPRS

**PTF FILE**
- Not a direct link with PTF data and CPRS
- 	The work Coding Staff does in PTF File does not show up in CPRS
- 	Ward at Discharge, Treating Specialty, Discharge Date from Patient Movement File

## Patient Movement File

-  This file holds the data for all admissions, transfers, discharges, treating specialty changes, and lodger movements.
- 72 Fields in Patient Movement File
- DATE/TIME
- TRANSACTION
- TYPE OF MOVEMENT
- WARD LOCATION
- BED-ROOM

## Patient Movement File

- Fields (cont)
- ASIH fields
- Source of Admission
- Ward at Discharge
- Length of Stay
- Opt-Out Facility Directory Fields

## Patient Movement File

- VistA Menu Option:
- Inpatient Roster
- Sort this report by (W)ard or (P)rovider?  WARD//
- Select division: ALL// COLUMBIA VAMC DIVISION
- Select ward: ALL//
- Sub-sort by (N)ame of Patient or (R)oom  NAME//

## Patient Movement File

**NAME          SSN  AGE  ADM DATE  DAY  WARD RM-BED  PRIM MD       ATTD MD       T SPEC   **
** ****CPRSPT,O  0001  61    06-25-2007    6     2B -CO  B221-A-  CPRSPRO,O  CPRSATTD,O   PSY**
** ****CPRSPT,O 0002   47    07-01-2007    1     2B-CO   B229-A   CPRSPRO,T  CPRSATTD,T    PSY**

## Patient Movement File

**Scenario:**
- You’re on a group reviewing the discharge flow process.  The perception is that discharges occur late in the day but there is no hard data.
- What data fields would you need from the Patient Movement File?

## Patient Movement File

- Discharges by Ward in Date/Time Order
- Ward at Discharge
- Date/Time
- Transaction
- Discharge

## Patient Movement File

- Discharges by Ward in Date/Time Order
- Print:
- Transaction
- Patient
- Ward at Discharge
- Type of Movement
- Date/Time

## Patient Movement File

- TRANS    PT	           WARD   TYPE MOVE       DATE/TIME
- DISC 	CPRSPT,O  	3-MED    OPT-NSC          JUN  3,2007  15:35
- DISC 	CPRSPT,T  	3-MED    OPT-NSC          JUN  3,2007  18:32
- DISC 	CPRSPT,TH  	3-SURG   OPT-NSC         JUN  3,2007  14:11
- DISC 	CPRSPT,F  	3W GS    OPT-NSC          JUN  3,2007  16:00
- DISC 	CPRSPT,FI  	3W GU    OPT-NSC         JUN  3,2007  13:02
- DISC 	CPRSPTT,S  	4 MED    OPT-SC            JUN  3,2007  10:47

## Patient Movement File

- Gains (Adm and IWT) to a Ward Location by Date Range
- Transaction
- Admission or Transfer
- Date/Time
- Ward Location

## Patient Movement File

- Gains (Adm and IWT) to a Ward Location by Date Range
- Print
- PATIENT
- DATE/TIME
- TRANSACTION
- WARD LOCATION
- TYPE OF MOVEMENT

## Patient Movement File

- Gains (Adm and IWT) to a Ward Location by Date Range
**PATIENT****	****DATE/TIME****	****  TRANS   WARD   TYPE**
- CPRSPT 	JUN 3, 2007 1403  ADM	  3 MED	   OPT-SC
- CPRSPT	JUN 3, 2007 1458  ADM	  3 MED	   OPT-AC
- CPRSPT	JUN 3, 2007 1513  TRANS  3 SURG  INTERWARD TRANS
- CPRSPT	JUN 3, 2007 1624  ADM	  4 MED	   OPT-NSC

## Patient Movement File

- Gains (Adm and IWT)
**PATIENT****	****DATE/TIME****	****  TRANS   WARD   TYPE**
- CPRSPT	JUN 3, 2007 1403  ADM	  3 MED	   OPT-SC
- CPRSPT	JUN 3, 2007 1458  ADM	  3 MED	   OPT-AC
- CPRSPT	JUN 3, 2007 1513  TRANS  3 SURG  INTERWARD TRANS
- CPRSPT	JUN 3, 2007 1624  ADM	  4 MED	   OPT-NSC
- Discharges
- TRANS    PT	           WARD   TYPE MOVE       DATE/TIME
- DISC 	CPRSPT  	3-MED    OPT-NSC          JUN  3,2007  15:35
- DISC 	CPRSPT  	3-MED    OPT-NSC          JUN  3,2007  18:32
- DISC 	CPRSPT  	3-SURG   OPT-NSC         JUN  3,2007  14:11
- DISC 	CPRSPT  	3W GS    OPT-NSC          JUN  3,2007  16:00
- DISC 	CPRSPT	3W GU    OPT-NSC         JUN  3,2007  13:02
- DISC 	CPRSPT	4 MED    OPT-SC            JUN  3,2007  10:47

## VistA Files – The Building Blocks of  CPRS

**Patient Movement File**
- Discharge Summaries in CPRS have
- Ward Location
- Admit Date
- Discharge Date
- Type of Release
- Inpatient Progress Notes have
- Ward Location
- Admit Date

## Hospital Location File

- Contains locations found in the hospital
**Wards**
**Clinics**
- 195 Fields
- Type – Clinic, Ward, Imaging, Other
- Service – Medicine, Surgery, Psych
- Treating Specialty – Cardio, Ent, Gen Med, etc

## Hospital Location File

- Fields (cont)
- 	**Appointment**
- Appointment Date/Time
- Patient
- Status
- Checked-in
- Checked Out
- User

## Hospital Location File

- Fields (cont)
- 	Clinic Set up Fields
- Length of Appointment
- Hour Clinic Display Begins
- Overbooks
- Schedule on Holidays
- Non-Count Clinic
- Prohibit Access to Clinic

## Hospital Location File

- Appointments – Ambulatory Care Reporting Menu (ACRP)
-  ACRP Reports Menu Option:
**  **_**AHRM   ACRP Ad Hoc Report Menu ...**_
-   CAAR   Clinic Appointment Availability Report
-   COPE   Consult Report (COPE)
-   CUSS   Clinic Utilization Statistical Summary
-   DVM     Data Validation Menu ...
-   EAR      Encounter Activity Report
**  **_**EARR   Encounter 'Action Required' Report**_
-   MTEE    Means Test/Eligibility/Enrollment Report
-  _**ODPR   Outpatient Diagnosis/Procedure Frequency Report**_
_** **__**ODPS   Outpatient Diagnosis/Procedure Code Search**_

## Hospital Location File

- Appointments – Ambulatory Care Reporting Menu (ACRP)
-  ACRP Reports Menu Option:
-    OEWS   Outpatient Encounter Workload Statistics
-    PAAF     Patient Activity by Appointment Frequency
-    PAS       Patient Appointment Statistics
-    PEL        Patient Encounter List
-    PMI        Performance Monitor Menu ...
-    RSPD    Review of Scheduling/PCE/Problem List Data
-    RVL       Retroactive Visits List
-    SCVA    SC Veterans Awaiting Appointments
-    TOFU    Trend of Facility Uniques by 12 Month Date Ranges
-    VWAS    Veterans Without Activity Since a Specified Date

## Hospital Location File

**AD HOC REPORT**
-  CL        CLINIC
-  SC        STOP CODE
-  PR        PROVIDER
-  _**DX        DIAGNOSIS**_
-  _**AP        AMBULATORY PROCEDURE**_
-  VF        V FILE ELEMENT
-  PD        PATIENT DEMOGRAPHICS
-  PE        PATIENT ELIGIBILITY
-  PC        PRIMARY CARE
-  EH        ENROLLMENT (HISTORICAL)
-  EC        ENROLLMENT (CURRENT)
-  OE        OUTPATIENT ENCOUNTER
-  PM        PERF MONITOR

## Hospital Location File

**AD HOC REPORT**
**DIAGNOSIS USED IN WHAT CLINIC**
**-------------------------- R E P O R T   F O R M A T ---------------**
**     ****Select one of the following:**
**          ****D         DETAILED**
**          ****S         SUMMARY**
**Select report format: SUMMARY// **
**Compare data to same date range previous year? NO// **
**     ****Select one of the following:**
**          ****F         FORMATTED TEXT**
**          ****D         DELIMITED VALUES FOR EXPORT**
**Produce output as: FORMATTED TEXT//**

## Hospital Location File

**AD HOC REPORT**
**DIAGNOSIS USED IN WHAT CLINIC**
**--------------------- R E P O R T   P E R S P E C T I V E ----------------------**
**     ****Select one of the following:**
**          ****CL        CLINIC**
**          ****SC        STOP CODE**
**          ****PR        PROVIDER**
**          ****DX        DIAGNOSIS**
**          ****AP        AMBULATORY PROCEDURE**
**          ****VF        V FILE ELEMENT**
**          ****PD        PATIENT DEMOGRAPHICS**
**          ****PE        PATIENT ELIGIBILITY**
**          ****PC        PRIMARY CARE**
**          ****EH        ENROLLMENT (HISTORICAL)**
**          ****EC        ENROLLMENT (CURRENT)**
**          ****OE        OUTPATIENT ENCOUNTER**
**          ****PM        PERF MONITOR**
**Select report perspective: ****CL**

## Hospital Location File

**AD HOC REPORT**
**DIAGNOSIS USED IN WHAT CLINIC**
**Select report perspective: CL**
**     ****Select one of the following:**
**          ****CN        CLINIC NAME**
**          ****CG        CLINIC GROUP**
**          ****CS        CLINIC SERVICE**
**Select CLINIC category: ****CN  CLINIC NAME**
**Beginning date: **
**Beginning date****: 7-1  (JUL 01, 2007)**
**   ****Ending date****: 7-15  (JUL 15, 2007)**

## Hospital Location File

**AD HOC REPORT**
**DIAGNOSIS USED IN WHAT CLINIC**
-  **Select additional output limiting factor:  (optional)**
**     ****Select one of the following:**
**          ****CL        CLINIC**
**          ****SC        STOP CODE**
**          ****PR        PROVIDER**
**          ****DX        DIAGNOSIS**
**          ****AP        AMBULATORY PROCEDURE**
**          ****VF        V FILE ELEMENT**
**          ****PD        PATIENT DEMOGRAPHICS**
**          ****PE        PATIENT ELIGIBILITY**
**          ****PC        PRIMARY CARE**
**          ****OE        OUTPATIENT ENCOUNTER**
**          ****PM        PERF MONITOR**
**Select limiting factor: ****DX**

## Hospital Location File

**AD HOC REPORT**
**DIAGNOSIS USED IN WHAT CLINIC**
**Select limiting factor: ****DX**
**--------------------- R E P O R T   L I M I T A T I O N S ----------------------**
**     ****Select one of the following:**
**          ****PD        PRIMARY DIAGNOSIS**
**          ****SD        SECONDARY DIAGNOSIS**
**          ****AD        ALL DIAGNOSES**
**          ****GH        GAF SCORE (HISTORICAL)**
**          ****GC        GAF SCORE (CURRENT)**
**Select DIAGNOSIS category: ****PD  PRIMARY DIAGNOSIS**
**     ****Select one of the following:**
**          ****L         LIST**
**          ****R         RANGE**
**          ****N         NULL (NO DATA VALUE)**
**Limit this factor by: ****L**

## Hospital Location File

**AD HOC REPORT**
**DIAGNOSIS USED IN WHAT CLINIC**
**Limit this factor by:**** L**
**                          ******* Item List Selection *****
**Select ICD DIAGNOSIS CODE NUMBER: ****401.9****  HYPERTENSION NOS**
**         ****...OK? Yes//   (Yes)**
**Select ICD DIAGNOSIS CODE NUMBER:**
**     ****Select one of the following:**
**          ****I         INCLUDE**
**          ****E        EXCLUDE**
**Include or exclude records in this category: ****I**

## Hospital Location File

**AD HOC REPORT**
**DIAGNOSIS USED IN WHAT CLINIC**
**  ****For date range: JUL 1,2007 to JUL 15,2007**
**  ****Date printed: JUL 27,2007@09:46                                         Page: 1**
**   ****--------------------------------------------------------------------------------**
**   ****CLINIC NAME:                                Encount.    Visits   Uniques**
**   ****------------------------------------------       --------          --------   --------  **
**   ****CO-CARDIO REHAB                            2                2          1**
**   ****CO-CARDIO TREADMILL                    1                1          1**
**   ****CO-CARDIO TUES                               1                1          1**
**   ****CO-CCHT RN PHONE CALL               4                4          4**
**   ****CO-RENAL TUES                                 1                1          1**
**   ****CO-VASC LAB                                      4                4         4**
**   ****CO-WOMENS CLINIC                           1                1         1**
**  ****======================================================**
**   ****REPORT TOTAL:                                14              14       12**

## Hospital Location File

- AD HOC REPORT
**AP        AMBULATORY PROCEDURE**
-   EM   EVALUATION & MANAGEMENT CODES
-   AP   AMBULATORY PROCEDURE (NO E&M CODES)
-   AC   ALL AMBULATORY PROCEDURE CODES
- --------------------------  R E P O R T   F O R M A T  -------------------------
-                 Report output format: SUMMARY
-        Compare data to previous year: NO
-                    Produce output as: FORMATTED TEXT

## Hospital Location File

- AD HOC REPORT
**AP        AMBULATORY PROCEDURE**
- ---------------------  R E P O R T   P E R S P E C T I V E  --------------------
- Perspective category: AMBULATORY PROCEDURE
-  Perspective sub-category: ALL AMBULATORY PROCEDURE CODE
- ---------------------  R E P O R T   L I M I T A T I O N S  --------------------
-                        Starting date: JUL 1,2007
-                        Ending date: JUL 3,2007

## Hospital Location File

- AD HOC REPORT
**AP        AMBULATORY PROCEDURE**
-  		Addl. limitation category: PROVIDER
-        Addl. limitation sub-category: **PRIMARY PROVIDER**
-                         Include list: **CPRSPROVIDER,O**
- ---------------------  R E P O R T   P R I N T   O R D E R  --------------------
-                         Output order: ALPHABETIC

## Hospital Location File

- AD HOC REPORT
**AP        AMBULATORY PROCEDURE**
-  ALL AMBULATORY PROC CODES:             Encount.   Visits  Uniques
-    99212 OFFICE/OUTPATIENT VISIT, EST          1         1         1
-    **99213 OFFICE/OUTPATIENT VISIT, EST          6         6         6**
-    99214 OFFICE/OUTPATIENT VISIT, EST          1         1         1
- REPORT TOTAL:                                                    8        8         8

## Hospital Location File

**Scenario:**
- While doing provider education and feedback, one of the doctors states he doesn’t need to know this because he leaves it up to the clinic clerk to enter all that stuff.
- How do you verify if there is a problem with the clinic check-out process?

## Hospital Location File

**Check Out User (Fileman)**
- Check Out User (Employee Name)
- Appointment Date/Time
- Print
- Clinic Name
- Patient (Name)
- Appt Date/Time
- Check Out Date/Time
- Check Out User (Employee)

## Hospital Location File

- Appointments – Checked Out User
**CLINIC   PATIENT     APPT DATE   CO DATE       CO USER**
**C&P  **     CPRSPT,1  6/22/07 0900  6/22/07 1115   CPRSCL
- DENTAL CPRSPT,2  6/22/07 0800  6/22/07 0948   CPRSPR,1
- ER/URG CPRSPT,3  6/22/07  0722  6/22/07 0829  CPRSPR,2
- GI/END  CPRSPT,4   6/22/07 0830   6/22/07 0949  CPRSPR,3
- GU         CPRSPT,5   6/22/07 0930   6/22/07 0948  CPRSPR,4

## VistA Files – The Building Blocks of  CPRS

- Hospital Location Files are seen in CPRS Progress Notes
-   Clinic Names
-   Date/Time of Appointment

## V FILES

- V CPT – CPT Codes for each Patient Visit
- V POV – ICD-9-CM Diagnoses Codes for each Visit.  POV – Purpose of Visit
- Files are huge:
-  V CPT                         (34,651,294 entries)
-  V POV                         (24,428,635 entries)

## V FILES

**V CPT**
- CPT
- PATIENT NAME
- VISIT (Date/Time)
- CPT Modifier

**V POV**
- POV (ICD-9 Code)
- Patient Name
- Visit (Date/Time)
- Primary/Secondary Dx

## V FILES

**Other V Files**
-    V EXAM                           (308,609 entries)
-    V HEALTH FACTORS     (5,158,632 entries)
-    V IMMUNIZATION           (779,523 entries)
-    V PATIENT ED                (4,686,055 entries)
-    V PROVIDER                   (26,384,473 entries)
-    V SKIN TEST                   (70,809 entries)

## V FILES

- VistA Menu Options
- AD HOC REPORT
-  CL        CLINIC
-  SC        STOP CODE
-  PR        PROVIDER
-  _**DX        DIAGNOSIS**_
-  _**AP        AMBULATORY PROCEDURE**_
-  _**VF        V FILE ELEMENT**_
-  PD        PATIENT DEMOGRAPHICS
-  PE        PATIENT ELIGIBILITY
-  PC        PRIMARY CARE
-  EH        ENROLLMENT (HISTORICAL)
-  EC        ENROLLMENT (CURRENT)
-  OE        OUTPATIENT ENCOUNTER
-  PM        PERF MONITOR

## V FILES

**V FILE ELEMENT**
- EX        EXAMINATION
- HF        HEALTH FACTOR
- IM        IMMUNIZATION
- PE        PATIENT EDUCATION
- TR        TREATMENTS
- ST        SKIN TEST

## V FILES

**Scenario:**
- Provider calls that an alert was received to perform a diabetic foot exam, but the patient is not diabetic.
- How do you locate where diabetic diagnosis was used?

## V FILES

**Searching for ICD-9 Code – example DM**
- V POV File
- Patient Name
- POV - Codes  250.00 – 250.93
- Visit – Date Range

## V FILES

- Searching for ICD-9 Code – example DM
- V POV File
- PRINT
- Patient Name
- Visit
- POV

## V FILES

- Searching for ICD-9 Code – example DM
- V POV File
- PATIENT NAME    VISIT                             **POV**
- CPRSPT, One         Nov   7, 2006 1030       250.60
- CPRSPT, ONE        Nov 13, 2006 1427       250.60
- CPRSPT, ONE        Jan    2, 2007 1430       250.60

## VistA Files – The Building Blocks of  CPRS

- Diagnoses, CPT Codes and Providers from
-  **V Files** are all part of the check out process in CPRS

## SURGERY FILE

- The SURGERY file contains information regarding a surgery case made up of an operative procedure, or multiple operative procedures for a patient.  The file includes the information necessary for creating the Nurses' Intraoperative Report, Operation Report, and Anesthesia Report.
- Contains 874 Fields

## SURGERY FILE

- Fields Include:
- Patient
- Visit (Date/Time)
- Operating Room
- Surgical Specialty
- Surgeon, First Asst, Second Asst, Attending
- Attending Code
- Perfusionist

## SURGERY FILE

- Fields (cont)
- Time Operation Began
- Anes Care Start Time
- Monitors
- Blood Loss
- Anesthesia Technique
- Preop Temperature

## SURGERY FILE

- VistA Menu Options:
**List of Operations**
- Start with Date: 6-22  (JUN 22, 2007)
- End with Date: 6-22  (JUN 22, 2007)

## SURGERY FILE

**List of Operations**
- DATE      PATIENT    SERVICE              SURGEON          ANESTH
- CASE#    SSN            OPERATION(S)    1ST ASST
-                 PRIORITY                                 2ND ASST
- ======================================================
- 6/22/07  CPRSPT,O  THORACIC             CPRSSURG,O  GENERAL
- 000001  000-00-0001 left vats w wedge   CPRS1ASST,O  OP TIME: 89 MIN
-                ELECTIVE
- 6/22/07  CPRSPT,T   VASCULAR SUR   CPRSSURG,T   MONITOR ANES
- 000002  000-00-0002 removal foreign...  CPRS1ASST,T  OP TIME: 61 MIN
-                EMERG                                      CPRS2ASST,O
- TOTAL CASES 2

## SURGERY FILE

**List of Operations (Fileman)**
**SURGERY**
- DIVISION   COLUMBIA, MO VAMC
- SURGERY SPECIALTY - ALPHABETIC
- DATE OF OPERATION
**PRINT**
- SURGERY SPECIALTY
- PATIENT
- SURGEON
- DATE OF OPERATION

## SURGERY FILE

- List of Operations
- SPECIALTY           PATIENT      SURGEON          DATE OF OPERATION
- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------
- GEN SURG           CPRSPT,T     CPRSSURG,T      JUN 21,2007  08:00
- GEN SURG           CPRSPT,T     CPRSSURG,T      JUN 22,2007  08:35
- GEN SURG           CPRSPT,F     CPRSSURG,T      JUN 22,2007  10:23
- OPHTHALMOL      CPRSPT,F    CPRSSURG,F      JUN 21,2007  07:40
- OPHTHALMOL      CPRSPT,S    CPRSSURG,F      JUN 21,2007  08:40
- OPHTHALMOL      CPRSPT,S    CPRSSURG,F      JUN 21,2007  09:40
- THORACIC            CPRSPT,E    CPRSSURG,S      JUN 22,2007  08:05
- THORACIC            CPRSPT,N    CPRSSURG,S      JUN 22,2007  11:47
- UROLOGY             CPRSPT,T    CPRSSURG,N      JUN 21,2007  07:33
- UROLOGY             CPRSPT,E    CPRSSURG,N      JUN 21,2007  11:23
- UROLOGY             CPRSPT,T    CPRSSURG,N      JUN 22,2007  08:15
- VASCULAR           CPRSPT,T     CPRSSURG,T      JUN 22,2007  14:45

## SURGERY FILE

- List of Operations – Fileman & Menu Option
- SPECIALTY           PATIENT      SURGEON          DATE OF OPERATION
- ------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------
- GEN SURG           CPRSPT,T     CPRSSURG,T      JUN 21,2007  08:00
- GEN SURG           CPRSPT,T     CPRSSURG,T      JUN 22,2007  08:35
- GEN SURG           CPRSPT,F     CPRSSURG,T      JUN 22,2007  10:23
- ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- DATE      PATIENT    SERVICE              SURGEON          ANESTH
- CASE#    SSN            OPERATION(S)    1ST ASST
-                 PRIORITY                                 2ND ASST
- ======================================================
- 6/22/07  CPRSPT,T   VASCULAR SUR   CPRSSURG,T   MONITOR ANES
- 000002  000-00-0002 removal foreign...  CPRS1ASST,T  OP TIME: 61 MIN
-                EMERG                                      CPRS2ASST,O

## SURGERY FILE

- VistA Menu Options:
- PCE FILING STATUS REPORT
- JUN 18, 2007   CPRSPT,O  000-00-0001  (59)    NOT FILED
- 00000001          THORACIC                                   <NONE>
-                            ESOPHAGEAL ...
- JUN 18, 2007    CPRSPT,T  000-00-0002  (82)    NOT FILED
- 00000002         UROLOGY                                    <NONE>
-                            remove penile im...
- JUN 18,2007@0735  CPRSPT,T 000-00-0003 (73)  FILED
-  0000003           UROLOGY                                     CHECKED OUT
-                            transurethral resect...

## SURGERY FILE

- VistA Menu Options:
- COMPLETED CASES MISSING CPT CODES
- JUN 18, 2007   CPRSPT,F  (000-00-0004)        CPRSSURG,O
- 00000004
-                             LAPAROSCOPIC RIGHT HMICOLECTOMY
- JUN 18, 2007   CPRSPT,F   (000-00-0005)       CPRSSURG,O
- 00000005
-                             excision of rectal carcinoid...
- JUN 18, 2007    CPRSPT,S   (000-00-0006)     CPRSSURG,T
- 00000006
-                              placement of portacath

## SURGERY FILE

- Another File to be aware of:
**SURGERY PROCEDURE/DIAGNOSIS CODES** File
- Contains the final procedure (CPT) codes and diagnosis (ICD9) codes for each completed case in the SURGERY file (#130).
- 35 Fields
- Surgery Case
**Principal Procedure Code **
**Prin Postop Diagnoses Code**
**Coding Completed By **
**Date Coding Completed**

## SURGERY FILE

**Surgical Coding Completion (Fileman)**
**Surgery File**
- SORT BY: NUMBER// .09  DATE OF OPERATION
- START WITH DATE OF OP.: FIRST// 6-8  (JUN 08, 2007)
- GO TO DATE OF OP.: LAST// 6-8  (JUN 08, 2007)
-   WITHIN DATE OF OPERATION, SORT BY: @DIVISION
-   START WITH DIVISION: FIRST// COLUMBIA, MO VAMC
-   GO TO DIVISION: LAST// COLUMBIA, MO VAMC

## SURGERY FILE

- Surgical Coding Completion
- Print
- FIRST PRINT FIELD: .01  PATIENT
- THEN PRINT FIELD: .09  DATE OF OPERATION
- THEN PRINT FIELD: **SURGERY PROCEDURE/DIAGNOSIS CODES:**
-  By 'SURGERY PROCEDURE', do you mean the SURGERY PROCEDURE/DIAGNOSIS CODES File, pointing via its 'SURGERY CASE' Field? Yes// **N  (No)**
-  By 'SURGERY PROCEDURE', do you mean the SURGERY PROCEDURE/DIAGNOSIS CODES File, pointing via its 'SURGERY CASE' Field ("B" Cross-reference)? **Yes//   (Yes)**

## SURGERY FILE

- Surgical Coding Completion
- Print
- THEN PRINT **SURGERY PROCEDURE/DIAGNOSIS CODES FIELD:** .03  PRIN POSTOP DIAGNOSIS CODE
- THEN PRINT SURGERY PROCEDURE/DIAGNOSIS CODES FIELD: 11  CODING COMPLETED BY  (multiple)
- THEN PRINT CODING COMPLETED BY SUB-FIELD: .01 **CODING COMPLETED BY**
- THEN PRINT CODING COMPLETED BY SUB-FIELD: 1 **DATE CODING COMPLETED**

## SURGERY FILE

- PATIENT      DATE OF OP       PRIN DX        CODER                 DATE CODED
- ---------------------------------------------------------------------------------------------------------
- CPRSPT,O    JUN 18,2007
- CPRSPT,T    JUN 18,2007
- CPRSPT,T    JUN 18,2007  07:35     185.       CPRSCODER,O     JUN 21,2007  12:10
- CPRSPT,F    JUN 18,2007  07:58     530.0     CPRSCODER,O     JUN 21,2007  12:38
- CPRSPT,F    JUN 18,2007  08:30     728.87   CPRSCODER,O     JUN 21,2007  13:05
- CPRSPT,S    JUN 18,2007  10:05     354.0     CPRSCODER,O     JUN 21,2007  12:26
- CPRSPT,S    JUN 18,2007  10:10     550.90   CPRSCODER,O     JUN 21,2007  13:18
- CPRSPT,E    JUN 18,2007  11:23     728.6     CPRSCODER,O     JUN 21,2007  13:14
- CPRSPT,N   JUN 18,2007  12:51     934.8     CPRSCODER,O     JUL  2,2007  09:58
- CPRSPT,T    JUN 18,2007  13:00
- CPRSPT,E    JUN 18,2007  13:30     354.0     CPRSCODER,O     JUN 21,2007  13:16

## VistA Files – The Building Blocks of  CPRS

- The data from the **VistA Surgery Files** are in the CPRS Surgery Tab
- 		Anesthesia Report
- 		Operative Report
- 		Nurse Intraoperative Report

## VistA Files – The Building Blocks of  CPRS

- Summary
**Reviewed VistA File Organization**
- Files
- Fields
- Menu Options
- Fileman Options

## VistA Files – The Building Blocks of  CPRS

**Looked Specifically at:**
- New Person File
- TIU Document File
- Hospital Location File
- Surgery File

- Patient File
- PTF File
- Patient Movement File
- V Files

## VistA Files – The Building Blocks of  CPRS

**?**