AP_COMP_FLDS_V2

(SQL View)
 Index Back

Source View: AP_COMP_FLDS_V1

Fixes DTL_PNLNAME Filters: FIELDTYPE : Edit Box Drop Down List Long Edit Box Check Box Radio Button FIELDUSE : NO Display Only NO Related Field PSRECDEFN.RECTYPE : SQL Table SQL View

SELECT PNLGRPNAME , PAGE_NAME , SUBPNLNAME , CASE DTL_PNLNAME WHEN SUBPNLNAME THEN ' ' ELSE DTL_PNLNAME END , RECNAME_PARENT , FIELDNAME , LBLTEXT , PNLNAME , PNLFLDID , FIELDTYPE , FIELDUSE , RECNAME , SPB_PAGE_NAME , PATHNAME FROM PS_AP_COMP_FLDS_V1 WHERE FIELDTYPE IN ( 4, 5, 6, 7, 8, 12 ) AND FIELDUSE - %DecMult(2, %TRUNCATE( %DECDIV( FIELDUSE, 2) , 0) ) = 0 AND %Truncate( %DECDIV(FIELDUSE, 16) , 0) - %DecMult(2, %TRUNCATE( %DECDIV( %TRUNCATE( %DECDIV(FIELDUSE, 16) , 0), 2) , 0) ) = 0 AND EXISTS ( SELECT 1 FROM PSRECDEFN WHERE RECTYPE IN ( 0, 1 ) AND RECNAME = PS_AP_COMP_FLDS_V1.RECNAME_PARENT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
2 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
3 SUBPNLNAME Character(18) VARCHAR2(18) NOT NULL SubPanel Name
4 DTL_PNLNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Panel/Page name
5 RECNAME_PARENT Character(15) VARCHAR2(15) NOT NULL Parent Record. If this comes from a sub-record, this column has the name of the sub-record, otherwise it has the same value as RECNAME.
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
8 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
9 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
10 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
11 FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use
12 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
13 SPB_PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
14 PATHNAME Character(254) VARCHAR2(254) NOT NULL PATHNAME