| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MOBILEPAGENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Mobile Page Name (see PSMPDEFN).
|
| 2 |
MOBILEDEVICEID |
Number(2,0) |
SMALLINT NOT NULL |
Mobile Device ID
|
| 3 |
BCTYPE |
Number(3,0) |
SMALLINT NOT NULL |
BC Property Type
|
| 4 |
BCITEMPARENT |
Character(30) |
VARCHAR2(30) NOT NULL |
Parent Collection Name
|
| 5 |
BCITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
BC Item Logical Name
|
| 6 |
ORDERNO |
Number(5,0) |
INTEGER NOT NULL |
Sort Order
|
| 7 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 8 |
SUPPRESSONDEV |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppress on this Device
|
| 9 |
DISPLAYTIMEZONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Time Zone
|
| 10 |
LBLTYPE |
Number(1,0) |
SMALLINT NOT NULL |
Label Type
|
| 11 |
LABEL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
|
| 12 |
LBLTEXT |
Character(60) |
VARCHAR2(60) NOT NULL |
Label Text
|
| 13 |
FIELDUSE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Panel Field Use
|
| 14 |
MSGSET |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
|
| 15 |
MSGNUM |
Number(5,0) |
INTEGER NOT NULL |
Message Number
|
| 16 |
SHOW_IN_LISTVW |
Character(1) |
VARCHAR2(1) NOT NULL |
Show in List View
|
| 17 |
HYPERLINK |
Character(1) |
VARCHAR2(1) NOT NULL |
Hyper Link
|
| 18 |
LISTVW_COL_PCT |
Number(3,0) |
SMALLINT NOT NULL |
List View Column Percent
|
| 19 |
READONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Read Only
|
| 20 |
ISPHONENUMBER |
Character(1) |
VARCHAR2(1) NOT NULL |
Is this field a phone number
|
| 21 |
SHOW_IN_HEADER |
Character(1) |
VARCHAR2(1) NOT NULL |
Show in Header
|
| 22 |
HORIZONTAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Horizontal
|
| 23 |
ISHTMLAREA |
Character(1) |
VARCHAR2(1) NOT NULL |
Is this rendered as HTML Area
|
| 24 |
HTMLAREAINLINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display HTML Area Inline
|
| 25 |
ISPUSHBUTTON |
Character(1) |
VARCHAR2(1) NOT NULL |
Push Button
|
| 26 |
INVISIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Invisible
|
| 27 |
WIDTH_IN_CHARS |
Number(3,0) |
SMALLINT NOT NULL |
Width in Characters
|
| 28 |
HEIGHT_IN_LINES |
Number(3,0) |
SMALLINT NOT NULL |
Height In Lines
|
| 29 |
RELATEDPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
Related Page
|
| 30 |
PROMPTDISPLAY |
Number(1,0) |
SMALLINT NOT NULL |
PromptDisplay
|
| 31 |
SHOW_DETAIL_ICON |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Detail Icon
|
| 32 |
DISPLAYINLINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Inline on Same Page
|
| 33 |
OCCURSCOUNT1 |
Number(2,0) |
SMALLINT NOT NULL |
Occurs Count First Level
|
| 34 |
ALLOW_CREATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Create
|
| 35 |
EDIT_IN_LISTVW |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit in List View
|
| 36 |
ALLOW_DELETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Delete
|
| 37 |
ERRORPAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use This Page For Errors
|
| 38 |
DETAILVIEWLBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Detail View Label
|
| 39 |
LISTVIEWLBL |
Character(30) |
VARCHAR2(30) NOT NULL |
List View Label
|
| 40 |
TABLABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Tab Label
|
| 41 |
MPTIMEPICKER |
Character(1) |
VARCHAR2(1) NOT NULL |
Mobile Agent Time Picker
|
| 42 |
MPTPINTERVAL |
Number(2,0) |
SMALLINT NOT NULL |
Mobile Device ID
|
| 43 |
MPLINEFEED |
Character(1) |
VARCHAR2(1) NOT NULL |
Insert Line Feed
|
| 44 |
MPGROUPLABEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Label
|
| 45 |
MPASDROPDOWN |
Character(1) |
VARCHAR2(1) NOT NULL |
Render As Drop Down
|
| 46 |
MPSUPPHEADER |
Character(1) |
VARCHAR2(1) NOT NULL |
Hide Header
|