STANDARD DATA DICTIONARY #727.805 -- NURSING EXTRACT FILE 3/24/25 PAGE 1
STORED IN ^ECX(727.805, *** 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 Nursing extract from
existing DHCP files. Entries into this file are made by extracting data from several files. 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: ECX805
CROSS
REFERENCED BY: EXTRACT NUMBER(AC)
727.805,.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.805,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 string representing the year and the month for which this extract was performed.
TECHNICAL DESCR:
Format is YYYYMM; Year 2000 compliant per vendor.
727.805,2 EXTRACT NUMBER 0;3 POINTER TO DSS EXTRACT LOG FILE (#727)
Extract Number
LAST EDITED: AUG 15, 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.805^AC
1)= S ^ECX(727.805,"AC",$E(X,1,30),DA)=""
2)= K ^ECX(727.805,"AC",$E(X,1,30),DA)
3)= DO NOT DELETE.
This cross reference is essential for managing and purging data in this file.
727.805,3 FACILITY 0;4 FREE TEXT
Facility
INPUT TRANSFORM: K:$L(X)>7!($L(X)<1) X
LAST EDITED: OCT 17, 1996
HELP-PROMPT: Enter the station number where this extract was performed.
DESCRIPTION:
Identifies the facility for this extract record.
TECHNICAL DESCR: An indicator of the division where this event happened. Using the NAME field (.01) pointer from the
DSS EXTRACTS file (#728), FACILITY is derived from the STATION NUMBER field (99) for that pointer
number in the INSTITUTION file (#4).
727.805,4 PATIENT NO. - DFN 0;5 POINTER TO PATIENT FILE (#2)
Patient No. - DFN
LAST EDITED: OCT 17, 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: Pointer to the NAME field (.01) of the PATIENT file (#2). This data represents the patient DFN.
PATIENT NO. - DFN data is derived from the NAME field (.02) of the NURS CLASSIFICATION file
(#214.6).
727.805,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: AUG 15, 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 NURSING EXTRACT
file (#727.805), 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.805,6 NAME 0;7 FREE TEXT
Name
INPUT TRANSFORM: K:$L(X)>4!($L(X)<4) X
LAST EDITED: AUG 15, 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 NURSING EXTRACT
file (#727.805), 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.805,7 IN OUT PATIENT INDICATOR 0;8 FREE TEXT
In Out Patient Indicator
INPUT TRANSFORM: K:$L(X)>1!($L(X)<1) X
LAST EDITED: NOV 28, 2001
HELP-PROMPT: Answer must be 1 character in length.
DESCRIPTION:
Indicates whether the patient was an inpatient or an outpatient for this extract entry.
TECHNICAL DESCR: This field formerly contained the pointer to the LOCATION TYPE file (#40.9) which was either
1=Outpatient or 3=Inpatient. Pointing to this file has become obsolete, and in FY2002 this field
has been changed to free text and will contain "O"=Outpatient or "I"=Inpatient.
727.805,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:
This 8-character string represents the date on which the Nursing classification was done.
TECHNICAL DESCR: Data source:
NURS CLASSIFICATION file (#214.6); CLASSIFICATION 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.805,9 ACUITY LEVEL 0;10 FREE TEXT
Acuity Level
INPUT TRANSFORM: K:$L(X)>1!($L(X)<1)!'("ABCDEFGHP12345"[X) X
LAST EDITED: AUG 15, 1996
HELP-PROMPT: Your answer must be 1 character in length.
DESCRIPTION:
The patient's current Nursing AMIS classification or acuity rating.
TECHNICAL DESCR:
ACUITY LEVEL is derived from the CATEGORY field (1) in the NURS CLASSIFICATION file (#214.6).
727.805,10 ENTERED BY 0;11 SET
Entered By
'C' FOR COMPUTER;
'U' FOR USER;
LAST EDITED: AUG 15, 1996
HELP-PROMPT: Enter C if computer generated, or U if user generated.
DESCRIPTION:
Enter C if the classification was computer generated, or U if it was user (RN) generated.
TECHNICAL DESCR:
ENTERED BY is derived from the ENTERED BY field (3) in the NURS CLASSIFICATION file (#214.6).
727.805,11 CLASSIFIER 0;12 POINTER TO NEW PERSON FILE (#200)
Classifier
LAST EDITED: AUG 15, 1996
HELP-PROMPT: Enter the name of the person who made the classification.
DESCRIPTION:
Identifies the person making the classification. Pointer to the NEW PERSON FILE (#200)
TECHNICAL DESCR:
CLASSIFIER is derived from the CLASSIFIER field (4) in the NURS CLASSIFICATION file (#214.6).
727.805,12 NURSE LOCATION 0;13 POINTER TO NURS LOCATION FILE (#211.4)
Nurse Location
LAST EDITED: AUG 15, 1996
HELP-PROMPT: Enter the ward on which the patient is classified.
DESCRIPTION:
Ward on which the patient is classified. Points to the NURS LOCATION file (#211.4).
TECHNICAL DESCR: NURSE LOCATION is derived from the NURS LOCATION field (6) in the NURS CLASSIFICATION file (#214.6)
which is a pointer to the NURS LOCATION file (#211.4).
727.805,13 NURSING BEDSECTION 0;14 POINTER TO NURS AMIS WARD FILE (#213.3)
Nursing Bedsection
LAST EDITED: AUG 15, 1996
HELP-PROMPT: Enter the nursing bedsection for which the patient is classified.
DESCRIPTION:
Nursing bedsection for which the patient is classified. Points to the NURS AMIS WARD file (#213.3).
TECHNICAL DESCR: NURSING BEDSECTION is derived from the NURSING BED SECTION field (7) in the NURS CLASSIFICATION
file (#214.6) which is a pointer to the NURS AMIS WARD file (#213.3).
727.805,14 MOVEMENT FILE # 0;15 POINTER TO PATIENT MOVEMENT FILE (#405)
Movement File Number
LAST EDITED: AUG 15, 1996
HELP-PROMPT: Enter the patient movement number associated with this extract record.
DESCRIPTION:
Current patient movement record associated with this extract record.
TECHNICAL DESCR: A call to IN5^VADPT (using the patient IEN and the event date) returns a patient movement number
(indicating inpatient status). This field is set to the value of VAIP(1), which is a pointer to the
PATIENT MOVEMENT file (#405).
727.805,15 TREATING SPECIALTY 0;16 FREE TEXT
Treating Specialty
INPUT TRANSFORM: K:$L(X)>3!($L(X)<2) X
LAST EDITED: NOV 03, 2009
HELP-PROMPT: Answer must be 2-3 characters in length
DESCRIPTION:
The PTF CODE of the treating specialty associated with this extract record.
TECHNICAL DESCR: This field is initialized to a null, indicating an outpatient status. If a call to IN5^VADPT (using
the patient IEN and the event date) returns a patient movement number (indicating inpatient
status), then the value of VAIP(8), which is the pointer to the FACILITY TREATING SPECIALTY file
(#45.7), is used to get the SPECIALTY field (1) which points to the SPECIALTY file (#42.4). Then,
the PTF Code (field #7 of file 42.4) is obtained and stored instead of the IEN of the specialty.
727.805,16 ADMISSION DATE 0;17 FREE TEXT
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 admission for this patient occurred.
TECHNICAL DESCR: Data source:
NURS CLASSIFICATION file (#214.6); NAME field (#.02)
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.805,17 ADMISSION TIME 0;18 FREE TEXT
Admission Time
INPUT TRANSFORM: K:$L(X)>6!($L(X)<6)!'(X?6N) 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 which represents the time of day at which the patient admission
occurred.
TECHNICAL DESCR: Data source:
NURS CLASSIFICATION file (#214.6); NAME field (#.02)
then to PATIENT MOVEMENT file (#405); DATE/TIME field (#.01)
Format is YYYYMMDD; Year 2000 compliant per vendor.
727.805,18 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.805,19 DSS PRODUCT DEPARTMENT 1;2 FREE TEXT
INPUT TRANSFORM: K:$L(X)>10!($L(X)<1) X
LAST EDITED: MAR 02, 2004
HELP-PROMPT: Answer must be 1-10 characters in length.
DESCRIPTION:
The nationally defined DSS Intermediate Department Number designated to the Nursing care product.
TECHNICAL DESCR: DSS PRODUCT DEPARTMENT field value is determined via the following process: The DSS Product
Department and IP Number File # 727.6 is populated via site specific HL7 messages generated by AAC
extracts which run on a monthly basis. The file is then used by the DSS extract routines to
identify and to populate the DSS PRODUCT DEPARTMENT and DSS IP# fields in the DSS extract files
before transmitting them to AAC.
Using the combination of Feeder System, Feeder Location and Feeder Key as an identifier for each
individual record matches are resolved and the designations are made. If no match is found in file
727.6 an error message is generated and a bulletin is triggered and sent to a DSS mail group
identifying the problem.
727.805,20 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.805,21 OBSERVATION PATIENT INDICATOR 1;4 FREE TEXT
INPUT TRANSFORM: K:$L(X)>4!($L(X)<1) X
LAST EDITED: AUG 14, 2001
HELP-PROMPT: Answer must be 1-4 characters in length.
DESCRIPTION: This field is derived from the inpatient/outpatient status, treating specialty, and DSS Identifier
or feeder key values in the record.
727.805,22 ENCOUNTER NUMBER 1;5 FREE TEXT
INPUT TRANSFORM: K:$L(X)>18!($L(X)<1) X
LAST EDITED: MAY 03, 2001
HELP-PROMPT: Answer must be 1-18 characters in length
DESCRIPTION: This field is derived from the inpatient/outpatient status, SSN, admit/visit date, treating
specialty, observation patient indicator, and DSS Identifier or feeder key values in the record.
727.805,23 PRODUCTION DIVISION CODE 1;6 FREE TEXT
INPUT TRANSFORM: K:$L(X)>6!($L(X)<3) X
LAST EDITED: AUG 12, 2002
HELP-PROMPT: Answer must be 3-6 characters in length.
DESCRIPTION: Data represents the medical center division the work was performed in. This field corresponds to
an entry in the INSTITUTION file (#4).
TECHNICAL DESCR:
Data comes from the STATION NUMBER field (#99) of the INSTITUTION file (#4).
727.805,24 DSS IP # 1;7 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: NOV 13, 2003
HELP-PROMPT: Type a Number between 1 and 9999999, 0 Decimal Digits
DESCRIPTION:
The nationally defined DSS Intermediate Product Number designated to the patient care product.
TECHNICAL DESCR: DSS IP# field value is determined via the following process: The DSS PRODUCT DEPARTMENT AND IP
NUMBER file (#727.6) is populated via site specific HL7 messages generated by AAC extracts which
run on a monthly basis. The file is then used by the DSS extract routines to identify and to
populate the DSS PRODUCT DEPARTMENT and DSS IP # fields in the DSS extract files before
transmitting them to AAC. Using the combination of Feeder System, Feeder Location and Feeder Key as
an identifier for each individual record does the matches. If no match is found an error message
is generated and a bulletin is triggered and sent to a DSS mail group identifying the problem.
727.805,25 PATCAT 1;8 SET
'AD' FOR Active Duty;
'ADD' FOR Active Duty Dependent;
'FNRS' FOR Former Non-Remarried Spouse;
'RET' FOR Retired;
'RETD' FOR Retiree Dependent;
'RES' FOR Reservist;
'REC' FOR Recruit;
'TDRL' FOR Temporary Disability;
'TFL' FOR TRICARE for Life;
LAST EDITED: SEP 03, 2010
HELP-PROMPT: Select the Patient's Category for the FHCC Reconciliation process.
DESCRIPTION: This is the Patient's category which will be used for FHCC (Federal Health Care Center)
Reconciliation. DSS must capture and report DoD patients so that the FHCC reconciliation process
can function as designed. "Reconciliation" is the process used within the new FHCC to determine
which patients DoD pays for and which VA pays for.
TECHNICAL DESCR: If the VistA Patient Type Code (TYPE (#391) field of the Patient (#2) file) = Active Duty, Military
Retiree, or TRICARE, then the value(s) in the VistA Other Eligibility multiple (PATIENT
ELIGIBILITIES (#361) field of the PATIENT (#2) file), which points to locally modifiable
ELIGIBILITY CODE (#8) file should be evaluated. If the value in the ELIGIBILITY CODE is equal to
any entry in the set of codes in this field, the value should be placed in this field.
FILES POINTED TO FIELDS
DSS EXTRACT LOG (#727) EXTRACT NUMBER (#2)
NEW PERSON (#200) CLASSIFIER (#11)
NURS AMIS WARD (#213.3) NURSING BEDSECTION (#13)
NURS LOCATION (#211.4) NURSE LOCATION (#12)
PATIENT (#2) PATIENT NO. - DFN (#4)
PATIENT MOVEMENT (#405) MOVEMENT FILE # (#14)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):