Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FAMSTSHIST


                            FAMSTSHIST FILE

UPDATED BY

ES10.1    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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: 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

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