PGM_SR_LVW

(SQL View)
 Index Back

Language View of PGM_SR_VW

This view is language view of PGM_SR_VW.

SELECT DISTINCT SR.EMPLID ,SR.BUSINESS_UNIT ,SR.PROJECT_ID ,SR.ACTIVITY_ID ,SR.PROJ_ROLE ,SR.SR_START_DATE ,SR.SR_END_DATE ,PRJL.LANGUAGE_CD ,PROJ.DESCR ,SR.ACTIVITY_DESCR FROM %Table(PROJECT) PROJ ,%Table(PROJECT_LANG) PRJL ,%Table(PGM_SR_ACT_VW) SR ,%Table(PROJ_ACTIVTY_LG) ACTL WHERE SR.BUSINESS_UNIT = PROJ.BUSINESS_UNIT AND SR.PROJECT_ID = PROJ.PROJECT_ID AND PRJL.BUSINESS_UNIT = PROJ.BUSINESS_UNIT AND PRJL.PROJECT_ID = PROJ.BUSINESS_UNIT AND ACTL.BUSINESS_UNIT = SR.BUSINESS_UNIT AND ACTL.PROJECT_ID = SR.PROJECT_ID AND ACTL.ACTIVITY_ID = SR.ACTIVITY_ID AND PRJL.LANGUAGE_CD = ACTL.LANGUAGE_CD

  • Related Language Record for PGM_SR_VW

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

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: PC_SR_BU_VW

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

    Default Value: OPR_DEF_TBL_PC.PROJECT_ID

    Prompt Table: SP_CAPRJ2_NONVW

    4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PC_SR_ACTIV_VW

    5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PC_SR_PJROLE_VW

    6 SR_START_DATE Date(10) DATE NOT NULL Status Report start date

    Prompt Table: PC_SR_STRTDT_VW

    7 SR_END_DATE Date(10) DATE Status Report end date
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 ACTIVITY_DESCR Character(30) VARCHAR2(30) NOT NULL Activity Description