| # |
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.)
1=Frame
2=Group Box
3=Static Image
4=Edit Box
5=Drop Down List
6=Long Edit Box
7=Check Box
8=Radio Button
9=Image
10=Scroll Bar
11=Subpage
12=Push Button/Link - PeopleCode
13=Push Button/Link - Scroll Action
14=Push Button/Link - Toolbar Action
15=Push Button/Link - External Link
16=Push Button/Link - Internal Link
17=Push Button/Link - Process
18=SecPage
19=Grid
20=Tree
21=Push Button/Link - Secondary Page
22=Horizontal Rule
24=Tab Separator
25=HTML Area
26=Push Button/Link - Prompt Action
27=Scroll Area
29=Push Button/Link - Page Anchor
30=Chart
31=Push Button/Link - Instant Message Action
32=Analytic Grid
|
| 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
|
| 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 |
GRDLBLMSGSET |
Number(3,0) |
SMALLINT NOT NULL |
Grid Label Message Set
|
| 64 |
GRDLBLMSGNUM |
Number(3,0) |
SMALLINT NOT NULL |
Grid Label Message Number
|
| 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
|