RB_CAL_PRSN_VW

(SQL View)
 Index Back

Person Name View

Person Name View used in My Calendar application

SELECT W.PERSON_ID , N.LAST_NAME_SRCH , N.FIRST_NAME_SRCH , N.BO_NAME_DISPLAY , D.DEPTID , D.DESCR , P.SYNCID , P.SYNCDTTM FROM PS_RB_WORKER W , PS_RD_PERSON P , PS_RD_PERSON_NAME N , PS_DEPT_TBL D WHERE W.PERSON_ID = N.PERSON_ID AND N.PRIMARY_IND = 'Y' AND W.PERSON_ID = P.PERSON_ID AND W.SETID_DEPT = D.SETID AND W.DEPTID = D.DEPTID AND D.EFFDT = ( SELECT MAX(D2.EFFDT) FROM PS_DEPT_TBL D2 WHERE D2.SETID = D.SETID AND D2.DEPTID = D.DEPTID AND D2.EFFDT <= %CurrentDateIn) AND D.EFF_STATUS = 'A'

  • Related Language Record: RB_CAL_PRSN_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    2 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    3 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    5 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
    6 DESCR_DEPT Character(30) VARCHAR2(30) NOT NULL Description
    7 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    8 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time