Encounters Cube Manual .gov



Cube: Encounters

Information Included:

All outpatient visits at each facility in the VISN. The visits included are direct outpatient and clinic visits, as well as inpatient encounters with providers of care. Date range for the cube is October 2007 thru February 2010. Information was obtained from Workload table in the data warehouse, which corresponds to file 9000010 (Visit) in VISTA.

Information Excluded:

Any patient whose last name begins with ‘ZZ’.

Any patient with the first or last name of ‘TEST’.

Cube Measures

|Measures |Description |

|Number of Clinic Stops |Number of Clinic Stops where the patient was seen. |

|Number of Procedures |Number of outpatient procedures performed. |

| |VISTA File: 9000010.18/ 81 File Name: CPT FLD NUMBER: .01 |

|Number of Diagnosis |Number of outpatient diagnoses. |

| |VISTA File: 9000010.07/ 80 File Name: POV FLD NUMBER: .01 POINTS TO: VISTA ICD DIAGNOSIS file |

|Number of Visits |Number of outpatient visits. |

|Unique Provider Count |Count of unique providers across the VISN based on the VID identifier found in the VStaff |

| |table. |

|Unique Patient Count |Count of unique patient across the VISN based on the VID identifier found in the VPatient |

| |table. |

 

 Cube Dimensions

|Dimensions |Levels |Description |

|ICD |Icd |ICD code group by number. |

| | |VISTA File: 80 File Name: CODE NUMBER FLD NUMBER: .01 |

| |Icddiag |(ICD code number) + ICD code name |

| | |VISTA File: 80 File Name: DIAGNOSIS FLD NUMBER: 3 |

|CPT |Major Diagnostic Category |Major procedure heading. |

| |Cpt category |VISTA File: 81 Field: 1 |

| |Cptshort List |Category of procedure. |

| | |VISTA File: 81 File Name: CPT CATEGORY FLD NUMBER: 3 |

| | |(CPT code number) + CPT code name |

| | |VISTA File: 81 File Name: SHORT NAME FLD NUMBER: 2 |

| | |VISTA File: 81 File Name: CPT CODE FLD NUMBER: .01 |

|Clinic Stop |Clinic Stop | Clinic Stop where patient was seen on outpatient visit. |

| | |VISTA File: 9000010 Field: 0.08 |

| |Location |Location within clinic where patient was seen on outpatient |

| | |visit. |

| | |VISTA File: 9000010 Field Name: 0.22 |

|PrimSecDiag |Primary |Was the diagnosis primary or secondary |

| |Secondary |VISTA File: 9000010.07 File Name: PRIMARY/SECONDARY FLD |

| | |NUMBER: .12 |

|PrimSecProv |Primary OP Prov |Primary or Secondary Outpatient Provider. |

| |Secondary OP Prov |VISTA File: 9000010.06 File Name: PRIMARY/SECONDARY FLD |

| | |NUMBER: .04 |

|Patient Gender |Gender |Sex of the Patient |

| | |VISTA File: 2 Field Name: SEX FLD NUMBER: .02 |

|Patient Demographic |Ethnic Background |Ethnic background of the patient. |

| | |VISTA File: 13-Feb Field Name: Race FLD NUMBER |

|Patient Geographic |State |State and county where the patient lives. |

| |County |VISTA File: 2 Field Name: COUNTY FLD NUMBER: |

| |  |VISTA File: 2 Field Name: STATE FLD NUMBER: .115 |

| |Zip Code |VISTA File: 2 Field Name: ZIPCODE FLD NUMBER: .116 |

|Patients |Site Name |Station where the Visit occurred |

| |Patient |Local Field based on Individual Site Number (e..g. 663) |

| | |Patient who received care for the Visit |

| | |VISTA File: 9000010 File Name: PATIENT NAME FLD NUMBER: 0.05|

| | |POINTS TO: 9000001.0 |

|Providers |Site Name |Station where the Visit occurred |

| |Provider |Local Field based on Individual Site Number (e..g. 663) |

| | |Provider who is the responsible care giver for the Visit |

| | |VISTA File: 9000010.06 File Name: PROVIDER FLD NUMBER: 0.01 |

| | |POINTS TO: NEW PERSON file - ^VA(200, |

|Visn20 |Alliance |Alliance where the Visit occurred |

| |Station |Local Field based on Individual Site Number (e..g. 663) |

| | |Station where the Visit occurred |

| | |Local Field based on Individual Site Number (e..g. 663) |

|Time.Calendar_Year |Year |Calendar year, quarter, month the visit occurred Fiscal |

|Time.Fiscal_Year |Quarter |year, quarter, month the visit occurred |

| |Month |VISTA File: 9000010 Field Name: Visit/Admit Date&Time Fld |

| | |Number: .01 |

|Patient Age |Age Range |Age range of the patient when the visit occurred. |

| | |VISTA File: 2 Field Name: Date of Birth FLD NUMBER: .03 |

| | |VISTA File: 9000010 Field Name: Visit/Admit Date&Time Fld |

| | |Number: .01 |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download