HRLakehouse - Access Request
- Maurya Mehta
- Chukwuebuka Ezema
- Jefferson Russell
If you need HR data for your system or reporting needs, you will need to access it through the HRLakehouse.
Application or Personal Access
Access to the HRLakehouse will be through SQL Authentication where a user and database name will be provided to developers.
For requesting this type of access, submit a ticket to it-analytics@usf.edu with the following information included:
Server
Test: test-usfsynapseanalytics-ondemand.sql.azuresynapse.net
Prod: usfsynapseanalytics-ondemand.sql.azuresynapse.net
Data Product: HRLakehouse
Table(s)/View(s): Provide list of available objects you need to which you need access.
Reason for Access: Provide a reason for user gaining access.
Optional: Account Name you prefer or to which you are adding access.
ACL Request
To access the objects in the HRLakehouse, you need to submit an ACL Request.
Source Information: Provide your source host name.
Destination Information:
ServerPort: 1433
Connection Parameters
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:
HRLakehouse Objects
Organization Structure
hcm.DepartmentPVOViewAll | |
hcm.OrganizationPVO | |
hcm.PerOrgTreeStructureBICVO | |
ita.VPAreaCollegeUnit | IT Analytics derived organizational structure, to reduce the number of joins required by end users to understand reporting structure in Oracle HCM |
Information
hcm.ContactPhonesPVO | |
hcm.ContactRelshipsPVO | |
hcm.ExternalIdentifierPVO | |
hcm.FlexBIPersonsDFFVI | |
hcm.VisaPermitPVOViewAll | |
hcm.DocumentsOfRecordExtractPVO | |
ita.EmployeeInformation | Derived employee information data to minimize extensive joins across multiple Lakehouse objects |
Job, Position & Compensation
hcm.PositionPVOViewAll hcm.FlexBIPositionCustomerFlexVI |
|
hcm.JobPVOViewAll hcm.JobExtractPVO | |
hcm.SalaryExtractPVO hcm.SalaryPVO | |
hcm.GradePVO | |
hcm.RatePVO | |
hcm.RateValuePVO | |
hcm.ValidGradesPVO | |
hcm.SeniorityDatesPVO |
Employee Assignment
hcm.GlobalPersonPVOViewAll | |
hcm.PersonExtraInformationEFFBIFlattenedVO | |
hcm.PersonLegislativeInfoPVOViewAll | |
hcm.AssignmentPVO | |
hcm.AssignmentSupervisorPVO | |
hcm.ManagerHrchyBottomUpPVOLineManager | |
hcm.FlexBIBaseWorkerAsgDFFVI | |
ita.EmployeeAssignment | Derived assignment data to minimize the number of joins required by users querying assignment data |
Leave Administration
hcm.AbsenceTypePVO hcm.AbsencePlanPVO hcm.PersonAbsEntryPVO |
|
hcm.PersonAccrualEntryPVO |
Payroll
fast.PS_HR_ACCTG_LINE | Data is sourced from FAST after payroll processing. |
fast.PS_PAY_ERN_DIST | Data is sourced from FAST after payroll processing. |
hcm.PayrollDistribution | |
hcm.PaymentCosting |
|
Oracle HCM Setup
hcm.ActionOccurrencesPVO | |
hcm.LookupValuesPVO | |
hcm.CountryPVO | |
hcm.CitizenshipPVOViewAll | |
hcm.LegalEmployerPVO | |
hcm.PersonEthinicityPVOViewAll | |
hcm.SalaryBasesPVO | |
hcm.Geography | |
hcm.UnionPVO | |
hcm.TimePeriodPVO | |
hcm.HRLocationsPVOViewAll |