GP_CHRT_PMTL_VW

(SQL View)
 Index Back

Chartfield Prompt View

this view is used to prompt for chartfield codes. Displayed are dynamic labels as defined by the user

SELECT %Substring(A.FIELDVALUE ,1 ,2) , C.LANGUAGE_CD ,C.LONGNAME FROM PSXLATITEM A , PSXLATITEMLANG X ,PSDBFLDLABL B ,PSDBFLDLABLLANG C WHERE A.FIELDNAME = 'CHART_FLD_CD' AND A.EFF_STATUS = 'A' AND A.EFFDT = X.EFFDT AND A.FIELDNAME = X.FIELDNAME AND A.FIELDVALUE = X.FIELDVALUE AND B.FIELDNAME = X.XLATLONGNAME AND B.FIELDNAME = C.FIELDNAME AND B.LABEL_ID = C.LABEL_ID AND B.DEFAULT_LABEL = 1 AND X.LANGUAGE_CD = C.LANGUAGE_CD AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM sub WHERE sub.FIELDNAME = 'CHART_FLD_CD' AND sub.FIELDVALUE = A.FIELDVALUE)

  • Related Language Record for GP_CHART_PMT_VW GP_CHRT_PMT2_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CHART_FLD_CD Character(2) VARCHAR2(2) NOT NULL Chart Field code
    17=AFFILIATE
    18=AFFILIATE_INTRA1
    19=AFFILIATE_INTRA2
    20=ALTACCT
    21=BUDGET_REF
    22=CHARTFIELD1
    23=CHARTFIELD2
    24=CHARTFIELD3
    25=CLASS_FLD
    26=DEPTID
    27=FUND_CODE
    28=OPERATING_UNIT
    29=PRODUCT
    30=PROGRAM_CODE
    31=PROJECT_ID
    32=BUSINESS_UNIT_PC
    33=ACTIVITY_ID
    34=RESOURCE_TYPE
    35=RESOURCE_CATEGORY
    36=RESOURCE_SUB_CAT
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name