HRLakehouse - Access Request

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.

To access the objects in the HRLakehouse, you need to submit an ACL Request.
Source Information: Provide your source host name.
Destination Information:
Server
- Test: test-usfsynapseanalytics-ondemand.sql.azuresynapse.net
- Prod: usfsynapseanalytics-ondemand.sql.azuresynapse.net
Port: 1433

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:

hcm.DepartmentPVOViewAll	Org-Department Mapping to PeopleSoft
hcm.OrganizationPVO hcm.FLEXBIOrgAttributesDFFVI	Org-Divisions Mapping to PeopleSoft
hcm.PerOrgTreeStructureBICVO	OrgTree Mapping to PeopleSoft
ita.VPAreaCollegeUnit	IT Analytics derived organizational structure, to reduce the number of joins required by end users to understand reporting structure in Oracle HCM

hcm.ContactPhonesPVO	Contacts Mapping to PeopleSoft
hcm.ContactRelshipsPVO	Contact Relationships Mapping to PeopleSoft
hcm.ExternalIdentifierPVO	External Identifier Mapping to PeopleSoft
hcm.FlexBIPersonsDFFVI	Person DFF Mapping to PeopleSoft
hcm.VisaPermitPVOViewAll	Visa Status Mapping to PeopleSoft
hcm.DocumentsOfRecordExtractPVO	Transcript Mapping to PeopleSoft
ita.EmployeeInformation	Derived employee information data to minimize extensive joins across multiple Lakehouse objects

hcm.PositionPVOViewAll hcm.FlexBIPositionCustomerFlexVI	Position Data Mapping to PeopleSoft
hcm.JobPVOViewAll hcm.JobExtractPVO	Job Mapping to PeopleSoft
hcm.SalaryExtractPVO hcm.SalaryPVO	Compensation Mapping to Peoplesoft
hcm.GradePVO	Salary Grade mapping to PeopleSoft
hcm.RatePVO	Grade Rate mapping to PeopleSoft
hcm.RateValuePVO	Grade Rate Value mapping to PeopleSoft
hcm.ValidGradesPVO	Grade Valid Grades mapping
hcm.SeniorityDatesPVO	Seniority Dates Mapping to PeopleSoft

hcm.GlobalPersonPVOViewAll	Worker Mapping to PeopleSoft
hcm.PersonExtraInformationEFFBIFlattenedVO	Tenure Mapping to PeopleSoft
hcm.PersonLegislativeInfoPVOViewAll	Other PVO Mapping to PeopleSoft
hcm.AssignmentPVO	Assignment Mapping to PeopleSoft
hcm.AssignmentSupervisorPVO	Assignment Supervisor Mapping to PeopleSoft
hcm.ManagerHrchyBottomUpPVOLineManager	Manager Hierarchy Mapping to PeopleSoft
hcm.FlexBIBaseWorkerAsgDFFVI	Assignment DFF to PeopleSoft
ita.EmployeeAssignment	Derived assignment data to minimize the number of joins required by users querying assignment data

hcm.AbsenceTypePVO

hcm.AbsencePlanPVO

hcm.PersonAbsEntryPVO

hcm.PersonAccrualEntryPVO

hcm.ActionOccurrencesPVO hcm.ActionReasonsPVO hcm.ActionsPVO hcm.ActionTypesPVO	Action Mapping to PeopleSoft
hcm.LookupValuesPVO	Other PVO Mapping to PeopleSoft
hcm.CountryPVO	Country Mapping to PeopleSoft
hcm.CitizenshipPVOViewAll	Citizenship Mapping to PeopleSoft
hcm.LegalEmployerPVO	Company Mapping to PeopleSoft
hcm.PersonEthinicityPVOViewAll	Ethnicity Mapping to PeopleSoft
hcm.SalaryBasesPVO	Frequency Mapping to PeopleSoft
hcm.Geography	State Mapping to PeopleSoft
hcm.UnionPVO	Union Mapping to PeopleSoft
hcm.TimePeriodPVO	Time Period Mapping to Peoplesoft
hcm.HRLocationsPVOViewAll	Locations Mapping to Peoplesoft

fast.PS_HR_ACCTG_LINE

Data is sourced from FAST after payroll processing.

hcm.PayrollDistribution

hcm.PaymentCosting