RB_CIM_BAT_SRVW (SQL View)	Index Back
Data Import Batch Header View This view returns the HE data import batches for use in configurable search.

RB_CIM_BAT_SRVW

(SQL View)

Data Import Batch Header View

This view returns the HE data import batches for use in configurable search.

SELECT A.BATCH_ID , A.BATCH_STAT , A.TEST_ID , A.IMP_SOURCE , A.IMP_RUN_CNTL_ID , A.IMP_PROC_INSTANCE , A.IMP_OPRID , A.INSTITUTION , A.ACAD_CAREER , A.DATE_LOADED , A.ROW_ADDED_OPRID , %DatePart(A.ROW_ADDED_DTTM) , A.ROW_ADDED_DTTM , A.CNT_S_READY + A.CNT_S_ADD + A.CNT_S_UPD + A.CNT_S_POSTED + A.CNT_S_IGNORE + A.CNT_S_SUSPEND + A.CNT_S_ERROR , A.CNT_S_READY , A.CNT_S_POSTED , A.CNT_S_IGNORE , A.CNT_S_SUSPEND , A.CNT_S_ERROR , A.CNT_S_ADD , A.CNT_S_UPD , A.CNT_PURGED , A.CNT_POSTED , A.CNT_ADDED , A.CNT_UPDATED , A.CNT_S_READY + A.CNT_S_ADD + A.CNT_S_UPD , A.CNT_S_POSTED + A.CNT_S_IGNORE , A.LAST_ACTION , %DatePart(A.LAST_ACTION_DTTM) , A.LAST_ACTION_BY , A.LAST_PRC_INST , A.LAST_PURGE_BY , %DatePart(A.LAST_PURGE_DTTM) , A.LAST_PURGE_INST , A.LAST_IMPORT_BY , %DatePart(A.LAST_IMPORT_DTTM) , A.LAST_IMPORT_INST , A.SYNCID FROM PS_RB_CIM_BAT_HDR A

# 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

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

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

4 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

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

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

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

8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

9 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

10 DATE_LOADED Date(10) DATE Date campus information loaded

11 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By

12 CREATION_DATE Date(10) DATE Creation date of the case.

13 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime

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

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

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

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

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

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

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

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

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

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

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

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

26 CNT_AWAIT_IMPORT Number(9,0) DECIMAL(9) NOT NULL Designates the number of HE data import rows that are awaiting import. This is a calculated field based on the number of rows in ready + add person + update person statuses.

27 CNT_AWAIT_PURGE Number(9,0) DECIMAL(9) NOT NULL Designates the number of HE data import rows that are awaiting purge. This is a calculated field based on the number of rows in posted + ignore statuses.

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_DATE Date(10) DATE This field designates the date that the data import batch was last imported or purged.

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_DATE Date(10) DATE This field stores the date that the data import batch was last purged.

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_DATE Date(10) DATE This field designates the date that the data import batch was last imported.

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

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

#	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
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
3	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID codes.
4	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
5	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.
6	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.
7	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.
8	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system.
9	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
10	DATE_LOADED	Date(10)	DATE	Date campus information loaded
11	CREATED_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Created By
12	CREATION_DATE	Date(10)	DATE	Creation date of the case.
13	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
14	CNT_ROWS	Number(9,0)	DECIMAL(9) NOT NULL	Total Row Count
15	CNT_S_READY	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Ready for Processing' status.
16	CNT_S_POSTED	Number(9,0)	DECIMAL(9) NOT NULL	Count of rows having a status of posted
17	CNT_S_IGNORE	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Ignore' status.
18	CNT_S_SUSPEND	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Suspended' status.
19	CNT_S_ERROR	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Error' status.
20	CNT_S_ADD	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Add Person' status.
21	CNT_S_UPD	Number(9,0)	DECIMAL(9) NOT NULL	This field stores the number of import rows in the 'Update Person' status.
22	CNT_PURGED	Number(9,0)	DECIMAL(9) NOT NULL	Count of rows purged
23	CNT_POSTED	Number(9,0)	DECIMAL(9) NOT NULL	Count of rows posted (add or update)
24	CNT_ADDED	Number(9,0)	DECIMAL(9) NOT NULL	Count of the number of new rows/people created
25	CNT_UPDATED	Number(9,0)	DECIMAL(9) NOT NULL	Number of rows/constituents updated (modified or changed)
26	CNT_AWAIT_IMPORT	Number(9,0)	DECIMAL(9) NOT NULL	Designates the number of HE data import rows that are awaiting import. This is a calculated field based on the number of rows in ready + add person + update person statuses.
27	CNT_AWAIT_PURGE	Number(9,0)	DECIMAL(9) NOT NULL	Designates the number of HE data import rows that are awaiting purge. This is a calculated field based on the number of rows in posted + ignore statuses.
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_DATE	Date(10)	DATE	This field designates the date that the data import batch was last imported or purged.
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_DATE	Date(10)	DATE	This field stores the date that the data import batch was last purged.
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_DATE	Date(10)	DATE	This field designates the date that the data import batch was last imported.
37	LAST_IMPORT_INST	Number(10,0)	DECIMAL(10) NOT NULL	Stores the process instance of the last import against this batch.
38	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.