REL_CLASS_IDROLE_TYPE_ID_1LANGUAGE_CDRBW_RC_R1_LVW2(SQL View) |
Index Back |
|---|---|
RLR for RBW_RC_R1_VWRelated language view for RBW_RC_R1_VW |
| SELECT DISTINCT RC.REL_CLASS_ID , ROLT.ROLE_TYPE_ID , ROLT.LANGUAGE_CD , ROLT.DESCR FROM PS_RBW_REL_CLASS RC , PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT , PS_BO_ROLE_TYP_LNG ROLT WHERE RC.REL_CLASS_ID = RCR.REL_CLASS_ID AND RELT.REL_TYPE_ID = RCR.REL_TYPE_ID AND (ROLT.ROLE_TYPE_ID = RELT.ROLE_TYPE_ID_1 OR ROLT.ROLE_TYPE_ID = RELT.ROLE_TYPE_ID_2) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |