SAD_TEST_XLT_VW

(SQL View)
 Index Back

Test ID Translate View

This view is used as the edit table for the Test ID Setup Record. It displays both the Test ID and the Test Description.

SELECT %Substring(A.FIELDVALUE,1,3) , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'SAD_TEST_ID' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PSXLATITEM A1 WHERE A1.FIELDNAME = A.FIELDNAME AND A1.FIELDVALUE = A.FIELDVALUE AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name