| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
START_DT |
Date(10) |
DATE |
Start Date
Default Value: %Date
|
| 3 |
END_DT |
Date(10) |
DATE |
end date
|
| 4 |
TL_WV_TIME1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Start Time
00=00:00
01=01:00
02=02:00
03=03:00
04=04:00
05=05:00
06=06:00
07=07:00
08=08:00
09=09:00
10=10:00
11=11:00
12=12:00
13=13:00
14=14:00
15=15:00
16=16:00
17=17:00
18=18:00
19=19:00
20=20:00
21=21:00
22=22:00
23=23:00
|
| 5 |
TL_WV_TIME2 |
Character(2) |
VARCHAR2(2) NOT NULL |
End Time
00=00:00
01=01:00
02=02:00
03=03:00
04=04:00
05=05:00
06=06:00
07=07:00
08=08:00
09=09:00
10=10:00
11=11:00
12=12:00
13=13:00
14=14:00
15=15:00
16=16:00
17=17:00
18=18:00
19=19:00
20=20:00
21=21:00
22=22:00
23=23:00
|
| 6 |
REP_PAY_HOURS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reported - Payable Hours
P=Payable Hours
R=Reported Hours
Default Value: R
|
| 7 |
SHOW_SCHEDULE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Schedule
Y/N Table Edit
Default Value: N
|
| 8 |
SHOW_HOLIDAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Holidays
Y/N Table Edit
Default Value: N
|
| 9 |
SHOW_GP_ABS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Absences
Y/N Table Edit
Default Value: N
|
| 10 |
SHOW_OVERTIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Planned Overtime
Y/N Table Edit
Default Value: N
|
| 11 |
SHOW_TRAINING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Training Hours
Y/N Table Edit
Default Value: N
|
| 12 |
SHOW_EXCEPTION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Exceptions
Y/N Table Edit
Default Value: N
|
| 13 |
SHOW_LABEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Symbols
Y/N Table Edit
Default Value: N
|
| 14 |
ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Flag
A=Active
I=Inactive
Y/N Table Edit
|
| 15 |
GROUP_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Group ID
Prompt Table:
TL_GROUP_VW
|