SCH_DFN_TBL_BRA(SQL Table) |
Index Back |
|---|---|
Schedule Definition TableSchedule Definition table Bra maintains the additional Info for GP Brazil Schedule |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_TL_01 |
| 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 | SHIFT_TYPE_BRA | Character(2) | VARCHAR2(2) NOT NULL |
Work Shift Brazil
00=Regular 01=Scale of Work 12x36 02=Scale of Work 24x72 03=Rotating Shift 04=Regular Sunday Off 05=Regular Except Sunday Off 06=Regular Periodic Sunday Off 07=Uninterrupted Rotation Shift 99=Others |
| 6 | SHIFT_TYPE_DTL_BRA | Character(100) | VARCHAR2(100) NOT NULL | Shift Type Detail Brazil |