Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            HCPATVISIT FILE

                             Patient Visit

This is the Patient Visit information file.

REFERENCED BY

PC210     PC530

UPDATED BY

BL92.1    CX100     CX20.1    CX20.2    CX20.4    CX20.5
CX220     CX30.1    CX300     CX506     CXCP.1    PC20.1
PC310     PC520     PC521     PC540     OE114     OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE830     OE950     PO31.1    RQ35.1    WH130
WH132     WH190     WH20.7    WH222     WH30.1    WH30.2
WH30.3    WH31.1    WH31.2    WH31.3    WH32.1    WH32.2
WH32.3    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                                   CX506   PC20.1
Company              This field contains the company number.     PC520   PC521

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

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

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

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

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

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

HPV-DISCH-DATE       Numeric 8  (yyyymmdd)                       PC20.1  PC520
Disch Date           The date the patient is discharged.         PC521

HPV-LAST-TRANS-DT    Numeric 8  (yyyymmdd)                       PC20.1  PC520
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
Diagnosis Related    This field identifies the Diagnostic        PC521
Group                Related Group.

HPV-PRACTNR-ID       Alpha 15                                    PC20.1  PC520
Practitioner ID      This field identifies the                   PC521
                     practitioner.

HPV-SEC-PRACTNR-ID   Alpha 15                                    PC20.1  PC520
Sec Practnr Id       This field contains a secondary
                     practitioner ID.

HPV-LAST-CHRG-SEQ    Numeric 4                                   BL92.1  CX100
Last Chrg Seq        The last charge sequence is used to         CX20.1  CX20.2
                     determine the next available charge         CX20.4  CX20.5
                     sequence to assign to a new charge for      CX220   CX30.1
                     the visit.                                  CX300   CX506
                                                                 CXCP.1  OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE830   OE950
                                                                 PC20.1  PC520
                                                                 PC540   PO31.1
                                                                 RQ35.1  WH130
                                                                 WH132   WH190
                                                                 WH20.7  WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH32.1  WH32.2
                                                                 WH32.3  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

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

                         HCPATVISIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HPVSET1   COMPANY                                                BL92.1  CX100
          VISIT-NBR                                              CX20.1  CX20.2
                                                                 CX20.4  CX20.5
                                                                 CX220   CX30.1
                                                                 CX300   CX506
                                                                 CXCP.1  PC20.1
                                                                 PC210   PC520
                                                                 PC521   PC530
                                                                 PC540   OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE830   OE950
                                                                 PO31.1  RQ35.1
                                                                 ...

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