SSR_FC_LBLSFFVW

(SQL View)
 Index Back

Class Search General Options


SELECT SSR_FC_SETUP_KEY , SSR_CS_IDX_FF , SSR_CLSLBL_DESCR1 , SSR_CLSLBL_FLD1 , SSR_CLSLBL_CODE1 , SSR_CLSLBL_SEP2_PX , SSR_CLSLBL_SEP2 , SSR_CLSLBL_SEP2_SX , SSR_CLSLBL_DESCR2 , SSR_CLSLBL_FLD2 , SSR_CLSLBL_CODE2 , SSR_CLSLBL_SEP3_PX , SSR_CLSLBL_SEP3 , SSR_CLSLBL_SEP3_SX , SSR_CLSLBL_DESCR3 , SSR_CLSLBL_FLD3 , SSR_CLSLBL_CODE3 , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_SSR_FC_CLSLBL WHERE SSR_CS_IDX_FF = 'S'

  • Related Language Record: SSR_FC_LBLSFFLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_FC_SETUP_KEY Character(2) VARCHAR2(2) NOT NULL Faculty Center Setup Key
    2 SSR_CS_IDX_FF Character(1) VARCHAR2(1) NOT NULL Form Factor Type
    N=Non-Small Form Factor
    S=Small Form Factor

    Default Value: S

    3 SSR_CLSLBL_DESCR1 Character(10) VARCHAR2(10) NOT NULL Class Data Label
    4 SSR_CLSLBL_FLD1 Character(1) VARCHAR2(1) NOT NULL Data Source
    C=Class Component
    N=Class Number
    S=Class Section
    5 SSR_CLSLBL_CODE1 Character(1) VARCHAR2(1) NOT NULL Use Component Code

    Y/N Table Edit

    6 SSR_CLSLBL_SEP2_PX Character(1) VARCHAR2(1) NOT NULL Blank Separator

    Y/N Table Edit

    7 SSR_CLSLBL_SEP2 Character(1) VARCHAR2(1) NOT NULL Separator Character
    8 SSR_CLSLBL_SEP2_SX Character(1) VARCHAR2(1) NOT NULL Blank Separator

    Y/N Table Edit

    9 SSR_CLSLBL_DESCR2 Character(10) VARCHAR2(10) NOT NULL Class Data Label
    10 SSR_CLSLBL_FLD2 Character(1) VARCHAR2(1) NOT NULL Data Source
    C=Class Component
    N=Class Number
    S=Class Section
    11 SSR_CLSLBL_CODE2 Character(1) VARCHAR2(1) NOT NULL Use Component Code

    Y/N Table Edit

    12 SSR_CLSLBL_SEP3_PX Character(1) VARCHAR2(1) NOT NULL Blank Separator

    Y/N Table Edit

    13 SSR_CLSLBL_SEP3 Character(1) VARCHAR2(1) NOT NULL Separator Character
    14 SSR_CLSLBL_SEP3_SX Character(1) VARCHAR2(1) NOT NULL Blank Separator

    Y/N Table Edit

    15 SSR_CLSLBL_DESCR3 Character(10) VARCHAR2(10) NOT NULL Class Data Label
    16 SSR_CLSLBL_FLD3 Character(1) VARCHAR2(1) NOT NULL Data Source
    C=Class Component
    N=Class Number
    S=Class Section
    17 SSR_CLSLBL_CODE3 Character(1) VARCHAR2(1) NOT NULL Use Component Code

    Y/N Table Edit

    18 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    19 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    20 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    21 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time