SSR_PROG_FORM

(SQL Table)
 Index Back

Program of Study Format

  • Related Language Record: SSR_PROGFORM_LN

  • Parent Record Of SSR_PRGFRM_R_LN SSR_PRGFRM_T_LN SSR_PROGFRM_DLN SSR_PROG_FORM_D SSR_PROG_FORM_R SSR_PROG_FORM_T

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SSR_ITEM_TYPE_PLN Character(20) VARCHAR2(20) NOT NULL Planning Node Item Type

    Prompt Table: SSR_ITEM_PFN_VW

    5 SSR_ITEM_TYPE_YOP Character(20) VARCHAR2(20) NOT NULL Year of Program Item Type

    Prompt Table: SSR_ITEM_PFN_VW

    6 SSR_ITEM_TYPE_EQT Character(20) VARCHAR2(20) NOT NULL Equates to a Term Item Type

    Prompt Table: SSR_ITEM_PFN_VW

    7 SSR_ITEM_TYPE_EQS Character(20) VARCHAR2(20) NOT NULL Equates to a Session

    Prompt Table: SSR_ITEM_PFN_VW

    8 ADD_SESSION Character(1) VARCHAR2(1) NOT NULL Add Session Level

    Y/N Table Edit

    Default Value: N

    9 SSR_PLN_DATE_CNTL Character(2) VARCHAR2(2) NOT NULL Student Planning
    10=Term/Session Table
    20=Academic Period Table

    Default Value: 20

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