FAMSTSHIST

UPDATED BY
ES10.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FSH-COMPANY
Element: Company Hr		Numeric 4
ES10.1
FSH-EMPLOYEE
Element: Employee		Numeric 9
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.
ES10.1
FSH-FAMILY-STATUS
Element: Family Status		Alpha 10
ES10.1
FSH-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
ES10.1
FSH-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
ES10.1
FSH-BENEFIT-UPDATE
Element: Benefit Update		Alpha 1
ES10.1
FSH-DEP-1
Element: Dep 1		Numeric 4
ES10.1
FSH-DEP-2
Element: Dep 2		Numeric 4
ES10.1
FSH-DEP-3
Element: Dep 3		Numeric 4
ES10.1
FSH-DEP-4
Element: Dep 4		Numeric 4
ES10.1
FSH-DEP-5
Element: Dep 5		Numeric 4
ES10.1
FSH-DEP-6
Element: Dep 6		Numeric 4
ES10.1
FSH-DEP-7
Element: Dep 7		Numeric 4
ES10.1
FSH-DEP-8
Element: Dep 8		Numeric 4
ES10.1
FSH-DEP-9
Element: Dep 9		Numeric 4
ES10.1


FAMSTSHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FSHSET1 COMPANY
EMPLOYEE
FAMILY-STATUS
EFFECT-DATE
ES10.1 HR11.1
PA115


FAMSTSHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:49:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.