TL_WV_OPTIONS(SQL Table) |
Index Back |
|---|---|
eTime World View OptionseTime Manager World View settings - used to determine color and priority for displaying time related data in the Daily, Weekly and Monthly Time Calendars |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TL_WV_TIME_EVENT |
Character(3) | VARCHAR2(3) NOT NULL |
Time Event
AAB=Approved Absence AOT=Approved Overtime ATR=Approved Training DEF=Default Reported/Payable Time EXC=Exceptions HOL=Holidays OFF=Off Day RAB=Requested Absence ROT=Requested Overtime RTR=Requested Training TRC=TRC List WRK=Workday |
| 2 | LIST_ID |
Character(12) | VARCHAR2(12) NOT NULL |
List ID
Prompt Table: TL_VAL_LIST_VW1 |
| 3 | TL_WV_OPTN_USE | Character(1) | VARCHAR2(1) NOT NULL |
Display
Y/N Table Edit |
| 4 | TL_WV_COLOR | Character(3) | VARCHAR2(3) NOT NULL |
Color
BGR=Blue-Green BLU=Blue BRN=Brown GRN=Green GRY=Gray LBL=Light Blue LGR=Light Green LGY=Light Gray LYL=Light Yellow ORN=Orange PNK=Pink RED=Red RVL=Red-Violet TAN=Tan VLT=Violet YEL=Yellow |
| 5 | TL_WV_PRIORITY | Number(2,0) | SMALLINT NOT NULL | Priority |
| 6 | TL_WV_SYMBOL | Character(3) | VARCHAR2(3) NOT NULL | Symbol |