AQS_PROJ_R_VW

(SQL View)
 Index Back

CFS: Project by Role

Chartfield Security: Stores the Project security values by Role.

SELECT DISTINCT C1.ROLEUSER , A.PRODSRCID , A.BUSINESS_UNIT , A.PROJECT_ID FROM PS_SEC_PROJ_ROLE A ,PS_INSTALLATION C , PSROLEUSER C1 WHERE C.PC = 'Y' AND A.ROLENAME = C1.ROLENAME UNION SELECT DISTINCT C1.ROLEUSER , A.PRODSRCID , B.BUSINESS_UNIT , A.PROJECT_ID FROM PS_SEC_PROJ_ROLE A ,PS_OI_BUSET_MAP B ,PS_INSTALLATION C , PSROLEUSER C1 WHERE A.SETID = B.PROJECT_SETID AND C.PC = 'N' AND A.ROLENAME = C1.ROLENAME

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PROJECT_FS.SETID

Prompt Table: SP_BU_FS_NONVW

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT_ID_VW