SPF_PROJ_R_VW

(SQL View)
 Index Back

Resource Based Project view


SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.DESCR , B.USE_OT FROM PS_PROJECT A , PS_SPA_TIME_TMPL B , PS_SPA_DEF_TE_TMPL C , PS_SET_CNTRL_GROUP SC WHERE A.BUSINESS_UNIT = SC.SETCNTRLVALUE AND SC.REC_GROUP_ID = 'SP_12' AND B.SETID = SC.SETID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND B.TE_TEMPLATE_ID = C.TE_TEMPLATE_ID AND A.EFF_STATUS = 'A' AND C.TE_TEMPLATE_ID IN ( SELECT D.TE_TEMPLATE_ID FROM PS_SPA_TIME_TMPL D WHERE D.SPA_TEMPLATE_TYPE = 'T')

  • Related Language Record: SPF_PROJ_R_LVW

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

    Prompt Table: BUS_UNIT_TBL_PC

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: PROJECT

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 OVERTIME_PERMITTED Character(1) VARCHAR2(1) NOT NULL Overtime Permitted
    N=No
    Y=Yes