HRS_CAL_VW_OPTN(SQL Table) |
Index Back |
|---|---|
Calendar View OptionsCalendar View Options |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | HRS_AVAIL_STS |
Character(3) | VARCHAR2(3) NOT NULL |
Availability Status
001=Busy 002=Tentative 003=Interview 004=No Information |
| 3 | HRS_DISPLAY_STS | Character(1) | VARCHAR2(1) NOT NULL |
Display Status
Y/N Table Edit |
| 4 | HRS_STATUS_COLOR | Character(3) | VARCHAR2(3) NOT NULL |
Status Color
001=Blue-Green 002=Blue 003=Brown 004=Green 005=Gray 006=Light Blue 007=Light Green 008=Light Yellow 009=Orange 010=Pink 011=Red 012=Red-Violet 013=Tan 014=Violet 015=Yellow |