RF_CALENDAR_OPT(SQL Table) |
Index Back |
|---|---|
Calendar OptionsOptions when displaying the worker's daily calendar. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | STD_DAYS | Number(4,2) | DECIMAL(3,2) NOT NULL | Standard Number of Days/Week |
| 3 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours field used in HD_360_RESPONSE_SYNC message. |
| 4 | TIME_FROM | Time(15) | TIMESTAMP | From Time |
| 5 | TIME_TO | Time(15) | TIMESTAMP | To Time |
| 6 | SUN | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Sunday
Y/N Table Edit Default Value: N |
| 7 | MON | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Monday
Y/N Table Edit Default Value: Y |
| 8 | TUES | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Tuesday.
Y/N Table Edit Default Value: Y |
| 9 | WED | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Wednesday.
Y/N Table Edit Default Value: Y |
| 10 | THURS | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Thursday.
Y/N Table Edit Default Value: Y |
| 11 | FRI | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Friday.
Y/N Table Edit Default Value: Y |
| 12 | SAT | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Saturday.
Y/N Table Edit Default Value: N |
| 13 | RS_ENABLE_WF | Character(1) | VARCHAR2(1) NOT NULL |
Used to store whether or not calendar workflow is enabled - not used.
Default Value: N |