DW_NS_workCalendar_D
This table contains information about calendar which is used to determine the work days available for scheduling project tasks and assigning resources as well as working days for the employee if Time-Off Management is used.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| friday | VARCHAR2 | 16 | Friday | ||||
| isdefault | VARCHAR2 | 16 | is default | ||||
| monday | VARCHAR2 | 16 | Monday | ||||
| name | VARCHAR2 | 128 | Calendar Name | ||||
| saturday | VARCHAR2 | 16 | Saturday | ||||
| starthour | VARCHAR2 | 16 | Starthour | ||||
| sunday | VARCHAR2 | 16 | Sunday | ||||
| thursday | VARCHAR2 | 16 | Thursday | ||||
| tuesday | VARCHAR2 | 16 | Tuesday | ||||
| wednesday | VARCHAR2 | 16 | Wednesday | ||||
| workhoursperday | NUMBER | Workhoursperday |