The BICC Mappings X-Walk is a mapping of tables and fields from the source GEMS to the equivalent table and fields within Oracle HCM and to the HR Lakehouse. The mapping is provided as a method to find a table or field that users are familiar with from GEMS and lookup the new location of that table and field within Oracle HCM and the HR Lakehouse.
Overview of Excel Layout
...
There are several tabs at the bottom of the screen. Each tab represents a logical grouping provided by the Oracle HCM or Analytics team.
...
Comments - Shows important information or primary key identifier.
Example Usage
...
Given the above screen shot of the Worker tab, if the user were looking for PS_JOB.EMPL_STATUS, the equivalent field is GlobalPersonPVOViewAll.AssignmentStatusTypesTLPEOUserStatus
...
FROM [hcm].[GlobalPersonPVOViewAll]
How to find the GEMS Table or Field
In Excel, click CTRL + F simultaneously to use the ‘Find and Replace’ option in Excel (see image below). Enter what you are searching for, then expand the ‘Search options’ highlighted below. For this example, we will search ‘POSITION_NBR’:
...
Tab | Source | HR Lakehouse |
|---|---|---|
Worker | PS_JOB.POSTION_NBR | hcm.GlobalPersonPVOViewAll.PositionPEOPositionCode |
Position | PS_POSITION_DATA.POSITION_NBR | hcm.PositionPVOViewAll.PositionPEOPositionCode |
ita.EmployeeAssignment | View that references GlobalPersonPVOViewAll.PositionPEOPositionCode | ita.EmployeeAssignment.PositionCode |
PS_PAY_ERN_DIST | PS_PAY_ERN_DIST.POSTION_NBR | fast.PS_PAY_ERN_DIST.POSTION_NBR |
ita.EmployeeInformation
The ita.EmployeeInformation view is one of a few curated lists of HR Lakehouse objects designed to streamline your data retrieval process, ensuring you access the most relevant and essential information quickly. This collection includes: ita.EmployeeAssignment, ita.PayCheck, ita.PayDeduction, ita.VPAreaCollegeUnit, FAST.PS_HR_ACCTG_LINE, and FAST.PS_PAY_ERN_DIST. These views have a condensed name under the ‘Lakehouse Column Name’ for user consumption and understanding. From the Excel tab ‘ita.EmployeeInformation’ you can see the columns available for use in this view.
...
A note for the ita.EmployeeAssignment view is to be aware that there are several USF employees that have multiple assignments. This view will not necessarily return one person, but one assignment per person.
ita.EmployeeAssignment
Another view is the ita.EmployeeAssignment view that is also one of a few curated lists of HR Lakehouse objects designed to streamline your data retrieval process, ensuring you access the most relevant and essential information quickly. is a consolidated view created by the Analytics team. A note for the ita.EmployeeAssignment view is to be aware that there are several USF employees that have multiple assignments. This view will not necessarily return one person, but one assignment per person.
...