HDCNTMART – No description in the Lawson data dictionary

System: Compensation D Mart (HC)
Prefix: HHH
Primary key: DATA-MART-NAME
Fields: 25
Updated by: 2 programs
Referenced by: 2 programs

HDCNTMART is a Lawson Compensation D Mart table (prefix HHH); no description in the lawson data dictionary. It is indexed by DATA-MART-NAME (HHHSET1). It is updated by HC02.1 and HC10.1 and referenced by HCHE.1 and HCHP.1. The table has 25 fields, 1 index and 0 documented relations.

About HDCNTMART

No description in the Lawson data dictionary.

Fields (25)

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

Field / column	Type	Description & values	Updated by
`HHH-DATA-MART-NAME` PK DATA_MART_NAME	Alpha 20 (Lower Case)	This field contains the name of the data mart.	HC02.1, HC10.1
`HHH-EMP-DIMENSION` EMP_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-MEAS-DIMENSION` MEAS_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-ORG-DIMENSION` ORG_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-GL-ORG-DIM` GL_ORG_DIM	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-TIME-DIMENSION` TIME_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-POS-DIMENSION` POS_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-JOB-DIMENSION` JOB_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-SCH-DIMENSION` SCH_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-ACV-DIMENSION` ACV_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-SUP-DIMENSION` SUP_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-YRS-DIMENSION` YRS_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-PRF-DIMENSION` PRF_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-AGE-DIMENSION` AGE_DIMENSION	Alpha 50 (Lower Case)	The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.	HC02.1, HC10.1
`HHH-TIME-INDICATOR` TIME_INDICATOR	Alpha 1	—	HC02.1, HC10.1
`HHH-FIXED-DATE` FIXED_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	HC02.1, HC10.1
`HHH-MAINT-DATE` MAINT_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	HC02.1, HC10.1
`HHH-MAINT-TIME` MAINT_TIME	Numeric 8	This field is updated automatically to indicate the time that the GL entry was created. It is system-maintained.	HC02.1, HC10.1
`HHH-NULL-GL-MBR` NULL_GL_MBR	Alpha 50 (Lower Case)	This is an override member name for Data Mart dimensions with no association to a Budget dimension.	HC02.1, HC10.1
`HHH-NULL-POS-MBR` NULL_POS_MBR	Alpha 50 (Lower Case)	This is an override member name for Data Mart dimensions with no association to a Budget dimension.	HC10.1
`HHH-NULL-JOB-MBR` NULL_JOB_MBR	Alpha 50 (Lower Case)	This is an override member name for Data Mart dimensions with no association to a Budget dimension.	HC10.1
`HHH-NULL-SCHD-MBR` NULL_SCHD_MBR	Alpha 50 (Lower Case)	This is an override member name for Data Mart dimensions with no association to a Budget dimension.	HC10.1
`HHH-NULL-ACV-MBR` NULL_ACV_MBR	Alpha 50 (Lower Case)	This is an override member name for Data Mart dimensions with no association to a Budget dimension.	HC02.1, HC10.1
`HHH-ALL-POS-LEVEL` ALL_POS_LEVEL	Alpha 1	—	HC10.1
`HHH-EXC-HDCT-OPT` EXC_HDCT_OPT	Numeric 1	—	HC10.1

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`HHHSET1`	`DATA-MART-NAME`	Primary		HC02.1, HCHE.1, HCHP.1

HDCNTMART – No description in the Lawson data dictionary

About HDCNTMART

Fields (25)

Indexes (1)

Programs

Updated by (2)

Referenced by (2)