PSDMT_INSTANCED

(SQL Table)
 Index Back

Saved Search Instance Detail

  • Parent record: PSDMT_INSTANCEH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    2 PS_OWNER Character(2) VARCHAR2(2) NOT NULL PeopleSoft Owner
    AM=Asset Management
    AP=Accounts Payable
    AR=Accounts Receivable
    BD=Budgets
    BI=Billing
    CA=Contracts
    CM=Cost Management
    CS=Customer Service
    EN=Engineering
    EX=Expenses
    GL=General Ledger
    HR=Human Resources
    IN=Inventory
    MG=Manufacturing
    OM=Order Management
    PC=Project Costing
    PL=Planning
    PO=Purchasing
    PR=Production Control
    PT=PeopleTools
    TL=Time and Labor
    TR=Treasury
    3 PSDMUNIT_ID Character(30) VARCHAR2(30) NOT NULL Transaction
    4 SEARCH_SAVE_ID Character(30) VARCHAR2(30) NOT NULL Save Search As
    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN_VW3

    6 RECALIAS Character(15) VARCHAR2(15) NOT NULL Record Alias
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    8 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    9 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    10 LOGIC_OPER_CHAR Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Like
    8=Not Like
    9=Is Empty
    A=Between
    B=Not Between
    11 LOGIC_OPER_DATE Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Begins with
    8=Does NOT begins with
    9=Is Empty
    A=Between
    B=Not Between
    12 LOGIC_OPER_NUM Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Like
    8=Does NOT begins with
    9=Is Empty
    A=Between
    B=Not Between
    13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    15 KEY_CHAR_30_01 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 01
    16 FIELDVALUE_CHAR1 Character(30) VARCHAR2(30) NOT NULL Value
    17 FIELDVALUE_CHAR2 Character(30) VARCHAR2(30) NOT NULL Value
    18 FIELDVALUE_CHR_DD1 Character(30) VARCHAR2(30) NOT NULL Value
    19 FIELDVALUE_CHR_DD2 Character(30) VARCHAR2(30) NOT NULL Value
    20 KEY_SIGN_NUM_28_0 Signed Number(29,0) DECIMAL(28) NOT NULL Key 1
    21 FIELDVALUE_NUM1 Signed Number(29,0) DECIMAL(28) NOT NULL Value
    22 FIELDVALUE_NUM2 Signed Number(29,0) DECIMAL(28) NOT NULL Value
    23 KEY_DATE_01 Date(10) DATE Key Date 01
    24 FIELDVALUE_DT1 Date(10) DATE Value
    25 FIELDVALUE_DT2 Date(10) DATE Value
    26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    27 FIELDVALUE_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Value
    28 FIELDVALUE_AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Value
    29 FIELDVALUE_CHAR1P Character(30) VARCHAR2(30) NOT NULL Value

    Prompt Table: %EDITTABLE

    30 FIELDVALUE_CHAR2P Character(30) VARCHAR2(30) NOT NULL Value

    Prompt Table: %EDITTABLE

    31 FIELDVALUE_DT1P Date(10) DATE Value

    Prompt Table: %EDITTABLE2

    32 FIELDVALUE_DT2P Date(10) DATE Value

    Prompt Table: %EDITTABLE2

    33 FIELDVALUE_NUM1P Signed Number(29,0) DECIMAL(28) NOT NULL Value

    Prompt Table: %EDITTABLE3

    34 FIELDVALUE_NUM2P Signed Number(29,0) DECIMAL(28) NOT NULL Value

    Prompt Table: %EDITTABLE3

    35 FIELDVALUE_DEC1 Signed Number(31,6) DECIMAL(29,6) NOT NULL Value
    36 FIELDVALUE_DEC2 Signed Number(31,6) DECIMAL(29,6) NOT NULL Value