RB_CONT_CM_VW(SQL View) |
Index Back |
|---|
| SELECT U.BO_REL_ID , A.CM_TYPE_ID , U.PRIMARY_IND , A.COUNTRY_CODE , A.PHONE , A.EXTENSION , A.EMAIL_ADDR FROM PS_CM A , PS_BO_CM B , PS_BO_CM_USE U WHERE A.CM_ID = B.CM_ID AND B.BO_ID = U.BO_ID AND B.PROFILE_CM_SEQ = U.PROFILE_CM_SEQ AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn AND U.BO_REL_ID > 0 AND A.CM_TYPE_ID IN (2,4) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_REL_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Relationship ID of a Business Object |
| 2 | CM_TYPE_ID | Number(6,0) | INTEGER NOT NULL | Contact Method Type ID |
| 3 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes |
| 4 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Country Code values. |
| 5 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | This field stores the Telephone number. |
| 6 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |
| 7 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |