|
|
HRIADIM FILE
REFERENCED BY
HC01.1 HC02.1 HCCE.1 HCHE.1
UPDATED BY
HC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HID-DATA-MART-NAME Alpha 20 (Lower Case)
Element: Data Mart NameThis field contains the name of the data
mart.
HID-DIM-TYPE Numeric 3
Element: Dim Type
HID-APPLIC-TYPE Alpha 3
Element: Applic Type The Application Type file stores the
names of the Lawson applications that
can be requested to supply information
to the OLAP database. The Lawson
applications that are currently
OLAP-ready are:
FIN = Financial Analyzer
FND = Daily Financial Analyzer
SA = Sales Analyzer
CX = Case Cart Analyzer
PO = Purchasing Analyzer
WO = Work Order Analyzer
CMP = Compensation
HDT = Headcount/Turnover
HID-DIMENSION-USE Alpha 1
Element: Dimension Use
HID-DIMENSION-NAME Alpha 50 (Lower Case)
Element: Dimension NameThe Dimension Name field contains the
dimension name that is used by the OLAP
database.
Valid values are:
Year
Period
Measures
Scenario
Compton
Territory
Customer
Items
HID-DIM-PREFIX-1 Alpha 5
Element: Dim Prefix 1
HID-DIM-PREFIX-2 Alpha 5
Element: Dim Prefix 2
HID-DIM-PREFIX-3 Alpha 5
Element: Dim Prefix 3
HID-DIM-ALIAS-OPT Alpha 1 HC10.1
Element: Dim Alias Opt
HID-DIM-BUILD-TO Numeric 2
Element: Dim Build To
HID-COMPANY Numeric 4
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
HID-GROUP-NAME Alpha 10
Element: Group Name
HID-DATE-1 Numeric 8 (yyyymmdd)
Element: Date 1
HID-DATE-2 Numeric 8 (yyyymmdd)
Element: Date 2
HID-FACTOR-1 Signed 7.2
Element: Factor 1
HID-SELECTION Alpha 100
Element: Selection
HID-DATE-STAMP Numeric 8 (yyyymmdd)
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
HID-TIME-STAMP Numeric 6 (hhmmss)
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
HID-USER-ID Alpha 10 (Lower Case)
Element: User
HRIADIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIDSET1 DATA-MART-NAME HC01.1 HC02.1
DIM-TYPE HC10.1 HCCE.1
HCHE.1
HRIADIM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
When HID-COMPANY != Zeroes
HID-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Emp Group PERSGROUP Required
When HID-GROUP-NAME != Spaces
HID-COMPANY -> PRG-COMPANY
HID-GROUP-NAME -> PRG-GROUP-NAME
Olap Db OLAPDBM Required
HID-DATA-MART-NAME -> ODB-DATA-MART-NAME
HRIADIM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Members HRIAMBR
HID-DATA-MART-NAME -> HIM-DATA-MART-NAME
HID-DIM-TYPE -> HIM-DIM-TYPE
HIM-MEMBER-TYPE
HIM-SEQ-NBR
|
