FAMSTSHIST FILE

UPDATED BY

ES10.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

FSH-COMPANY          Numeric 4                                   ES10.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

FSH-EMPLOYEE         Numeric 9                                   ES10.1
Employee             Contains the employee number. Each
                     person employed by the company is
                     assigned a unique number. The system
                     uses the employee number to correlate
                     all of the information related to that
                     person.

FSH-FAMILY-STATUS    Alpha 10                                    ES10.1
Family Status

FSH-EFFECT-DATE      Numeric 8  (yyyymmdd)                       ES10.1
Effective Date

FSH-DATE-STAMP       Numeric 8  (yyyymmdd)                       ES10.1
Date Stamp           Contains the server date (month, date,
                     and year) of the last change to this
                     record.

FSH-BENEFIT-UPDATE   Alpha 1                                     ES10.1
Benefit Update

FSH-DEP-1            Numeric 4                                   ES10.1
Dep 1

FSH-DEP-2            Numeric 4                                   ES10.1
Dep 2

FSH-DEP-3            Numeric 4                                   ES10.1
Dep 3

FSH-DEP-4            Numeric 4                                   ES10.1
Dep 4

FSH-DEP-5            Numeric 4                                   ES10.1
Dep 5

FSH-DEP-6            Numeric 4                                   ES10.1
Dep 6

FSH-DEP-7            Numeric 4                                   ES10.1
Dep 7

FSH-DEP-8            Numeric 4                                   ES10.1
Dep 8

FSH-DEP-9            Numeric 4                                   ES10.1
Dep 9

                         FAMSTSHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FSHSET1   COMPANY                                                ES10.1
          EMPLOYEE
          FAMILY-STATUS
          EFFECT-DATE

FSHSET2   COMPANY
          FAMILY-STATUS
          EMPLOYEE
          EFFECT-DATE

FSHSET3   COMPANY
          EMPLOYEE
          EFFECT-DATE
          FAMILY-STATUS

                         FAMSTSHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            FSH-COMPANY     -> PRS-COMPANY  (PRSSET1)
                            Spaces          -> PRS-PROCESS-LEVEL

Dep 1          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-1       -> EMD-SEQ-NBR

Dep 2          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-2       -> EMD-SEQ-NBR

Dep 3          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-3       -> EMD-SEQ-NBR

Dep 4          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-4       -> EMD-SEQ-NBR

Dep 5          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-5       -> EMD-SEQ-NBR

Dep 6          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-6       -> EMD-SEQ-NBR

Dep 7          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-7       -> EMD-SEQ-NBR

Dep 8          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-8       -> EMD-SEQ-NBR

Dep 9          EMDEPEND     Not Required

                            FSH-COMPANY     -> EMD-COMPANY
                            FSH-EMPLOYEE    -> EMD-EMPLOYEE
                            FSH-DEP-9       -> EMD-SEQ-NBR