Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            HCPATVISIT FILE

                             Patient Visit

This is the Patient Visit information file.

REFERENCED BY

PC210     PC530

UPDATED BY

CXCP.1    PC20.1    PC310     PC520     PC521     PC540
POIJ.1    WH130     WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

HPV-PATIENT-CLASS    Alpha 1                                     PC20.1  PC520
Patient Class        This provides for a category of patient.    PC521
                     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 was admitted.          PC521

HPV-DISCH-DATE       Numeric 8  (yyyymmdd)                       PC20.1  PC520
Disch Date           The discharge date of the patient.          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
Diag Rel Grp         This identifies the Diagnostic Related      PC521
                     Group.

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

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                                   CXCP.1  PC20.1
Last Chrg Seq        The last charge sequence is used to         PC520   PC540
                     determine the next available charge         POIJ.1  WH130
                     sequence to assign to a new charge for      WH33.1  WH33.2
                     the visit.                                  WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

HPV-UPDATE-DATE      Numeric 8  (yyyymmdd)                       PC20.1  PC520
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                                                CXCP.1  PC20.1
          VISIT-NBR                                              PC210   PC520
                                                                 PC521   PC530
                                                                 PC540   POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

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