JPM_DESCR_FLDV1

(SQL View)
Index Back

Description Field View

View that returns a record's description fields

SELECT FIELDNAME , LONGNAME FROM PSDBFLDLABL WHERE DEFAULT_LABEL = 1

  • Related Language Record: JPM_DESCR_FDLV1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_PROMPT_FLD_NM Character(18) VARCHAR2(18) NOT NULL Prompt Field Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description