SAD_TEST_RECS2 (SQL Table)	Index Back
Additional Candidate Info Recs This table contains the names of the records used to hold Additional Candidate Information. Each record is populated by the Admissions Test Post process. This list of records will be used to validate queries for the Create Prospects from Data Loads process.

SAD_TEST_RECS2

(SQL Table)

Additional Candidate Info Recs

This table contains the names of the records used to hold Additional Candidate Information. Each record is populated by the Admissions Test Post process. This list of records will be used to validate queries for the Create Prospects from Data Loads process.

Parent record: SAD_TEST_SETUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SAD_TEST_ID Character(3) VARCHAR2(3) NOT NULL Admissions Test Load Ids
ACT=ACT Assessment
ADA=American Dental Association
AMC=Medical College Admission Test
AP=Advanced Placement
CRS=Candidate Referral Service
DAT=Dental Admission Test
EOS=Educational Opportunity Srvc
GMS=GMASS
GMT=Grad Management Admission Test
GRE=Graduate Record Exam
LST=Law School Admission Test
QTC=Queensland Tertiary Admissions
SAT=Scholastic Assessment Test
SSS=Student Search Service
STC=South Australian Tertiary Adm.
TFL=Test of Engl as a Foreign Lang
UAC=UAC
VTC=Victoria Teritory Acad Center

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

3 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N