|
Introduction
"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 Generic dictionary table
U User-defined field
E Users table
X Special field
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. |
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"
Report Table Fields
| Admitting Doctor Code | R.ADMDR |
| Admitting Doctor Name | R.ADMDR.D.DOCNAME |
| Attending Doctor Code | R.ATTDR |
| Attending Doctor Name | R.ATTDR.D.DOCNAME |
| Consulting Doctor #1 Code | R.CONSULT1 |
| Consulting Doctor #1 Name | R.CONSULT1.D.DOCNAME |
| Consulting Doctor #2 Code | R.CONSULT2 |
| Consulting Doctor #2 Name | R.CONSULT2.D.DOCNAME |
| Consulting Doctor #3 Code | R.CONSULT3 |
| Consulting Doctor #3 Name | R.CONSULT3.D.DOCNAME |
| Dictating Doctor Code | R.DOCTOR |
| Dictating Doctor Name | R.DOCTOR.D.DOCNAME |
| Dictating Doctor Initials | R.DOCTOR.D.INITIALS |
| Dictating Doctor Author ID | R.DOCTOR.D.AUTHORID |
| Dictating Doctor Extra 1 | R.DOCTOR.D.EXTRA1 |
| Dictating Doctor Extra 2 | R.DOCTOR.D.EXTRA2 |
| Dictating Doctor Extra 3 | R.DOCTOR.D.EXTRA3 |
| Dictating Doctor Extra 4 | R.DOCTOR.D.EXTRA4 |
| Dictating Doctor Extra 5 | R.DOCTOR.D.EXTRA5 |
| Dictation Date | R.DICT_DATE |
| Dictation Time | R.DICT_TIME |
| Electronically Signed Date | R.SIGNDATE |
| Electronically Signed Time | R.SIGNTIME |
| Electronically Signed Doctor Code | R.SIGNDOC |
| Electronically Signed Doctor Name | R.SIGNDOC.D.DOCNAME |
| Electronically Signed Status | R.STATUS |
| Exam Description | R.EXAMDESC |
| Medical Record Number | R.MRUN |
| Other Doctor #2 Code | R.DOCTOR1 |
| Other Doctor #2 Name | R.DOCTOR1.D.DOCNAME |
| Other Doctor #3 Code | R.DOCTOR2 |
| Other Doctor #3 Name | R.DOCTOR2.D.DOCNAME |
| Referring Doctor Code | R.REFDR |
| Referring Doctor Name | R.REFDR.D.DOCNAME |
| Report Type Code | R.REPT_TYPE |
| Report Type Description | F.DESC |
| Reviewed By Code | R.REVIEWEDBY |
| Social Security Number | M.SSN |
| Transcriptionist Code | R.SCRIBE |
| Transcription Date | R.TRANS_DATE |
| Transcription Time | R.TRANS_TIME |
| Voice Job Number | R.VOICEJOB |
User Table Fields
| Transcriptionist Employee Number | E.EMPNO |
| Transcriptionist Initials | E.INITIALS |
Special Fields
| Dictating Line | X.DICTATING_LINE |
| 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 |
| All CC Names (Separate lines) | X.ALL_CC_NAMES |
| All CC Names (All on one line) | X.ALL_CC_NAMES2 |
| All CC Names and Addresses (Separate lines) | X.ALL_CC_ADDRESSES |
| All CC Names and Addresses (One line per) | X.ALL_CC_ADDRESSES2 |
| All CC Names and Addresses (One line per) | X.ALL_CC_ADDRESSES3 |
Special bracketed field for CC's
| Bracketed Field | Description |
| X.ALL_CC_NAMES | Prints each cc: name on a separate line |
| X.ALL_CC_NAMES2 | Prints all cc: names on one line, separated by a slash character |
| William P. Smith, M.D. / David S. Jones, M.D. |
| X.ALL_CC_ADDRESSES | Prints cc: names and their addresses on separate lines |
| X.ALL_CC_ADDRESSES2 | Prints each cc: name and address on one line |
| 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. |
| William P. Smith, M.D. (FAX) |
| David S. Jones, M.D. (78873 S. Broadway Blvd, Twinsburg, Ohio 44234) |
|