TP_CONTRCT_SRCH

(SQL View)
 Index Back

Third Party Contract View

This view will be used to display the valid Third Party Contracts - TP_CON_TYPE = 'T'

SELECT A.BUSINESS_UNIT ,A.CONTRACT_NUM ,A.TP_CONTRACT_TYPE ,A.EXT_ORG_ID ,B.DESCR ,A.TP_STATUS ,A.TP_CON_EXT_CON_NUM ,A.DELIVER_CODE ,A.REQUISITION_NBR FROM PS_TP_CONTRACT A , PS_EXT_ORG_TBL B WHERE A.TP_CON_TYPE = 'T' AND B.EXT_ORG_ID = A.EXT_ORG_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EXT_ORG_TBL B1 WHERE B1.EXT_ORG_ID= B.EXT_ORG_ID AND B1.EFFDT<=%CurrentDateIn)

  • Related Language Record: TPCONTRCTSRCHLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

    Prompt Table: TP_CONT_SRCH_VW

    3 TP_CONTRACT_TYPE Character(1) VARCHAR2(1) NOT NULL Third Party Contract Type
    C=Specific Course
    L=Specific Course List
    P=Specific Year or Period
    T=Specific Term
    4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 TP_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
    A=Active
    C=Cancelled
    H=Hold
    I=Inactive
    U=Not Posted

    Default Value: A

    7 TP_CON_EXT_CON_NUM Character(30) VARCHAR2(30) NOT NULL External Contract
    8 DELIVER_CODE Character(30) VARCHAR2(30) NOT NULL Delivery Code
    9 REQUISITION_NBR Character(30) VARCHAR2(30) NOT NULL Requisition Number