SA_TEST_TBL_AET (SQL Table)	Index Back
Academic Test/Exam Codes 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_AET

(SQL Table)

Academic Test/Exam Codes

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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 EFFDT Date(10) DATE Effective Date

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

5 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID
3	EFFDT	Date(10)	DATE	Effective Date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	SCC_ENTITY_ID	Character(40)	VARCHAR2(40) NOT NULL	Entitiy ID