SSF_STTPGRVW_LN

(SQL View)
 Index Back

Stdnt Contract Group Rel Lang

Related Language for SSF_STD_TPGR_VW

SELECT DISTINCT A.BUSINESS_UNIT , B.SSF_TPC_GROUP , A.EMPLID , C.LANGUAGE_CD , C.DESCR FROM PS_TP_STUDENT A , PS_SSF_CONTR_GRP B , PS_SSF_TPC_GRP_LNG 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 for SSF_STD_TPGR_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description