Database Links

Database links use a database account from the target database to login and access tables.

Database Link to HRDW

In the case of ITS Admin it uses SECE's ITSADMIN_SECE_USR database account. This account has only been granted access to the following SECE tables:

NOTE: in order to have the database link see more tables you would need to grant the ITSADMIN_SECE_USR database account in the target SECE database the privileges.

SECE Database

TABLE NAME	PURPOSE
PLCITEMS	To access account information
PLCONCAMPUS	To access pay step and rates
STUDENT	To access student profile data
JOBCONTACTS	To access supervisor data
CONTACT	To access supervisor data
JOB	To access job data
JOBDESCR	To access job data
PAYSCALE	To access pay step and rates
PLACEMENT	To access active placement data

HR Datamart (data loaded nightly from PeopleSoft)

TABLE NAME	DESCRIPTION
PSEMPL	Person and position info
PSACCT	Account info
PSCERT	n/u
PSETHNICITY	n/u
PSNAME	n/u
PSPOSNA	n/u
PSPOSNM	n/u
PSQACCT	n/u
PSQEMPL	n/u
PSQPOSNA	n/u
PSQPOSNM	n/u
PSSUSP	n/u
PSTENPRO	n/u
HR_CURR_EMPL_SUPV_TBL	n/u

ITS Admin

Database Links

Analytics

Related content