PST_PNLFIELDS

index back

Upgrader Panel Work


  • Parent record: PSPNLDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    SRC_TGTCharacter(1)VARCHAR2(1) NOT NULLSource/Target Indicator
    FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
    FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
    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
    LBLTEXTCharacter(60)VARCHAR2(60) NOT NULLLabel Text
    FIELDUSENumber(10,0)DECIMAL(10) NOT NULLPanel Field Use
    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
    HELPCONTEXTNUMNumber(10,0)DECIMAL(10) NOT NULLHelp Context Number
    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
    IMAGE_FMTNumber(2,0)SMALLINT NOT NULLImage FormatOnly set for FIELDTYPE of Images and Attachments.
    1=BMP - Bitmaps
    2=CUT - HALO Image
    3=DIB - Bitmaps
    4=EPS - Postscript
    5=GIF - Graphics Int Format
    6=JPG - JPEG
    7=PCT - Macintosh
    8=PCX - Zsoft
    9=RLE - Bitmaps
    10=TGA - Targa
    16=Attachment
    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
    GRDCOLHDGSTYLECharacter(30)VARCHAR2(30) NOT NULLGrid Column Heading Style
    GRDODDROWSTYLECharacter(30)VARCHAR2(30) NOT NULLGrid Odd Row Style
    GRDEVENROWSTYLECharacter(30)VARCHAR2(30) NOT NULLGrid Even Row 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
    GRDACTRECNAMECharacter(15)VARCHAR2(15) NOT NULLGrid Action Record Name
    GRDACTFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLGrid Action Field Name
    GRDACTPNLNAMECharacter(18)VARCHAR2(18) NOT NULLGrid Action Panel Name
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19