A
Address(expC,expL,expL)
Data Format Returned: X
Returns a formatted address string from individual address elements.
Parameters
Variable | Status | Description |
---|---|---|
expC | Optional | Alias name containing address element fields. If no alias name is specified, the currently selected alias is assumed. |
expL | Optional | If
true (.T. ), formatted address is returned
on a single line. If false (.F. ), formatted
address is returned on multiple lines. If not passed, multiple lines is
assumed. |
expL | Optional | Applies
only if single-line format is selected (i.e. .T.
is passed as the second parameter). If the third parameter is true (.T. ), city, state and zip are always included in
the address string. If false (.F. or not
specified), city, state and zip are only included if they are different
from the default city, state and zip for this workstation. |
Assumes all relevant address fields have been added to query.
Address()
returns the full address for
the selected fields.
108 Third St. Des Moines, IA 50309.
Address(.t.)
returns just the street information.
108 Third St.
Address(.t.,.F.)
would return just the
address unless, the city state and zip are different than the default
station listed in your Station Lookup.
Age(expD1,expD2,expN)
Data Format Returned: X
Calculates a persons age based on a birth date and comparison date. Returns age as a decimal number (age in whole years + decimal value of fractional years since last birthday), a whole number representing the elapsed months since the last birthday, or an integer value representing current age in whole years.
Parameters
Variable | Status | Description |
---|---|---|
expD1 | Required | The person's date of birth. |
expD2 | Optional | The date to calculate the age to. If not passed, current system date is assumed. |
expN | Optional | An integer value that dictates the value to return. 0 (or not passed) = return decimal value, 1=return months elapsed since last birthday, 2=return integer value of age in years. |
Age(Ptnt_age.Dob)
returns the
age of a patient through the system date in decimal format.
Age(Ptnt_age.Dob,,2
) returns the age through
the system date as an integer
Age(Ptnt_age.Dob,{^1990/01/01})
returns
the age of the patient on the date specified in decimal format.
Age(Ptnt_age.Dob,{^1990/01/01},2)
returns
the age of a patient on the date specified as an integer.
Age(Ems Ptnt_age.Dob,,1)
returns the number
of months until the person’s next birthday in decimal format.
ALLTRIM(expC)
Removes leading and trailing blanks from the specified character expression and returns the trimmed expression as a character string.
Returns: Character
ALLTRIM( )
can be used to ensure that
blanks are removed from data entered by a user.
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | Specifies the character expression from which leading and trailing blanks are removed. |
ArsonInvlData(expC1,expC2,expC3)
Data Format Returned: X
Formats arson lead/involvement information for viewing based on currently logged in user security, by masking alpha and numeric characters in a result expression with a specified character. This will prevent unauthorized view of arson involvement information by users who are not allowed to view personal information for reports other than the ones he/she has entered.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The involvement ID of the lead/involvement
record to check. This corresponds to the SUSP_ID
field from the INC_ASUB record. |
expC2 | Required | The
expression to return. This must evaluate to a valid character expression.
If the expression uses fields in an alias other than the currently selected
alias, those fields must be not. The
character used to mask alpha and numeric characters in result expression
from expC2. If no character
is specified, an asterisk (*) is used. ed in the ALIAS.FIELDNAME
format. |
expC3 | Optional | The character used to mask alpha and numeric characters in result expression from expC2. If no character is specified, an asterisk (*) is used. |
ArsonInvlData(Arson_suspect.Susp_id,'Arson_suspect.Last',)
returns the last name as *****
if
the user printing the report does not have security rights to view that
information. If
the user has the appropriate rights, then the return is the last name
of the arson suspect.
ArsonInvlData(Arson_suspect.Susp_id,Arson_suspect.Ssn,#)
this would
return ###-##-####
if the user printing the report does not have security
rights to view that information. If
the user has the appropriate rights, then the return is the last name
of the arson suspect.
ArsonInvlViewable(expC1)
Data Format Returned: X
Determines if information for an arson investigative lead/involvement record is viewable by the currently logged in user. This function can be used to prevent unauthorized view of arson lead/involvement information by users who are not allowed to view personal information for reports other than the ones he/she has entered.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The involvement ID of the patient record
to check. This corresponds to the SUSP_ID
field from the INC_ASUB record. |
AttendanceStatus(expN)
Data Format Returned: X
Returns the character description of the attendance status value passed as follows.
- 1 = Scheduled
- 2 = Attended
- 3 = Unexcused Absence
- 4 = Excused Absence
Parameters
Variable | Status | Description |
---|---|---|
expN | Required | The numeric value of the attendance status. Typically this would be the Attended field in activity or training detail. |
Available(expC1,expD,expC2,expC3,expC4,expC5,expL)
Data Format Returned: X
Determines if a staff member is marked as available based on a date, time, station, shift and unit value passed. Determination is made based on records found in staff availability.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The ID of the staff member to determine availability status for. |
expD | Required | The date to check availability for. |
expC2 | Required | The time to check availability for. |
expC3 | Optional | The station to check availability for. If not passed, this parameter is ignored in the check. |
expC4 | Optional | The shift to check availability for. If not passed, this parameter is ignored in the check. |
expC5 | Optional | The unit to check availability for. If not passed, this parameter is ignored in the check. |
expL | Optional |
If
passed as true ( |
AvgElapsed(expC1,expC2,expC3,expN,expC4)
Data Format Returned: X
Returns the total average elapsed time between two sets of date/time fields in a table or query alias. Only includes records where a valid date/time value can be determined for an upper and lower value.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Alias name or table name to retrieve records from. Must be the name of an alias in use or a physical table name. |
expC2 | Required |
The prefix of the fields for low date and time. Valid options are as follows.
|
expC3 | Required | The prefix of the fields for the upper date and time. Valid options are the same as for expC2 |
expN | Optional |
Determines the format of the return value. Options are as follows.
If not passed, 4 is assumed. |
expC4 | Optional | If passed, must be a valid expression which can be used to qualify records. If passed, only those records where this expression evaluates to true are included in the results calculation. |