ADM_CAR_PARMS

(SQL Table)
 Index Back

Personal and Career Data Parms

Personal Data and Career related information parameters needed to determine the recruiters information and recruiting categories. This information is used to process recruiting information via a batch program.

  • Parent Record Of ADM_INTRS_PARMS ADM_PROG_PARMS ADM_RECR_PARMS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    4 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: CITIZEN_STS_TBL
    Set Control Field: COUNTRY

    5 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    6 ZIP_SELECTION Character(1) VARCHAR2(1) NOT NULL Postal Selection
    B=Begins With
    E=Equals To
    N=Not Applicable
    R=Range

    Default Value: N

    7 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    8 ZIP_TO Character(12) VARCHAR2(12) NOT NULL This field is another postal code/zip code field which can be used to specify the range of Zip code. If the regular Zip is used as a 'From/Only' zip code field then this field can be used as a 'To' field.
    9 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: COUNTRY_TBL

    11 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: SAD_STATE_C2_VW

    12 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    13 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    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_SCRTY

    14 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

    Prompt Table: TERM_TBL

    15 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

    Prompt Table: ADMIT_TYPE_VW

    16 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    17 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
    18 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    19 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
    APPL=Applicant
    INAC=Inactive
    INQR=Inquiry
    PAPL=Pre-Applicant
    PROS=Prospect
    SUSP=Suspect
    20 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source

    Prompt Table: REFERL_SRCE_TBL

    21 ADM_CREATION_DT Date(10) DATE Admission Data Creation Date
    22 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center

    Prompt Table: ADM_RECRCTR_SVW

    23 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing Interest
    C=Commuter
    F=Off Campus Housing
    H=On Campus Housing
    24 FIN_AID_SELECTION Character(1) VARCHAR2(1) NOT NULL This is a field is similar to FIN_AID_INTEREST except that there translate values which describe if the student is interested in Financial Aid or not or did not check for it.
    I=Interested in Fin Aid
    N=Not Interested in Fin Aid
    R=Not Applicable

    Default Value: R

    25 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last School Attended

    Prompt Table: EXT_ORGSCHL_VW

    26 GRADUATION_DT Date(10) DATE Graduation Date
    27 RECR_INTEREST_CHK Character(1) VARCHAR2(1) NOT NULL Region Assignment

    Y/N Table Edit

    Default Value: Y

    28 RECR_CAT_INTER_CHK Character(1) VARCHAR2(1) NOT NULL Categories/Recruiters

    Y/N Table Edit

    Default Value: Y

    29 REGION_FROM Character(1) VARCHAR2(1) NOT NULL Region from
    A=Address
    O=School
    R=Region Tree

    Default Value: R

    30 REGION_SELECTION Character(1) VARCHAR2(1) NOT NULL Region Selection
    A=Not Applicable
    B=Replace Blank
    N=Replace Non-Blank

    Default Value: A

    31 REGION_SEL_PROMPT Character(10) VARCHAR2(10) NOT NULL Region Selection Prompt

    Prompt Table: REGN_BASE_SRCH

    32 REGION Character(10) VARCHAR2(10) NOT NULL Region

    Prompt Table: REGN_BASE_SRCH

    33 SUBJECT_SELECTION Character(1) VARCHAR2(1) NOT NULL Subject Priority Selection
    N=Not Applicable
    O=Non-Priority
    P=Priority

    Default Value: N

    34 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: HCR_REG_REGN_I