SA_TEST_TBL_VW (SQL View)	Index Back
Academic Test/Exam Codes View Use SA_TEST_TBL to assign codes to tests and enter descriptions. A test can be any type of academic test that a student must take to qualify admission, satisfy prerequisites, or receive advanced placement credit. Vocational tests are assigned in a separate record, the TEST_TBL. You can create only one SA_TEST_TBL record per test code.

SA_TEST_TBL_VW

(SQL View)

Academic Test/Exam Codes View

Use SA_TEST_TBL to assign codes to tests and enter descriptions. A test can be any type of academic test that a student must take to qualify admission, satisfy prerequisites, or receive advanced placement credit. Vocational tests are assigned in a separate record, the TEST_TBL. You can create only one SA_TEST_TBL record per test code.

SELECT TEST_ID , EFFDT , DESCR , DESCRSHORT FROM PS_SA_TEST_TBL

Related Language Record: SA_TEST_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: SA_TEST_TBL.DESCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: SA_TEST_TBL.DESCR