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