HGA_PNLFIELD_VW(SQL View) |
Index Back |
|---|---|
Panel Fieldclone PSPNLFIELD and replace GRDLBLMSGSET (3) and GLDLBLMSGNUM (3) with MSGSET and MSGNUM - Nbr 5 |
| SELECT PNLNAME , PNLFLDID , FIELDNUM , PNLFIELDNAME , FIELDTYPE , EDITSIZE , DSPLFORMAT , FIELDLEFT , FIELDTOP , FIELDRIGHT , FIELDBOTTOM , EDITLBLLEFT , EDITLBLTOP , EDITLBLRIGHT , EDITLBLBOTTOM , DSPLFILL , LBLTYPE , LBLLOC , LBLPADSIZE , USEDEFAULTLABEL , LABEL_ID , LBLTEXT , FIELDUSE , FIELDUSETMP , DEFERPROC , OCCURSLEVEL , RECNAME , FIELDNAME , ONVALUE , OFFVALUE , ASSOCFIELDNUM , OCCURSCOUNT1 , OCCURSOFFSET1 , OCCURSCOUNT2 , OCCURSOFFSET2 , OCCURSCOUNT3 , OCCURSOFFSET3 , SUBPNLNAME , SUBPNLVER , FIELDSTYLE , LABELSTYLE , FIELDSIZETYPE , LABELSIZETYPE , PRCSTYPE , PRCSNAME , PROMPTFIELD , FORMATFAMILY , DISPFMTNAME , POPUPMENU , TREECTRLID , TREECTRLTYPE , MULTIRECTREE , NODECOUNT , GRDCOLUMNCOUNT , GRDSHOWCOLHDG , GRDSHOWROWHDG , GRDODDROWSTYLE , GRDEVENROWSTYLE , GRDACTIVETABSTYLE , GRDINACTIVETABSTYL , GRDNAVBARSTYLE , GRDLABELSTYLE , GRDLBLMSGSET , GRDLBLMSGNUM , GRDLBLALIGN , GRDACTTYPE , GRDALLOWCOLSORT , TABENABLE , PBDISPLAYTYPE , OPENNEWWINDOW , URLDYNAMIC , URL_ID , GOTOPORTALNAME , GOTONODENAME , GOTOMENUNAME , GOTOPNLGRPNAME , GOTOMKTNAME , GOTOPNLNAME , GOTOPNLACTION , SRCHBYPNLDATA , SCROLLACTION , TOOLACTION , CONTNAME , CONTNAMEOVER , CONTNAMEDISABLE , PTLBLIMGCOLLAPSE , PTLBLIMGEXPAND , PTADJHIDDENFIELDS , PTCOLLAPSEDATAAREA , PTDFLTVIEWEXPANDED , PTHIDEFIELDS , SHOWCOLHIDEROWS , PTLEBEXPANDFIELD , SHOWTABCNTLBTN , SELINDICATORTYPE , SECUREINVISIBLE , ENABLEASANCHOR , URLENCODEDBYAPP 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 | PNLFLDID |
Number(4,0) | SMALLINT NOT NULL | Page Field ID |
| 3 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 4 | PNLFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Panel Field Name |
| 5 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 6 | EDITSIZE | Number(5,0) | INTEGER NOT NULL | Currently Not Used |
| 7 | DSPLFORMAT | Number(10,0) | DECIMAL(10) NOT NULL | Display Format |
| 8 | FIELDLEFT | Number(4,0) | SMALLINT NOT NULL | Field Left |
| 9 | FIELDTOP | Number(4,0) | SMALLINT NOT NULL | Field Top |
| 10 | FIELDRIGHT | Number(4,0) | SMALLINT NOT NULL | Field Right |
| 11 | FIELDBOTTOM | Number(4,0) | SMALLINT NOT NULL | Field Bottom |
| 12 | EDITLBLLEFT | Number(4,0) | SMALLINT NOT NULL | Edit Label Left |
| 13 | EDITLBLTOP | Number(4,0) | SMALLINT NOT NULL | Edit Label Top |
| 14 | EDITLBLRIGHT | Number(4,0) | SMALLINT NOT NULL | Edit Label Right |
| 15 | EDITLBLBOTTOM | Number(4,0) | SMALLINT NOT NULL | Edit Label Bottom |
| 16 | DSPLFILL | Character(1) | VARCHAR2(1) NOT NULL | Display Fill Character |
| 17 | LBLTYPE | Number(1,0) | SMALLINT NOT NULL |
Label Type
0=None 1=Text 2=RFT Short 3=RFT Long |
| 18 | LBLLOC | Number(1,0) | SMALLINT NOT NULL | Label Location |
| 19 | LBLPADSIZE | Number(5,0) | INTEGER NOT NULL | Currently Not Used |
| 20 | USEDEFAULTLABEL | Character(1) | VARCHAR2(1) NOT NULL | Use Default Label |
| 21 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 22 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 23 | FIELDUSE | Number(10,0) | DECIMAL(10) NOT NULL | Panel Field Use |
| 24 | FIELDUSETMP | Number(10,0) | DECIMAL(10) NOT NULL | Panel Field Use (Temporary) |
| 25 | DEFERPROC | Number(1,0) | SMALLINT NOT NULL | Deferred Processing mode |
| 26 | OCCURSLEVEL | Number(1,0) | SMALLINT NOT NULL | Occurs level |
| 27 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 28 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELD |
| 29 | ONVALUE | Character(4) | VARCHAR2(4) NOT NULL |
On Value
Prompt Table: XLATTABLE_VW |
| 30 | OFFVALUE | Character(4) | VARCHAR2(4) NOT NULL |
Off Value
Prompt Table: XLATTABLE_VW |
| 31 | ASSOCFIELDNUM | Number(4,0) | SMALLINT NOT NULL | Associated Field Number |
| 32 | OCCURSCOUNT1 | Number(2,0) | SMALLINT NOT NULL | Occurs Count First Level |
| 33 | OCCURSOFFSET1 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset First Level |
| 34 | OCCURSCOUNT2 | Number(2,0) | SMALLINT NOT NULL | Occurs Count Second Level |
| 35 | OCCURSOFFSET2 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset Second Level |
| 36 | OCCURSCOUNT3 | Number(2,0) | SMALLINT NOT NULL | Occurs Count Third Level |
| 37 | OCCURSOFFSET3 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset Third Level |
| 38 | SUBPNLNAME | Character(18) | VARCHAR2(18) NOT NULL |
SubPanel Name
Prompt Table: PSPNLDEFN_VW |
| 39 | SUBPNLVER | Number(10,0) | DECIMAL(10) NOT NULL | SubPanel Version Number |
| 40 | FIELDSTYLE | Character(30) | VARCHAR2(30) NOT NULL |
Field Style Name
Prompt Table: PSSTYLEDEFN |
| 41 | LABELSTYLE | Character(30) | VARCHAR2(30) NOT NULL |
Label Style Name
Prompt Table: PSSTYLEDEFN |
| 42 | FIELDSIZETYPE | Number(1,0) | SMALLINT NOT NULL | Field Size Type |
| 43 | LABELSIZETYPE | Number(1,0) | SMALLINT NOT NULL | Label Position |
| 44 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PRCSTYPE_VW |
| 45 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL |
Process Name
Prompt Table: PRCSDEFN |
| 46 | PROMPTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Dropdown Prompt Field |
| 47 | FORMATFAMILY | Character(15) | VARCHAR2(15) NOT NULL | Format Family Name (see PSFMTDEFN). |
| 48 | DISPFMTNAME | Character(15) | VARCHAR2(15) NOT NULL | Display Format Name (see PSFMTITEM). |
| 49 | POPUPMENU | Character(30) | VARCHAR2(30) NOT NULL | Popup Menu |
| 50 | TREECTRLID | Number(3,0) | SMALLINT NOT NULL | Tree Control ID |
| 51 | TREECTRLTYPE | Number(3,0) | SMALLINT NOT NULL | Tree Control Type |
| 52 | MULTIRECTREE | Number(3,0) | SMALLINT NOT NULL | Multi Record Tree |
| 53 | NODECOUNT | Number(3,0) | SMALLINT NOT NULL | Node Count |
| 54 | GRDCOLUMNCOUNT | Number(3,0) | SMALLINT NOT NULL | Grid Column Count |
| 55 | GRDSHOWCOLHDG | Number(3,0) | SMALLINT NOT NULL | Grid Show Column Heading |
| 56 | GRDSHOWROWHDG | Number(3,0) | SMALLINT NOT NULL | Grid Show Row Heading |
| 57 | GRDODDROWSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Odd Row Style |
| 58 | GRDEVENROWSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Even Row Style |
| 59 | GRDACTIVETABSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grud Active Tab Style |
| 60 | GRDINACTIVETABSTYL | Character(30) | VARCHAR2(30) NOT NULL | Grid Inactive Tab Style |
| 61 | GRDNAVBARSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Nav Bar Style |
| 62 | GRDLABELSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Label Style |
| 63 | MSGSET | Number(5,0) | INTEGER NOT NULL | Message Set Number |
| 64 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 65 | GRDLBLALIGN | Number(3,0) | SMALLINT NOT NULL | Grid Label Alignment |
| 66 | GRDACTTYPE | Number(3,0) | SMALLINT NOT NULL | Grid Action Type |
| 67 | GRDALLOWCOLSORT | Character(1) | VARCHAR2(1) NOT NULL | Allow Column Sorting |
| 68 | TABENABLE | Number(3,0) | SMALLINT NOT NULL | Enable Tab Key in ActiveX |
| 69 | PBDISPLAYTYPE | Number(1,0) | SMALLINT NOT NULL | Pushbutton display type |
| 70 | OPENNEWWINDOW | Number(1,0) | SMALLINT NOT NULL | Open in New Window |
| 71 | URLDYNAMIC | Number(1,0) | SMALLINT NOT NULL | Dynamic URL |
| 72 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 73 | GOTOPORTALNAME | Character(30) | VARCHAR2(30) NOT NULL | Go to Portal Name |
| 74 | GOTONODENAME | Character(30) | VARCHAR2(30) NOT NULL | Go to Node Name |
| 75 | GOTOMENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Go to Menu Name |
| 76 | GOTOPNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Go to Panel Group Name |
| 77 | GOTOMKTNAME | Character(3) | VARCHAR2(3) NOT NULL | Go to Market Name |
| 78 | GOTOPNLNAME | Character(18) | VARCHAR2(18) NOT NULL | Go to Panel Name |
| 79 | GOTOPNLACTION | Number(1,0) | SMALLINT NOT NULL | Go to Panel Action (Mode) |
| 80 | SRCHBYPNLDATA | Number(1,0) | SMALLINT NOT NULL | Use Panel Data in Search |
| 81 | SCROLLACTION | Number(2,0) | SMALLINT NOT NULL | Scroll Action |
| 82 | TOOLACTION | Number(2,0) | SMALLINT NOT NULL | Toolbar Action |
| 83 | CONTNAME | Character(30) | VARCHAR2(30) NOT NULL | Content Name |
| 84 | CONTNAMEOVER | Character(30) | VARCHAR2(30) NOT NULL | Content Name (On Mouse Over) |
| 85 | CONTNAMEDISABLE | Character(30) | VARCHAR2(30) NOT NULL | Content Name Disabled |
| 86 | PTLBLIMGCOLLAPSE | Character(30) | VARCHAR2(30) NOT NULL | Label Image for Collapse |
| 87 | PTLBLIMGEXPAND | Character(30) | VARCHAR2(30) NOT NULL | Label Image for Expand |
| 88 | PTADJHIDDENFIELDS | Character(1) | VARCHAR2(1) NOT NULL | Adj Layout for Hidden Fields |
| 89 | PTCOLLAPSEDATAAREA | Character(1) | VARCHAR2(1) NOT NULL | Collapsible Data Area |
| 90 | PTDFLTVIEWEXPANDED | Character(1) | VARCHAR2(1) NOT NULL | Default View to Expanded |
| 91 | PTHIDEFIELDS | Character(1) | VARCHAR2(1) NOT NULL | Hide All Flds when Grp Box Hid |
| 92 | SHOWCOLHIDEROWS | Character(1) | VARCHAR2(1) NOT NULL | Show Column On Hide Rows |
| 93 | PTLEBEXPANDFIELD | Character(1) | VARCHAR2(1) NOT NULL | LEB Expand Fld when Dspl Only |
| 94 | SHOWTABCNTLBTN | Character(1) | VARCHAR2(1) NOT NULL | Show Tab Control Button |
| 95 | SELINDICATORTYPE | Number(1,0) | SMALLINT NOT NULL | Selection Indicator Type |
| 96 | SECUREINVISIBLE | Character(1) | VARCHAR2(1) NOT NULL | Secure Invisible Field |
| 97 | ENABLEASANCHOR | Character(1) | VARCHAR2(1) NOT NULL | Enable As Anchor |
| 98 | URLENCODEDBYAPP | Character(1) | VARCHAR2(1) NOT NULL | URL Encoded by Application |