SSR_RS_TOPC_STG

(SQL Table)
 Index Back

Research Enrollment Tracking

Topic - Research Enrollment Tracking

  • Parent record: SSR_RS_TOPC_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number
    4 SSR_RS_TOPIC_SEQ Number(3,0) SMALLINT NOT NULL This field is used to create a unique key when multiple topics exist for a research project.
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 SSR_RS_TOPIC_ID Character(6) VARCHAR2(6) NOT NULL This field is a sequential code used to create unique table entries to pre-define topics to be used in research management.
    7 SSR_RS_TOPIC_CAT Character(2) VARCHAR2(2) NOT NULL Field used to identify if the topic is part of a larger grouping

    Prompt Table: SSR_RS_TPCCATVW

    8 SSR_RS_THESIS_TITL Long Character(254) VARCHAR2(254) Thesis Title
    9 SSR_RS_RSRCH_TOPIC Long Character(254) VARCHAR2(254) Research Topic Description
    10 SSR_RS_STATUS Character(12) VARCHAR2(12) NOT NULL Status associated within the status group code.

    Prompt Table: SSR_RS_TPSTS_VW

    11 SSR_RS_ACTION_DT Date(10) DATE NOT NULL Status Date

    Default Value: %Date

    12 SSR_RS_DESCRLONG Long Character CLOB This field is used for the descrlong field sin research management
    13 SSR_RS_TPCCMNT Long Character(254) VARCHAR2(254) Comment
    14 SSR_DISPLAY_SS Character(1) VARCHAR2(1) NOT NULL Display in Self Service

    Y/N Table Edit

    Default Value: N

    15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time