All Tables View

job_id :

plan_id :

plan_line_item_id :

client_id :

Client Code :

Client Name :

campaign_type_id :

campaign_action_id :

Campaign Type :

Campaign Action :

job_description :

internal_notes :

budgeted_hours :

billable_rate :

agency_hours_cost :

vendor_cost :

Total :

Date Created :

due_date :

task_owner_staff_id :

task_owner_name :

job_status :

billable :

sort_order :

is_active :

job_id	plan_id	plan_line_item_id	client_id	Client Code	Client Name	campaign_type_id	campaign_action_id	Campaign Type	Campaign Action	job_description	internal_notes	budgeted_hours	billable_rate	agency_hours_cost	vendor_cost	Total	Date Created	due_date	task_owner_staff_id	task_owner_name	job_status	billable	sort_order	is_active
1	1		3	26-0111	Snead Eye	2	6	MCM-1: Website Marketing	MCM-F: Web Management	Temporary seed row for wpDataTables setup.	Can be deleted later.	1.00	150.00	150.00	1,250.00	1,400.00	04/22/2026 07:11 PM	05/01/2026	1	RT	Not Started	Yes	0	0
10	3	1	3	26-0111	Snead Eye	1	6	TEST-TYPE: Test Campaign Type	MCM-F: Web Management	Web Management - Maintain service availability.		1.00	150.00	150.00	0.00	150.00	04/23/2026 03:30 PM	05/01/2026			Not Started	Yes	0	1
job_id	plan_id	plan_line_item_id	client_id	Client Code	Client Name	campaign_type_id	campaign_action_id	Campaign Type	Campaign Action	job_description	internal_notes	budgeted_hours	billable_rate	agency_hours_cost	vendor_cost	Total	Date Created	due_date	task_owner_staff_id	task_owner_name	job_status	billable	sort_order	is_active

staff_id	staff_code	first_name	last_name	display_name	email	status	date_created
1	STF-001	Jane	Smith	Jane Smith	jane@example.com	Active	04/22/2026 04:41 PM
2	RT	Ryan	Toohey	Ryan Toohey		Active	04/22/2026 05:22 PM
3	DC	DC	User	DC		Active	04/22/2026 05:22 PM
4	EQ	EQ	User	EQ		Active	04/22/2026 05:22 PM
5	NB	NB	User	NB		Active	04/22/2026 05:22 PM
6	SB	SB	User	SB		Active	04/22/2026 05:22 PM
staff_id	staff_code	first_name	last_name	display_name	email	status	date_created

campaign_action_id	campaign_action_code	campaign_action_name	status	sort_order
1	MCM-A	Campaign Action Plan	Active	1
2	MCM-B	Copywriting	Active	2
3	MCM-C	Graphic Design	Active	3
4	MCM-D	Creative Production	Active	4
5	MCM-E	Campaign Execution	Active	5
6	MCM-F	Web Management	Active	6
7	MCM-G	Web SEO Technical	Active	7
8	MCM-H	Web SEO Content	Active	8
9	MCM-I	Web Design & Dev.	Active	9
10	ROI-A	Weekly Results Tracking & Analysis	Active	10
campaign_action_id	campaign_action_code	campaign_action_name	status	sort_order

campaign_type_id	campaign_type_code	campaign_type_name	status	sort_order
1	TEST-TYPE	Test Campaign Type	Active	0
2	MCM-1	Website Marketing	Active	1
3	MCM-2	PPC Marketing	Active	2
4	MCM-3	eMail Marketing	Active	3
5	MCM-5	Digital Media (CPM)	Active	5
6	MCM-6	TV Advertising	Active	6
7	MCM-11	Collateral	Active	11
campaign_type_id	campaign_type_code	campaign_type_name	status	sort_order

client_id	client_code	client_name	default_billable_rate	status
1	TEST-001	Test Client	100.00	Active
2	26-0000	Temporary	150.00	Active
3	26-0111	Snead Eye	150.00	Active
4	26-0222	CHC	150.00	Active
5	26-0333	Mario’s	125.00	Active
6	26-0555	CII	125.00	Active
7	26-0666	Stilwell Rest.	125.00	Active
8	26-0777	PCT	35.00	Active
client_id	client_code	client_name	default_billable_rate	status

plan_id	client_id	plan_name	plan_month	plan_year	plan_type	billable_rate_override	plan_status	billing_status	date_created	date_approved	invoice_date	created_by_user_id	approved_by	approval_pdf	notes
1	1	Trigger Test Plan	4	2,026	Monthly Marketing Plan		Draft	Unbilled	04/22/2026 04:41 PM						Test plan for trigger check
2	3	Snead May 2026 Marketing Plan	5	2,026	Monthly Marketing Plan		Draft	Unbilled	04/22/2026 07:07 PM						Temporary plan to seed jobs table
3	3	Snead May 2026 Marketing Plan	5	2,026	Monthly Marketing Plan		Draft	Unbilled	04/23/2026 03:21 PM						Test plan
plan_id	client_id	plan_name	plan_month	plan_year	plan_type	billable_rate_override	plan_status	billing_status	date_created	date_approved	invoice_date	created_by_user_id	approved_by	approval_pdf	notes

Jobs