RBW_REL_CLS_VW(SQL View) |
Index Back |
---|---|
Relationship Class viewView on the Relationship Classification table |
SELECT REL_CLASS_ID , SEQNO , DESCR , NEW_BO_FLG , ROLE_TYPE_ID_ORG FROM PS_RBW_REL_CLASS WHERE ACTIVE_FLG = 'Y' |
# | 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 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | NEW_BO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether a Relationship Classification should result in a new Business Object
Y/N Table Edit Default Value: N |
5 | ROLE_TYPE_ID_ORG | Number(12,0) | DECIMAL(12) NOT NULL |
Organization Role Type ID
Prompt Table: BO_ROLE_TYPE |