RA_MEMSRCH_WRK(SQL Table) |
Index Back |
|---|---|
Member Search CriteriaMember search criteria work record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_OPERNAME | Character(2) | VARCHAR2(2) NOT NULL |
Find Member - name search criteria
1=begins with 2=equals |
| 2 | RA_OPERFNAME | Character(2) | VARCHAR2(2) NOT NULL |
Find Member - first name search criteria
1=begins with 2=equals |
| 3 | RA_OPERLNAME | Character(2) | VARCHAR2(2) NOT NULL |
Find Member - last name search criteria
1=begins with 2=equals |
| 4 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | RA_RETURN | Character(1) | VARCHAR2(1) NOT NULL | Return to Task detail page in Marketing |
| 8 | RA_SRCHMEMBER_BTN | Character(1) | VARCHAR2(1) NOT NULL | Find Member page - search button |
| 9 | PB_CLEAR | Character(1) | VARCHAR2(1) NOT NULL | Clear |
| 10 | PB_CANCEL | Character(1) | VARCHAR2(1) NOT NULL | Cancel |