| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BASE_RECORD |
Character(15) |
VARCHAR2(15) NOT NULL |
Base Record
Prompt Table:
QRY_BASE_REC_VW
|
| 2 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 3 |
SELECTED_CB |
Character(1) |
VARCHAR2(1) NOT NULL |
Row Selected Checkbox
N=Not Selected
Y=Selected
Y/N Table Edit
Default Value: N
|
| 4 |
SEC_APPLIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Security Applied
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 5 |
EXCEED_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exceed Limit
N=No
Y=Yes
Default Value: N
|
| 6 |
CONFLICT_SEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Conflict of Secured Field
N=No
Y=Yes
Default Value: N
|
| 7 |
CONFLICT_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Conflict Overrides
N=No
Y=Yes
Default Value: N
|
| 8 |
RELATED_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Add a Criteria to Query
Default Value: Y
|
| 9 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|
| 10 |
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
|
| 11 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
System Data
Default Value: N
|