EOTP_RECT_BU_VW

(SQL View)
Index Back

TPM View for BU

TPM View for BU used in recruitment event to select business unit based on role security for the user

SELECT DISTINCT B.BUSINESS_UNIT , C.DESCR , A.ROLEUSER FROM PSROLEUSER A , PS_EOTP_BUSEC B , PS_EOTP_BU C WHERE A.ROLENAME = B.ROLENAME AND B.BUSINESS_UNIT = C.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User