BO_IDPROFILE_CM_SEQ_EMLRC_EMAIL_VW1(SQL View) |
Index Back |
|---|---|
BO email AddressThis view brings email address of a specific business object |
| SELECT B.BO_ID , B.PROFILE_CM_SEQ , D.DESCR , D.DESCR , C.EMAIL_ADDR FROM PS_BO_CM B , PS_CM C , PS_CM_PURP_TYPE D WHERE B.CM_TYPE_ID = 4 AND B.CM_TYPE_ID = C.CM_TYPE_ID AND B.CM_ID = C.CM_ID AND B.CM_PURPOSE_TYPE_ID = D.CM_PURPOSE_TYPE_ID AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn |
| # | 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 | PROFILE_CM_SEQ_EML |
Number(31,0) | DECIMAL(31) NOT NULL | Used to store the contact method sequence number for a email address. |
| 3 | RC_PURP_TYPE_DSC30 | Character(30) | VARCHAR2(30) NOT NULL | Purpose Type |
| 4 | RC_PURP_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Short Description |
| 5 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |