Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HCPATVISIT


                            HCPATVISIT FILE

                             Patient Visit

This is the Patient Visit information file.

REFERENCED BY

PC210     PC530

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    CXCP.1    IC28.1    PC20.1    PC310
PC520     PC521     PC540     MA180     MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA66.2    MA66.3
MA67.1    MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1
OE10.1    OE10.2    OE10.3    OE10.4    OE10.5    OE10.6
OE10.7    OE10.8    OE11.1    OE11.4    OE11.8    OE11.9
OE110     OE111     OE113     OE114     OE116     OE129
OE13.2    OE13.3    OE13.5    OE13.6    OE14.4    OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE510     OE530     OE81.1    OE810     OE830
OE90.1    OE90.2    PO100     PO101     PO122     PO131
PO20.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO23.1    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     POI3.1    POIE.1    POII.1    POIJ.1    RQ10.1
RQ10.2    RQ35.1    WH130     WH132     WH190     WH20.2
WH20.7    WH222     WH30.1    WH30.2    WH30.3    WH30.4
WH31.1    WH31.2    WH31.3    WH31.4    WH32.1    WH32.2
WH32.3    WH32.4    WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830
WO132     WO140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HPV-COMPANY            Numeric 4                                 PC20.1  PC520
Element: Company       This field contains the company number.   PC521

HPV-VISIT-NBR          Alpha 12                                  PC20.1  PC520
Element: Visit Number  This is the identifier that makes a       PC521
                       visit unique with a company.

HPV-PATIENT-ID         Alpha 12                                  PC20.1  PC520
Element: Patient ID    This uniquely identifies a patient        PC521
                       within a company.

HPV-PATIENT-CLASS      Alpha 1                                   PC20.1  PC520
Element: Patient Class This provides for a category of patient.  PC521
                       I = Inpatient
                       O = Outpatient

HPV-ROOM               Alpha 10                                  PC20.1  PC520
Element: Room          This identifies the room the patient is   PC521
                       in.

HPV-BED                Numeric 2                                 PC20.1  PC520
Element: Bed           This field contains the patient's bed     PC521
                       number.

HPV-ADMIT-DATE         Numeric 8  (yyyymmdd)                     PC20.1  PC520
Element: Admit Date    The date the patient was admitted.        PC521

HPV-DISCH-DATE         Numeric 8  (yyyymmdd)                     PC20.1  PC520
Element: Disch Date    The discharge date of the patient.        PC521

HPV-LAST-TRANS-DT      Numeric 8  (yyyymmdd)                     PC20.1  PC520
Element: Last Trans Dt This is the date of the last add/update
                       to a charge for this visit.

HPV-DIAG-REL-GRP       Alpha 15                                  PC20.1  PC520
Element: Diag Rel Grp  This identifies the Diagnostic Related    PC521
                       Group.

HPV-PRACTNR-ID         Alpha 15                                  PC20.1  PC520
Element: Practitioner IThis field contains the practitioner ID.  PC521

HPV-SEC-PRACTNR-ID     Alpha 15                                  PC20.1  PC520
Element: Practitioner IThis field contains a secondary
                       practitioner ID.

HPV-LAST-CHRG-SEQ      Numeric 4                                 AP125   AP126
Element: Sequence NumbeThe last charge sequence is used to       AP131   AP25.1
                       determine the next available charge       AP25.2  AP26.1
                       sequence to assign to a new charge for    AP27.1  AP30.4
                       the visit.                                BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 CXCP.1  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

HPV-UPDATE-DATE        Numeric 8  (yyyymmdd)                     PC20.1  PC520
Element: Update Date   This is the date of the last update to    PC521
                       the visit record.

                         HCPATVISIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HPVSET1   COMPANY                                                AP125   AP126
          VISIT-NBR                                              AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 CXCP.1  IC28.1
                                                                 PC20.1  PC210
                                                                 PC520   PC521
                                                                 PC530   PC540
                                                                 MA180   MA530
                                                                 ...

HPVSET2   COMPANY       KeyChange                                PC20.2  PC310
          PATIENT-ID                                             PC521
          VISIT-NBR

                         HCPATVISIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Hcpatient      HCPATIENT    Required

                            HPV-COMPANY       -> HPT-COMPANY
                            HPV-PATIENT-ID    -> HPT-PATIENT-ID

                         HCPATVISIT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Hcpatchrg      HCPATCHRG

                            HPV-COMPANY       -> HPR-COMPANY
                            HPV-VISIT-NBR     -> HPR-VISIT-NBR
                                                 HPR-REV-CENTER
                                                 HPR-FROM-LOCATION
                                                 HPR-DATE-OF-CHRG
                                                 HPR-ITEM
                                                 HPR-CHARGE-SEQ