STAT_RPT_LLNG_V

(SQL View)
 Index Back

Stat Rpt Prompt for Acct

Prompt Table for Account or Alt Account Option on Statutory Reports Run Request Pages

SELECT A.FIELDNAME ,B.LANGUAGE_CD ,B.LONGNAME ,B.SHORTNAME ,A.ORIG_CF_NAME FROM PS_FS_CF_TEMPLATE A , PSDBFLDLABLLANG B , PSDBFLDLABL C WHERE A.CF_ACTIVE_STATUS = 'A' AND A.ORIG_CF_NAME IN ('ACCOUNT','ALTACCT') AND A.FIELDNAME = C.FIELDNAME AND C.FIELDNAME = B.FIELDNAME AND C.DEFAULT_LABEL = 1 AND C.LABEL_ID = B.LABEL_ID

  • Related Language Record for STAT_RPT_LBL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    4 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    5 ORIG_CF_NAME Character(18) VARCHAR2(18) NOT NULL Holds the Original Chartfield Name. This will not change!