HRCMEASX – No description in the Lawson data dictionary

System
Compensation D Mart (HC)
Prefix
HCX
Primary key
DIMENSION-NAME, MEMBER-NAME
Fields
10
Updated by
2 programs
Referenced by
2 programs

HRCMEASX is a Lawson Compensation D Mart table (prefix HCX); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME, MEMBER-NAME (HCXSET1); alternate indexes: HCXSET2. It is updated by HC01.7 and HC10.1 and referenced by HCDL.1 and HCMS.1. The table has 10 fields, 2 indexes and 0 documented relations.

About HRCMEASX

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the HCX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
HCX-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the dimension name that is used by the OLAP database. Valid values are: Year Period Measures Scenario Compton Territory Customer ItemsHC01.7, HC10.1
HCX-MEMBER-NAME PK
MEMBER_NAME		Alpha 50 (Lower Case)The Member Name field contains the member name of the measure. This user-defined field can contain up to 50 characters of any kind.HC01.7, HC10.1
HCX-MBR-USE
MBR_USE		Alpha 1The User Member field specifies whether the measure is used. Valid values are:
  • Y Yes
  • N No
HC01.7, HC10.1
HCX-MBR-TYPE
MBR_TYPE		Alpha 2The Member Type field specifies the compensation member type. Valid values are:
  • 1 Base
  • 2 Incentive
  • 3 Other
HC01.7, HC10.1
HCX-PAY-CLASS
PAY_CLASS		Alpha 3The 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
HC01.7, HC10.1
HCX-PAY-SUM-GRP
PAY_SUM_GRP		Alpha 3The 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
HC01.7, HC10.1
HCX-MBR-AMOUNT
MBR_AMOUNT		Alpha 1The 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
HC01.7, HC10.1
HCX-DATE-1
DATE_1		Numeric 8 (yyyymmdd)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.HC01.7, HC10.1
HCX-DATE-2
DATE_2		Numeric 8 (yyyymmdd)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.HC01.7, HC10.1
HCX-FACTOR-1
FACTOR_1		Signed 7.2The 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.HC01.7, HC10.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HCXSET1DIMENSION-NAME, MEMBER-NAMEPrimaryHC01.4, HC01.7, HCDL.1
HCXSET2DIMENSION-NAME, MBR-TYPE, MBR-USE, MEMBER-NAMEHCMS.1

Programs

Updated by (2)

Referenced by (2)