SSR_PROG_FORM_V

(SQL View)
 Index Back

Program of Study Format Detail


SELECT a.INSTITUTION , a.SSR_FORMAT_ID , b.SSR_NODE_ID , b.DESCR50 , b.SSR_ITEM_TYPE , b.SSR_PARENT_NODE_ID , CASE WHEN b.SSR_ITEM_TYPE = a.SSR_ITEM_TYPE_PLN THEN 'Y' ELSE 'N' END , CASE WHEN b.SSR_ITEM_TYPE = a.SSR_ITEM_TYPE_YOP THEN 'Y' ELSE 'N' END , CASE WHEN b.SSR_ITEM_TYPE = a.SSR_ITEM_TYPE_EQT THEN 'Y' ELSE 'N' END , CASE WHEN b.SSR_ITEM_TYPE = a.SSR_ITEM_TYPE_EQS THEN 'Y' ELSE 'N' END , b.SSR_YR_OF_PROG , a.SSR_PLN_DATE_CNTL FROM PS_SSR_PROG_FORM a , PS_SSR_PROG_FORM_D b WHERE a.INSTITUTION = b.INSTITUTION AND a.SSR_FORMAT_ID = b.SSR_FORMAT_ID

  • Related Language Record: SSR_PROGFORM_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 SSR_FORMAT_ID Character(15) VARCHAR2(15) NOT NULL Format ID
    3 SSR_NODE_ID Number(4,0) SMALLINT NOT NULL Node ID
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type

    Prompt Table: SSR_ITYP_CA_VW

    6 SSR_PARENT_NODE_ID Number(4,0) SMALLINT NOT NULL Parent Node ID
    7 SSR_PLANNING_NODE Character(1) VARCHAR2(1) NOT NULL Planning Node

    Y/N Table Edit

    8 SSR_YOP_FL Character(1) VARCHAR2(1) NOT NULL Equates to Year of Program

    Y/N Table Edit

    9 SSR_TERM_LVL_FL Character(1) VARCHAR2(1) NOT NULL Equates to a Term

    Y/N Table Edit

    10 SSR_SESS_LVL_FL Character(1) VARCHAR2(1) NOT NULL Equates to a Session

    Y/N Table Edit

    11 SSR_YR_OF_PROG Character(4) VARCHAR2(4) NOT NULL Year of Program
    00=Not Set
    01=01 - First Year
    02=02 - Second Year
    03=03 - Third Year
    04=04 - Fourth Year
    05=05 - Fifth Year
    06=06 - Sixth Year
    12 SSR_PLN_DATE_CNTL Character(2) VARCHAR2(2) NOT NULL Student Planning
    10=Term/Session Table
    20=Academic Period Table