PSDBFLD_LENGTH

(SQL View)
 Index Back

Fieldname and Field Length VW

List of fieldnames and their lengths, as defined in the Application Designer.

SELECT a.fieldname , a.length FROM PSDBFIELD a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 LENGTH Number(5,0) INTEGER NOT NULL Length