| 
 | 
                             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
 |