BO_REL_VIEWER_V(SQL View) |
Index Back |
|---|---|
Relationship ViewerUsed in Relationship Viewer, view of PS_BO_REL A , PS_BO BO1 , PS_BO BO2 , PS_BO_REL_TYPE B , PS_BO_ROLE_TYPE C1 , PS_BO_ROLE_TYPE D1 |
| SELECT A.REL_TYPE_ID , B.DESCR , A.BO_ID_1 , BO1.BO_NAME , A.ROLE_TYPE_ID_1 , C1.DESCR , A.BO_ID_2 , BO2.BO_NAME , A.ROLE_TYPE_ID_2 , D1.DESCR , B.HIERARCHICAL_IND , B.PEER2PEER_IND , A.START_DT , A.END_DT FROM PS_BO_REL A , PS_BO BO1 , PS_BO BO2 , PS_BO_REL_TYPE B , PS_BO_ROLE_TYPE C1 , PS_BO_ROLE_TYPE D1 WHERE A.REL_TYPE_ID = B.REL_TYPE_ID AND A.ROLE_TYPE_ID_1 = C1.ROLE_TYPE_ID AND A.ROLE_TYPE_ID_2 = D1.ROLE_TYPE_ID AND B.ROLE_TYPE_ID_1 = C1.ROLE_TYPE_ID AND B.ROLE_TYPE_ID_2 = D1.ROLE_TYPE_ID AND A.BO_ID_1 = BO1.BO_ID AND A.BO_ID_2 = BO2.BO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REL_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
| 2 | REL_TYPE_NAME | Character(50) | VARCHAR2(50) NOT NULL | Relationship Type Name |
| 3 | BO_ID_1 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 1 |
| 4 | BO_NAME_1 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 1 |
| 5 | ROLE_TYPE_ID_1 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 6 | BO_ROLE_NAME_1 | Character(50) | VARCHAR2(50) NOT NULL | BO Role Name 1 |
| 7 | BO_ID_2 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 2 |
| 8 | BO_NAME_2 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 2 |
| 9 | ROLE_TYPE_ID_2 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 10 | BO_ROLE_NAME_2 | Character(50) | VARCHAR2(50) NOT NULL | BO Role Name 2 |
| 11 | HIERARCHICAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if the relationsip is equivalent or hierarchial.
N=No Y=Yes |
| 12 | PEER2PEER_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates a Peer to Peer relationship.
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 13 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 14 | END_DT | Date(10) | DATE | This field stores the end date values. |