REL_CLASS_IDROLE_TYPE_ID_1ROLE_TYPE_ID_2RBW_RC_R2_VW(SQL View) |
Index Back |
|---|---|
Rel Class Role 2 viewView of Role 2 values for a given Relationship Classification and Role 1 |
| SELECT RCR.REL_CLASS_ID , ROLT1.ROLE_TYPE_ID , ROLT2.ROLE_TYPE_ID , ROLT2.DESCR FROM PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT , PS_BO_ROLE_TYPE ROLT1 , PS_BO_ROLE_TYPE ROLT2 WHERE RCR.REL_TYPE_ID = RELT.REL_TYPE_ID AND (ROLT1.ROLE_TYPE_ID = RELT.ROLE_TYPE_ID_1 AND ROLT2.ROLE_TYPE_ID = RELT.ROLE_TYPE_ID_2 OR ROLT1.ROLE_TYPE_ID = RELT.ROLE_TYPE_ID_2 AND ROLT2.ROLE_TYPE_ID = RELT.ROLE_TYPE_ID_1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REL_CLASS_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Unique identifier of a Relationship Classification in Wealth Management |
| 2 | ROLE_TYPE_ID_1 |
Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 3 | ROLE_TYPE_ID_2 |
Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |