EOPCPANEL_VW(SQL View) |
Index Back |
---|
SELECT DISTINCT PG.PNLGRPNAME , PG.PNLNAME , P.DESCR , ' ' , ' ' FROM PSPNLDEFN P , PSPNLGROUP PG WHERE P.PNLNAME = PG.PNLNAME |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
2 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
5 | EOPCGROUPBOX1 | Character(1) | VARCHAR2(1) NOT NULL | Group Box |