HRIADIM

REFERENCED BY
WACP.1 WAMS.1 WAOP.1 WAYR.1 HCCE.1 HCHE.1
WAPC.1


UPDATED BY
HC01.1 HC02.1 HC10.1 WA01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HID-DATA-MART-NAME
Element: Data Mart Name		Alpha 20 (Lower Case)
This field contains the name of the data mart.
WA01.1
HID-DIM-TYPE
Element: Dim Type		Numeric 3
WA01.1
HID-APPLIC-TYPE
Element: Applic Type		Alpha 3
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
WA01.1
HID-DIMENSION-USE
Element: Dimension Use		Alpha 1
WA01.1
HID-DIMENSION-NAME
Element: Dimension Name		Alpha 50 (Lower Case)
The 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
WA01.1
HID-DIM-PREFIX-1
Element: Dim Prefix 1		Alpha 5
WA01.1
HID-DIM-PREFIX-2
Element: Dim Prefix 2		Alpha 5
HID-DIM-PREFIX-3
Element: Dim Prefix 3		Alpha 5
HID-DIM-ALIAS-OPT
Element: Dim Alias Opt		Alpha 1
HC10.1 WA01.1
HID-DIM-BUILD-TO
Element: Dim Build To		Numeric 2
WA01.1
HID-COMPANY
Element: Company		Numeric 4
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.
WA01.1
HID-GROUP-NAME
Element: Group Name		Alpha 10
HID-DATE-1
Element: Date 1		Numeric 8 (yyyymmdd)
WA01.1
HID-DATE-2
Element: Date 2		Numeric 8 (yyyymmdd)
WA01.1
HID-FACTOR-1
Element: Factor 1		Signed 7.2
HID-SELECTION
Element: Selection		Alpha 100
WA01.1
HID-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
WA01.1
HID-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
WA01.1
HID-USER-ID
Element: User		Alpha 10 (Lower Case)
WA01.1


HRIADIM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIDSET1 DATA-MART-NAME
DIM-TYPE
HC01.1 HC02.1
HC10.1 HCCE.1
HCHE.1 WA01.1
WACP.1 WAMS.1
WAOP.1 WAPC.1
WAYR.1


HRIADIM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 11:14:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.