Lawson Insight Technical Documentation

                             HCPATIENT FILE

                                Patient

This is the Patient Information file.

REFERENCED BY

PC210     PC530     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       The company number represents an          PC521
                       established company and is entered on
                       all function codes.

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: 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          This field contains the patient's date    PC521
                       of birth.

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

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

HPT-FICA-NBR           Alpha 15                                  PC521
Social Security
Number

                         HCPATIENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HPTSET1   COMPANY                                                PC20.1  PC20.2
          PATIENT-ID                                             PC210   PC310
                                                                 PC520   PC521
                                                                 PC530   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
                                                                 ...

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