RDH_MRGREL_VW

(SQL View)
 Index Back

CDM Merge Relationships

This is the record for the CDM Merge Relationships view.

SELECT A.REL_TYPE_ID , A.BO_ID_1 , A.ROLE_TYPE_ID_1 , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , A.START_DT , A.END_DT , A.BO_REL_ID , B.PRIMARY_IND , B.REL_TYPE_ID_STD , A.ROW_ADDED_DTTM FROM PS_BO_REL A , PS_BO_REL_TYPE B WHERE A.REL_TYPE_ID = B.REL_TYPE_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

Prompt Table: BO_REL_TYPE

2 BO_ID_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1

Prompt Table: BO

3 ROLE_TYPE_ID_1 Number(12,0) DECIMAL(12) NOT NULL Role Type ID

Prompt Table: RB_VALID_RLTYP1

4 BO_ID_2 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 2

Prompt Table: BO

5 ROLE_TYPE_ID_2 Number(12,0) DECIMAL(12) NOT NULL Role Type ID

Prompt Table: RB_VALID_RLTYP2

6 START_DT Date(10) DATE Start date field to store start date value.
7 END_DT Date(10) DATE This field stores the end date values.
8 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object
9 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes
10 REL_TYPE_ID_STD Number(12,0) DECIMAL(12) NOT NULL Non-Primary Relationship Type
11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.