SCH_CRITERIA_IDEFFDTDefault Value: %date
A=Create Personal Schedule
N=Select Predefined Schedule
Y=Use Default Schedule
SCH_AENRL_PREF(SQL Table) |
Index Back |
|---|---|
Sch Auto Enroll PrefSch Auto Enroll Pref |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCH_CRITERIA_ID |
Character(12) | VARCHAR2(12) NOT NULL | Enrollment Group |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | SCHEDULE_GRP | Character(10) | VARCHAR2(10) NOT NULL | Scheduling Organizational Group Code |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | 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). |
| 6 | USE_DFLT_WS | Character(1) | VARCHAR2(1) NOT NULL |
Indicator for Primary Schedule
A=Create Personal Schedule N=Select Predefined Schedule Y=Use Default Schedule |