BO_IDRD_CTCT_ADDR_V(SQL View) |
Index Back |
|---|---|
address for contact listThis is the record for the view that shows the Primary Addresses for the Business Object. |
| SELECT P.PERSON_ID , BC.BO_ID , CM.ADDRESS1 , CM.CITY , CM.STATE , CM.POSTAL FROM PS_BO_CM BC , PS_CM CM , PS_BO_CM_USE U ,PS_RD_PERSON P WHERE BC.CM_TYPE_ID = 1 AND CM.CM_ID = BC.CM_ID AND BC.PROFILE_CM_SEQ = U.PROFILE_CM_SEQ AND U.PRIMARY_IND = 'Y' AND P.BO_ID = BC.BO_ID AND U.ROLE_TYPE_ID = 8 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 3 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 4 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 5 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 6 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |