The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

'null' reason code in kdrv_calendar_exceptions, (Mercury 6.0)

Highlighted
Alexei Malinovs
Regular Collector

'null' reason code in kdrv_calendar_exceptions, (Mercury 6.0)

Hello all,

In kdrv_calendar_exceptions table stored days marked by resource in his/her resource calendar as non working and working days. There is column in the table called REASON_CODE.

REASON_CODE can have following 3 values:
1. Empty - when no reason is specified
2. One of the reason codes available for the resource
3. 'null'

Question:
What does this 'null' string (it is not NULL field, it is 'null' string) means. It is not official reason code. The only logic I found that it apears only if you do not specify the reason code but in very seldom cases. In most of the cases REASON_CODE just kept empty.

Anyone have an explanation?

//Add this to "OnDomLoad" event