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.DepartmentPVOViewAll | Org-Department Mapping to PeopleSoft
| ||
dbo.ExternaIIdentifierPVO | |||
dbo.FLEX_BI_OrgAttributesDFF_VI | |||
dbo.GlobalPersonPVOViewAll | |||
dbo.LegalEmployerPVO | |||
dbo.LookupValuesPVO | |||
dbo.DepartmentPVOViewAllOrganizationPVO | Org-Department Divisions Mapping to PeopleSoft
| ||
dbo.OrganizationPVOPersonEthinicityPVOViewAll | Org-Divisions Ethnicity Mapping to PeopleSoft | ||
dbo.PersonEthinicityPVOViewAllPersonLegislativeInfoPVOViewAll | Ethnicity Other PVO Mapping to PeopleSoft | ||
dbo.SalaryBasesPVO | |||
dbo.SalaryPVO | |||
dbo.StateProvincePVO | |||
dbo.UnionPVO | |||
dbo.VPAreaCollegeUnit | Join of dbo.OrganizationPVO and dbo.FLEX_BI_OrgAttributesDFF_VI | dbo.PersonLegislativeInfoPVOViewAll |