SAD_ACT_SUS_COL (SQL Table)	Index Back
ACT Suspense College Extracur SAD_ACT_SUS_COL contains the ACT College Extracuricular Planned Activities.

SAD_ACT_SUS_COL

(SQL Table)

ACT Suspense College Extracur

SAD_ACT_SUS_COL contains the ACT College Extracuricular Planned Activities.

# 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_ACT_SUS

3 COLLEGE_ACTIV_ACT Character(2) VARCHAR2(2) NOT NULL ACT College Activities
CC=Campus or Community Service
DC=Departmental Clubs
DE=Debate
DT=Dramatics, Theater
FS=Fraternity or Sorority
IA=Intramural Athletics
IM=Instrumental Music
PO=Political Organizations
PU=Publications
RE=Racial or Ethnic Organizations
RO=Religious Organizations
RT=Radio-TV
SG=Student Government
SI=Special Interest Groups
VA=Varsity Athletics
VM=Vocal Music
Prompt Table: PSXLATITEM

4 COL_PARTICIP_ACT Character(1) VARCHAR2(1) NOT NULL Participated
Y/N Table Edit
Default Value: N

#	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_ACT_SUS
3	COLLEGE_ACTIV_ACT	Character(2)	VARCHAR2(2) NOT NULL	ACT College Activities CC=Campus or Community Service DC=Departmental Clubs DE=Debate DT=Dramatics, Theater FS=Fraternity or Sorority IA=Intramural Athletics IM=Instrumental Music PO=Political Organizations PU=Publications RE=Racial or Ethnic Organizations RO=Religious Organizations RT=Radio-TV SG=Student Government SI=Special Interest Groups VA=Varsity Athletics VM=Vocal Music Prompt Table: PSXLATITEM
4	COL_PARTICIP_ACT	Character(1)	VARCHAR2(1) NOT NULL	Participated Y/N Table Edit Default Value: N