RB_CIM_ACAD (SQL Table)	Index Back
Data Import Academic Details This record is a staging record to store the import academic details from a Higher Education data import of prospects and test scores.

RB_CIM_ACAD

(SQL Table)

Data Import Academic Details

This record is a staging record to store the import academic details 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic program field coming from campus solution system.
Prompt Table: ACAD_PROG_TBL

5 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan field coming from campus solution system
Prompt Table: ACAD_PLAN_TBL

6 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic sub plan, a field together with program, plan, and sub plan to store student program information.
Prompt Table: ACAD_SUBPLN_TBL

#	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic program field coming from campus solution system. Prompt Table: ACAD_PROG_TBL
5	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan field coming from campus solution system Prompt Table: ACAD_PLAN_TBL
6	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic sub plan, a field together with program, plan, and sub plan to store student program information. Prompt Table: ACAD_SUBPLN_TBL