PSMPCONTDEV

(SQL Table)
Index Back

  • Related Language Record: PSMPCONTDEVLANG
  • Parent record: PSMPDEFN
  • # 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