Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRYEARS


                              HRYEARS FILE

REFERENCED BY

HC01.1    HC02.1    HCCE.1    HCDL.1    HCHP.1    HCYR.1

UPDATED BY

HC03.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HRY-DIMENSION-NAME     Alpha 50  (Lower Case)                    HC03.3
Element: Dimension NameThe Dimension Name field contains the
                       dimension name that is used by the OLAP
                       database.

                       Valid values are:
                       Year
                       Period
                       Measures
                       Scenario
                       Compton
                       Territory
                       Customer
                       Items

HRY-MEMBER-PREFIX      Alpha 5  (Lower Case)                     HC03.3
Element: Member Prefix The Member Prefix field contains a
                       unique prefix to differentiate the
                       dimension name from other like-named
                       dimensions.  This user-defined name can
                       contain up to five characters of any
                       kind.

HRY-ALIAS-OPT          Alpha 1                                   HC03.3
Element: Alias Opt

HRY-BUILD-TO-LEVEL     Numeric 1                                 HC03.3
Element: Build To Level

HRY-MAX-YEAR           Numeric 3                                 HC03.3
Element: Max Year

HRY-FOLLOWING-TEXT     Alpha 45  (Lower Case)                    HC03.3
Element: Following Text

HRY-ROLL-UP-RANGE      Numeric 2                                 HC03.3
Element: Roll Up Range

HRY-RANGE-START        Numeric 2                                 HC03.3
Element: Range Start

HRY-DATE-SELECTION     Numeric 1                                 HC03.3
Element: Date Selection1 = Employee Hire Date
                       2 = Employee Adjusted Hire Date
                       3 = Employee Seniority Date
                       4 = Job Code Start Date
                       5 = Schedule Start Date

                         HRYEARS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HRYSET1   DIMENSION-NAME                                         HC01.1  HC02.1
                                                                 HC03.3  HCCE.1
                                                                 HCDL.1  HCHP.1
                                                                 HCYR.1