RB_CIM_ROW_SRVW

(SQL View)
 Index Back

Data Import Batch Row View

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

SELECT B.BATCH_ID , B.TEST_REC_NBR , A.BATCH_STAT , A.TEST_ID , B.B_ROW_STATUS , B.BYPASS_VAL , B.LAST_NAME , B.FIRST_NAME , B.MIDDLE_NAME , B.NAME_PREFIX , B.NAME_SUFFIX , B.E_ADDR_TYPE , B.EMAIL_ADDR , B.PHONE_TYPE , B.PHONE , B.ADDRESS_TYPE , B.ADDRESS1 , B.ADDRESS2 , B.ADDRESS3 , B.CITY , B.STATE , B.POSTAL , B.COUNTRY , B.BIRTHDATE , B.NATIONAL_ID_TYPE , B.NATIONAL_ID , B.SEX , B.MARITAL_STATUS , B.CITIZENSHIP_STATUS , B.INSTITUTION , B.ACAD_CAREER , B.CAMPUS , B.RECRUITING_STATUS , B.ADM_REFRL_SRCE , B.ADMIT_TYPE , B.ADMIT_TERM , B.ACADEMIC_LEVEL , B.LAST_SCH_ATTEND , B.GRADUATION_DT , B.FIN_AID_INTEREST , B.HOUSING_INTEREST , B.RELIGIOUS_PREF , B.REG_REGION , B.EMPLID , B.BO_ID , A.ROW_ADDED_OPRID , %DatePart(A.ROW_ADDED_DTTM) , A.ROW_ADDED_DTTM , B.ROW_LASTMANT_DTTM , B.ROW_LASTMANT_OPRID , A.SYNCID FROM PS_RB_CIM_BAT_HDR A , PS_RB_CIM_BAT_ROW B WHERE B.BATCH_ID = A.BATCH_ID AND A.BATCH_STAT <> 'L'

# 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 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 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
4 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID codes.
5 B_ROW_STATUS Character(1) VARCHAR2(1) NOT NULL This field stores the status of a data import batch row used in the import of prospects and test scores into CRM.
A=Add Person
E=Error
I=Ignore
P=Posted
R=Ready for Processing
S=Suspended
U=Update Person
6 BYPASS_VAL Character(1) VARCHAR2(1) NOT NULL Bypass validation operation when processing rows or sets of rows
N=No
Y=Yes
7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
10 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
11 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
12 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Address type field used in HD_360_RESPONSE_SYNC message.
BUSN=Business
CAMP=Campus
DORM=Dorm
HOME=Home
OTHR=Other
13 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
14 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL phone type field to store value of phone type.
BUSN=Business Phone
CAMP=Campus
CELL=Cellular Phone
DFLT=Default
DORM=Dormitory
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
15 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
16 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address type field to store address type information.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
LEGL=Legal
MAIL=Mailing
OTHR=Other
17 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
18 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
19 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
20 CITY Character(30) VARCHAR2(30) NOT NULL City
21 STATE Character(6) VARCHAR2(6) NOT NULL State
22 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
23 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
24 BIRTHDATE Date(10) DATE Birthdate of the person.
25 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
26 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
27 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown
28 MARITAL_STATUS Character(2) VARCHAR2(2) NOT NULL Marital Status
1=Single
2=Married
3=Married but Separated
4=Divorced
5=Widow
29 CITIZENSHIP_STATUS Character(4) VARCHAR2(4) NOT NULL DMO
NRA=Non-Resident Alien
PRA=Permanent Resident Alien
RA=Resident Alien
USC=U.S. Citizen
30 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.
31 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
32 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
33 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
APPL=Applicant
INAC=Inactive
INQR=Inquiry
PROS=Prospect
SUSP=Suspect
34 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source
35 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit type stores information about the type of admission.
36 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.
37 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
38 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last school attended
39 GRADUATION_DT Date(10) DATE Enter the graduation date information.
40 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest

Y/N Table Edit

41 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing
42 RELIGIOUS_PREF Character(4) VARCHAR2(4) NOT NULL This field stores the religious preference of an individual.
43 REG_REGION Character(5) VARCHAR2(5) NOT NULL REG_REGION field used in the HCM / CRM sync Application Messages.
44 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
45 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
46 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
47 CREATION_DATE Date(10) DATE Creation date of the case.
48 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
49 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
50 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
51 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.