FIN9001_AET(SQL Table) |
Index Back |
|---|---|
AET file for RB_9001 AE prog.Used as the AET file for App. Engine program RB_9001 to set security views. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SECURITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security N=No Security O=User ID Level Security |
| 3 | SETID_SECURITY | Character(1) | VARCHAR2(1) NOT NULL | TableSet ID Security |
| 4 | FIELD_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Secured Field Type
B=Business Unit Level Security S=TableSet ID Level Security |
| 5 | APPLY_SECURITY | Character(1) | VARCHAR2(1) NOT NULL | Apply Security flag |
| 6 | BU_SECURITY | Character(1) | VARCHAR2(1) NOT NULL | Business Unit Security |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 9 | SEARCH_TEXT | Character(15) | VARCHAR2(15) NOT NULL | Search Text for Security Views |
| 10 | SEARCH_TEXT2 | Character(15) | VARCHAR2(15) NOT NULL | Search Text for Security Views |
| 11 | SEARCH_TEXT3 | Character(15) | VARCHAR2(15) NOT NULL | Search Text for Security Views |
| 12 | VIEW_NO_SECURITY | Character(15) | VARCHAR2(15) NOT NULL | No Security View |
| 13 | VIEW_OPR_SECURITY | Character(15) | VARCHAR2(15) NOT NULL | User ID Security View |
| 14 | VIEW_CLS_SECURITY | Character(15) | VARCHAR2(15) NOT NULL | Permission List Security View |
| 15 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
| 16 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 17 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 18 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 19 | OBJECTTYPENAME | Character(8) | VARCHAR2(8) NOT NULL | Object Type Name- Version/Table reference |
| 20 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 21 | VERSION2 | Number(10,0) | DECIMAL(10) NOT NULL | Version |
| 22 | ACTION_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Action Flag
A=Action Default Value: N |
| 23 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 24 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Criteria SQL.............................................................. |
| 25 | OPTN_CATEGORY_LVL | Character(4) | VARCHAR2(4) NOT NULL |
Option Category Level
CRM=Customer Relationship Mgmt CSTM=Custom EPM=Enterprise Performance Mgmt FIN=Financials HRMS=Human Resources Management LS=Learning Solutions PPTL=PeopleTools SCM=Supply Chain Management |
| 26 | USEROPTN | Character(12) | VARCHAR2(12) NOT NULL | User Option |
| 27 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 28 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 29 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |