Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             HCPATIENT FILE

                                Patient

This is the Patient Information file.

REFERENCED BY

BL92.1    CX100     CX20.1    CX20.2    CX20.4    CX20.5
CX220     CX240     CX30.1    CX300     PC210     PC530
OE114     WH130     WH132     WH190     WH222     WH30.1
WH30.2    WH30.3    WH31.1    WH31.2    WH31.3    WH32.1
WH32.2    WH32.3    WH33.5    WH34.1    WH34.2    WH34.3
WH34.4    WH40.1    WH40.2    WH520     WH830

UPDATED BY

CX506     PC20.2    PC310     PC520     PC521

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HPT-COMPANY          Numeric 4                                   CX506   PC20.2
Company              The company number represents an            PC520   PC521
                     established company and is entered on
                     all function codes.

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

HPT-LAST-NAME        Alpha 30  (Lower Case)                      CX240   CX506
Last Name            This field contains the last name of        PC20.2  PC520
                     the patient.                                PC521

HPT-FIRST-NAME       Alpha 15  (Lower Case)                      CX240   CX506
First Name           This field contains the first name of       PC20.2  PC520
                     the patient.                                PC521

HPT-MIDDLE-INIT      Alpha 1                                     CX240   CX506
Middle Initial       This field contains the middle initial      PC20.2  PC520
                     of the patient.                             PC521

HPT-BIRTHDATE        Numeric 8  (yyyymmdd)                       CX506   PC20.2
Date of Birth        This field contains the patient's date      PC520   PC521
                     of birth.

HPT-UPDATE-DATE      Numeric 8  (yyyymmdd)                       PC20.2  PC520
Update Date          This is the date of the last update to      PC521
                     the patient record.

HPT-CONTRACT         Alpha 10                                    PC20.2  PC520
Contract             This field contains the contract
                     information for the patient.

                         HCPATIENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HPTSET1   COMPANY                                                BL92.1  CX100
          PATIENT-ID                                             CX20.1  CX20.2
                                                                 CX20.4  CX20.5
                                                                 CX220   CX240
                                                                 CX30.1  CX300
                                                                 CX506   PC20.1
                                                                 PC20.2  PC210
                                                                 PC310   PC520
                                                                 PC521   PC530
                                                                 OE114   WH130
                                                                 WH132   WH190
                                                                 WH222   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 ...

HPTSET2   COMPANY       KeyChange
          LAST-NAME
          FIRST-NAME
          PATIENT-ID

                         HCPATIENT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            HPT-COMPANY       -> ICC-COMPANY  (ICCSET1)

                         HCPATIENT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Hcpatvisit     HCPATVISIT

                            HPT-COMPANY       -> HPV-COMPANY
                            HPT-PATIENT-ID    -> HPV-PATIENT-ID
                                                 HPV-VISIT-NBR