REL_CLASS_IDPrompt Table: RBW_REL_CLASS
REL_TYPE_IDPrompt Table: %EDITTABLE19
Prompt Table: BO_ROLE_TYPE
Prompt Table: BO_ROLE_TYPE
Y/N Table Edit
Default Value: N
RBW_RL_CL_RL_VW(SQL View) |
Index Back |
|---|---|
Rel Class viewView on Wealth Management Relationship Classifications, joined with BO_REL_TYPE to get Role Type ID 1 and Role Type ID 2 |
| SELECT RCR.REL_CLASS_ID , RCR.REL_TYPE_ID , RELT.ROLE_TYPE_ID_1 , RELT.ROLE_TYPE_ID_2 , RCR.USE_CM_INFO_FLG FROM PS_RBW_REL_CLS_ROL RCR , PS_BO_REL_TYPE RELT WHERE RCR.REL_TYPE_ID = RELT.REL_TYPE_ID |
| # | 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
Prompt Table: RBW_REL_CLASS |
| 2 | REL_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Relationship Type ID
Prompt Table: %EDITTABLE19 |
| 3 | ROLE_TYPE_ID_1 | Number(12,0) | DECIMAL(12) NOT NULL |
Role Type ID
Prompt Table: BO_ROLE_TYPE |
| 4 | ROLE_TYPE_ID_2 | Number(12,0) | DECIMAL(12) NOT NULL |
Role Type ID
Prompt Table: BO_ROLE_TYPE |
| 5 | USE_CM_INFO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates where to pull Contact information from
Y/N Table Edit Default Value: N |