Timesheet hour color

J

jcaruso

Does anyone know what table/column is used to determine timesheet hour color
of Red, Blue, and Black in the interface?

For example: seems that 'unaccepted' hours (pending manager approval) should
be a '1' in the MSP_WEB_ASSIGNMENTS.WASSN_ACTUALS_PENDING table.

I'm getting mixed results (blue pending and black accepted) and the data
dictionary is lacking. Any help would be appreciated.
 
V

virsharma

Find the value of MSP_WEB_GROUP_SCHEMES. WGROUP_SCHEME_ID field where
WGROUP_SCHEME_NAME =’ Timesheet’ and then use its reference key
(MSP_WEB_GROUP_SCHEMES .WGROUP_SCHEME_ID) in MSP_WEB_GROUP_SETTINGS table,
MSP_WEB_GROUP_SETTINGS.WGROUP_ROW_COLOR is for the background color for cells
that appear in the grids and MSP_WEB_GROUP_SETTINGS .WGROUP_TEXT_COLOR for
the text color for cells that appear in the grids. These columns have integer
values 1 for Black, 2 for Red etc …..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red mark and blue mark in timesheet hrs 0
Changing Timesheet Approver using the PSI 1
Project Server 2010 - Issues with Timesheet 0
Timesheet and Timesheet Lines approval statuses 2
Timesheet approver 1
Roses are blue and violets are red 0
Hrs in resources timesheet showing red and blue 3
Timesheet shows unsubmitted 1

Top