PTAFCRTA_IDSEQ_NBRRECNAMEPrompt Table: RECDEFN_VW
FIELDNAMEPrompt Table: PSRECFIELDALL
PTAFCRTA_VAL1<=Less Than
<>=Not Equal To
==Equals
>=Greater Than
B=Between
NN=Is Not Blank
NU=Is Blank
PTAFCRTA_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 | PTAFCRTA_ID |
Character(100) | VARCHAR2(100) NOT NULL | Criteria ID |
| 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 | PTAFCRTA_VAL1 |
Character(100) | VARCHAR2(100) NOT NULL | Criteria Value 1 |
| 6 | PTAFCRTA_OPERATOR | Character(3) | VARCHAR2(3) NOT NULL |
Criteria Operator
<=Less Than <>=Not Equal To ==Equals >=Greater Than B=Between NN=Is Not Blank NU=Is Blank |
| 7 | PTAFCRTA_VAL2 | Character(100) | VARCHAR2(100) NOT NULL | Criteria Value 2 |