REFERENCED BY
HC01.1 | HC02.1 | HCCE.1 | HCHE.1 |
HC10.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. |
|
||
HID-DIM-TYPE Element: Dim Type | Numeric 3 |
|
||
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 |
|
||
HID-DIMENSION-USE Element: Dimension Use | Alpha 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 |
|
||
HID-DIM-PREFIX-1 Element: Dim Prefix 1 | Alpha 5 |
|
||
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 |
|
||
HID-DIM-BUILD-TO Element: Dim Build To | Numeric 2 |
|
||
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. |
|
||
HID-GROUP-NAME Element: Group Name | Alpha 10 |
|
||
HID-DATE-1 Element: Date 1 | Numeric 8 (yyyymmdd) |
|
||
HID-DATE-2 Element: Date 2 | Numeric 8 (yyyymmdd) |
|
||
HID-FACTOR-1 Element: Factor 1 | Signed 7.2 |
|
||
HID-SELECTION Element: Selection | Alpha 100 |
|
||
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. |
|
||
HID-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
HID-USER-ID Element: User | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HIDSET1 |
DATA-MART-NAME DIM-TYPE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||
Emp Group | PERSGROUP |
Required
| ||||||||||||
Olap Db | OLAPDBM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Members | HRIAMBR |
|
All trademarks and registered trademarks are the property of their
respective owners.