SEC_RULE_PRD_R

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: SEC_ROLE.EFFDT

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: SEC_FIELDS_VW

4 SEC_RULE Character(10) VARCHAR2(10) NOT NULL Security Rule

Prompt Table: SEC_RULE_DFN_VW

5 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