REL_CLASS_IDROLE_TYPE_ID_1ROLE_TYPE_ID_2LANGUAGE_CDRBW_RC_R2_LVW(SQL View) |
Index Back |
|---|---|
RLR for RBW_RC_R2_VWRelated language view for RBW_RC_R2_VW |
| SELECT RCR.REL_CLASS_ID , ROLT1.ROLE_TYPE_ID , ROLT2.ROLE_TYPE_ID , ROLT2.LANGUAGE_CD , ROLT2.DESCR FROM PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT , PS_BO_ROLE_TYPE ROLT1 , PS_BO_ROLE_TYP_LNG 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |