TL_WV_OPTNS_VW3 (SQL View)	Index Back
eTime World View - TRC Lists eTime Manager World View settings - TRC List options

TL_WV_OPTNS_VW3

(SQL View)

eTime World View - TRC Lists

eTime Manager World View settings - TRC List 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 = '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
Default Value: TRC

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
Default Value: Y

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

#	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 Default Value: TRC
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 Default Value: Y
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