Files > PAI EXTRACT

name

PAI EXTRACT

number

727.823

location

^ECX(727.823,

description

This file contains data elements as specified by the Decision Support System (DSS) Program Office for the Patient Assessment Instrument (PAI) extract from existing DHCP files. Entries into this file are made by extracting data from the PAF file (#45.9). Once approved by the DSS site manager, entries in this file are loaded into an electronic mail message and sent to the commercial vendor. This file is intended to be used for validation purposes only. Entries should be made only by the extract load routine. Since validation techniques will be determined by the local site, it is intended that the site add whatever cross references deemed necessary. However, this file contains one nationally determined cross reference, the "AC" cross reference on the EXTRACT NUMBER field (#2). This cross reference is used by the DSS Extracts software package as an essential feature for managing and purging data in this file and should not be modified. This file should NOT be modified directly using VA FileMan.

Fields

#	Name	Location	Type	Details	Index	Description
.01	sequence number(+)	0;1	NUMERIC			The record number for this extract entry.
1	year month	0;2	FREE TEXT			A six character numeric string representing the year and the month for which this extract was performed.
2	extract number	0;3	POINTER	727	AC	The corresponding entry in the DSS EXTRACT LOG file (#727) for this extract.
3	facility	0;4	FREE TEXT			Identifies the facility for this extract record.
4	patient no. - dfn	0;5	POINTER	2		An identifying number for the patient at the local site.
5	ssn	0;6	FREE TEXT			The patient's social security number. Any patient with an SSN beginning with "00000" is considered a "test patient" and will not be included in the extract.
6	name	0;7	FREE TEXT			The first four characters of the patient's last name.
7	in out patient indicator	0;8	POINTER	40.9		Indicates whether the patient was an inpatient or an outpatient for this extract entry.
8	day	0;9	FREE TEXT			A 6-character numeric string that represents tha date on which the patient classification occurred.
9	admission date(+)	0;10	FREE TEXT			This 8-character string represents the date on which the patient Admission took place.
10	admission time	0;11	FREE TEXT			A 6-character numeric string that represents the time of day at which the patient Admission occurred.
11	transfer/admission date	0;12	FREE TEXT			An 8-character numeric string that represents the date on which the patient was admitted or transferred to the long-term ward.
12	transfer/admission time	0;13	FREE TEXT			A 6-character numeric string that represents the time of day at which the patient's admission or transfer to the long-term ward occurred.
13	race	0;14	FREE TEXT			Race ABBREVIATION for this patient.
14	master patient index	1;1	FREE TEXT			A national VA system identifier which uniquely identifies a patient.
15	dss dept.	1;2	FREE TEXT			The DSS Department Code for the patient care product.
16	dom,prrtp and saartp indicator	1;3	FREE TEXT			DOM, PRRTP and SAARTP Indicator indicates if the patient is admitted to either a DOM, PRRTP or SAARTP at the time hospital service is provided. Domiciliary (DOM) Psychiatric Residential Rehabilitation Treatment Program (PRRTP) Substance Abuse Residential Rehabiltation Treatment Program (SARRTP)
17	extended op indicator	1;4	FREE TEXT			Indicates that a patient is an Extended Outpatient.