DFW_PNLFIELD_VW

(SQL View)
Index Back

DFW PNLFIELD View


SELECT DISTINCT PNLNAME , PNLFIELDNAME , SELINDICATORTYPE FROM PSPNLFIELD WHERE SELINDICATORTYPE NOT IN (0, 1, 2)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
2 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
3 SELINDICATORTYPE Number(1,0) SMALLINT NOT NULL Selection Indicator Type