SSR_RS_SUPR_TYP

(SQL Table)
Index Back

Research Supervisor Type setup

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 SSR_RS_SUPER_TYPE Character(4) VARCHAR2(4) NOT NULL Supervisor Role
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    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