RB_CIM_BAT_HDR (SQL Table)	Index Back
Data Import Batch Row This record is a staging record to store the import batch header from a Higher Education data import of prospects and test scores.

RB_CIM_BAT_HDR

(SQL Table)

Data Import Batch Row

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

Parent Record Of RB_CIM_BAT_ROW RB_CIM_NAME_VAL RB_CIM_ROW_SBR

# 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 BATCH_STAT Character(1) VARCHAR2(1) NOT NULL This field stores the status of a data import batch used in the import of prospects and test scores into CRM.
A=Active
C=Purged
E=Error
I=Import in Progress
L=Load in Progress
P=Purge in Progress
Default Value: L

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

4 DATE_LOADED Date(10) DATE NOT NULL Date campus information loaded

5 IMP_SOURCE Character(4) VARCHAR2(4) NOT NULL This field designates the source of the data import for import of prospects and test scores into CRM. Valid values can designate either Campus or External sources.
CAMP=Campus Solutions
EXT=External

6 IMP_RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL This field stores the run control ID used in the import of a data batch for import of prospects and test scores into CRM.

7 IMP_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL This field stores the process instance in the import of a data batch for import of prospects and test scores into CRM.

8 IMP_OPRID Character(30) VARCHAR2(30) NOT NULL This field stores the user ID of the person who ran the data import for import of prospects and test scores into CRM.

9 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.
Prompt Table: INSTITUTION_TBL

10 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

11 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version

12 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic career field coming from campus solution system.
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table: ACAD_CAR_TBL

13 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center

14 SAD_ETHNIC_PRCS_SW Character(1) VARCHAR2(1) NOT NULL Ethnicity Update Rule
I=Update If Not Populated
U=Update All Records

15 SAD_ACT_ETH_VER Character(1) VARCHAR2(1) NOT NULL Update IPEDS Ethnicity
D=Do Not Update
N=For New Person Records Added

16 CNT_ROWS Number(9,0) DECIMAL(9) NOT NULL Total Row Count

17 CNT_S_READY Number(9,0) DECIMAL(9) NOT NULL This field stores the number of import rows in the 'Ready for Processing' status.

18 CNT_S_POSTED Number(9,0) DECIMAL(9) NOT NULL Count of rows having a status of posted

19 CNT_S_IGNORE Number(9,0) DECIMAL(9) NOT NULL This field stores the number of import rows in the 'Ignore' status.

20 CNT_S_SUSPEND Number(9,0) DECIMAL(9) NOT NULL This field stores the number of import rows in the 'Suspended' status.

21 CNT_S_ERROR Number(9,0) DECIMAL(9) NOT NULL This field stores the number of import rows in the 'Error' status.

22 CNT_S_ADD Number(9,0) DECIMAL(9) NOT NULL This field stores the number of import rows in the 'Add Person' status.

23 CNT_S_UPD Number(9,0) DECIMAL(9) NOT NULL This field stores the number of import rows in the 'Update Person' status.

24 CNT_PURGED Number(9,0) DECIMAL(9) NOT NULL Count of rows purged

25 CNT_POSTED Number(9,0) DECIMAL(9) NOT NULL Count of rows posted (add or update)

26 CNT_ADDED Number(9,0) DECIMAL(9) NOT NULL Count of the number of new rows/people created

27 CNT_UPDATED Number(9,0) DECIMAL(9) NOT NULL Number of rows/constituents updated (modified or changed)

28 LAST_ACTION Character(1) VARCHAR2(1) NOT NULL This field is used by the HE Data Importer to indicate what action was last run on the batch, import or purge.
I=Import
P=Purge

29 LAST_ACTION_DTTM DateTime(26) TIMESTAMP LAST_ACTION_DTTM

30 LAST_ACTION_BY Character(30) VARCHAR2(30) NOT NULL This field stores the user ID of the person who ran the last import or purge upon the data import batch.

31 LAST_PRC_INST Number(10,0) DECIMAL(10) NOT NULL This field stores the last process instance used by the HE data importer for this batch.

32 LAST_PURGE_BY Character(30) VARCHAR2(30) NOT NULL Stores the user ID of the person who ran the last purge against this batch.

33 LAST_PURGE_DTTM DateTime(26) TIMESTAMP Stores the timestamp of when the last purge against this batch was run.

34 LAST_PURGE_INST Number(10,0) DECIMAL(10) NOT NULL Stores the process instance of the last purge against this batch.

35 LAST_IMPORT_BY Character(30) VARCHAR2(30) NOT NULL Stores the user ID of the person who ran the last import against this batch.

36 LAST_IMPORT_DTTM DateTime(26) TIMESTAMP Stores the timestamp of when the last import against this batch was run.

37 LAST_IMPORT_INST Number(10,0) DECIMAL(10) NOT NULL Stores the process instance of the last import against this batch.

38 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

39 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

40 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

41 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

42 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

43 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	BATCH_STAT	Character(1)	VARCHAR2(1) NOT NULL	This field stores the status of a data import batch used in the import of prospects and test scores into CRM. A=Active C=Purged E=Error I=Import in Progress L=Load in Progress P=Purge in Progress Default Value: L
3	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID codes. Prompt Table: SA_TEST_TBL
4	DATE_LOADED	Date(10)	DATE NOT NULL	Date campus information loaded
5	IMP_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	This field designates the source of the data import for import of prospects and test scores into CRM. Valid values can designate either Campus or External sources. CAMP=Campus Solutions EXT=External
6	IMP_RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	This field stores the run control ID used in the import of a data batch for import of prospects and test scores into CRM.
7	IMP_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	This field stores the process instance in the import of a data batch for import of prospects and test scores into CRM.
8	IMP_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field stores the user ID of the person who ran the data import for import of prospects and test scores into CRM.
9	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system. Prompt Table: INSTITUTION_TBL
10	MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
11	VERSIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation Version
12	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic career field coming from campus solution system. BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Prompt Table: ACAD_CAR_TBL
13	ADM_RECR_CTR	Character(4)	VARCHAR2(4) NOT NULL	Recruiting Center
14	SAD_ETHNIC_PRCS_SW	Character(1)	VARCHAR2(1) NOT NULL	Ethnicity Update Rule I=Update If Not Populated U=Update All Records
15	SAD_ACT_ETH_VER	Character(1)	VARCHAR2(1) NOT NULL	Update IPEDS Ethnicity D=Do Not Update N=For New Person Records Added
16	CNT_ROWS	Number(9,0)	DECIMAL(9) NOT NULL	Total Row Count
17	CNT_S_READY	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Ready for Processing' status.
18	CNT_S_POSTED	Number(9,0)	DECIMAL(9) NOT NULL	Count of rows having a status of posted
19	CNT_S_IGNORE	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Ignore' status.
20	CNT_S_SUSPEND	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Suspended' status.
21	CNT_S_ERROR	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Error' status.
22	CNT_S_ADD	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Add Person' status.
23	CNT_S_UPD	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Update Person' status.
24	CNT_PURGED	Number(9,0)	DECIMAL(9) NOT NULL	Count of rows purged
25	CNT_POSTED	Number(9,0)	DECIMAL(9) NOT NULL	Count of rows posted (add or update)
26	CNT_ADDED	Number(9,0)	DECIMAL(9) NOT NULL	Count of the number of new rows/people created
27	CNT_UPDATED	Number(9,0)	DECIMAL(9) NOT NULL	Number of rows/constituents updated (modified or changed)
28	LAST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	This field is used by the HE Data Importer to indicate what action was last run on the batch, import or purge. I=Import P=Purge
29	LAST_ACTION_DTTM	DateTime(26)	TIMESTAMP	LAST_ACTION_DTTM
30	LAST_ACTION_BY	Character(30)	VARCHAR2(30) NOT NULL	This field stores the user ID of the person who ran the last import or purge upon the data import batch.
31	LAST_PRC_INST	Number(10,0)	DECIMAL(10) NOT NULL	This field stores the last process instance used by the HE data importer for this batch.
32	LAST_PURGE_BY	Character(30)	VARCHAR2(30) NOT NULL	Stores the user ID of the person who ran the last purge against this batch.
33	LAST_PURGE_DTTM	DateTime(26)	TIMESTAMP	Stores the timestamp of when the last purge against this batch was run.
34	LAST_PURGE_INST	Number(10,0)	DECIMAL(10) NOT NULL	Stores the process instance of the last purge against this batch.
35	LAST_IMPORT_BY	Character(30)	VARCHAR2(30) NOT NULL	Stores the user ID of the person who ran the last import against this batch.
36	LAST_IMPORT_DTTM	DateTime(26)	TIMESTAMP	Stores the timestamp of when the last import against this batch was run.
37	LAST_IMPORT_INST	Number(10,0)	DECIMAL(10) NOT NULL	Stores the process instance of the last import against this batch.
38	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
39	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
40	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
41	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
42	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
43	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time