| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
SEC_PNLGRP_VW
|
| 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 |
ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Flag
A=Active
I=Inactive
Default Value: A
|
| 4 |
SEC_ACCESS_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
When user has partial access
D=Deny Access
G=Grant Access
X=Default from Higher Level
|
| 5 |
ACTIVE_PROD |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Product Flag
A=Active
I=Inactive
Default Value: A
|
| 6 |
SEC_DISTRIB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Secure Dist Code
Y/N Table Edit
Default Value: N
|
| 7 |
SINGLE_TRANS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Transaction Display
Y/N Table Edit
Default Value: Y
|
| 8 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
Prompt Table:
COMP_REC_LV0_VW
|