ADM_APP_CAR_SVW

(SQL View)
 Index Back

Adm Applicant Career Sequence

This Admission Applicant Career Sequence Table view is used to propagate changes made to the Student Records Academic Program stack to the Admissions Application stack. Changes are copied only if the Academic Program originated from the Admissions stack.

select emplid, acad_career, stdnt_car_nbr, adm_appl_nbr, appl_prog_nbr, evaluatn_status, evaluation_dt, evaluation_chg, summary_new, test_score_new, course_new, subject_new, genl_matl_new, auto_update, stdnt_car_nbr_sr, create_prog_status from PS_ADM_APP_CAR_SEQ

  • Parent record: ADM_APPL_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 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: STDNT_CAREER

    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Prompt Table: ADM_APPL_DATA

    5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
    6 EVALUATN_STATUS Character(2) VARCHAR2(2) NOT NULL Evaluation Status
    CM=Complete
    IP=In Progress

    Default Value: NA

    Prompt Table: EVAL_STATUS_TBL

    7 EVALUATION_DT Date(10) DATE Evaluation Date

    Default Value: %date

    8 EVALUATION_CHG Character(1) VARCHAR2(1) NOT NULL Evaluation Changed

    Y/N Table Edit

    Default Value: N

    9 SUMMARY_NEW Character(1) VARCHAR2(1) NOT NULL New Summary

    Y/N Table Edit

    Default Value: N

    10 TEST_SCORE_NEW Character(1) VARCHAR2(1) NOT NULL New Test Score

    Y/N Table Edit

    Default Value: N

    11 COURSE_NEW Character(1) VARCHAR2(1) NOT NULL New Course

    Y/N Table Edit

    Default Value: N

    12 SUBJECT_NEW Character(1) VARCHAR2(1) NOT NULL New Subject

    Y/N Table Edit

    Default Value: N

    13 GENL_MATL_NEW Character(1) VARCHAR2(1) NOT NULL New General Material

    Y/N Table Edit

    Default Value: N

    14 AUTO_UPDATE Character(1) VARCHAR2(1) NOT NULL Automatic Update Process

    Y/N Table Edit

    Default Value: N

    15 STDNT_CAR_NBR_SR Number(3,0) SMALLINT NOT NULL Student Career Number
    16 CREATE_PROG_STATUS Character(1) VARCHAR2(1) NOT NULL Create Program Status
    E=Fatal SQL Error(s) Encountered
    M=Readmit Error
    R=Required
    S=Successfully Processed
    T=Setup/Input Error