Additional Information |
  
|
Additional Information |
|
BRACKETED FIELDS: "Bracketed Fields" is the name of the technique used in ChartNet to merge patient demographic and other database fields into the header, body, footer, or page footer sections of a report is called Bracketed Fields. Bracketed fields get replaced by the database field that they represent at print time. There are two syntaxes used when specifying bracketed fields, "single" and "double".
Here are some examples of bracketed fields:
[r.acctno) - inserts the account number
[r.dict_date) - inserts the dictation date
[r.trans_date) - inserts the transcription date
[r.doctor) - inserts the dictating doctor's code
[r.doctor.d.docname) - inserts the dictating doctor's name
[u.120_ssn) - inserts the patient's social security number 'user-defined field'
[x.age) - inserts the patient's age
Single Bracketed Fields: Single bracketed fields are used to retrieve a value from a single table. For example "'R.DOCTOR' would be single bracketed field and would retrieve just the dictating provider's code.
Single bracketed fields have the syntax ''table code'.'field name':'optional format code''
Double Bracketed Fields: Double bracketed fields are used to get field's value from one table, then go to another table to get the value of another field. For example, "'R.DOCTOR.D.DOCNAME ' would be a double bracketed field and would retrieve the doctor's code from the Reports table, then go out and retrieve the doctor's name from the Provider's table.
Double bracketed fields have the syntax [table code1].[field name1].[table code2].[field name2]:[optional format code]
Table Codes: Bracketed fields 'both single and double' are made up of a "table code", followed by a period '"."', followed by a field name. The following is a list of valid table codes:
R Reports table
F Forms table
A Address table
M MPI table
O Orders table
S Sites table
G Value Lookup List
U User-defined field
E Users table
X Special field
Bracketed field when using a Value Lookup List: Examples of fields using a Value Lookup List are below.
[R.USER1.G.LOCATION) - Will use the value entered in the USER1 field on the RDS to display the value from the description field in the Location Value Lookup List.
[R.USER1.G.LOCATION.EXTRA1) Will use the value entered in the USER1 field on the RDS to display the value from the Extra 1 field in the Location Value Lookup List.
Controlling the Length of the Bracketed Field: The bracketed field needs to be large enough to hold the maximum length of the field being inserted. For example, if the account number is 10 digits, then the total length of the bracketed field must be at least 10 characters 'brackets included'. If the merged field is actually less than the bracketed field width, then spaces will be appended to pad the field out to the width of the bracketed field. If the merged field is longer than the bracketed field width, then the field will be truncated.
Terminating Characters: The following characters can be used to terminate bracketed fields:
"]'" Right bracket. Will cause blanks to be appended to the merged data in order to pad out the field to the width of the bracketed field.
For example, "['R.PTNAME ]'" will result in "SMITH, JOHN ". (i.e. Blanks not trimmed from the name). Note that the total length of the bracketed field, including the brackets, is 20. This means that the name that is merged in will have a length of 20.
")'" Right parenthesis. Will trim trailing blanks from the data field before it is merged in.
For example, "['R.PTNAME )'" will result in "SMITH, JOHN". (i.e. blanks trimmed from name). Use this terminating character when you have multiple bracketed fields on one line, right next to each other, and you do not want large blank spaces in between them.
"}'" Right curly brace. Will cause a line that contains the bracketed field to be physically removed from the report if the merged data field is blank and the bracketed field is the only text on the line. If the merged data is not blank, then the right curly brace acts like the right bracket.
Special Bracketed Fields (X.):
Patient Age - X.AGE
Page Number - X.PAGE
Total Pages - X.TOTPAGES
Copy To - X.COPY
System Date - X.DATE
System Time - X.TIME
Dictated By - X.DICTATED_BY
Attending - X.ATTENDING
Dictating - X.DICTATING
Dictating2 - X.DICTATING2
Dictating Line - X.DICTATING_LINE
Signed By - X.SIGNEDBY
Unsigned - X.UNSIGNED
ChartScript Trans Date - X.TRANS1
Letter/Envelope/CC Name X.NAMEADDR1
Letter/Envelope/CC Address Line 1 X.NAMEADDR2
Letter/Envelope/CC Address Line 2 X.NAMEADDR3
Letter/Envelope/CC Address Line 3 X.NAMEADDR4
Letter/Envelope/CC Address Line 4 X.NAMEADDR5
Letter/Envelope/CC Address Line 5 X.NAMEADDR6
Special bracketed field for CC's:
Bracketed Field Description
X.ALL_CC_NAMES - Prints each cc: name on a separate line
Example:
William P. Smith, M.D.
David S. Jones, M.D.
X.ALL_CC_NAMES2 - Prints all cc: names on one line, separated by a slash character
Example:
William P. Smith, M.D. / David S. Jones, M.D.
X.ALL_CC_ADDRESSES - Prints cc: names and their addresses on separate lines
Example:
William P. Smith, M.D.
1234 Main St.
Hudson, Ohio 44236
David S. Jones, M.D.
78873 S. Broadway Blvd
Twinsburg, Ohio 44234
X.ALL_CC_ADDRESSES2 - Prints each cc: name and address on one line
Example:
William P. Smith, M.D. '1234 Main St., Hudson, Ohio 44236'
David S. Jones, M.D. '78873 S. Broadway Blvd, Twinsburg, Ohio 44234'
X.ALL_CC_ADDRESSES3 - Prints each cc: name and address on one line. If the cc: was sent via Fax or Email, then the text "'FAX'" or "'Email'" will appear next to the cc: name. If the cc: is to be sent via printed copy, then the cc: address will be printed.
Example:
William P. Smith, M.D. 'FAX'
David S. Jones, M.D. '78873 S. Broadway Blvd, Twinsburg, Ohio 44234'
Formatting Codes: Bracketed fields can also contain formatting codes to take care of special formatting requirements. For example, to print a patient name in "First Last" format with proper case, add a colon followed by "N2" to the end of the R.PTNAME field as shown below.
[r.ptname:n2) - will format the patient name "SMITH, JOHN W." to "JOHN W. SMITH"
Normally, data that is merged into a report using the "bracketed field" technique will be formatted according to how the data is stored in the database. You can have ChartNet print the data in a different format by appending a "format code" to the end of the field name in the bracketed field. For example, to have the visit date of "06/20/2004" print out as "June 20, 2004", you would use "'R.VISITDT:D2'", where the ":D2" is the format code. Note that all format codes must be preceded with a colon '":"'.
List of format codes:
Medical Record Number
M1 xx xx xx
M2 xx-xx-xx-xx-x
DATES
DB - dd/mm/yyyy
D1 - yyyymmdd
D2 - June 9, 2001
D2B - 9 June, 2001
D3 - mm/dd/yy
D3B - dd/mm/yy
D4 - strip out "/" if blank date
D5 - yyyy mm dd
D6 - mmddyy
D6B - ddmmyy
D7 - Tue December 31, 2002
D7B - Tue 31 December, 2002
D8 - mm-dd-yy
D8B - dd-mm-yy
D9 - yyyy-mm-dd
D10 - yymmdd
TIMES
T1 - hh mm 'a or p'
T2 - hhmm 'a or p'
T3 - hhmm 'military'
T4 - hh mm 'military'
T5 - hh:mm 'military'
PATIENT NAMES
N1 - ChartScript format
N2 - First MI Last (proper case)
N3 - FIRST MI LAST (upper case)
N4 - LAST FIRST MI (HL7 format)
N5 - LASTNAME
N6 - FIRSTNAME
N7 - LASTNAME (proper case)
N8 - FIRSTNAME (proper case)
N9 - Initials
NI - Patient name: Middle initial
PROVIDER NAMES
P1 - LAST, FIRST M, TITLE (uppercase)
P2 - Last, First M, TITLE (proper case)
P3 - Last name (proper case)
P4 - Initials
P5 - Append provider code
OTHER
PC - convert to proper case (if all uppercase)
UC - convert to upper case
LC - convert to lower case
PC1 - convert to proper case
Ln - returns the left-most n characters
Rn - returns the right-most n characters
ZFn - zero-fills the value to length n
RCxy - replace characters. x is the old characters; y is the new character
Sxxx - strip out characters. xxx is the string of 1-3 characters to strip out.
SA - strip out all alpha characters leaving only numerics
RZ - remove leading zeros
S1 - used with x.signatures. Will create lines to sign on.
S2 - same as S1, but will not put provider names in proper case
Fnd - Get a sub-field from a delimited field. n=field# d=delimiter character