QRY_SEC_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BASE_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Base Record |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Record 1 Name |
| 7 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 8 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |
| 9 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Fieldname 2 |
| 10 | RECNAME_3 | Character(15) | VARCHAR2(15) NOT NULL | Rename |
| 11 | FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 12 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 13 | QSC_SECURITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Query Security
0=No Security 1=User ID 2=Role 3=Permission List |
| 14 | ERRORS_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Process Errors Only |
| 15 | CONFLICT_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Conflict Overrides
N=No Y=Yes |
| 16 | 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 |