BO_IDEFFDTDefault Value: %date
RB_INT_CNT_EMVW(SQL View) |
Index Back |
|---|---|
Primary Email for a RepRB_INT_CNT_EMVW - For Integration Contact Email View |
| SELECT BO_ID , BO_CM_START_DT , EMAIL_ADDR FROM PS_BO_SRCH_EML WHERE ROLE_TYPE_ID = 8 AND PRIMARY_IND = 'Y' |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |