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 |