GP_CHRT_PMT2_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) ,B.LONGNAME FROM PSXLATITEM A , PSXLATITEMLANG X ,PSDBFLDLABL B WHERE A.FIELDNAME = 'CHART_FLD_CD' AND B.DEFAULT_LABEL = 1 AND A.FIELDNAME = X.FIELDNAME AND A.FIELDVALUE = X.FIELDVALUE AND X.LANGUAGE_CD = 'ENG' AND B.FIELDNAME = X.XLATLONGNAME AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM sub WHERE sub.FIELDNAME = 'CHART_FLD_CD' AND sub.FIELDVALUE = A.FIELDVALUE)

  • Related Language Record: GP_CHRT_PMTL_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_CF
    27=FUND_CODE
    28=OPERATING_UNIT
    29=PRODUCT
    30=PROGRAM_CODE
    31=PROJECT_ID
    2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name