Lawson Insight Technical Documentation

                             HCPATIENT FILE

                                Patient

This is the Patient Information file.

REFERENCED BY

BL92.1    PC210     PC530     OE114     WH130     WH132
WH190     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.5    WH34.1    WH34.2    WH34.3
WH34.4    WH40.1    WH40.2    WH520     WH830

UPDATED BY

PC20.2    PC310     PC520     PC521

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HPT-COMPANY            Numeric 4                                 PC20.2  PC520
Element: Company       Identifies the AP company if the          PC521
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

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

HPT-MIDDLE-INIT        Alpha 1                                   PC20.2  PC520
Element: Middle InitialThis field contains the middle initial    PC521
                       of the patient.

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

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

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

HPT-FICA-NBR           Alpha 20                                  PC521
Social Security
Number

                         HCPATIENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HPTSET1   COMPANY                                                BL92.1  PC20.1
          PATIENT-ID                                             PC20.2  PC210
                                                                 PC310   PC520
                                                                 PC521   PC530
                                                                 OE114   WH130
                                                                 WH132   WH190
                                                                 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.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 ...

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