SETIDSCH_ADHOC_IND1=Common Schedule
2=Ad Hoc Primary Schedule
3=Ad Hoc Alternate Schedule
SCHEDULE_IDLANGUAGE_CDEFFDTDefault Value: %date
Default Value: SCH_DEFN_LANG.DESCR
SCH_DEFN_LANG(SQL Table) |
Index Back |
|---|---|
Related Lang Sched DefinitionSchedule Definition table maintains the Schedule Name (DESCR) as well as the date and time of the last scheduled out punch, which is for use by subsequent schedule creation runs. |
| # | 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 |
| 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: SCH_DEFN_LANG.DESCR |