RBM_CAL_PERSON(SQL View) |
Index Back |
|---|---|
Person search Mobile CalendarPerson search for Mobile calendar. Used by Task Management. |
| SELECT A.PERSON_ID , B.NAME ,C.SUN ,C.MON ,C.TUES ,C.WED ,C.THURS ,C.FRI ,C.SAT , A.SYNCID , A.SYNCDTTM FROM PS_RD_PERSON A , PS_RD_PERSON_PN_VW B , PS_RF_WORKER_TBL C WHERE A.PERSON_ID = B.PERSON_ID AND A.PERSON_ID = C.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | SUN | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Sunday
Y/N Table Edit Default Value: INSTALLATION.SUN |
| 4 | MON | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Monday
Y/N Table Edit Default Value: INSTALLATION.MON |
| 5 | TUES | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Tuesday.
Y/N Table Edit Default Value: INSTALLATION.TUES |
| 6 | WED | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Wednesday.
Y/N Table Edit Default Value: INSTALLATION.WED |
| 7 | THURS | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Thursday.
Y/N Table Edit Default Value: INSTALLATION.THURS |
| 8 | FRI | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Friday.
Y/N Table Edit Default Value: INSTALLATION.FRI |
| 9 | SAT | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Saturday.
Y/N Table Edit Default Value: INSTALLATION.SAT |
| 10 | 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. |
| 11 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |