SF_DFRCFLD_VW

(SQL View)
 Index Back

View of Fields from psrecfield


SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B WHERE A.RECNAME = 'GL_INTERFACE' AND A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1 AND A.FIELDNAME IN ('DEFERRED_ACCOUNT', 'DEFERRED_FUND_CODE', 'DEFERRED_PROG_CODE', 'DEFERRED_PROJ_ID', 'DEFR_BUDGET_PERIOD', 'DEFERRED_CLASS_FLD', 'DEFERRED_AFFILIATE', 'DEFERRED_LEDGER', 'DEFERRED_DEPTID', 'DEFERRED_BUD_REF', 'DEFERRED_CF1', 'DEFERRED_CF2', 'DEFERRED_CF3')

# 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