EMPLIDEMPL_RCDWTD_BEGIN_WK_DT_UKY/N Table Edit
Default Value: N
WRK_TIME_DIR_UK(SQL Table) |
Index Back |
|---|---|
UK Working Time DirectiveMain record used to keep daily exceptions in the UK Working Time Directive feature. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | 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. |
| 4 | 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. |
| 5 | 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. |
| 6 | 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. |
| 7 | 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. |
| 8 | 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. |
| 9 | 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. |
| 10 | 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. |
| 11 | 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. |
| 12 | 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. |
| 13 | 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. |
| 14 | 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. |
| 15 | 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. |
| 16 | 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. |
| 17 | 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. |
| 18 | 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. |
| 19 | 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. |
| 20 | 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. |
| 21 | 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. |
| 22 | 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. |
| 23 | 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. |
| 24 | 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. |
| 25 | 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. |
| 26 | 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. |
| 27 | 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. |
| 28 | 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. |
| 29 | 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. |
| 30 | 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. |
| 31 | 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. |
| 32 | 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. |
| 33 | 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. |
| 34 | 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. |
| 35 | 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. |
| 36 | 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. |
| 37 | 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. |
| 38 | 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. |
| 39 | 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.
Y/N Table Edit Default Value: N |