TRA_CF_VW

(SQL View)
 Index Back

Treas. Acctg CFs Prompt Tbl

02/17/2005 CMH Changed viewtext-- looks like we don't need the SBR... WHERE A.RECNAME IN ('TRA_TMPL_DETL', 'CF14_AN_SBR')

SELECT DISTINCT A.FIELDNAME , B.LONGNAME , A.EDITTABLE FROM PSRECFIELDDB A , PSDBFLDLABL_VW B WHERE A.RECNAME = 'TRA_TMPL_DETL' AND (A.FIELDNAME IN ( SELECT DISTINCT FIELDNAME FROM PS_FS_CF_TEMPLATE WHERE CF_ACTIVE_STATUS <> 'I') OR A.FIELDNAME = 'STATISTICS_CODE') AND A.FIELDNAME = B.FIELDNAME

# 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 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table