SETID_SCHEDSCH_ADHOC_IND_ALT1=Common Schedule
2=Ad Hoc Primary Schedule
3=Ad Hoc Alternate Schedule
ALT_WRK_SCHED_IDLANGUAGE_CDEFFDTDefault Value: %date
Default Value: SCH_DEFN_LANG.DESCR
SCH_DEFN_VW_LNG(SQL View) |
Index Back |
|---|---|
Related Lang Sched DefinitionView of ScheduleDefinition table language record for use with SCH_DEFN_VW - Alternate Schedules view. |
| SELECT SETID , SCH_ADHOC_IND , SCHEDULE_ID , LANGUAGE_CD , EFFDT , DESCR , DESCRSHORT FROM PS_SCH_DEFN_LANG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_SCHED |
Character(5) | VARCHAR2(5) NOT NULL | SetID for Schedule ID |
| 2 | SCH_ADHOC_IND_ALT |
Character(1) | VARCHAR2(1) NOT NULL |
This field is used on Schedule Definitions to indicate if the Alternate 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 | ALT_WRK_SCHED_ID |
Character(16) | VARCHAR2(16) NOT NULL | TR Alternate Schedule ID |
| 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 |