Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HDCNTMART


                             HDCNTMART FILE

REFERENCED BY

HCHE.1    HCHP.1

UPDATED BY

HC02.1    HC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HHH-DATA-MART-NAME     Alpha 20  (Lower Case)                    HC02.1  HC10.1
Element: Data Mart NameThis field contains the name of the data
                       mart.

HHH-EMP-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-MEAS-DIMENSION     Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-ORG-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-GL-ORG-DIM         Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-TIME-DIMENSION     Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-POS-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-JOB-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-SCH-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-ACV-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-SUP-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-YRS-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-PRF-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-AGE-DIMENSION      Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: User Dim Name 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.


HHH-TIME-INDICATOR     Alpha 1                                   HC02.1  HC10.1
Element: Time Indicator

HHH-FIXED-DATE         Numeric 8  (yyyymmdd)                     HC02.1  HC10.1
Element: Date          This field displays the system date
                       when this was created.

HHH-MAINT-DATE         Numeric 8  (yyyymmdd)                     HC02.1  HC10.1
Element: Date          This field displays the system date
                       when this was created.

HHH-MAINT-TIME         Numeric 8                                 HC02.1  HC10.1
Element: Time          This field is updated automatically to
                       indicate the time that the GL entry was
                       created. It is system-maintained.

HHH-NULL-GL-MBR        Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

HHH-NULL-POS-MBR       Alpha 50  (Lower Case)                    HC10.1
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

HHH-NULL-JOB-MBR       Alpha 50  (Lower Case)                    HC10.1
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

HHH-NULL-SCHD-MBR      Alpha 50  (Lower Case)                    HC10.1
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

HHH-NULL-ACV-MBR       Alpha 50  (Lower Case)                    HC02.1  HC10.1
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

HHH-ALL-POS-LEVEL      Alpha 1                                   HC10.1
Element: All Pos Level

HHH-EXC-HDCT-OPT       Numeric 1                                 HC10.1
Element: Exc Hdct Opt

                         HDCNTMART FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HHHSET1   DATA-MART-NAME                                         HC02.1  HCHE.1
                                                                 HCHP.1