SEC_PROJ_PERM

(SQL Table)
Index Back

CFS: Project by Perm List

Chartfield Security: Stores the Project security values by row level security permission list.

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

Default Value: PROJECT_FS.SETID

Prompt Table: SP_BU_FS_NONVW

4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: PROJECT_ID_VW