PSPNLFIELD

index back

Panel Field


  • Related language record: PSPNLFIELDLANG
  • Parent record: PSPNLDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).

    Prompt Table: PSPNLDEFN_VW

    PNLFLDIDNumber(4,0)SMALLINT NOT NULLPage Field ID
    FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
    PNLFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLPanel Field Name
    FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
    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
    EDITSIZENumber(5,0)INTEGER NOT NULLCurrently Not Used
    DSPLFORMATNumber(10,0)DECIMAL(10) NOT NULLDisplay Format
    FIELDLEFTNumber(4,0)SMALLINT NOT NULLField Left
    FIELDTOPNumber(4,0)SMALLINT NOT NULLField Top
    FIELDRIGHTNumber(4,0)SMALLINT NOT NULLField Right
    FIELDBOTTOMNumber(4,0)SMALLINT NOT NULLField Bottom
    EDITLBLLEFTNumber(4,0)SMALLINT NOT NULLEdit Label Left
    EDITLBLTOPNumber(4,0)SMALLINT NOT NULLEdit Label Top
    EDITLBLRIGHTNumber(4,0)SMALLINT NOT NULLEdit Label Right
    EDITLBLBOTTOMNumber(4,0)SMALLINT NOT NULLEdit Label Bottom
    DSPLFILLCharacter(1)VARCHAR2(1) NOT NULLDisplay Fill Character
    LBLTYPENumber(1,0)SMALLINT NOT NULLLabel Type
    0=None
    1=Text
    2=RFT Short
    3=RFT Long
    LBLLOCNumber(1,0)SMALLINT NOT NULLLabel Location
    LBLPADSIZENumber(5,0)INTEGER NOT NULLCurrently Not Used
    USEDEFAULTLABELCharacter(1)VARCHAR2(1) NOT NULLUse Default Label
    LABEL_IDCharacter(18)VARCHAR2(18) NOT NULLLABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    LBLTEXTCharacter(60)VARCHAR2(60) NOT NULLLabel Text
    FIELDUSENumber(10,0)DECIMAL(10) NOT NULLPanel Field Use
    FIELDUSETMPNumber(10,0)DECIMAL(10) NOT NULLPanel Field Use (Temporary)
    DEFERPROCNumber(1,0)SMALLINT NOT NULLDeferred Processing mode
    OCCURSLEVELNumber(1,0)SMALLINT NOT NULLOccurs level
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    ONVALUECharacter(4)VARCHAR2(4) NOT NULLOn Value

    Prompt Table: XLATTABLE_VW

    OFFVALUECharacter(4)VARCHAR2(4) NOT NULLOff Value

    Prompt Table: XLATTABLE_VW

    ASSOCFIELDNUMNumber(4,0)SMALLINT NOT NULLAssociated Field Number
    OCCURSCOUNT1Number(2,0)SMALLINT NOT NULLOccurs Count First Level
    OCCURSOFFSET1Number(4,0)SMALLINT NOT NULLOccurs Offset First Level
    OCCURSCOUNT2Number(2,0)SMALLINT NOT NULLOccurs Count Second Level
    OCCURSOFFSET2Number(4,0)SMALLINT NOT NULLOccurs Offset Second Level
    OCCURSCOUNT3Number(2,0)SMALLINT NOT NULLOccurs Count Third Level
    OCCURSOFFSET3Number(4,0)SMALLINT NOT NULLOccurs Offset Third Level
    SUBPNLNAMECharacter(18)VARCHAR2(18) NOT NULLSubPanel Name

    Prompt Table: PSPNLDEFN_VW

    SUBPNLVERNumber(10,0)DECIMAL(10) NOT NULLSubPanel Version Number
    FIELDSTYLECharacter(30)VARCHAR2(30) NOT NULLField Style Name

    Prompt Table: PSSTYLEDEFN

    LABELSTYLECharacter(30)VARCHAR2(30) NOT NULLLabel Style Name

    Prompt Table: PSSTYLEDEFN

    FIELDSIZETYPENumber(1,0)SMALLINT NOT NULLField Size Type
    LABELSIZETYPENumber(1,0)SMALLINT NOT NULLLabel Position
    PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

    Prompt Table: PRCSTYPE_VW

    PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name

    Prompt Table: PRCSDEFN

    PROMPTFIELDCharacter(18)VARCHAR2(18) NOT NULLDropdown Prompt Field
    FORMATFAMILYCharacter(15)VARCHAR2(15) NOT NULLFormat Family Name (see PSFMTDEFN).
    DISPFMTNAMECharacter(15)VARCHAR2(15) NOT NULLDisplay Format Name (see PSFMTITEM).
    POPUPMENUCharacter(30)VARCHAR2(30) NOT NULLPopup Menu
    TREECTRLIDNumber(3,0)SMALLINT NOT NULLTree Control ID
    TREECTRLTYPENumber(3,0)SMALLINT NOT NULLTree Control Type
    MULTIRECTREENumber(3,0)SMALLINT NOT NULLMulti Record Tree
    NODECOUNTNumber(3,0)SMALLINT NOT NULLNode Count
    GRDCOLUMNCOUNTNumber(3,0)SMALLINT NOT NULLGrid Column Count
    GRDSHOWCOLHDGNumber(3,0)SMALLINT NOT NULLGrid Show Column Heading
    GRDSHOWROWHDGNumber(3,0)SMALLINT NOT NULLGrid Show Row Heading
    GRDODDROWSTYLECharacter(30)VARCHAR2(30) NOT NULLGrid Odd Row Style
    GRDEVENROWSTYLECharacter(30)VARCHAR2(30) NOT NULLGrid Even Row Style
    GRDACTIVETABSTYLECharacter(30)VARCHAR2(30) NOT NULLGrud Active Tab Style
    GRDINACTIVETABSTYLCharacter(30)VARCHAR2(30) NOT NULLGrid Inactive Tab Style
    GRDNAVBARSTYLECharacter(30)VARCHAR2(30) NOT NULLGrid Nav Bar Style
    GRDLABELSTYLECharacter(30)VARCHAR2(30) NOT NULLGrid Label Style
    GRDLBLMSGSETNumber(3,0)SMALLINT NOT NULLGrid Label Message Set
    GRDLBLMSGNUMNumber(3,0)SMALLINT NOT NULLGrid Label Message Number
    GRDLBLALIGNNumber(3,0)SMALLINT NOT NULLGrid Label Alignment
    GRDACTTYPENumber(3,0)SMALLINT NOT NULLGrid Action Type
    GRDALLOWCOLSORTCharacter(1)VARCHAR2(1) NOT NULLAllow Column Sorting
    TABENABLENumber(3,0)SMALLINT NOT NULLEnable Tab Key in ActiveX
    PBDISPLAYTYPENumber(1,0)SMALLINT NOT NULLPushbutton display type
    OPENNEWWINDOWNumber(1,0)SMALLINT NOT NULLOpen in New Window
    URLDYNAMICNumber(1,0)SMALLINT NOT NULLDynamic URL
    URL_IDCharacter(30)VARCHAR2(30) NOT NULLURL Identifier (see PSURLDEFN).
    GOTOPORTALNAMECharacter(30)VARCHAR2(30) NOT NULLGo to Portal Name
    GOTONODENAMECharacter(30)VARCHAR2(30) NOT NULLGo to Node Name
    GOTOMENUNAMECharacter(30)VARCHAR2(30) NOT NULLGo to Menu Name
    GOTOPNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLGo to Panel Group Name
    GOTOMKTNAMECharacter(3)VARCHAR2(3) NOT NULLGo to Market Name
    GOTOPNLNAMECharacter(18)VARCHAR2(18) NOT NULLGo to Panel Name
    GOTOPNLACTIONNumber(1,0)SMALLINT NOT NULLGo to Panel Action (Mode)
    SRCHBYPNLDATANumber(1,0)SMALLINT NOT NULLUse Panel Data in Search
    SCROLLACTIONNumber(2,0)SMALLINT NOT NULLScroll Action
    TOOLACTIONNumber(2,0)SMALLINT NOT NULLToolbar Action
    CONTNAMECharacter(30)VARCHAR2(30) NOT NULLContent Name
    CONTNAMEOVERCharacter(30)VARCHAR2(30) NOT NULLContent Name (On Mouse Over)
    CONTNAMEDISABLECharacter(30)VARCHAR2(30) NOT NULLContent Name Disabled
    PTLBLIMGCOLLAPSECharacter(30)VARCHAR2(30) NOT NULLLabel Image for Collapse
    PTLBLIMGEXPANDCharacter(30)VARCHAR2(30) NOT NULLLabel Image for Expand
    PTADJHIDDENFIELDSCharacter(1)VARCHAR2(1) NOT NULLAdj Layout for Hidden Fields
    PTCOLLAPSEDATAAREACharacter(1)VARCHAR2(1) NOT NULLCollapsible Data Area
    PTDFLTVIEWEXPANDEDCharacter(1)VARCHAR2(1) NOT NULLDefault View to Expanded
    PTHIDEFIELDSCharacter(1)VARCHAR2(1) NOT NULLHide All Flds when Grp Box Hid
    SHOWCOLHIDEROWSCharacter(1)VARCHAR2(1) NOT NULLShow Column On Hide Rows
    PTLEBEXPANDFIELDCharacter(1)VARCHAR2(1) NOT NULLLEB Expand Fld when Dspl Only
    SHOWTABCNTLBTNCharacter(1)VARCHAR2(1) NOT NULLShow Tab Control Button
    SELINDICATORTYPENumber(1,0)SMALLINT NOT NULLSelection Indicator Type
    SECUREINVISIBLECharacter(1)VARCHAR2(1) NOT NULLSecure Invisible Field
    ENABLEASANCHORCharacter(1)VARCHAR2(1) NOT NULLEnable As Anchor
    URLENCODEDBYAPPCharacter(1)VARCHAR2(1) NOT NULLURL Encoded by Application
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19