RD_PERS_SRCH_VW(SQL View) |
Index Back |
|---|---|
Person Search ViewSearches on person record. Basic search view for Person Search. |
| SELECT DISTINCT A.PERSON_ID , B.NAME , 'N' , A.SETID , A.CONTACT_FLAG , 'N' , A.BO_ID FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B , PS_BO_ROLE R WHERE A.PERSON_ID = B.PERSON_ID AND R.BO_ID = A.BO_ID AND R.ROLE_TYPE_ID IN (4, 17) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Business Name Display. BO_NAME.NAME_DISPLAY |
| 3 | ROW_TAG | Character(1) | VARCHAR2(1) NOT NULL |
Selected
N=No Y=Yes |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 5 | CONTACT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
An attribute that describes the specific purpose of a given bank/counterparty contact person.
It is also used to indicate whether a person has a Contact role.
E=External Contact I=Internal Corporate Contact |
| 6 | ROW_FIND | Character(1) | VARCHAR2(1) NOT NULL | Find target row. |
| 7 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |