SSR_RS_TPCORGVW

(SQL View)
 Index Back

Topic Organization Record

Topic Organization Record

SELECT A.institution , a.ssr_Rs_topic_id ,a.ssr_project_ind , a.ext_org_id , b.descr FROM PS_SSR_RS_TPC_ORG A JOIN PS_EXT_ORG_TBL B ON A.ext_org_id = B.ext_org_id WHERE %EffdtCheck(SSR_RS_TPC_ORG ef1,A ,%currentdatein) AND a.ssr_rs_orgtyp_ind ='1' AND %EffdtCheck(EXT_ORG_TBL ef2,B ,%currentdatein) UNION SELECT A.institution , a.ssr_Rs_topic_id ,a.ssr_project_ind , a.ACAD_ORG , b.descr FROM PS_SSR_RS_TPC_ORG A JOIN PS_ACAD_ORG_TBL B ON A.ACAD_ORG = B.ACAD_ORG WHERE %EffdtCheck(SSR_RS_TPC_ORG ef1,A ,%currentdatein) AND a.ssr_rs_orgtyp_ind ='2' AND %EffdtCheck(ACAD_ORG_TBL ef2,B ,%currentdatein)

  • Parent record: SSR_RS_TPCSETUP

    • # 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_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.
    3 SSR_PROJECT_IND Character(1) VARCHAR2(1) NOT NULL Project
    4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_SRCH

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description