TITLE_IV_SRCH (SQL View)	Index Back
Title IV Schools/Univ Srch Use SCHOOL_SRCH to find schools by the SCHOOL_CODE, description or commonly used codes..

TITLE_IV_SRCH

(SQL View)

Title IV Schools/Univ Srch

Use SCHOOL_SRCH to find schools by the SCHOOL_CODE, description or commonly used codes..

SELECT aid_year , cps_school_code , descr FROM PS_TIV_SCHOOL_TBL

Related Language Record: TITLEIVSRCHLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Prompt Table: AID_YR_TBL_LANG

2 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Prompt Table: AID_YR_TBL_LANG
2	CPS_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	CPS School Code. Also known as Title IV School Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description