Service Booking Schema July 24

	A	B	C	D	E	F
1	Field Label	API Name	Type	Help Text	Formula	Attributes
2	Active Booking	maica_cc__Active_Booking__c	Formula (Checkbox)	Indicates that this is the active Service Booking record for the Participant.	AND( TODAY()>= maica_cc__Start_Date__c, TODAY()<= maica_cc__End_Date__c, ISPICKVAL(maica_cc__Status__c, "APPR") )	Required
3	Booking Type	maica_cc__Booking_Type__c	Picklist (Plan Managed; Standard Booking)
4	Budget Status	maica_cc__Budget_Status__c	Formula (Text)		IMAGE( IF( maica_cc__Total_Remaining__c < 0, "/resource/maica__Vertic_Images/cancel.png", IF(maica_cc__Total_Allocated__c = maica_cc__Total_Expenditure__c, "/resource/maica__Vertic_Images/checked.png", "/resource/maica__Vertic_Images/checked.png" ) ), "") + IF( maica_cc__Total_Remaining__c < 0, ' - Over Budget', IF(maica_cc__Total_Allocated__c = maica_cc__Total_Expenditure__c, ' - Budget Completed', ' - Under Budget') )
5	Created By ID	CreatedById	Lookup (User)			Required
6	Created Date	CreatedDate	Datetime			Required
7	Days into Funding	maica_cc__Days_into_Funding__c	Formula (Double)	The number of days into the current Funding period	today() - maica_cc__Start_Date__c
8	Deleted	IsDeleted	Checkbox			Required
9	End Date	maica_cc__End_Date__c	Date
10	Funding	maica_cc__Funding__c	Lookup (Maica_Cc__Funding__C)
11	Funding Period Progress	maica_cc__Funding_Period_Progress__c	Formula (Percent)	Indicates the percentage of completion for the current Funding period	MAX(0, MIN(100, IF( maica_cc__Start_Date__c > TODAY() ,0,IF(maica_cc__End_Date__c < TODAY(),1, (TODAY() - maica_cc__Start_Date__c) / (maica_cc__End_Date__c - maica_cc__Start_Date__c)) )))
12	Funding Period Remaining	maica_cc__Funding_Period_Remaining__c	Formula (Percent)	The percentage of time remaining in the Funding Period	MIN(1, MAX(0, (1- ((maica_cc__End_Date__c - maica_cc__Start_Date__c)-(maica_cc__End_Date__c - TODAY()))/(maica_cc__End_Date__c - maica_cc__Start_Date__c))))
13	Last Activity Date	LastActivityDate	Date
14	Last Modified By ID	LastModifiedById	Lookup (User)			Required
15	Last Modified Date	LastModifiedDate	Datetime			Required
16	Last NDIS Sync	maica_cc__Last_NDIS_Sync__c	Datetime
17	Last Referenced Date	LastReferencedDate	Datetime
18	Last Viewed Date	LastViewedDate	Datetime
19	NDIS Reference	maica_cc__NDIS_Reference__c	Text (100)			Unique, External ID, Case Sensitive
20	Participant	maica_cc__Participant__c	Lookup (Contact)			Required
21	Provider Comments	maica_cc__Provider_Comments__c	Textarea (255)
22	Record ID	Id	Id (18)			Required
23	Rejection Notes	maica_cc__Rejection_Notes__c	Text (255)
24	Rejection Reason	maica_cc__Rejection_Reason__c	Picklist (Change is not acceptable per agreement; No capacity to fulfil; Not enough funding committed; Service not available; Other)
25	Revised End Date	maica_cc__Revised_End_Date__c	Date
26	Service Booking ID	Name	Text (80)			Required
27	Start Date	maica_cc__Start_Date__c	Date
28	Status	maica_cc__Status__c	Picklist (In Process; Awaiting Participant Approval; Awaiting Provider Approval; Change Awaiting Participant; Change Awaiting Provider; Rejected; Approved; Completed; Deleted)
29	System Modstamp	SystemModstamp	Datetime			Required
30	Total Allocated	maica_cc__Total_Allocated__c	Formula (Currency)
31	Total Expenditure	maica_cc__Total_Expenditure__c	Formula (Currency)		maica_cc__Total_Allocated__c - maica_cc__Total_Remaining__c
32	Total Remaining	maica_cc__Total_Remaining__c	Formula (Currency)
33	Utilisation	maica_cc__Utilisation__c	Formula (Percent)		maica_cc__Total_Expenditure__c / maica_cc__Total_Allocated__c
34	Utilisation Remaining	maica_cc__Utilisation_Remaining__c	Formula (Percent)		maica_cc__Total_Remaining__c / maica_cc__Total_Allocated__c
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100