RD_P_VALID_ROLT

(SQL View)
 Index Back

Valid Individual Role Types

Available Role Types for an Individual.

SELECT B.ROLE_TYPE_ID , B.DESCR , B.DESCRSHORT FROM PS_BO_ROLE_TYPE B WHERE B.BO_TYPE_ID = 1 AND EXISTS ( SELECT 'X' FROM PS_BO_ROLE A WHERE A.ROLE_TYPE_ID = B.ROLE_TYPE_ID)

  • Related Language Record: BO_ROLE_TYP_LNG

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

    Default Value: BO_ROLE_TYP_LNG.DESCR