SETIDSCH_ADHOC_IND1=Common Schedule
2=Ad Hoc Primary Schedule
3=Ad Hoc Alternate Schedule
Default Value: 1
SCHEDULE_IDEFFDTDefault Value: %date
I=Invalid
N=Not Validated
V=Valid
Default Value: N
SCH_WRK_SHF_CHG(SQL Table) |
Index Back |
|---|---|
Wrkd day & Shft ChangesThis table is populated when there are changes to Workday and Shift Definitions which have been already used in building the Schedule Calendar as of date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SCH_ADHOC_IND |
Character(1) | VARCHAR2(1) NOT NULL |
This field is used on Schedule Definitions to indicate if a Schedule is Ad Hoc (i.e. belonging to a specific employee) or Common (used by many employees)
1=Common Schedule 2=Ad Hoc Primary Schedule 3=Ad Hoc Alternate Schedule Default Value: 1 |
| 3 | SCHEDULE_ID |
Character(16) | VARCHAR2(16) NOT NULL | The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition). |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | SCH_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of Scedule definition. Indicates if the Schedule has been validated, and if it has, whether it is valid.
I=Invalid N=Not Validated V=Valid Default Value: N |