SEC_DEPT_BU_PVW

(SQL View)
 Index Back

CFS: Department BUGL View

Chartfield Security: Busniess Unit GL edit table.

SELECT B.ROWSECCLASS , B.PRODSRCID , A.SETID , %Sql(DEPTID, A.) , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.MANAGER_NAME , A.ACCOUNTING_OWNER , A.SYNCID , A.SYNCDTTM FROM PS_DEPT_TBL A , PS_SEC_DEPT_PERM B WHERE %Join(COMMON_KEYS, DEPT_TBL A, DEPT_TBL B, EFFDT) AND A.BUDGETARY_ONLY = 'N'

  • Related Language Record: SEC_DEPT_BU_PLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
    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 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    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 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Identifies the name of the manager of a specified department.
    10 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner
    11 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.
    12 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

    Default Value: %datetime