SAD_UC_STARWVW

(SQL View)
 Index Back

SELECT a.institution , a.sad_uc_pers_id , a.sad_uc_appcode , a.emplid , c.last_name_srch , c.first_name_srch , c.last_name , c.first_name ,a.sad_uc_appyear ,a.Sad_uc_timestamp ,a.SAD_UC_CHOICE_CNCL ,a.sad_uc_recstatus FROM ps_sad_uc_starw a LEFT OUTER JOIN PS_PERSON_NAME c ON a.emplid = c.emplid WHERE a.sad_uc_system = 'UCAS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
3 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
6 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 SAD_UC_APPYEAR Character(4) VARCHAR2(4) NOT NULL Application Year
10 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
11 SAD_UC_CHOICE_CNCL Character(1) VARCHAR2(1) NOT NULL Cancelled

Y/N Table Edit

12 SAD_UC_RECSTATUS Character(2) VARCHAR2(2) NOT NULL Status
NA=No Action
P=Pending
PR=Partially Removed
R=Removed

Default Value: P