RSPD_PLN_MGR_VW

(SQL View)
 Index Back

Manager to staff Dashboard

Dashboard view of the manager's reporting relationships

SELECT DISTINCT A.PERSON_ID_MANAGER , A.PERSON_ID , TM.REL_TYPE_ID , TM.BO_ID_1 , TM.ROLE_TYPE_ID_1 , TM.BO_ID_2 , TM.ROLE_TYPE_ID_2 , B.OPRID , TM.BO_REL_ID , TM.START_DT , TM.END_DT , TM.ACCT_OWNER FROM PS_RSF_ACC_SUSER A , PSOPRALIAS B , PS_RD_ACCT_TM_VW TM , PS_RD_PERSON P WHERE A.PERSON_ID_MANAGER = B.PERSON_ID AND B.OPRALIASTYPE = 'PER' AND TM.BO_ID_1 = P.BO_ID AND P.PERSON_ID = A.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID
4 BO_ID_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1

Prompt Table: RB_PRSN_BO_VW

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

Default Value: 17

Prompt Table: RB_VALID_ROLTYP

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

Prompt Table: BO

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

Prompt Table: RB_VALID_ROLTYP

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object
10 START_DT Date(10) DATE Start date field to store start date value.
11 END_DT Date(10) DATE This field stores the end date values.
12 ACCT_OWNER Character(1) VARCHAR2(1) NOT NULL Account Team Owners....................
N=No
Y=Yes