Compensation D Mart – Lawson HC tables and programs
Compensation D Mart (HC) in Lawson S3 v10 MSP6 has 20 tables, 38 online screens and 0 batch programs.
Tables (20)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| HCDIMEMP | HDE | No description in the Lawson data dictionary | EMP-DIMENSION, EMPLOYEE | 2 |
| HDCNTDTL | HDL | No description in the Lawson data dictionary | MEAS-OBJ-ID, GROUP-NAME, EMP-STATUS | 4 |
| HDCNTGRP | HDG | No description in the Lawson data dictionary | MEAS-OBJ-ID, GROUP-NAME | 7 |
| HDCNTMART | HHH | No description in the Lawson data dictionary | DATA-MART-NAME | 25 |
| HDTDIM | HCA | The HDTDIM data file contains the data mart, dimension, and Years of Service member names for the Compensation and… | DATA-MART-NAME | 17 |
| HRCMEASX | HCX | No description in the Lawson data dictionary | DIMENSION-NAME, MEMBER-NAME | 10 |
| HRCOMPMEAS | HCM | No description in the Lawson data dictionary | DIMENSION-NAME | 22 |
| HREMPDIM | HRE | The HREMPDIM file contains the information used when building the Employee dimension. | EMP-DIMENSION | 16 |
| HRHDCTMEAS | HHM | No description in the Lawson data dictionary | MEAS-DIMENSION | 16 |
| HRIAAGE | HRA | No description in the Lawson data dictionary | DIMENSION-NAME | 9 |
| HRIAATTR | HRI | The HRIAATTR data file contain the information required to build the attribute dimensions. | DIMENSION-NAME, LAW-ATTR-NAME | 4 |
| HRIAJOB | HRJ | No description in the Lawson data dictionary | DIMENSION-NAME | 7 |
| HRIAORG | HRO | No description in the Lawson data dictionary | DIMENSION-NAME | 5 |
| HRIAPERF | HRF | No description in the Lawson data dictionary | DIMENSION-NAME | 3 |
| HRIAPOS | HIP | No description in the Lawson data dictionary | DIMENSION-NAME | 7 |
| HRIASCH | HRD | No description in the Lawson data dictionary | DIMENSION-NAME | 7 |
| HRIASUP | HRS | No description in the Lawson data dictionary | DIMENSION-NAME | 8 |
| HRYEARS | HRY | No description in the Lawson data dictionary | DIMENSION-NAME | 9 |
| TRNOVERCAT | TRT | No description in the Lawson data dictionary | MEAS-OBJ-ID, TURNOVER-TYPE, GROUP-NAME | 8 |
| TRNOVERDTL | TOD | No description in the Lawson data dictionary | MEAS-OBJ-ID, GROUP-NAME, SEQ-NBR | 8 |
Online screens (38)
| Screen | Description | Updates | References |
|---|---|---|---|
| HC01.1 | Compensation Data Mart Setup | 1 | 12 |
| HC01.2 | Employee Dimension Definition | 1 | 12 |
| HC01.3 | Employee Attributes | 1 | 2 |
| HC01.4 | Measures Dimension Definition | 1 | 1 |
| HC01.5 | Position Dimension Definition | 1 | 0 |
| HC01.6 | Job Dimension Definition | 1 | 2 |
| HC01.7 | Additional Cash Compensation Measures | 1 | 1 |
| HC01.8 | Organization Dimension Definition | 1 | 0 |
| HC01.9 | Supervisor Dimension Definition | 1 | 0 |
| HC02.1 | Headcount and Turnover Data Mart Setup | 1 | 14 |
| HC02.2 | Headcount and Turnover Measures | 5 | 6 |
| HC02.3 | Headcount Group Criteria | 1 | 3 |
| HC02.4 | Headcount Group Definition | 2 | 2 |
| HC02.5 | Turnover Group Criteria | 3 | 6 |
| HC02.6 | Turnover Group Definition | 2 | 2 |
| HC03.1 | Schedule Dimension Definition | 1 | 0 |
| HC03.2 | Job Attributes | 1 | 2 |
| HC03.3 | Years of Service Dimension | 1 | 0 |
| HC03.4 | Age Dimension | 1 | 0 |
| HC03.5 | Performance Dimension | 1 | 0 |
| HC10.1 | Compensation Data Mart Upgrade | 26 | 2 |
| HCAG.1 | Olap Dimension Retrieval Format | 7 | 3 |
| HCCE.1 | Compensation Data Mart Edit | 0 | 15 |
| HCCP.1 | Olap Dimension Retrieval Format | 7 | 5 |
| HCDL.1 | Olap Data Load | 3 | 44 |
| HCEA.1 | Olap Dimension Retrieval Format | 1 | 0 |
| HCEM.1 | Olap Dimension Retrieval Format | 8 | 20 |
| HCHE.1 | Olap Data Load | 0 | 12 |
| HCHM.1 | Olap Dimension Retrieval Format | 7 | 5 |
| HCHP.1 | Olap Data Load | 3 | 42 |
| HCJA.1 | Olap Dimension Retrieval Format | 1 | 0 |
| HCJC.1 | Olap Dimension Retrieval Format | 7 | 7 |
| HCMS.1 | Olap Dimension Retrieval Format | 7 | 4 |
| HCPO.1 | Olap Dimension Retrieval Format | 7 | 6 |
| HCRV.1 | Olap Dimension Retrieval Format | 7 | 4 |
| HCSC.1 | Olap Dimension Retrieval Format | 7 | 5 |
| HCSU.1 | Olap Dimension Retrieval Format | 7 | 5 |
| HCYR.1 | Olap Dimension Retrieval Format | 7 | 3 |
Other tables used by Compensation D Mart programs (58)
ACACTGRP, ACACTIVITY, ACIAACVDIM, DEPTCODE, EBCSVREC, EMPLOYEE, EMSTATUS, GLCGCPY, GLNAMES, HRCTRYCODE, HREMPUSF, HRHISTORY, HRIADIM, HRIAMBR, HRSECLEV, HRSUPER, HRUSERFLDS, IAATTRIB, IACALCMBR, IADIMATTR, IADIMDLT, IADIMTYPES, IADRILL, IAFILEDEF, IAFILEDLT, IAFORMULA, IATIME, IATIMEPRD, JOBCLASS, JOBCODE, MXLISTMBR, OLAPDBM, OLAPDIM, ORGSTRUC, PACLASS, PACLASSPOS, PADICT, PAEMPLOYEE, PAEMPPOS, PAPOSITION, PAPOSRULE, PATHFIND, PAYMASTR, PCODES, PERSACTHST, PERSACTION, PERSACTYPE, PERSGROUP, PGEMPLOYEE, PRPROCGRP, PRSAGDTL, PRSAGHEAD, PRSYSTEM, PRTIME, PSGRELATE, REVIEW, ROLAPDIM, ROLAPIDS