Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Pointer To FileMan Files |  Fields
Print Page as PDF
Global: ^ECX(727.805

Package: DSS Extracts

Global: ^ECX(727.805


Information

FileMan FileNo FileMan Filename Package
727.805 NURSING EXTRACT DSS Extracts

Description

Pointer To FileMan Files, Total: 6

Package Total FileMan Files
Nursing Service 2 NURS LOCATION(#211.4)[12]    NURS AMIS WARD(#213.3)[13]    
Registration 2 PATIENT MOVEMENT(#405)[14]    PATIENT(#2)[4]    
DSS Extracts 1 DSS EXTRACT LOG(#727)[2]    
Kernel 1 NEW PERSON(#200)[11]    

Fields, Total: 26

Field # Name Loc Type Details
.01 SEQUENCE NUMBER 0;1 NUMBER
************************REQUIRED FIELD************************

  • 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
1 YEAR MONTH 0;2 FREE TEXT

  • 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.
2 EXTRACT NUMBER 0;3 POINTER TO DSS EXTRACT LOG FILE (#727) DSS EXTRACT LOG(#727)

  • 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.
3 FACILITY 0;4 FREE TEXT

  • 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).
4 PATIENT NO. - DFN 0;5 POINTER TO PATIENT FILE (#2) PATIENT(#2)

  • 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).
5 SSN 0;6 FREE TEXT

  • 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.
6 NAME 0;7 FREE TEXT

  • 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.
7 IN OUT PATIENT INDICATOR 0;8 FREE TEXT

  • 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.
8 DAY 0;9 FREE TEXT

  • 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.
9 ACUITY LEVEL 0;10 FREE TEXT

  • 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).
10 ENTERED BY 0;11 SET
  • '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).
11 CLASSIFIER 0;12 POINTER TO NEW PERSON FILE (#200) NEW PERSON(#200)

  • 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).
12 NURSE LOCATION 0;13 POINTER TO NURS LOCATION FILE (#211.4) NURS LOCATION(#211.4)

  • 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).
13 NURSING BEDSECTION 0;14 POINTER TO NURS AMIS WARD FILE (#213.3) NURS AMIS WARD(#213.3)

  • 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).
14 MOVEMENT FILE # 0;15 POINTER TO PATIENT MOVEMENT FILE (#405) PATIENT MOVEMENT(#405)

  • 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).
15 TREATING SPECIALTY 0;16 FREE TEXT

  • 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.
16 ADMISSION DATE 0;17 FREE TEXT

  • 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.
17 ADMISSION TIME 0;18 FREE TEXT

  • 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.
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.
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.
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)
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.
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.
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).
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.
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.
Info |  Desc |  Pointer To FileMan Files |  Fields