SEC_KKPRJID_RVW

(SQL View)
 Index Back

CFS: KK Project ID CF View

ChartField Security: This is a view used primarily by customers that are not using the Projects application since it uses "setid" mapping rather than the Projects "Integration Templates". It will return all active projects, including summary level values.

SELECT DISTINCT C.ROLEUSER , B.PRODSRCID , A.SETID , A.PROJECT_ID , A.DESCR FROM PS_PROJECT_FS A , PS_SEC_PROJ_ROLE B , PSROLEUSER C WHERE A.EFF_STATUS='A' AND %Join(COMMON_KEYS, PROJECT_FS A, PROJECT_FS B) AND C.ROLENAME = B.ROLENAME

  • Related Language Record: SEC_PROJFS_RLNG

    • # 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 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description