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

  • 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
    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 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name