C
CalcTime(expD1,expC1,expD2,expC2)
Data Format Returned: X
Returns the amount of time elapsed between two date/time values as a
formatted time string (HH:MM:SS
).
Parameters
Variable | Status | Description |
---|---|---|
expD1 | Required | Beginning date. |
expC1 | Required | Beginning
time in the format HH:MM:SS . |
expD2 | Optional | Ending date. If not passed, current system date is assumed. |
expC2 | Optional | Ending time in the format HH:MM:SS. If not passed, current system time is assumed. |
CalcTime({^2002/01/01},'08:00',{^2002/01/03},'08:00')
returns 48:00
, that is the amount of time that passes between the two times
and dates.
CalcTime(Average_resp.Alm_date,Average_resp.Alm_time,Average_resp.Arv_date,Average_resp.Arv_time)
returns
time that has passed between alarm time and arrival time.
CategoryDescript(expC)
Data Format Returned: X
Returns the description for a lookup category.
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | Category name for which to return description. |
CategoryDescript(VITA REFF)
returns the
description for the code category in parentheses. Above
example would return “Respiratory Effort\Quality”.
CDOW(expD\expDT)
Displays the character
day of week name for a date field, such as Monday, Tuesday, Wednesday, and so forth. CDOW( )
can be used to group data by day of week for statistical reporting.
Returns: Character
CDOW( )
can be used to group data
by day of week for statistical reporting.
Parameters
Variable | Description |
---|---|
expD | Specifies the date expression from which the day of week is returned. |
expDT | Specifies the datetime from which CDOW( ) returns the day. |
CategoryDescript(VITA REFF)
returns the
description for the code category in parentheses. Above
example would return “Respiratory Effort\Quality”.
CEILING
rounds a positive number with a fractional
portion up to the next highest integer value, and rounds a negative number
with a fractional portion up to its integer value.
Data Format Returned: N
CMonth(expD)
Displays the character day of month name for a date field (e.g. January, February, March, and so forth).
Returns: Character
Parameters
Variable | Description |
---|---|
expD | Specifies the date expression from which the month name returned. |
CodeDescript(expC1,expC2)
Data Format Returned: X
Returns the description of a lookup code in a specified lookup category.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Category name in which code resides. |
expC2 | Required | Code for which to return description. |
CodeDescript('EMS PROC',Ems_procedures _code.Code)
returns the description for the procedure code that is affiliated with
the actual procedure code that the report is returning. This
returns just the description.
trim(Ems_procedures _code.Code)+' '+CodeDescript('EMS
PROC',Ems_procedures _code.Code)
returns both the code and the
description, and puts only one space between code and description.
The return would look like below:
12 EKG Monitoring
CodeList(expC1,expC2,expC3,expN1,expN2)
Data Format Returned: X
Returns a mult-line list of code/description value pairs for a code table which contains multiple code selections linked to a master parent record. Example is actions taken for an incident.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Alias name or table name containing code/description pairs. |
expC2 | Required if expC1 is a table, optional if expC1 is an alias | Specifies the ID that is used to query records in the code table |
expC3 | Optional | Code/Description expression to return. A separate value is evaluated and returned for each code record. If not passed, CODE + DESCRIPTION is assumed.
|
expN1 | Optional | Maximum number of code/description pair records to report. If not passed, all records are assumed. |
expN2 | Optional | Maximum number of characters to return per line of the list. Use to prevent line wrapping. |
ContactName(expC)
Data Format Returned: X
Returns a formatted name for a contact, such as an occupancy, staff member, hydrant or vendor contact.
Parameters
Variable | Status | Description |
---|---|---|
expC | Optional | Name of alias containing contact name fields. If not passed currently selected alias is assumed. |
CreatedBy(expC1,expC2)
Data Format Returned: X
Returns the name of the user who created a specific record in a specific table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
CreatedBy('Inc_main',Inc_main.Inci_id)
returns the name of the user who created a fire incident.
CreatedDateTime(expC1,expC2)
Data Format Returned: X
Returns the date and time of the creation of a specific record in a specific table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
CreatedWks(expC1,expC2)
Data Format Returned: X
Returns the workstation where a specific record in a specific table was created.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of the table in which the record resides. This must be a literal table name and not the name of an alias or view. |
expC2 | Required | The key value of the record to return information for. This must be a primary key value. |
CurrentShiftCode(expT1,expC1)
Data Format Returned: X
Returns the shift code from the current shift. By default, the current shift is determined by the system date/time and the schedule id set in workstation options. If multiple shifts are on duty at the time, the most common non-blank shift code will be returned. If there is no most common code, one of the non-blank shift codes will be selected randomly.
Parameters
Variable | Status | Description |
---|---|---|
expT1 | Optional | The date/time to calculate the current shift for. Defaults to datetime() .
|
expC1 | Optional | The schedule to calculate the current shift for. Defaults to the schedule set in workstation options. |
CurrentStaff(expC1,expT1,expC2)
Returns a list of staff currently on duty, one per line. By default, the current staff is determined by the system date/time and the schedule id set in workstation options. You may also override the expression that determines how the staff line items are formatted.
Note: For columns to show up correctly, a non-proportional font must be used.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Optional | Expression to return for each staff member.
Defaults to STAFF_ID + StaffName() .
|
expT1 | Optional | The date/time to calculate the current shift for. Defaults to datetime() .
|
expC2 | Optional | The schedule to calculate the current shift for. Defaults to the schedule set in workstation options. |
CurrHrs(expC1,expN1,expC2,expD1,expD2,expN2)
Data Format Returned: X
Returns the number of credit hours, points or hours paid for a specified staff member toward a specified training program requirement code.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The staff ID number of the person you want to return credit hours for. |
expN1 | Required |
Use to indicate whether the requirement is a training or activity requirement.
|
expC2 | Required | The training or activity code that you want to return the value for. If the value of expN is 1, this must be a valid training category code. If 2, this value must be a valid activity code. |
expD1 | Optional | If passed, credit hours will be summed from this date forward. If not passed, all credit hours up to expD2 will be returned. |
expD2 | Optional | If passed, credit hours will be summed from expD1 up to this date. If not passed, all credit from expD1 up to the current system date will be returned. |
expN2 | Optional |
Indicates what value to return.
If not passed, 1 (Hours) is assumed. |
CurrHrs(Ems_procedures_code.Staff_id,2,'MX',
returns hours for each staff member from the date displayed on the report,
and the current system date for the activity code (
Ems_procedures_performed_by_procedure_code.Date,,2)‘MX’
) specified.
The
first “2
” indicates it is returning info for an activity. The
second “2
” means it will display the points to date.
CurrHrs(Training_attendence.Staff_id,1,Training_attendence.Tra_code,
Training_attendence.Date,,)