Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HCPATIENT


                             HCPATIENT FILE

                                Patient

This is the Patient Information file.

REFERENCED BY

BL92.1    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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HPT-COMPANY            Numeric 4
Element: Company       Identifies the AP company if the
                       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
Element: Patient Id    This uniquely identifies a patient
                       within a company.

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

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

HPT-MIDDLE-INIT        Alpha 1
Element: Middle Init   This field contains the middle initial
                       of the patient.

HPT-BIRTHDATE          Numeric 8  (yyyymmdd)
Element: Birthdate     This field contains the patient's date
                       of birth.

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

HPT-CONTRACT           Alpha 15
Element: Contract      This field contains the contract
                       information for the patient.

HPT-FICA-NBR           Alpha 20
Element: Fica Nbr

                         HCPATIENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HPTSET1   COMPANY                                                BL92.1  WH130
          PATIENT-ID                                             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

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