PERSON_IDRC_WORKERTZ_VW(SQL View) |
Index Back |
|---|---|
Worker Timezone view |
| SELECT A.PERSON_ID , B.TIMEZONE FROM PS_RB_WORKER A , PS_RB_LOCATION_TMZ B WHERE A.SETID_LOCATION = B.SETID AND A.LOCATION = B.LOCATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |