SAD_ACT_CD_COL (SQL Table)	Index Back
ACT SPS College Activities SAD_ACT_CD_COL contains the ACT College Extracuricular Activities

SAD_ACT_CD_COL

(SQL Table)

ACT SPS College Activities

SAD_ACT_CD_COL contains the ACT College Extracuricular Activities

Parent record: SAD_ACT_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 TEST_DT Date(10) DATE NOT NULL Test Date
Prompt Table: SAD_ACT_CD

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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	TEST_DT	Date(10)	DATE NOT NULL	Test Date Prompt Table: SAD_ACT_CD
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