RB_CIM_BAT_ROW

(SQL Table)
 Index Back

Data Import Batch Row

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

  • Parent record: RB_CIM_BAT_HDR

    • # 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 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

    Default Value: R

    5 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    6 BYPASS_VAL Character(1) VARCHAR2(1) NOT NULL Bypass validation operation when processing rows or sets of rows
    N=No
    Y=Yes

    Default Value: N

    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 BIRTHDATE Date(10) DATE Birthdate of the person.
    9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    10 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    11 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
    12 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
    13 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
    14 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
    15 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    16 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    17 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    18 CITY Character(30) VARCHAR2(30) NOT NULL City
    19 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    21 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    22 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
    23 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    24 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: RD_CAMPUS_VW

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

    Prompt Table: INSTITUTION_TBL

    26 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

    27 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
    F=Female
    M=Male
    U=Unknown
    28 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status field used in HD_360_RESPONSE_SYNC message.
    A=Annulled
    B=Living Together
    C=Common-Law
    D=Divorced
    E=Separated
    F=Living Apart
    G=Maintained
    H=Head of Household
    I=Interlocutory
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    X=Widowed With Pension
    Y=Polygamous
    29 MARITAL_STATUS Character(2) VARCHAR2(2) NOT NULL Marital Status
    1=Single
    2=Married
    3=Married but Separated
    4=Divorced
    5=Widow
    30 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
    31 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
    32 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
    33 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
    34 CM_PURP_TYPE_ADDR Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration
    35 CM_PURP_TYPE_MAIL Number(6,0) INTEGER NOT NULL CP Purp Type Mail
    36 CM_PURP_TYPE_PHON Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration
    37 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL This field stores the ethnic group code of an individual.
    38 REG_REGION Character(5) VARCHAR2(5) NOT NULL REG_REGION field used in the HCM / CRM sync Application Messages.
    39 ETH_SETID Character(5) VARCHAR2(5) NOT NULL This field stores the SetID for ethnicity.
    40 CITIZENSHIP_STATUS Character(4) VARCHAR2(4) NOT NULL DMO
    NRA=Non-Resident Alien
    PRA=Permanent Resident Alien
    RA=Resident Alien
    USC=U.S. Citizen
    41 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
    APPL=Applicant
    INAC=Inactive
    INQR=Inquiry
    PROS=Prospect
    SUSP=Suspect
    42 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source
    43 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit type stores information about the type of admission.

    Prompt Table: ADMIT_TYPE_VW

    44 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.

    Prompt Table: TERM_TBL

    45 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
    46 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last school attended

    Prompt Table: EXT_ORGSCHL_VW

    47 GRADUATION_DT Date(10) DATE Enter the graduation date information.
    48 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest

    Y/N Table Edit

    49 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing interest
    C=Commuter
    F=Off Campus Housing
    H=On Campus Housing
    50 RELIGIOUS_PREF Character(4) VARCHAR2(4) NOT NULL This field stores the religious preference of an individual.
    51 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    52 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    53 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    54 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    55 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.
    56 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time