|
SELECT B.DEPTID , A.EMPLID , A.EMPL_RCD , A.WTD_BEGIN_WK_DT_UK , A.WTD_END_WK_DT_UK , A.WTD_ACT_HRS_SUN_UK , A.WTD_ACT_MIN_SUN_UK , A.WTD_ACT_HRS_MON_UK , A.WTD_ACT_MIN_MON_UK , A.WTD_ACT_HRS_TUE_UK , A.WTD_ACT_MIN_TUE_UK , A.WTD_ACT_HRS_WED_UK , A.WTD_ACT_MIN_WED_UK , A.WTD_ACT_HRS_THU_UK , A.WTD_ACT_MIN_THU_UK , A.WTD_ACT_HRS_FRI_UK , A.WTD_ACT_MIN_FRI_UK , A.WTD_ACT_HRS_SAT_UK , A.WTD_ACT_MIN_SAT_UK , A.WTD_ACTWRK_HRS_UK , A.WTD_ACTWRK_MINS_UK , A.WTD_BRK_HRS_SUN_UK , A.WTD_BRK_MIN_SUN_UK , A.WTD_BRK_HRS_MON_UK , A.WTD_BRK_MIN_MON_UK , A.WTD_BRK_HRS_TUE_UK , A.WTD_BRK_MIN_TUE_UK , A.WTD_BRK_HRS_WED_UK , A.WTD_BRK_MIN_WED_UK , A.WTD_BRK_HRS_THU_UK , A.WTD_BRK_MIN_THU_UK , A.WTD_BRK_HRS_FRI_UK , A.WTD_BRK_MIN_FRI_UK , A.WTD_BRK_HRS_SAT_UK , A.WTD_BRK_MIN_SAT_UK , A.WTD_BRK_HRS_UK , A.WTD_BRK_MINS_UK , A.WTD_TOTWRK_HRS_UK , A.WTD_TOTWRK_MINS_UK , A.WTD_EXCEP_FLAG_UK , B.COMPANY FROM PS_WRK_TIME_DIR_UK A , PS_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_JOB B2 WHERE B.EMPLID=B2.EMPLID AND B.EMPL_RCD=B2.EMPL_RCD AND B2.EFFDT<=%CurrentDateIn) AND B.EFFSEQ=( SELECT MAX(B3.EFFSEQ) FROM PS_JOB B3 WHERE B.EMPLID=B3.EMPLID AND B.EMPL_RCD=B3.EMPL_RCD AND B.EFFDT=B3.EFFDT)
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 4 |
WTD_BEGIN_WK_DT_UK |
Date(10) |
DATE |
Date used to indicate on which day the week starts for entering daily exceptions in the UK Working Time Directive feature.
|
| 5 |
WTD_END_WK_DT_UK |
Date(10) |
DATE |
Date used to indicate on which day the week ends for entering daily exceptions in the UK Working Time Directive feature.
|
| 6 |
WTD_ACT_HRS_SUN_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Hours worked on Sunday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 7 |
WTD_ACT_MIN_SUN_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Minutes worked on Sunday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 8 |
WTD_ACT_HRS_MON_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Hours worked on Monday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 9 |
WTD_ACT_MIN_MON_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Minutes worked on Monday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 10 |
WTD_ACT_HRS_TUE_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Hours worked on Tuesday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 11 |
WTD_ACT_MIN_TUE_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Minutes worked on Tuesday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 12 |
WTD_ACT_HRS_WED_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Hours worked on Wednesday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 13 |
WTD_ACT_MIN_WED_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Minutes worked on Wednesday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 14 |
WTD_ACT_HRS_THU_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Hours worked on Thursday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 15 |
WTD_ACT_MIN_THU_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Minutes worked on Thursday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 16 |
WTD_ACT_HRS_FRI_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Hours worked on Friday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 17 |
WTD_ACT_MIN_FRI_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Minutes worked on Friday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 18 |
WTD_ACT_HRS_SAT_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Hours worked on Saturday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 19 |
WTD_ACT_MIN_SAT_UK |
Number(2,0) |
SMALLINT NOT NULL |
Actual Minutes worked on Saturday. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 20 |
WTD_ACTWRK_HRS_UK |
Number(3,0) |
SMALLINT NOT NULL |
Total Actual Hours Worked in page used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 21 |
WTD_ACTWRK_MINS_UK |
Number(2,0) |
SMALLINT NOT NULL |
Total Actual Minutes Worked in page used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 22 |
WTD_BRK_HRS_SUN_UK |
Number(2,0) |
SMALLINT NOT NULL |
Sunday Break Hours. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 23 |
WTD_BRK_MIN_SUN_UK |
Number(2,0) |
SMALLINT NOT NULL |
Sunday Break Minutes. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 24 |
WTD_BRK_HRS_MON_UK |
Number(2,0) |
SMALLINT NOT NULL |
Monday Break Hours. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 25 |
WTD_BRK_MIN_MON_UK |
Number(2,0) |
SMALLINT NOT NULL |
Monday Break Minutes. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 26 |
WTD_BRK_HRS_TUE_UK |
Number(2,0) |
SMALLINT NOT NULL |
Tuesday Break Hours. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 27 |
WTD_BRK_MIN_TUE_UK |
Number(2,0) |
SMALLINT NOT NULL |
Tuesday Break Minutes. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 28 |
WTD_BRK_HRS_WED_UK |
Number(2,0) |
SMALLINT NOT NULL |
Wednesday Break Hours. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 29 |
WTD_BRK_MIN_WED_UK |
Number(2,0) |
SMALLINT NOT NULL |
Wednesday Break Minutes. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 30 |
WTD_BRK_HRS_THU_UK |
Number(2,0) |
SMALLINT NOT NULL |
Thursday Break Hours. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 31 |
WTD_BRK_MIN_THU_UK |
Number(2,0) |
SMALLINT NOT NULL |
Thursday Break Minutes. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 32 |
WTD_BRK_HRS_FRI_UK |
Number(2,0) |
SMALLINT NOT NULL |
Friday Break Hours. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 33 |
WTD_BRK_MIN_FRI_UK |
Number(2,0) |
SMALLINT NOT NULL |
Friday Break Minutes. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 34 |
WTD_BRK_HRS_SAT_UK |
Number(2,0) |
SMALLINT NOT NULL |
Saturday Break Hours. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 35 |
WTD_BRK_MIN_SAT_UK |
Number(2,0) |
SMALLINT NOT NULL |
Saturday Break Minutes. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 36 |
WTD_BRK_HRS_UK |
Number(3,0) |
SMALLINT NOT NULL |
Total Break Hours. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 37 |
WTD_BRK_MINS_UK |
Number(2,0) |
SMALLINT NOT NULL |
Total Break Minutes. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 38 |
WTD_TOTWRK_HRS_UK |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Total weekly hours worked. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 39 |
WTD_TOTWRK_MINS_UK |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Total weekly minutes worked. Used for entering daily exceptions for the UK Working Time Directive functionality.
|
| 40 |
WTD_EXCEP_FLAG_UK |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to indicate if Daily Exceptions have been added in the UK Working Time Directive feature.
|
| 41 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|