RD_ROLE_REL(SQL View) |
Index Back |
|---|---|
Primary ContactsView Containing Primary Contacts. |
| SELECT A.ROLE_TYPE_ID_2 , A.REL_TYPE_ID , A.REL_TYPE_ID_STD FROM PS_BO_REL_TYPE A WHERE REL_TYPE_ID IN ( SELECT B.REL_TYPE_ID FROM PS_BO_REL_CAT_ITEM B WHERE B.BO_REL_CATEGORY_ID = 2) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 2 | PRIMARY_REL_TYP_ID | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
| 3 | REL_TYPE_ID_STD | Number(12,0) | DECIMAL(12) NOT NULL | Non-Primary Relationship Type |