Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Created By: Shannon Scoffield
Created Date/Time: 7/29/2014 5:28 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
 
Time Id: 2354
Template/Type: Other Documentation
Title/Caption: Note - Options for work in progress
Start Date: 2/25/2009
Main Status: Active

click to enlarge - photo by: Shannon Scoffield -
 
 


Notes:
Options for work in progress:
New table:
- Possible multi-feature
- Keep database smaller
- Check sub table and then filter main query by invoice numbers
- Own history page if record count >0
- Unable to run all code on 1 query
New fields on invoice table:
- Limited to a single time period
- No pre-filter – keep code in same query
- DB will grow in size – need 3 fields per invoice
- Most invoices do not even need W.I.P status
W.I.P is a special permission and is only used by certain corps