HRCOMPMEAS – No description in the Lawson data dictionary

System
Compensation D Mart (HC)
Prefix
HCM
Primary key
DIMENSION-NAME
Fields
22
Updated by
2 programs
Referenced by
3 programs

HRCOMPMEAS is a Lawson Compensation D Mart table (prefix HCM); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME (HCMSET1). It is updated by HC01.4 and HC10.1 and referenced by HCCE.1, HCDL.1 and HCMS.1. The table has 22 fields, 1 index and 0 documented relations.

About HRCOMPMEAS

No description in the Lawson data dictionary.

Fields (22)

Column = COBOL field name without the HCM- 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
#HCM-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the name of the Measures dimension. This user-defined name can contain up to 50 characters of any kind.HC01.4, HC10.1
#HCM-MEMBER-PREFIX
MEMBER_PREFIX		Alpha 5 (Lower Case)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.HC01.4, HC10.1
#HCM-CSH-USE
CSH_USE		Alpha 1The Use Cash Compensation specifies whether the Cash Compensation measure is used. Valid values are:
  • Y Yes
  • N No
HC01.4, HC10.1
#HCM-CSH-ALIAS-NAME
CSH_ALIAS_NAME		Alpha 50 (Lower Case)The Cash Compensation Alias Name field contains the user-defined alias name for the Cash Compensation measure.HC01.4, HC10.1
#HCM-BAS-USE
BAS_USE		Alpha 1The Use Base Salary field specifies whether the Base Salary measure is used. Valid values are:
  • Y Yes
  • N No
HC01.4, HC10.1
#HCM-BAS-ALIAS-NAME
BAS_ALIAS_NAME		Alpha 50 (Lower Case)The Base Salary Alias Name field contains the user-defined alias name for the Base Salary measure.HC01.4, HC10.1
#HCM-TGT-USE
TGT_USE		Alpha 1The Use Target Cash Compensation field specifies whether the Target Cash Compensation measure is used. Valid values are:
  • Y Yes
  • N No
HC01.4, HC10.1
#HCM-TGT-ALIAS-NAME
TGT_ALIAS_NAME		Alpha 50 (Lower Case)—HC01.4, HC10.1
#HCM-TGT-SOURCE
TGT_SOURCE		Alpha 20 (Lower Case)—HC01.4, HC10.1
#HCM-MKT-USE
MKT_USE		Alpha 1The Use Market Salary field specifies whether the Market Salary measure is used. Valid values are:
  • Y Yes
  • N No
HC01.4, HC10.1
#HCM-MKT-ALIAS-NAME
MKT_ALIAS_NAME		Alpha 50 (Lower Case)The Market Salary alias name field contains the user-defined alias name of the Market Salary measure.HC01.4, HC10.1
#HCM-RNG-USE
RNG_USE		Alpha 1The Use Range Midpoint field specifies wheter the Range Midpoint measure is used. Valid values are:
  • Y Yes
  • N No
HC01.4, HC10.1
#HCM-RNG-ALIAS-NAME
RNG_ALIAS_NAME		Alpha 50 (Lower Case)The Range Midpoint Alias Name field contains the user-defined alias name for the Range Midpoint measure.HC01.4, HC10.1
#HCM-RNG-DATE
RNG_DATE		Numeric 8 (yyyymmdd)The Range Date field contains the date used when calculating the Range Midpoint measure.HC01.4, HC10.1
#HCM-CPA-USE
CPA_USE		Alpha 1The Use Compa Ratio field specifies whether the Compa Ratio is used. Valid values are:
  • Y Yes
  • N No
HC01.4, HC10.1
#HCM-CPA-ALIAS-NAME
CPA_ALIAS_NAME		Alpha 50 (Lower Case)The Compa Ratio Alias Name field contains the user-defined alias name for the Compa Ratio.HC01.4, HC10.1
#HCM-PCT-USE
PCT_USE		Alpha 1The Use Percent of Range field specifies whether the Percent of Range measure is used. Valid values are:
  • Y Yes
  • N No
HC01.4, HC10.1
#HCM-PCT-ALIAS-NAME
PCT_ALIAS_NAME		Alpha 50 (Lower Case)The Percent of Range Alias Name field contains the user-defined alias name for the Percent of Range measure.HC01.4, HC10.1
#HCM-ZON-USE
ZON_USE		Alpha 1The Use Zone field specifies whether the Zone measure is used. Valid values are:
  • Y Yes
  • N No
HC01.4, HC10.1
#HCM-ZON-ALIAS-NAME
ZON_ALIAS_NAME		Alpha 50 (Lower Case)The Zone Alias Name field contains the user-defined alias name for the Zone measure.HC01.4, HC10.1
#HCM-ZON-NBR-ZONES
ZON_NBR_ZONES		Numeric 3The Number Zones field identifies the number of times that the range between the minimum and the maximum should be divided. This number is used as an alternative to comparing an employee's salary to the Compa ratio. This method is used to describe the salary zone the employee is in.HC01.4, HC10.1
#HCM-DEFAULT-MEAS
DEFAULT_MEAS		Numeric 2The Default Measure field specifies the default measure for the Measures dimension. Valid values are:
  • 1 Cash Compensation
  • 2 Base Salary
  • 3 Target Cash Compensation
  • 4 Market Salary
  • 5 Range Midpoint
  • 6 Compa Ratio
  • 7 Percent of Range
  • 8 Zone
HC01.4, HC10.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
HCMSET1
  1. DIMENSION-NAME
PrimaryHC01.1, HC01.4, HC01.7, HCCE.1, HCDL.1, HCMS.1

Programs

Updated by (2)

Referenced by (3)