| Schedule for X | ||||||||||
| !! | ID | Date | Time | Who | Risk | Task | Notes/Risk Factors | |||
| A | X001 | due | estimate | Me | H M L | Something to do | ||||
| actual | act | % | Detailed task description or just a
list of sub-tasks
|
|||||||
| Additional Notes | ||||||||||
| Database Queries Required | |||
| Name | Purpose | Columns and Conditions | Unknowns |
| 1)Name of query | Brief description of query purpose | Field list in layman's terms
Where Clauses in layman's terms From Tables in layman's terms |
Uncertainties about query possibilities |
|
Equivalent SQL
|
SQL Statement | ||
|
Equivalent SQL
|
|||
| Notes | |||
| Schedule Guide | |
| Completion status | |
| !! | Task completion priority A=Must Haves B=Should Haves C=Could Haves (Optional) |
| ID | Task Number for reference |
| Date | Completion date as currently scheduled |
| Actual Completion date | |
| Time | Original estimate of time to complete this task |
| Actual time worked on this task to date | |
| Percentage complete | |
| Who | Who this task is assigned to |
| Risk | Risk that this task will not finish on time High, Medium and Low |
| Task | Task Name |
| Task details or sub task list | |
| Notes | Notes and Risk Factors including what previous task this is dependent on, What risks exist that could push this task over the time limit |