PSMPCONTDEV(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Mobile Page Name (see PSMPDEFN). | |
| 2 | Number(2,0) | SMALLINT NOT NULL | Mobile Device ID | |
| 3 | Number(3,0) | SMALLINT NOT NULL | BC Property Type | |
| 4 | Character(30) | VARCHAR2(30) NOT NULL | Parent Collection Name | |
| 5 | 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
0=None 1=Text 2=RFT Short 3=RFT Long |
| 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 |