|
|
FAMSTSHIST FILE
UPDATED BY
ES10.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FSH-COMPANY Numeric 4 ES10.1
Element: Company Hr
FSH-EMPLOYEE Numeric 9 ES10.1
Element: 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
Element: Family Status
FSH-EFFECT-DATE Numeric 8 (yyyymmdd) ES10.1
Element: Effect Date
FSH-DATE-STAMP Numeric 8 (yyyymmdd) ES10.1
Element: 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
Element: Benefit Update
FSH-DEP-1 Numeric 4 ES10.1
Element: Dep 1
FSH-DEP-2 Numeric 4 ES10.1
Element: Dep 2
FSH-DEP-3 Numeric 4 ES10.1
Element: Dep 3
FSH-DEP-4 Numeric 4 ES10.1
Element: Dep 4
FSH-DEP-5 Numeric 4 ES10.1
Element: Dep 5
FSH-DEP-6 Numeric 4 ES10.1
Element: Dep 6
FSH-DEP-7 Numeric 4 ES10.1
Element: Dep 7
FSH-DEP-8 Numeric 4 ES10.1
Element: Dep 8
FSH-DEP-9 Numeric 4 ES10.1
Element: Dep 9
FAMSTSHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FSHSET1 COMPANY ES10.1 HR11.1
EMPLOYEE PA115
FAMILY-STATUS
EFFECT-DATE
FAMSTSHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
FSH-COMPANY -> PRS-COMPANY
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
Employee EMPLOYEE Required
FSH-COMPANY -> EMP-COMPANY
FSH-EMPLOYEE -> EMP-EMPLOYEE
|
