EOTP_RECT_BU_VW(SQL View) |
Index Back |
---|---|
TPM View for BUTPM 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 |