Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HRCMEASX


                             HRCMEASX FILE

REFERENCED BY

HCDL.1    HCMS.1

UPDATED BY

HC01.7    HC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HCX-DIMENSION-NAME     Alpha 50  (Lower Case)                    HC01.7  HC10.1
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

HCX-MEMBER-NAME        Alpha 50  (Lower Case)                    HC01.7  HC10.1
Element: Member Name   The Member Name field contains the
                       member name of the measure. This
                       user-defined field can contain up to 50
                       characters of any kind.

HCX-MBR-USE            Alpha 1                                   HC01.7  HC10.1
Element: Mbr Use       The User Member field specifies whether
                       the measure is used.

                       Valid values are:
                       Y = Yes
                       N = No

HCX-MBR-TYPE           Alpha 2                                   HC01.7  HC10.1
Element: Mbr Type      The Member Type field specifies the
                       compensation member type.

                       Valid values are:
                       1=Base
                       2=Incentive
                       3=Other

HCX-PAY-CLASS          Alpha 3                                   HC01.7  HC10.1
Element: Pay Class     The Pay Class field specifies the cash
                       compensation pay class.

                       Valid values are:
                       All = All
                       GAR = Garnishment Pay
                       OVT = Overtime Pay
                       PIK = Payment in Kind
                       REG = Regular Pay
                       TIP = Tips Pay

HCX-PAY-SUM-GRP        Alpha 3                                   HC01.7  HC10.1
Element: Pay Sum Grp   The Pay Summary Group field specifies
                       the pay summar group.

                       Valid values are:
                       GAR = Garnishment Pay
                       OVT = Overtime Pay
                       PIK = Payment in Kind
                       REG = Regular Pay
                       TIP = Tips

HCX-MBR-AMOUNT         Alpha 1                                   HC01.7  HC10.1
Element: Mbr Amount    The Amount field specifies the value
                       that indicates the type of salary amount
                       from PR52.1 (Payroll History - Year to
                       Date).

                       Valid values are:
                       1=Wage Amount
                       2=Shift Differential
                       3=OT Premium
                       4=Wage minus Shift
                       5=Wage minus OT
                       6=Wage minus Shift;OT

HCX-DATE-1             Numeric 8  (yyyymmdd)                     HC01.7  HC10.1
Element: Date 1        The Pay Begin field specifies the
                       beginning date to start the cash
                       compensation range.

                       Records from PR51.1 (Payroll History -
                       Year To Date) with a check date on or
                       after this date are selected.

HCX-DATE-2             Numeric 8  (yyyymmdd)                     HC01.7  HC10.1
Element: Date 2        The Pay End field specifies the ending
                       date to end the cash compensation range.

                       Records from PR51.1 (Payroll History -
                       Year To Date) with a check date on or
                       before this date are selected.

HCX-FACTOR-1           Signed 7.2                                HC01.7  HC10.1
Element: Factor 1      The Factor field specifies the
                       annualization factor for dates you
                       select.

                       For example, if you select a six-month
                       range in the Payment Dates field, type 2
                       to annualize the results.

                         HRCMEASX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HCXSET1   DIMENSION-NAME                                         HC01.4  HC01.7
          MEMBER-NAME                                            HCDL.1

HCXSET2   DIMENSION-NAME                                         HCMS.1
          MBR-TYPE
          MBR-USE
          MEMBER-NAME