PSDMT_FILL_VW

(SQL View)
 Index Back

Fill Core Search Rowset


SELECT A.PS_OWNER , A.PSDMUNIT_ID , A.FIELDNUM , A.RECNAME , A.FIELDNAME , B.LABEL_ID , B.LONGNAME , C.FIELDTYPE , C.LENGTH , C.DECIMALPOS , A.PROMPT_EDITTYPE , A.PROMPT_TBL , '1' , '1' , '1' , %subrec(PSDMT_SRCHPROPS, A) , A.PSDMT_REQUIRED_SW , CASE WHEN U.FIELD_ORDER = 0 THEN 999 ELSE U.FIELD_ORDER END FROM %Table(PSDMT_UNIT_DTL) A , %Table(PSDBFLDLABL) B , %Table(PSDBFIELD) C , %Table(PSDMT_UDC) U WHERE A.FIELDNAME = B.FIELDNAME AND A.LABEL_ID = B.LABEL_ID AND B.FIELDNAME = C.FIELDNAME AND A.ACTIVE_STATUS = 'A' AND U.PS_OWNER = A.PS_OWNER AND U.PSDMUNIT_ID = A.PSDMUNIT_ID AND U.FIELDNUM = A.FIELDNUM AND U.SELECT_SW = 'Y'

  • Related Language Record: PSDMT_FILL_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 PSDMUNIT_ID Character(30) VARCHAR2(30) NOT NULL Transaction
    3 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN_VW3

    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    6 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    7 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label
    8 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    9 LENGTH Number(5,0) INTEGER NOT NULL Length
    10 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    11 PROMPT_EDITTYPE Character(1) VARCHAR2(1) NOT NULL Edit Type
    1=No Table Edit
    2=Prompt Table
    3=Translate Table
    4=Yes/No
    5=Currency Controlled
    12 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table

    Prompt Table: PSRECDEFN_VW3

    13 PSDMT_LOPER_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
    C=In List
    D=Not In List
    14 PSDMT_LOPER_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
    C=In List
    D=Not In List
    15 PSDMT_LOPER_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
    C=In List
    D=Not In List
    16 UPDT_SETID_FROM Number(4,0) SMALLINT NOT NULL Field Number
    17 UPDT_BUS_UNIT_FROM Number(4,0) SMALLINT NOT NULL Field Number
    18 UPDT_KEY_FROM Number(4,0) SMALLINT NOT NULL Field Number
    19 UPDT_KEY_CURR_FROM Number(4,0) SMALLINT NOT NULL Field Number
    20 SETID_FIELD Character(18) VARCHAR2(18) NOT NULL SetID Field
    21 RECNAME_SETID Character(15) VARCHAR2(15) NOT NULL Set Id Record Name
    22 PSDMT_REQUIRED_SW Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    23 FIELD_ORDER Number(3,0) SMALLINT NOT NULL Field Order