How To Review Which Timesheet Populate Options Are Set

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Which table/options can be queried to assist in finding out from the database, what are the current timesheet options are set to in 
Classic UI > Administration > Project Management > Timesheet Options > Default Time Entry Options
?

Populate Time Range x days before time period start (default = 7) x days after time period end (default = 7)	NKT.TB.TA_RANGE_START NKT.TB.TA_RANGE_FINISH
RequiredUser Value 1 Lookup	NKT.GEN.LOOKUP_4_USER_VALUE1
Populate assigned tasks	NKT.GEN.AUTOPOPULATE
Copy time entries from previous timesheet    Include actuals from previous timesheet (except for incidents)	NKT.GEN.AUTOPOPULATE_TASKS NKT.GEN.AUTOPOPULATE_VALUES
Display Unit	NKT.GEN.DISPLAY_HOURLY
Decimal Places	NKT.Cust.PRECISION
Enable Note Date	NKT.GEN.ENABLE_NOTE_DATE
Allow posting of future timesheets	PRJ_POST_FUTURE_TIMESHEETS
Allow entry of line item total	NKT.GEN.POST_LINEITEM_TOTALS
Display time attestation message on submit	NKT.GEN.DISPLAY_ATTESTN_MSG
Allow end user column configuration	NKT.GEN.USER_COL_CONFIG
Display Effort Gauge	NKT.GEN.EFFORT_GAUGE

 

Resolution

For example, the following can be used:

SELECT
V.VALUE, o.OPTION_CODE
FROM    
CMN_OPTION_VALUES V , 
CMN_OPTIONS O
WHERE V.OPTION_ID = O.ID
AND O.OPTION_CODE IN 
('NKT.GEN.AUTOPOPULATE',
'NKT.GEN.AUTOPOPULATE_TASKS',
'NKT.GEN.AUTOPOPULATE_VALUES')