SAD_UC_SCHCXTVW

(SQL View)
Index Back

SCHOOL CONTEXTUAL SEARCH VIEW

SCHOOL CONTEXTUAL DATA SEARCH VIEW

SELECT C.INSTITUTION , C.SAD_UC_SCHOOL , S.SAD_UC_SCHOOLNAME , C.SAD_UC_YEAR , C.SAD_UC_TIMESTAMP ,c.SAD_UC_IMPORTED , c.SAD_UC_ACTIVE_IND FROM %Table(SAD_UC_SCH_CtXT) C , %Table(SAD_UC_SCHOOL) S WHERE C.SAD_UC_SCHOOL=S.SAD_UC_SCHOOL

# 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_SCHOOL Character(10) VARCHAR2(10) NOT NULL UCAS School

Prompt Table: SAD_UC_SCHOOLVW

3 SAD_UC_SCHOOLNAME Character(100) VARCHAR2(100) NOT NULL School Name
4 SAD_UC_YEAR Number(4,0) SMALLINT NOT NULL School Year
5 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
6 SAD_UC_IMPORTED Character(1) VARCHAR2(1) NOT NULL Imported
7 SAD_UC_ACTIVE_IND Character(1) VARCHAR2(1) NOT NULL Active