RBW_HH_ROLE_VW

(SQL View)
 Index Back

Household Role view

View to get the Role Type associated with the Household Relationship Classification

SELECT RC.ROLE_TYPE_ID_ORG , ROLT.DESCR FROM PS_RBW_REL_CLASS RC , PS_BO_ROLE_TYPE ROLT WHERE RC.ROLE_TYPE_ID_ORG = ROLT.ROLE_TYPE_ID AND RC.ACTIVE_FLG = 'Y' AND RC.NEW_BO_FLG = 'Y'

  • Related Language Record: RBW_HH_ROLE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLE_TYPE_ID_2 Number(12,0) DECIMAL(12) NOT NULL Role Type ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description