STAT_RPT_LBL_VW

(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.LONGNAME ,B.SHORTNAME ,A.ORIG_CF_NAME FROM PS_FS_CF_TEMPLATE A , PSDBFLDLABL_VW B WHERE A.CF_ACTIVE_STATUS = 'A' AND A.ORIG_CF_NAME IN ('ACCOUNT','ALTACCT') AND A.FIELDNAME = B.FIELDNAME

  • Related Language Record: STAT_RPT_LLNG_V

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