PSPTRECFLDLBLVW

(SQL View)
 Index Back

record field label view

Use this view to retrieve field label for a record.

SELECT T.RECNAME , W.FIELDNAME , W.LABEL_ID , T.FIELDNUM , V.FIELDTYPE FROM %Table(PSRECFIELDDB) T ,%Table(PSDBFIELD) V ,%Table(PSDBFLDLABL) W WHERE T.FIELDNAME=V.FIELDNAME AND T.FIELDNAME=W.FIELDNAME AND T.LABEL_ID=W.LABEL_ID UNION SELECT T.RECNAME , W.FIELDNAME , W.LABEL_ID , T.FIELDNUM , V.FIELDTYPE FROM %Table(PSRECFIELDDB) T ,%Table(PSDBFIELD) V ,%Table(PSDBFLDLABL) W WHERE T.FIELDNAME=V.FIELDNAME AND T.FIELDNAME=W.FIELDNAME AND W.DEFAULT_LABEL=1 AND T.LABEL_ID=' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
5 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)