RB_CIM_TST_SCRE (SQL Table)	Index Back
Data Import Test Score Details This record is a staging record to store the import test score data from a Higher Education data import of prospects and test scores.

RB_CIM_TST_SCRE

(SQL Table)

Data Import Test Score Details

This record is a staging record to store the import test score data from a Higher Education data import of prospects and test scores.

Parent record: RB_CIM_BAT_ROW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BATCH_ID Number(15,0) DECIMAL(15) NOT NULL CDH INTERFACE TABLE FIELD - BATCH_ID
Prompt Table: RB_CIM_BAT_HDR

2 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.

3 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID codes.
Prompt Table: SA_TEST_TBL

4 TEST_DT Date(10) DATE NOT NULL Enter test date.

5 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Enter the test component information.
Prompt Table: SA_TCMP_REL_TBL

6 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

7 TEST_ID_OVRD Character(11) VARCHAR2(11) NOT NULL Test ID Over
Prompt Table: SA_TEST_TBL

8 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score

9 SCORE_LETTER Character(4) VARCHAR2(4) NOT NULL Enter the test score letter code.

10 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL Academic level
0=Unknown
01=Pre-Eighth Grade
1=Eighth Grade
2=Ninth Grade
3=Tenth Grade
4=Eleventh Grade
5=Twelfth Grade
6=Postsecondary First Year
7=Postsecondary Sophomore
8=Postsecondary Junior
9=Postsecondary Senior
90=Post-Secondary
91=Postsecondary Professional
92=Postsecondary Master
93=Postsecondary Doctoral
94=Postdoctoral
A1=Basic User/Breakthrough (NLD)
A2=Basic User/Waystage (NLD)
B1=Independ. User/Threshold (NLD)
B2=Independ. User/Vantage (NLD)
C1=Prof. User/Effective (NLD)
C2=Proficient User/Master (NLD)

11 DATE_LOADED Date(10) DATE Date campus information loaded

12 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile information captured using this field.

13 TEST_ADMIN Character(1) VARCHAR2(1) NOT NULL Enter the test administration information.

14 TEST_INDEX Number(7,1) DECIMAL(6,1) NOT NULL Enter the test index information.

15 REV_SCORE_IND Character(1) VARCHAR2(1) NOT NULL Rev Score Indicator

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BATCH_ID	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - BATCH_ID Prompt Table: RB_CIM_BAT_HDR
2	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.
3	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID codes. Prompt Table: SA_TEST_TBL
4	TEST_DT	Date(10)	DATE NOT NULL	Enter test date.
5	TEST_COMPONENT	Character(5)	VARCHAR2(5) NOT NULL	Enter the test component information. Prompt Table: SA_TCMP_REL_TBL
6	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
7	TEST_ID_OVRD	Character(11)	VARCHAR2(11) NOT NULL	Test ID Over Prompt Table: SA_TEST_TBL
8	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score
9	SCORE_LETTER	Character(4)	VARCHAR2(4) NOT NULL	Enter the test score letter code.
10	EXT_ACAD_LEVEL	Character(4)	VARCHAR2(4) NOT NULL	Academic level 0=Unknown 01=Pre-Eighth Grade 1=Eighth Grade 2=Ninth Grade 3=Tenth Grade 4=Eleventh Grade 5=Twelfth Grade 6=Postsecondary First Year 7=Postsecondary Sophomore 8=Postsecondary Junior 9=Postsecondary Senior 90=Post-Secondary 91=Postsecondary Professional 92=Postsecondary Master 93=Postsecondary Doctoral 94=Postdoctoral A1=Basic User/Breakthrough (NLD) A2=Basic User/Waystage (NLD) B1=Independ. User/Threshold (NLD) B2=Independ. User/Vantage (NLD) C1=Prof. User/Effective (NLD) C2=Proficient User/Master (NLD)
11	DATE_LOADED	Date(10)	DATE	Date campus information loaded
12	PERCENTILE	Number(3,0)	SMALLINT NOT NULL	Percentile information captured using this field.
13	TEST_ADMIN	Character(1)	VARCHAR2(1) NOT NULL	Enter the test administration information.
14	TEST_INDEX	Number(7,1)	DECIMAL(6,1) NOT NULL	Enter the test index information.
15	REV_SCORE_IND	Character(1)	VARCHAR2(1) NOT NULL	Rev Score Indicator