AGC_CAT_LVW

(SQL View)
 Index Back

AGC Category View Rel Lang

Activity Guide Composer Category View Rel Lang

SELECT DISTINCT PKG.AGC_CATEGORY_ID , PKG.EFFDT , PKGL.LANGUAGE_CD , PKGL.DESCR50 FROM PS_AGC_CAT_TBL PKG , PS_AGC_CAT_LNG PKGL , PS_AGC_CAT_CTX CTX , PS_AGC_CAT_STEP STEP WHERE PKG.AGC_CATEGORY_ID = PKGL.AGC_CATEGORY_ID AND PKG.EFFDT = PKGL.EFFDT AND PKG.AGC_CATEGORY_ID = CTX.AGC_CATEGORY_ID AND PKG.EFFDT = CTX.EFFDT AND PKG.AGC_CATEGORY_ID = STEP.AGC_CATEGORY_ID AND PKG.EFFDT = STEP.EFFDT AND PACKAGEROOT <> ' ' AND AGC_CREATE_CLASS <> ' '

  • Related Language Record for AGC_CAT_CURR_VW AGC_CAT_NOTF_VW AGC_CAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50