ADM_APPL_SBP_VW

(SQL View)
 Index Back

Admission Applicant Subplan VW

This Admission Applicant Subplan 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 , effdt , effseq , acad_plan , acad_sub_plan , declare_dt , req_term , SCC_ROW_ADD_OPRID ,SCC_ROW_ADD_DTTM ,SCC_ROW_UPD_OPRID ,SCC_ROW_UPD_DTTM FROM PS_ADM_APPL_SBPLAN

  • Parent record: ADM_APPL_PLAN

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

    Prompt Table: ADM_APP_CAR_SEQ

    6 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Default Value: ACAD_PLAN.ACAD_PLAN

    Prompt Table: ADM_APPL_PLAN

    9 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

    Prompt Table: ACAD_SUBPLN_TBL

    10 DECLARE_DT Date(10) DATE NOT NULL Declare Date

    Default Value: %date

    11 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term

    Prompt Table: TERM_TBL

    12 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    13 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    14 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    15 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time