|
|
HRIAMBR FILE
HR Datamart Members
REFERENCED BY
HCMS.1 HCMS.2 HCOP.1 HCOP.2 HCTM.1 HCUF.1
UPDATED BY
HC01.1 HC01.2 HC02.1 HC02.2 HC02.3 HCEM.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIM-APPLIC-NAME Alpha 8 (Lower Case) HC01.1 HC01.2
Application Name The Application Name is the name of the HC02.1 HC02.2
application that describes the database HC02.3 HCEM.1
names it contains. This user-defined
name can contain up to eight characters.
The first letter of the name must be
capitalized.
HIM-DATABASE-NAME Alpha 8 (Lower Case) HC01.1 HC01.2
Database Name The Database Name is the name of the HC02.1 HC02.2
database that is stored within the OLAP HC02.3 HCEM.1
application. Each application may
contain more than one database. This
user-defined name can contain up to
eight characters. The first letter of
the name must be capitalized.
HIM-DIM-TYPE Numeric 3 HC01.1 HC01.2
Dim Type HC02.1 HC02.2
HC02.3 HCEM.1
HIM-MEMBER-TYPE Numeric 3 HC01.1 HC01.2
Member Type HC02.1 HC02.2
HC02.3 HCEM.1
HIM-SEQ-NBR Numeric 4 HC01.2 HC02.2
Sequence Number An automatically assigned sequence HC02.3 HCEM.1
number.
HIM-MBR-USE Alpha 1 HC01.1 HC01.2
Mbr Use HC02.1 HC02.2
HC02.3 HCMS.1
HIM-MBR-NAME Alpha 30 (Lower Case) HC01.1 HC01.2
Member Name The Member Name field contains the HC02.1 HC02.2
user-defined member name for the income
statement member. This name can contain
up to 30 characters of any kind.
HIM-MBR-ALIAS-NAME Alpha 30 (Lower Case) HC01.1 HC01.2
Alias Name HC02.1
HIM-TYPE Alpha 2 HC01.1 HC01.2
Type This identifies whether this record is HC02.1 HC02.2
created because of a picking
transaction, or because of a return.
Valid values are:
"IS" = Picking transaction.
"RR" = Return.
~$1 VENDOR
The vendor's identification code.
HIM-PAY-CLASS Alpha 3 HC01.2
Payment Class
HIM-PAY-SUM-GRP Alpha 3 HC01.2
Payment Summary
Group
HIM-DATE-1 Numeric 8 (yyyymmdd) HC01.1 HC01.2
Date 1
HIM-DATE-2 Numeric 8 (yyyymmdd) HC01.2
Date 2
HIM-FACTOR-1 Signed 7.2 HC01.2
Factor 1
HIM-SELECTION Alpha 100 HC01.1 HC01.2
Selection HC02.1 HC02.2
HC02.3 HCEM.1
HIM-DATE-STAMP Numeric 8 (yyyymmdd) HC01.1 HC01.2
Date Stamp Contains the server date (month, date, HC02.1 HC02.2
and year) of the last change to this HC02.3 HCEM.1
record.
HIM-TIME-STAMP Numeric 6 (hhmmss) HC01.1 HC01.2
Time Stamp Contains the server time (hour, minute, HC02.1 HC02.2
and second) when the record was last HC02.3 HCEM.1
changed.
HIM-USER-ID Alpha 10 (Lower Case) HC01.1 HC01.2
User ID Name Contains the user ID of the person who HC02.1 HC02.2
last changed this record. HC02.3
HRIAMBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HIMSET1 APPLIC-NAME HC01.1 HC01.2
DATABASE-NAME HC02.1 HC02.2
DIM-TYPE HC02.3 HCEM.1
MEMBER-TYPE HCMS.1 HCMS.2
SEQ-NBR HCOP.1 HCOP.2
HCTM.1 HCUF.1
HRIAMBR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Dimension HRIADIM Required
HIM-APPLIC-NAME -> HID-APPLIC-NAME
HIM-DATABASE-NAME -> HID-DATABASE-NAME
HIM-DIM-TYPE -> HID-DIM-TYPE
Olap Db OLAPDBM Required
HIM-APPLIC-NAME -> ODB-APPLIC-NAME
HIM-DATABASE-NAME -> ODB-DATABASE-NAME
Pay Class PAYCLASS Required
When HIM-PAY-CLASS != Spaces
HID-COMPANY -> PCL-COMPANY
HIM-PAY-CLASS -> PCL-PAY-CLASS
Pay Sum Grp PAYSUMGRP Required
When HIM-PAY-SUM-GRP != Spaces
HID-COMPANY -> PSG-COMPANY
HIM-PAY-SUM-GRP -> PSG-PAY-SUM-GRP
HRIAMBR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pay Classes PSGRELATE
Valid When HIM-PAY-SUM-GRP != Spaces
HID-COMPANY -> PSR-COMPANY
HIM-PAY-SUM-GRP -> PSR-PAY-SUM-GRP
PSR-PAY-CLASS
|