SAD_UC_CHCE_VW

(SQL View)
Index Back

UCAS Choice View

UCAS Choice View.

SELECT DISTINCT INSTITUTION ,SAD_UC_APPCODE ,SAD_UC_PERS_ID ,SAD_UC_CHOICENO FROM PS_SAD_UC_IVSTARC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code
3 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
4 SAD_UC_CHOICENO Number(3,0) SMALLINT NOT NULL Choice Number