SAD_PRS_INT_SUS (SQL Table)	Index Back
Data Import Interest Details This record is used for building message structure to hold Interest Details details to subscribe Interest Details details from a Higher Education data import of prospects and test scores.

SAD_PRS_INT_SUS

(SQL Table)

Data Import Interest Details

This record is used for building message structure to hold Interest Details details to subscribe Interest Details details from a Higher Education data import of prospects and test scores.

Parent record: SAD_BIO_PRS_SUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID codes.

2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

3 TEST_REC_NBR Number(9,0) DECIMAL(9) NOT NULL Unique record number within a batch. This field was created by CRM and should be replaced with the OFFICIAL version of the field from Campus.

4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

5 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL The data source for the application data.
A8=TEAS Degree Information
AAD=AADSAS
ACT=American College Testing
AE=Ad-Hoc Employee
AMC=AMCAS
AO=Ad-Hoc Organizational
E=Extract
ETS=Educational Testing Service
GH=OLSAS Last Secondary-G2
LSD=LSDAS
PI=Prev/Post Secondary Info
RS=OLSAS Postsecondary Info
SCH=School
SLF=Self-Reported Information
WWW=World Wide Web
Default Value: SLF

8 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID codes.
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	TEST_REC_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Unique record number within a batch. This field was created by CRM and should be replaced with the OFFICIAL version of the field from Campus.
4	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	EXT_SUBJECT_AREA	Character(4)	VARCHAR2(4) NOT NULL	External Subject Area
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	LS_DATA_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	The data source for the application data. A8=TEAS Degree Information AAD=AADSAS ACT=American College Testing AE=Ad-Hoc Employee AMC=AMCAS AO=Ad-Hoc Organizational E=Extract ETS=Educational Testing Service GH=OLSAS Last Secondary-G2 LSD=LSDAS PI=Prev/Post Secondary Info RS=OLSAS Postsecondary Info SCH=School SLF=Self-Reported Information WWW=World Wide Web Default Value: SLF
8	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority