If you need HR data for your system or reporting needs, you will need to access thru this Employee Data Lake.
Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
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.ExternamIdentifierPVO | |
dbo.FLEX_BI_OrgAttributesDFF_VI | |
dbo.GlobalPersonPVOViewAll | |
dbo.LegalEmployerPVO | |
dbo.LookupValuesPVO | |
dbo.OracleHCMDepartment | 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 |