SETIDDefault Value: RS_SHIFT_DETAIL.SETID
Prompt Table: SP_SETID_NONVW
SHIFT_IDDefault Value: RS_SHIFT_DETAIL.SHIFT_ID
SEQ_NBRRS_SHIFT_TIME(SQL Table) |
Index Back |
|---|---|
Shift Time detailsSRP/Created new Record for Shift Time details; |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: RS_SHIFT_DETAIL.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SHIFT_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Shift ID
Default Value: RS_SHIFT_DETAIL.SHIFT_ID |
| 3 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | START_MONDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 5 | END_MONDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 6 | START_TUESDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 7 | END_TUESDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 8 | START_WEDNESDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 9 | END_WEDNESDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 10 | START_THURSDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 11 | END_THURSDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 12 | START_FRIDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 13 | END_FRIDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 14 | START_SATURDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 15 | END_SATURDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 16 | START_SUNDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |
| 17 | END_SUNDAY | Time(15) | TIMESTAMP | SRP/Created new field for storing the time; |