EOAWCRTA_VAL(SQL Table) |
Index Back |
|---|---|
User List DefinitionMaps User List to sources or user list data e.g. roles, queries, application classes & SQL Definitions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOAWCRTA_ID |
Character(100) | VARCHAR2(100) NOT NULL | Criteria ID Field |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL |
| 5 | EOAWCRTA_VAL1 |
Character(100) | VARCHAR2(100) NOT NULL | Criteria Value 1 |
| 6 | EOAWCRTA_OPERATOR |
Character(3) | VARCHAR2(3) NOT NULL |
Approval Framework Criteria Operator
<=Less Than <>=Not Equal To ==Equals >=Greater Than B=Between IN=List Values NI=Not In List NN=Is Not Blank NU=Is Blank |
| 7 | EOAWCRTA_VAL2 |
Character(100) | VARCHAR2(100) NOT NULL | Criteria Value 2 |
| 8 | EOAWCRTA_VAL3 | Long Character | CLOB | List Values |