CI_FLD_PROP_SEQ

(SQL View)
 Index Back

CI Data fields with tab seq

CI Data Property fields that are associated to page tab field sequence.

SELECT A.BCNAME ,B.PNLGRPNAME , D.BCITEMPARENT ,C.RECNAME ,D.BCITEMNAME ,C.FIELDNAME ,MIN((B.SUBITEMNUM * 10000) + C.FIELDNUM) FROM PSBCDEFN A , PSPNLGROUP B , PSPNLFIELD C ,PSBCITEM D , PSRECFIELDALL E WHERE A.BCPGNAME = B.PNLGRPNAME AND B.PNLNAME = C.PNLNAME AND C.FIELDTYPE NOT IN (0, 2, 10, 11,18, 19, 23, 24,27) AND ((%Round(((C.FIELDUSE) / (2)), 0)) - ((%Round(((C.FIELDUSE) / (4)),0)) * ( 2))) <> 1 AND A.BCNAME = D.BCNAME AND C.RECNAME = D.RECNAME AND C.FIELDNAME = D.FIELDNAME AND D.BCTYPE = 4 AND D.BCACCESS = 1 AND E.RECNAME = D.RECNAME AND E.FIELDNAME = D.FIELDNAME AND ((%Round(((E.USEEDIT) / (2)),0) ) * ( 2)) = E.USEEDIT GROUP BY C.RECNAME, C.FIELDNAME, D.BCITEMPARENT ,D.BCITEMNAME, B.PNLGRPNAME, A.BCNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).
2 BCPGNAME Character(30) VARCHAR2(30) NOT NULL Panel Group Name
3 BCITEMPARENT Character(30) VARCHAR2(30) NOT NULL Parent Collection Name
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

5 BCITEMNAME Character(30) VARCHAR2(30) NOT NULL BC Item Logical Name
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSDBFIELD

7 SORT_FIELD Number(6,0) INTEGER NOT NULL Sort Field