SEC_DST_IU_RVW

(SQL View)
 Index Back

IU- All Distrib Codes View

Chartfield Security (Role): This view is used in Bill Entry and Interunit Control Panels. In Bill Entry Panels, record level set control field is used. In Interunit Control panels, field level set control field is used on BI_LINE_IU_EXP and BI_LINE_IU_PAY.

SELECT DISTINCT C.ROLEUSER , B.PRODSRCID , A.SETID , A.DST_ID , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT FROM PS_DST_CODE_TBL A , PS_SEC_DST_ROLE B , PSROLEUSER C WHERE %Join(COMMON_KEYS, DST_CODE_TBL A, DST_CODE_TBL B, EFFDT) AND C.ROLENAME = B.ROLENAME

  • Related Language Record: SEC_DST_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
    4 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
    5 EFFDT Date(10) DATE Effective Date
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description