STANDARD DATA DICTIONARY #727.823 -- PAI EXTRACT FILE 3/24/25 PAGE 1
STORED IN ^ECX(727.823, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 3.0)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
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.
COMPILED CROSS-REFERENCE ROUTINE: ECX823
CROSS
REFERENCED BY: EXTRACT NUMBER(AC)
727.823,.01 SEQUENCE NUMBER 0;1 NUMBER (Required)
Sequence Number
INPUT TRANSFORM: K:+X'=X!(X>999999999)!(X<1)!(X?.E1"."1N.N) X S:$D(X) DINUM=X
LAST EDITED: AUG 12, 1998
HELP-PROMPT: Enter a number between 1 and 999999999, 0 decimal digits.
DESCRIPTION:
The record number for this extract entry.
TECHNICAL DESCR:
The internal entry number (IEN) for this record. This entry is DINUMed.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
727.823,1 YEAR MONTH 0;2 FREE TEXT
Year/Month
INPUT TRANSFORM: K:$L(X)>6!($L(X)<6)!'(X?6N) X
OUTPUT TRANSFORM: S Y=$$ECXYMX^ECXUTL(Y)
LAST EDITED: SEP 24, 1997
HELP-PROMPT: Answer must be 6 characters in length.
DESCRIPTION: A six character numeric string representing the year and the month for which this extract was
performed.
TECHNICAL DESCR:
Format is YYYYMM; Year 2000 compliant per vendor.
727.823,2 EXTRACT NUMBER 0;3 POINTER TO DSS EXTRACT LOG FILE (#727)
Extract Number
LAST EDITED: OCT 08, 1996
HELP-PROMPT: Enter the extract number for this extract.
DESCRIPTION:
The corresponding entry in the DSS EXTRACT LOG file (#727) for this extract.
TECHNICAL DESCR: A pointer to the DSS EXTRACT LOG file (#727). The primary purpose is to pick up the header for the
mail message.
CROSS-REFERENCE: 727.823^AC
1)= S ^ECX(727.823,"AC",$E(X,1,30),DA)=""
2)= K ^ECX(727.823,"AC",$E(X,1,30),DA)
3)= DO NOT DELETE.
This cross reference is essential for managing and purging data in this file.
727.823,3 FACILITY 0;4 FREE TEXT
Facility
INPUT TRANSFORM: K:$L(X)>7!($L(X)<1) X
LAST EDITED: OCT 14, 1996
HELP-PROMPT: Enter the station number where this extract was performed.
DESCRIPTION:
Identifies the facility for this extract record.
TECHNICAL DESCR:
For the PAI extract, the FACILITY field is null.
727.823,4 PATIENT NO. - DFN 0;5 POINTER TO PATIENT FILE (#2)
Patient No. - DFN
LAST EDITED: OCT 15, 1996
HELP-PROMPT: Enter the name of the patient for this extract record.
DESCRIPTION:
An identifying number for the patient at the local site.
TECHNICAL DESCR: Derived from the NAME field (.01) in the PAF file (#45.9). NAME is a pointer to the PATIENT file
(#2). This data represents the patient DFN.
727.823,5 SSN 0;6 FREE TEXT
Social Security Number
INPUT TRANSFORM: K:$L(X)>10!($L(X)<9)!'(X?9N!X?9N1"P") X
LAST EDITED: OCT 08, 1996
HELP-PROMPT: Your answer must be 9 to 10 characters in length.
DESCRIPTION: 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.
TECHNICAL DESCR: Using the patient pointer (DFN) stored in the PATIENT NO. - DFN field (4) in the PAI EXTRACT file
(#727.823), SSN data is derived from the SOCIAL SECURITY NUMBER field (.09) in the PATIENT file
(#2).
"Test" patient status is determined in PAT^ECXUTL3. Any patient with an SSN beginning with "00000"
will not be included in the extract.
727.823,6 NAME 0;7 FREE TEXT
Name
INPUT TRANSFORM: K:$L(X)>4!($L(X)<4) X
LAST EDITED: OCT 08, 1996
HELP-PROMPT: Your answer must be 4 characters in length.
DESCRIPTION:
The first four characters of the patient's last name.
TECHNICAL DESCR: Using the patient pointer (DFN) stored in the PATIENT NO. - DFN field (4) in the PAI EXTRACT file
(#727.823), NAME data is derived from the NAME field (.01) in the PATIENT file (#2). The first four
characters of the first "," piece are used, padded with trailing spaces if necessary.
727.823,7 IN OUT PATIENT INDICATOR 0;8 POINTER TO LOCATION TYPE FILE (#40.9)
In Out Patient Indicator
LAST EDITED: OCT 08, 1996
HELP-PROMPT: Enter the appropriate inpatient or outpatient indicator.
DESCRIPTION:
Indicates whether the patient was an inpatient or an outpatient for this extract entry.
TECHNICAL DESCR: For the PAI extract this field is set to 3, indicating inpatient status in the LOCATION TYPE file
(#40.9).
727.823,8 DAY 0;9 FREE TEXT
Day
INPUT TRANSFORM: K:$L(X)>8!($L(X)<8) X
OUTPUT TRANSFORM: S Y=$$ECXDATEX^ECXUTL(Y)
LAST EDITED: SEP 24, 1997
HELP-PROMPT: Answer must be 8 characters in length.
DESCRIPTION:
A 6-character numeric string that represents tha date on which the patient classification occurred.
TECHNICAL DESCR: Data source:
PAF file (#45.9); ASSESSMENT DATE field (#2)
This field is always exactly 8 numeric characters in length. The format is YYYYMMDD; for example,
19970923. If the date cannot be determined, then a default is used. The default date value is the
value of the YEAR MONTH field (#1) concatenated with "01" for the day (DD) portion. Year 2000
compliant per vendor.
727.823,9 ADMISSION DATE 0;10 FREE TEXT (Required)
Admission Date
INPUT TRANSFORM: K:$L(X)>8!($L(X)<8) X
OUTPUT TRANSFORM: S Y=$$ECXDATEX^ECXUTL(Y)
LAST EDITED: SEP 24, 1997
HELP-PROMPT: Answer must be 8 characters in length.
DESCRIPTION:
This 8-character string represents the date on which the patient Admission took place.
TECHNICAL DESCR: DATE. Data source:
PAF file (#45.9); DATE OF ADMISSION/TRANSFER IN field (#7)
then to PATIENT MOVEMENT file (#405); DATE/TIME field (#.01)
This field is always exactly 8 numeric characters in length. The format is YYYYMMDD; for example,
19970923. If the date cannot be determined, then a default is used. The default date value is the
value of the YEAR MONTH field (#1) concatenated with "01" for the day (DD) portion. Year 2000
compliant per vendor.
727.823,10 ADMISSION TIME 0;11 FREE TEXT
Admission Time
INPUT TRANSFORM: K:$L(X)>6!($L(X)<6) X
OUTPUT TRANSFORM: S Y=$$ECXTIMEX^ECXUTL(Y,0)
LAST EDITED: SEP 24, 1997
HELP-PROMPT: Answer must be 6 characters in length.
DESCRIPTION: A 6-character numeric string that represents the time of day at which the patient Admission
occurred.
TECHNICAL DESCR: Derived by using the DATE OF ADMISSION/TRANSFER IN field (7) in the PAF file (#45.9) to find the
corresponding admission in the PATIENT MOVEMENT file (#405). The TIME portion of the DATE/TIME
field (.01) for that admission in the PATIENT MOVEMENT file (#405) is the ADMISSION TIME, padded
with trailing zeroes to six digits. Data source:
PAF file (#45.9); DATE OF ADMISSION/TRANSFER IN field (#7)
then to PATIENT MOVEMENT file (#405); DATE/TIME field (#.01)
This field is always exactly 6 numeric characters in length; if time cannot be determined, then
"000300" is used as default.
727.823,11 TRANSFER/ADMISSION DATE 0;12 FREE TEXT
Transfer/Admission Date
INPUT TRANSFORM: K:$L(X)>8!($L(X)<8) X
OUTPUT TRANSFORM: S Y=$$ECXDATEX^ECXUTL(Y)
LAST EDITED: SEP 24, 1997
HELP-PROMPT: Answer must be 8 characters in length.
DESCRIPTION: An 8-character numeric string that represents the date on which the patient was admitted or
transferred to the long-term ward.
TECHNICAL DESCR: Data source:
PAF file (#45.9); DATE OF ADMISSION/TRANSFER in field (#7)
This field is always exactly 8 numeric characters in length. The format is YYYYMMDD; for example,
19970923. If the date cannot be determined, then a default is used. The default date value is the
value of the YEAR MONTH field (#1) concatenated with "01" for the day (DD) portion. Year 2000
compliant per vendor.
727.823,12 TRANSFER/ADMISSION TIME 0;13 FREE TEXT
Transfer/Admission Time
INPUT TRANSFORM: K:$L(X)>6!($L(X)<6) X
OUTPUT TRANSFORM: S Y=$$ECXTIMEX^ECXUTL(Y,0)
LAST EDITED: SEP 24, 1997
HELP-PROMPT: Answer must be 6 characters in length.
DESCRIPTION: 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.
TECHNICAL DESCR: Data source:
PAF file (#45.9); DATE OF ADMISSION/TRANSFER in field (#7)
This field is always exactly 6 numeric characters in length; if time cannot be determined, then
"000300" is used as default.
727.823,13 RACE 0;14 FREE TEXT
Race
INPUT TRANSFORM: K:$L(X)>1!($L(X)<1) X
LAST EDITED: OCT 15, 1996
HELP-PROMPT: Enter race ABBREVIATION for this patient.
DESCRIPTION:
Race ABBREVIATION for this patient.
TECHNICAL DESCR: Using the patient pointer (DFN) stored in the PATIENT NO. - DFN field (4), RACE data is shown as
the ABBREVIATION field (2) of the RACE file (#10) entry pointed to by the RACE field (.06) in the
PATIENT file (#2).
727.823,14 MASTER PATIENT INDEX 1;1 FREE TEXT
INPUT TRANSFORM: K:$L(X)>10!($L(X)<1) X
LAST EDITED: MAY 04, 1999
HELP-PROMPT: Answer must be 1-10 characters in length.
DESCRIPTION:
A national VA system identifier which uniquely identifies a patient.
TECHNICAL DESCR: The source is not known at this time, but will likely become available in an FY2000 enhancement to
the Vista system.
727.823,15 DSS DEPT. 1;2 FREE TEXT
INPUT TRANSFORM: K:$L(X)>10!($L(X)<4) X
LAST EDITED: MAY 06, 1999
HELP-PROMPT: Answer must be 4-10 characters in length.
DESCRIPTION:
The DSS Department Code for the patient care product.
TECHNICAL DESCR:
A free text field of 4-10 characters; data not yet available. Field is set to null.
727.823,16 DOM,PRRTP AND SAARTP INDICATOR 1;3 FREE TEXT
INPUT TRANSFORM: K:$L(X)>1!($L(X)<1) X
LAST EDITED: OCT 10, 2000
HELP-PROMPT: Answer must be 1 character in length. DOM, PRRTP and SARTP Indicator indicates the patient status
at the time of hospital service.
DESCRIPTION: 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)
727.823,17 EXTENDED OP INDICATOR 1;4 FREE TEXT
INPUT TRANSFORM: K:$L(X)>4!($L(X)<1) X
LAST EDITED: JUN 14, 2000
HELP-PROMPT: Answer must be 1-4 characters in length. This field has yet to be defined by BTSO.
DESCRIPTION:
Indicates that a patient is an Extended Outpatient.
FILES POINTED TO FIELDS
DSS EXTRACT LOG (#727) EXTRACT NUMBER (#2)
LOCATION TYPE (#40.9) IN OUT PATIENT INDICATOR (#7)
PATIENT (#2) PATIENT NO. - DFN (#4)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):