SEC_OU_BU_RVW

(SQL View)
 Index Back

CFS: Oper Unit BUGL View

Chartfield Security: Business Unit GL edit table.

SELECT DISTINCT C.ROLEUSER , B.PRODSRCID , A.SETID , %Sql(OPERATING_UNIT, A.) , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.SYNCID , A.SYNCDTTM FROM PS_%Sql(OPER_UNIT_TBL, A) , PS_SEC_OU_ROLE B , PSROLEUSER C WHERE %Join(COMMON_KEYS, %Sql(OPER_UNIT_TBL, A), %Sql(OPER_UNIT_TBL, B), EFFDT) AND A.BUDGETARY_ONLY = 'N' AND C.ROLENAME = B.ROLENAME

  • Related Language Record: SEC_OU_BU_RLG

    • # 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 PRODSRCID Character(4) VARCHAR2(4) NOT NULL Chartfield Security: Source Product
    DBI=Billing
    DCM=Cost Management
    DIN=Inventory
    DMI=Mobile Inventory
    DOM=Order Management
    DPO=Purchasing
    DPV=eProcurement
    DSP=Service Procurement
    FAM=Asset Management
    FAP=Payables
    FAR=Receivables
    FCA=Contracts
    FEX=Expenses
    FGL=General Ledger
    FGM=Grants Management
    FPC=Project Costing
    FTR=Treasury
    KK=Commitment Control
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    4 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

    Default Value: %datetime