If you need HR data for your system or reporting needs, you will need to access thru this Employee Data Lake.
Application or Personal Access
To access this data lake 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
Data Product: Employee Data Lake
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 data lake, you need to submit an ACL Request.
Source Information: Provide your source host name.
Server
Port: 1433
Employee Data Lake Objects
Object Name | Documentation |
---|---|
dbo.ActionOccurencesPVO | |
dbo.ActionReasonsPVO | |
dbo.ActionsPVO | |
dbo.ActionTypesPVO | |
dbo.CitizenshipPVOViewAll | |
dbo.CountryPVO | |
dbo.ExternaIIdentifierPVO | |
dbo.FLEX_BI_OrgAttributesDFF_VI | |
dbo.GlobalPersonPVOViewAll | |
dbo.LegalEmployerPVO | |
dbo.LookupValuesPVO | |
dbo.DepartmentPVOViewAll | Org-Department Mapping to PeopleSoft
|
dbo.OrganizationPVO | |
dbo.PersonEthinicityPVOViewAll | |
dbo.SalaryBasesPVO | |
dbo.SalaryPVO | |
dbo.StateProvincePVO | |
dbo.UnionPVO | |
dbo.VPAreaCollegeUnit | Join of dbo.OrganizationPVO and dbo.FLEX_BI_OrgAttributesDFF_VI |