SETIDSHIFT1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: N
SHIFT_TBL(SQL Table) |
Index Back |
|---|---|
Shift CodesDefines a shift and any associated differentials that affect earnings. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SHIFT |
Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | EMPL_SHIFT_DIFF | Character(1) | VARCHAR2(1) NOT NULL |
Employee Shift Differential?
Y/N Table Edit Default Value: N |
| 8 | SHIFT_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Shift Differential Rate |
| 9 | SHIFT_FACTOR | Number(5,3) | DECIMAL(4,3) NOT NULL | Shift Differential Factor |
| 10 | TIME_IN_HR | Number(2,0) | SMALLINT NOT NULL | Time In Hour |
| 11 | TIME_IN_MIN | Number(2,0) | SMALLINT NOT NULL | Time In Minute |
| 12 | TIME_OUT_HR | Number(2,0) | SMALLINT NOT NULL | Time Out Hour |
| 13 | TIME_OUT_MIN | Number(2,0) | SMALLINT NOT NULL | Time Out Minute |