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.OracleHCMDepartmentActionOccurencesPVO | Org-Department Action Mapping to PeopleSoft | |
dbo.OrganizationPVOActionReasonsPVO | Org-Divisions Action Mapping to PeopleSoft | |
dbo.FLEX_BI_OrgAttributesDFF_VIOrg-Divisions ActionsPVO | ||
dbo.VPAreaCollegeUnitJoin of dbo.OrganizationPVO and dbo.FLEX_BI_OrgAttributesDFF_VIActionTypesPVO | ||
dbo.SalaryPVOCitizenshipPVOViewAll | ||
dbo.CountryPVO | ||
dbo.StateProvincePVOExternamIdentifierPVO | ||
dbo.PersonEthinicityPVOViewAllEthnicity FLEX_BI_OrgAttributesDFF_VI | ||
dbo.ActionsPVOGlobalPersonPVOViewAll | Action Worker Mapping to PeopleSoft | |
dbo.ActionReasonsPVOLegalEmployerPVO | ||
dbo.ActionOccurencesPVOAction LookupValuesPVO | ||
dbo.OracleHCMDepartment | Org-Department Mapping to PeopleSoft
| |
dbo.ActionTypesPVOOrganizationPVO | ||
dbo.CitizenshipPVOViewAllPersonEthinicityPVOViewAll | Citizenship Ethnicity Mapping to PeopleSoft | |
dbo.GlobalPersonPVOViewAllSalaryBasesPVO | ||
dbo.LegalEmployerPVOSalaryPVO | Company Salary Mapping to PeopleSoft | |
dbo.SalaryBasesPVOStateProvincePVO | Frequency State Mapping to PeopleSoft | |
dbo.ExternamIdentifierPVOUnionPVO | Worker Union Mapping to PeopleSoft | |
dbo.LookupValuesPVOVPAreaCollegeUnit | dbo.UnionPVO | Union Mapping to PeopleSoftJoin of dbo.OrganizationPVO and dbo.FLEX_BI_OrgAttributesDFF_VI |