PSMPCONTDEV(SQL Table) |
Index Back |
---|
# | 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
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 |