SAD_AP_SUS_PREV (SQL Table)	Index Back
AP Suspense Previous AI This contains all the Previous AI information from prior years.

SAD_AP_SUS_PREV

(SQL Table)

AP Suspense Previous AI

This contains all the Previous AI information from prior years.

Parent record: SAD_AP_SUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
Prompt Table: SA_TEST_TBL

2 TEST_REC_NBR Number(9,0) DECIMAL(9) NOT NULL Test Type Record Nbr
Prompt Table: SAD_AP_SUS

3 SCHL_PERD_NBR Number(2,0) SMALLINT NOT NULL School Attended Nbr

4 PREV_AI_YRS_AP Character(2) VARCHAR2(2) NOT NULL AP Previous AI Years

5 PREV_AI_CODE_AP Character(6) VARCHAR2(6) NOT NULL AP Previous AI Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID Prompt Table: SA_TEST_TBL
2	TEST_REC_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Test Type Record Nbr Prompt Table: SAD_AP_SUS
3	SCHL_PERD_NBR	Number(2,0)	SMALLINT NOT NULL	School Attended Nbr
4	PREV_AI_YRS_AP	Character(2)	VARCHAR2(2) NOT NULL	AP Previous AI Years
5	PREV_AI_CODE_AP	Character(6)	VARCHAR2(6) NOT NULL	AP Previous AI Code