SAD_UC_PERIDVW

(SQL View)
 Index Back

SELECT a.oprid ,a.institution , a.sad_uc_system , a.sad_uc_appyear , a.sad_uc_pers_id , a.sad_uc_appcode , a.emplid , b.last_name_srch , b.first_name_srch , b.last_name , b.first_name ,f.oprclass ,f.birthdate , f.birthdate_msk FROM %Table(SAD_UC_APPLOPVW) a JOIN PS_PERSON_NAME b ON a.emplid = b.emplid JOIN PS_PERSON_MSK_VW F ON a.emplid = f.emplid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 SAD_UC_SYSTEM Character(4) VARCHAR2(4) NOT NULL UCAS System
APPL=Apply
GTTR=UTT
GTTR=UTT
UCAS=UCAS
4 SAD_UC_APPYEAR Character(4) VARCHAR2(4) NOT NULL Application Year
5 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
6 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
10 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
11 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
12 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
13 BIRTHDATE Date(10) DATE Date of Birth
14 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth