SCH_MNG_OPTIONS(SQL Table) |
Index Back |
|---|---|
Schedule Options for ManagersThis page is used for selecting the schedule options used by managers |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | MAX_DISPLAY_ROWS | Number(2,0) | SMALLINT NOT NULL | Max rows displayed in a pagelet |
| 3 | DEFAULT_DISPLAY | Character(2) | VARCHAR2(2) NOT NULL |
Page Display on the Manage Schedules Page
D=Day T=Date Range W=Week Default Value: W |
| 4 | SCH_DAYOF_WEEK | Character(1) | VARCHAR2(1) NOT NULL |
Used to display the days in the week
1=1- Monday 2=2- Tuesday 3=3- Wednesday 4=4- Thursday 5=5- Friday 6=6- Saturday 7=7- Sunday |
| 5 | TRN_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Training Selection
Y/N Table Edit Default Value: Y |
| 6 | ABS_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Absence Icon selected
Y/N Table Edit Default Value: Y |
| 7 | HOL_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Holiday Selection
Y/N Table Edit Default Value: Y |
| 8 | NOSHOW_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
No Shows
Y/N Table Edit Default Value: Y |
| 9 | SHIFT_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Shift Selection
Y/N Table Edit |
| 10 | TIME_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Time Selection
Y/N Table Edit |
| 11 | HOURS_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Hours Selection
Y/N Table Edit |
| 12 | TASKDATA_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Task data Selection
Y/N Table Edit |
| 13 | TR_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporting
Y/N Table Edit |
| 14 | SCH_TR_DATA | Character(30) | VARCHAR2(30) NOT NULL |
Task Reporting Data
Prompt Table: SCH_MNG_TR_DATA |
| 15 | SCH_TASK_DATA | Character(30) | VARCHAR2(30) NOT NULL |
Task Data
Prompt Table: SCH_MNG_TD_DATA |
| 16 | SCH_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 17 | SCH_END_TIME | Time(15) | TIMESTAMP | End Time |