SAD_BIO_PRS_SUS

(SQL Table)
 Index Back

Data Import Bio Details

This record is used for building message structure to hold bio demo details to subscribe bio demo details from a Higher Education data import of prospects and test scores.

  • Parent record: SAD_HEADER_CRM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID codes.
    2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    3 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.
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
    6 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
    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 BIRTHDATE Date(10) DATE Birthdate of the person.
    11 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
    F=Female
    M=Male
    U=Unknown
    12 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
    13 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
    14 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    15 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    16 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.
    17 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

    18 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
    APPL=Applicant
    INAC=Inactive
    INQR=Inquiry
    PROS=Prospect
    SUSP=Suspect
    19 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
    20 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    21 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    22 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    23 CITY Character(30) VARCHAR2(30) NOT NULL City
    24 STATE Character(6) VARCHAR2(6) NOT NULL State
    25 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    26 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    27 CITIZENSHIP_STATUS Character(4) VARCHAR2(4) NOT NULL DMO
    NRA=Non-Resident Alien
    PRA=Permanent Resident Alien
    RA=Resident Alien
    USC=U.S. Citizen
    28 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
    29 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
    30 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
    31 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
    32 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    33 REG_REGION Character(5) VARCHAR2(5) NOT NULL REG_REGION field used in the HCM / CRM sync Application Messages.
    34 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL This field stores the ethnic group code of an individual.
    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 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source
    39 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last school attended
    40 GRADUATION_DT Date(10) DATE Enter the graduation date information.
    41 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest
    42 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing interest
    C=Commuter
    F=Off Campus Housing
    H=On Campus Housing
    43 RELIGIOUS_PREF Character(4) VARCHAR2(4) NOT NULL This field stores the religious preference of an individual.