PO_PNLFIELD

(SQL View)
Index Back

PO PNLFIELDS


SELECT PNLNAME ,RECNAME ,FIELDNAME ,FIELDTYPE ,SECUREINVISIBLE FROM PSPNLFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).

Prompt Table: PSPNLDEFN_VW

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSDBFIELD

4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
5 SECUREINVISIBLE Character(1) VARCHAR2(1) NOT NULL Secure Invisible Field