BO_IDPERSON_IDBO_CM_ADD_VW(SQL View) |
Index Back |
|---|---|
email addressview of the prerson id and email address of the business object id |
| SELECT A.BO_ID ,C.PERSON_ID , B.EMAIL_ADDR FROM PS_BO_CM A , PS_CM B , PS_RD_PERSON C WHERE C.BO_ID=A.BO_ID AND A.CM_ID=B.CM_ID AND A.CM_TYPE_ID=B.CM_TYPE_ID AND A.CM_TYPE_ID=4 AND A.CM_PURPOSE_TYPE_ID=27 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |