SSF_STD_TPGR_VW

(SQL View)
 Index Back

Student Contract Group View


SELECT DISTINCT A.BUSINESS_UNIT , B.SSF_TPC_GROUP , A.EMPLID , C.DESCR FROM PS_TP_STUDENT A , PS_SSF_CONTR_GRP B , PS_SSF_TPC_GROUP C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.CONTRACT_NUM = B.CONTRACT_NUM AND B.SSF_TPC_GROUP = C.SSF_TPC_GROUP

  • Related Language Record: SSF_STTPGRVW_LN

    • # 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 SSF_TPC_GROUP Character(25) VARCHAR2(25) NOT NULL Third Party Contract Group

    Prompt Table: SSF_TPC_GROUP

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

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