GM_PT_SEARCH(SQL Table) |
Index Back |
|---|---|
Grants Portal Search Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SEARCH_OPTION_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
User Saved Search
Prompt Table: %EDITTABLE |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | SEARCHING_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Search Type
A=Award Searching P=Project Searching S=Personnel Searching |
| 4 | GM_OPERATION | Character(4) | VARCHAR2(4) NOT NULL |
Arithmetic Operation
<=Less Than <==Less Than or Equal To <>=Not Equal To ==Equal To >=Greater Than >==Greater Than or Equal To BEGN=Begin With BTW=Between IN=In List LIKE=Contains |
| 5 | FIELDVAL5 | Character(250) | VARCHAR2(250) NOT NULL | Field Value 5 |
| 6 | FIELDVALUE_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Value |
| 7 | FIELDVALUE_DT1 | Date(10) | DATE | Value |
| 8 | CREATED_BY | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 9 | GM_PT_SRCH_PUBLIC | Character(1) | VARCHAR2(1) NOT NULL |
Save Portal Search As Public or Private
Default Value: Y |