EX_PE_TIP_PRS

(SQL Table)
 Index Back

Personalize TIP for Expenses

  • Parent Record Of EX_TIP_PRS_DEPT EX_TIP_TE_DEPT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

    Y/N Table Edit

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 DEPT_PROJ_VIEW Character(1) VARCHAR2(1) NOT NULL Department Project View
    D=View by Department
    P=View by Project

    Default Value: D

    5 GL_BU_SOURCE Character(1) VARCHAR2(1) NOT NULL GL Business Unit Source
    S=Specify
    U=From Employee Profile

    Default Value: U

    6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    7 BUSINESS_UNIT_GL1 Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with an internal counterparty.

    Prompt Table: SP_BU_GL_NONVW

    8 PC_BU_SOURCE Character(1) VARCHAR2(1) NOT NULL A flag to indicate where the Business Unit personalization filter will come from: User Preference or a Specified Value.
    S=Specify
    U=Projects User Preferences

    Default Value: U

    9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    10 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU

    Prompt Table: SP_BU_PC_NONVW

    11 PROJECT_OPT_FILTER Character(2) VARCHAR2(2) NOT NULL Project Filters
    MP=My Projects
    NO=No Additional Filters
    PM=Project Manager
    SP=Project ID

    Default Value: NO

    12 PC_GRAPH_TYPE Character(1) VARCHAR2(1) NOT NULL Pagelet Format
    B=Bar Graph
    P=Pie Graph

    Default Value: B