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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    CXCP.1    IC28.1
PC20.1    PC310     PC520     PC521     PC540     MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
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    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POII.1
POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ35.1    RQIE.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: Position Nbr                                            PC521

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: Date                                                    PC521

HPV-DISCH-DATE         Numeric 8  (yyyymmdd)                     PC20.1  PC520
Element: Date                                                    PC521

HPV-LAST-TRANS-DT      Numeric 8  (yyyymmdd)                     PC20.1  PC520
Element: Date          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: Practnr Grp                                             PC521

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   AP20.1
                       determine the next available charge       AP20.2  AP20.3
                       sequence to assign to a new charge for    AP20.4  AP20.5
                       the visit.                                AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PC20.1
                                                                 PC520   PC540
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 ...

HPV-UPDATE-DATE        Numeric 8  (yyyymmdd)                     PC20.1  PC520
Element: 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   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 PC20.1  PC210
                                                                 PC520   PC521
                                                                 PC530   PC540
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 ...

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