| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
TRC_DESCR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC Presentations
C=Show CODE - Description
D=Show Description - CODE
O=Show Description Only
Default Value: C
|
| 3 |
TRC_DESCR_FLU_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC Presentations
C=CODE - Description
D=Description - CODE
O=Description
|
| 4 |
TIME_PREPOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Prepopulation Method
0=Off
1=Prior Period
2=Schedule
3=Task Values
Default Value: 0
|
| 5 |
DFLT_TIME_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Timesheet Display
B=Bi-Weekly
D=Daily
M=Monthly
W=Weekly
Z=Time Reporting Period
Default Value: W
|
| 6 |
START_DAY_OF_WEEK |
Character(1) |
VARCHAR2(1) NOT NULL |
Start Day of Week
1=1 - Monday
2=2 - Tuesday
3=3 - Wednesday
4=4 - Thursday
5=5 - Friday
6=6 - Saturday
7=7 - Sunday
Default Value: 1
|
| 7 |
TL_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Indicator
A=Ascending
D=Descending
|
| 8 |
TL_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Details option User Preference
C=Collapsed
E=Expanded
|
| 9 |
SAVE_FOR_LATER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Save For Later Option
A=Always Validate
B=Never Validate
N=Save For Later Is Not Allowed
U=Use User Preference
Y=Prompt For Validation
Default Value: Y
|
| 10 |
SUBMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field introduced to allow controlling the Submit confirmation on the timesheet.
C=Confirm
S=Skip Confirmation
U=Use User Preference
Default Value: C
|
| 11 |
TL_PG_TSS_RT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Realtime Processing
D=Use Installation Default
N=No Realtime Processing
Y=Allow Realtime Processing
Default Value: D
|
| 12 |
SCH_BACKGROUND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Scheduled Time background Type
C=Color Code
P=Pattern
S=Solid Color
|
| 13 |
SCH_BACKGROUND |
Character(30) |
VARCHAR2(30) NOT NULL |
Schedule time background
|
| 14 |
REP_BACKGROUND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Scheduled Time background Type
C=Color Code
P=Pattern
S=Solid Color
|
| 15 |
REP_BACKGROUND |
Character(30) |
VARCHAR2(30) NOT NULL |
reporting time background
|
| 16 |
OVT_BACKGROUND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Overtime background Option
C=Color Code
P=Pattern
S=Solid Color
|
| 17 |
OVT_BACKGROUND |
Character(30) |
VARCHAR2(30) NOT NULL |
Overtime background
|