SP_LEDGKK_OPRVW

(SQL View)
 Index Back

Budget Type Operator view

Operator security view of KK_BUDGET_TYPE.

SELECT B.OPRID , A.SETID1 , A.LEDGER_GROUP , A.EFFDT , A.EFF_STATUS , A.CONTROL_CHARTFIELD , A.FILTER_CHARTFIELD , A.DESCR , A.BUDG_TYPE , A.ASSOC_EXP_BD , A.CNTRL_OPTN , A.TOLERANCE , A.BUDGET_STATUS , A.ENABLE_FS FROM PS_KK_BUDGET_TYPE A , PS_SEC_LEDGER_OPR B WHERE A.LEDGER_GROUP = B.LEDGER_GROUP

  • Related Language Record: KK_BD_TYPE_LANG

    • # 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    4 EFFDT Date(10) DATE Effective Date
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 CONTROL_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Control ChartField
    7 FILTER_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Ruleset ChartField

    Prompt Table: CFS_KK_VW
    Set Control Field: SETID1

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 BUDG_TYPE Character(1) VARCHAR2(1) NOT NULL Budget Type
    E=Expense
    R=Revenue
    10 ASSOC_EXP_BD Character(10) VARCHAR2(10) NOT NULL Associated Expenditure Budget
    11 CNTRL_OPTN Character(1) VARCHAR2(1) NOT NULL Commitment Control Option
    0=Control
    1=Tracking w/ Budget
    2=Track w/o Budget
    3=Default from Higher Level
    4=Control Initial Document
    12 TOLERANCE Signed Number(13,8) DECIMAL(11,8) NOT NULL Tolerance Percent
    13 BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Status
    0=Open
    1=Closed
    2=Hold
    3=Default
    14 ENABLE_FS Character(1) VARCHAR2(1) NOT NULL Enable Funding Source