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

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    

Copyright © 2019, 2026, Oracle and/or its affiliates.