RIM_SYNCSTAT_VW

(SQL View)
 Index Back

RIM Sync Status View

RIM Sync Status View - This view is used as a Search Record for the RIM Status Page

SELECT RIM.OPRID , PER.LAST_NAME , PER.FIRST_NAME , PER.BO_NAME_DISPLAY FROM PS_RD_PERSON_NAME PER , PS_RB_OPRALIAS_VW OPR , PS_RIM_SYNCLOG RIM WHERE PER.PERSON_ID = OPR.PERSON_ID AND OPR.OPRID = RIM.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object