HRLakehouse - Access Request
- Maurya Mehta
- Jefferson Russell
- Shreya Phapunkar
If you need HR data for your system or reporting needs, you will need to access it through the HRLakehouse.
Application or Personal Access
ACL Request
How to Connect
Once access has been granted use any SQL database tools to connect to the lake house.
Provide the database name HRLakehouse in the connection parameters. For example in SSMS:
Step 1: Enter server address and usf email address  | Step 2: Switch to connection properties and enter database name HRLakehouse  |
|---|
HRLakehouse Objects
Reporting Views
The following curated list of HRLakehouse objects is designed to streamline your data retrieval process, ensuring you access the most relevant and essential information quickly. This collection includes:
Lakehouse Object | Description | Mapping |
|---|---|---|
Organization Structure | ||
ita.VPAreaCollegeUnit | Contains organizational hierarchy including sub-departments, departments, colleges or units, and VP Areas. | |
Employee Demographic and Appointment | ||
ita.EmployeeInformation | Provides employee demographic data such as NetID, Person Number, phone number, address, etc. | |
ita.EmployeeAssignment | Provides employee assignment related data such as | |
Payroll Information | ||
ita. PayCheck | Contains the total paycheck amount for an employee in a pay period. It provides the total earnings, total deductions, total tax and net pay. | |
ita.PayDeductions | Contains the Pay deductions and earnings for an employee in a pay period. It provides the Chartfield distribution for standard earnings and deductions | |
fast.PS_PAY_ERN_DIST | Contains earnings distribution information which provides an employee earnings allocation across various chartfields for a given pay period. | |
fast.PS_HR_ACCTG_LINE | Contains detailed accounting information for payroll and other HR-related financial transactions. | |
Additional Lakehouse Views
The HRLakehouse objects listed below provide additional data to support more complex reporting requirements.