PROJID_ADD_LVW

(SQL View)
 Index Back

Project Add Mode View

This is a view used primarily by customers that are not using the Projects application since it uses "setid" mapping rather than the Projects "Integration Templates"

SELECT A.SETID , A.PROJECT_ID , B.LANGUAGE_CD , B.DESCR FROM PS_PROJECT_FS A , PS_PROJECT_LFS B WHERE %Join(COMMON_KEYS, PROJECT_FS A, PROJECT_LFS B)

  • Related Language Record for PROJFS_ADD_VW PROJFS_UPD_VW PROJID_ADD_VW PROJID_BUGL_VW PROJID_OM_VW SP_NPCPRJ_CLSVW SP_NPCPRJ_NONVW SP_NPCPRJ_OPRVW SP_PRJ_GL_CLSVW SP_PRJ_GL_NONVW SP_PRJ_GL_OPRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description