TL_TR_EE_PREF(SQL Table) |
Index Back |
|---|
| # | 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 Code or Description
C=Display TRC/TRC Description D=Display TRC Description/TRC Default Value: C |
| 3 | TIME_PREPOP | Character(1) | VARCHAR2(1) NOT NULL |
Time Prepopulation Method
1=Prior Period 2=Schedule Information 3=Task Values |
| 4 | DFLT_TIME_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Default Timesheet Display
D=Daily W=Weekly Z=Time Reporting Period Default Value: W |
| 5 | 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 |