RBW_HH_CM_RL_VW(SQL View) |
Index Back |
|---|---|
CM Role Type viewView to get the primary contact Role Type ID for Households |
| SELECT RELT.ROLE_TYPE_ID_1 , RC.ROLE_TYPE_ID_ORG , RC.REL_CLASS_ID FROM PS_RBW_REL_CLASS RC , PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT WHERE RC.REL_CLASS_ID = RCR.REL_CLASS_ID AND RELT.REL_TYPE_ID = RCR.REL_TYPE_ID AND RC.ACTIVE_FLG = 'Y' AND RCR.USE_CM_INFO_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLE_TYPE_ID_CM | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 2 | ROLE_TYPE_ID_ORG | Number(12,0) | DECIMAL(12) NOT NULL | Organization Role Type ID |
| 3 | REL_CLASS_ID | Number(12,0) | DECIMAL(12) NOT NULL | Unique identifier of a Relationship Classification in Wealth Management |