CS_BINDFLD_VW

(SQL View)
Index Back

SELECT A.RECNAME , A.FIELDNAME , L.LONGNAME FROM PSRECFIELDDB A , PSDBFLDLABL L WHERE A.FIELDNAME = L.FIELDNAME AND L.DEFAULT_LABEL = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_BIND_RECNAME Character(15) VARCHAR2(15) NOT NULL Binds Recordname

Prompt Table: CS_RECVIEW_VW

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description