TL_WV_OPTNS_VW2(SQL View) |
Index Back |
|---|---|
eTime World View -Scheduled TmeTime Manager World View settings - scheduled time options |
| SELECT TL_WV_TIME_EVENT , LIST_ID , TL_WV_OPTN_USE , TL_WV_COLOR , TL_WV_PRIORITY , TL_WV_SYMBOL FROM PS_TL_WV_OPTIONS WHERE TL_WV_TIME_EVENT NOT IN ('DEF','TRC') |
| # | 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 |
| 3 | TL_WV_OPTN_USE | Character(1) | VARCHAR2(1) NOT NULL |
Display
Y/N Table Edit Default Value: N |
| 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 |