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.OracleHCMDepartment | Org-Department Mapping to PeopleSoft
|
dbo.OrganizationPVO | |
dbo.FLEX_BI_OrgAttributesDFF_VI | |
dbo.VPAreaCollegeUnit | Join of OrganizationPVO and FLEX_BI_OrgAttributesDFF_VI |