SSR_FC_MTGSFFVW

(SQL View)
Index Back

Faculty Center Setup Fluid

Faculty Center Setup Fluid

SELECT SSR_FC_SETUP_KEY , SSR_FRMFACTYP_FL , SSR_RANGE_MAX , SSR_DESCR80 , SSR_DESCR80_2 , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_SSR_FC_MTGSC_FL WHERE SSR_FRMFACTYP_FL = 'SF'

  • Related Language Record: SSR_FC_MTGSFFLN
  • Parent record: SSR_FC_SETUP_FL
  • # 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_FRMFACTYP_FL Character(2) VARCHAR2(2) NOT NULL Form Factor Type
    LF=Non-small Form Factor
    SF=Small Form Factor
    3 SSR_RANGE_MAX Number(5,0) INTEGER NOT NULL Range Max
    4 SSR_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports.
    5 SSR_DESCR80_2 Character(80) VARCHAR2(80) NOT NULL This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports and communications.
    6 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    7 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    8 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    9 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time