SAE_TERM_VW

(SQL View)
 Index Back

SELECT TRM.STRM , TRM.INSTITUTION , TRM.ACAD_CAREER , TRM.DESCR , TRM.TERM_BEGIN_DT , TRM.TERM_END_DT , TRM.DESCRSHORT , TRM.SESSION_CODE , TRM.WEEKS_OF_INSTRUCT , TRM.TERM_CATEGORY , TRM.ACAD_YEAR , TRM.TRANSCIPT_DT_PRT , TRM.HOLIDAY_SCHEDULE , TRM.SIXTY_PCT_DT , TRM.USE_DYN_CLASS_DATE , TRM.SSR_TRMAC_LAST_DT , TRM.SSR_SSENRLDISP_BDT , TRM.SSR_SSENRLDISP_EDT , TRM.SSR_SSPLNRDISP_BDT , TRM.SSR_SSPLNRDISP_EDT , TERMSCOPE.SAE_MODE , TERMSCOPE.SAE_EVENT_DT , 'T' SAE_UNITIND FROM %Table(TERM_TBL) TRM , %Table(SAE_TERM_EXT) TERMSCOPE , %Table(SAE_INST_SCOPE) INSTSCOPE WHERE TRM.INSTITUTION = INSTSCOPE.INSTITUTION AND INSTSCOPE.SAE_MODE <> 'D' AND TRM.STRM = TERMSCOPE.STRM AND TRM.INSTITUTION = TERMSCOPE.INSTITUTION AND TRM.ACAD_CAREER = TERMSCOPE.ACAD_CAREER AND TERMSCOPE.SAE_INCLUDE = 'Y' AND (( %CurrentDateIn >= TRM.TERM_BEGIN_DT ) OR EXISTS ( SELECT 'x' FROM PS_SAE_CLASS_EXT CLS_EXT , PS_SAE_SESSION_EXT SES_EXT WHERE CLS_EXT.INSTITUTION = SES_EXT.INSTITUTION AND CLS_EXT.ACAD_CAREER = SES_EXT.ACAD_CAREER AND CLS_EXT.STRM = SES_EXT.STRM AND CLS_EXT.SESSION_CODE = SES_EXT.SESSION_CODE AND CLS_EXT.INSTITUTION = TRM.INSTITUTION AND CLS_EXT.ACAD_CAREER = TRM.ACAD_CAREER AND CLS_EXT.STRM = TRM.STRM AND %Coalesce(CLS_EXT.SAE_INTEG_START_DT, %DateAdd(CLS_EXT.START_DT, SES_EXT.SAE_START_OFFSET)) <= %CurrentDateIn ) ) AND ( (%CurrentDateIn <= TRM.TERM_END_DT) OR EXISTS ( SELECT 'x' FROM PS_SAE_CLASS_EXT CLS_EXT , PS_SAE_SESSION_EXT SES_EXT WHERE CLS_EXT.INSTITUTION = SES_EXT.INSTITUTION AND CLS_EXT.ACAD_CAREER = SES_EXT.ACAD_CAREER AND CLS_EXT.STRM = SES_EXT.STRM AND CLS_EXT.SESSION_CODE = SES_EXT.SESSION_CODE AND CLS_EXT.INSTITUTION = TRM.INSTITUTION AND CLS_EXT.ACAD_CAREER = TRM.ACAD_CAREER AND CLS_EXT.STRM = TRM.STRM AND %Coalesce(CLS_EXT.SAE_INTEG_END_DT, %DateAdd(CLS_EXT.END_DT, SES_EXT.SAE_END_OFFSET)) >= %CurrentDateIn ) )

  • Related Language Record: SAE_TERM_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 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_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: TERM_VAL_TBL.DESCR

    5 TERM_BEGIN_DT Date(10) DATE NOT NULL Term Begin Date
    6 TERM_END_DT Date(10) DATE NOT NULL Term Ending Date
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TERM_VAL_TBL.DESCRSHORT

    8 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2

    Prompt Table: SESSION_TBL

    9 WEEKS_OF_INSTRUCT Number(2,0) SMALLINT NOT NULL Weeks of Instruction
    10 TERM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Term Category
    0=Full Year
    1=1st Semester
    2=2nd Semester
    3=Summer Session AUS
    4=Winter Session AUS
    C=Medical Clinical
    I=Intersession Term
    M=Medical Level 1
    R=Regular Term
    S=Summer Term
    W=Winter Term

    Default Value: R

    11 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    12 TRANSCIPT_DT_PRT Character(2) VARCHAR2(2) NOT NULL Transcript Date Print
    C=Print Class Dates
    N=Do Not Print Any Dates
    S=Print Session Dates
    T=Print Term Dates

    Default Value: INSTALLATION_SA.TRANSCIPT_DT_PRT

    13 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Default Value: ACAD_CAR_TBL.HOLIDAY_SCHEDULE

    Prompt Table: HOLIDAY_TBL

    14 SIXTY_PCT_DT Date(10) DATE NOT NULL Sixty Percent Point in Time
    15 USE_DYN_CLASS_DATE Character(1) VARCHAR2(1) NOT NULL Use Dynamic Class Dates

    Y/N Table Edit

    Default Value: ACAD_CAR_TBL.USE_DYN_CLASS_DATE

    16 SSR_TRMAC_LAST_DT Date(10) DATE NOT NULL Max Program Effdt for Term

    Default Value: TERM_TBL.TERM_BEGIN_DT

    17 SSR_SSENRLDISP_BDT Date(10) DATE NOT NULL Show term in Self Service Enrollment begin date
    18 SSR_SSENRLDISP_EDT Date(10) DATE NOT NULL Show term in Self Service Enrollment end date
    19 SSR_SSPLNRDISP_BDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date
    20 SSR_SSPLNRDISP_EDT Date(10) DATE NOT NULL Show term in Self Service Planner end date
    21 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
    A=Add
    C=Change
    D=Delete
    22 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp
    23 SAE_UNITIND Character(1) VARCHAR2(1) NOT NULL Unit Indicator