SA_TEST_CMP_TBL (SQL Table)	Index Back
Test Component Table Use SA_TEST_CMP_TBL to define the components of a test such as a quantitative or verbal section. Use the SA_TCMP_REL_TBL, test component relationship table, to define the components that are valid for a test. The test component pairs table prompts but does not edit on the Test Components Table. This allows for entering components that aren't on the Test Components Table. You may wish to do this if a component is unique to a given test and you don't want to maintain it in the Test Components Table. Use SA_TEST_TBL to assign codes to academic tests and enter descriptions. An academic test is any test that a student must take to qualify for admission, satisfy prerequisites, or achieve advanced placement.

SA_TEST_CMP_TBL

(SQL Table)

Test Component Table

Use SA_TEST_CMP_TBL to define the components of a test such as a quantitative or verbal section. Use the SA_TCMP_REL_TBL, test component relationship table, to define the components that are valid for a test. The test component pairs table prompts but does not edit on the Test Components Table. This allows for entering components that aren't on the Test Components Table. You may wish to do this if a component is unique to a given test and you don't want to maintain it in the Test Components Table. Use SA_TEST_TBL to assign codes to academic tests and enter descriptions. An academic test is any test that a student must take to qualify for admission, satisfy prerequisites, or achieve advanced placement.

Related Language Record: SA_TEST_CMP_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Enter the test component information.

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

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

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

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: SA_TEST_CMP_TBL.DESCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_COMPONENT	Character(5)	VARCHAR2(5) NOT NULL	Enter the test component information.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: SA_TEST_CMP_TBL.DESCR