FAMSTSHIST – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
FSH
Primary key
COMPANY, EMPLOYEE, FAMILY-STATUS, EFFECT-DATE
Fields
15
Updated by
3 programs
Referenced by
0 programs

FAMSTSHIST is a Lawson Human Resources table (prefix FSH); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, FAMILY-STATUS, EFFECT-DATE (FSHSET1). It is related 1:1 to PRSYSTEM, EMDEPEND and EMPLOYEE. It is updated by ES10.1, HR11.1 and PA115. The table has 15 fields, 1 index and 11 documented relations.

About FAMSTSHIST

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the FSH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#FSH-COMPANY PK
COMPANY		Numeric 4—ES10.1
#FSH-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 PK
FAMILY_STATUS		Alpha 10—ES10.1
#FSH-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)—ES10.1
#FSH-DATE-STAMP
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
BENEFIT_UPDATE		Alpha 1—ES10.1
#FSH-DEP-1
DEP_1		Numeric 4—ES10.1
#FSH-DEP-2
DEP_2		Numeric 4—ES10.1
#FSH-DEP-3
DEP_3		Numeric 4—ES10.1
#FSH-DEP-4
DEP_4		Numeric 4—ES10.1
#FSH-DEP-5
DEP_5		Numeric 4—ES10.1
#FSH-DEP-6
DEP_6		Numeric 4—ES10.1
#FSH-DEP-7
DEP_7		Numeric 4—ES10.1
#FSH-DEP-8
DEP_8		Numeric 4—ES10.1
#FSH-DEP-9
DEP_9		Numeric 4—ES10.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FSHSET1
  1. COMPANY
  2. EMPLOYEE
  3. FAMILY-STATUS
  4. EFFECT-DATE
PrimaryES10.1, HR11.1, PA115

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMDEPENDEMPLOYEEFAMSTSHIST

One to one (11) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
FSH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Dep 1EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-1→EMD-SEQ-NBR
Dep 2EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-2→EMD-SEQ-NBR
Dep 3EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-3→EMD-SEQ-NBR
Dep 4EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-4→EMD-SEQ-NBR
Dep 5EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-5→EMD-SEQ-NBR
Dep 6EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-6→EMD-SEQ-NBR
Dep 7EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-7→EMD-SEQ-NBR
Dep 8EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-8→EMD-SEQ-NBR
Dep 9EMDEPENDNot Required
FSH-COMPANY→EMD-COMPANY
FSH-EMPLOYEE→EMD-EMPLOYEE
FSH-DEP-9→EMD-SEQ-NBR
EmployeeEMPLOYEERequired
FSH-COMPANY→EMP-COMPANY
FSH-EMPLOYEE→EMP-EMPLOYEE

Programs

Updated by (3)