Formatting Codes

Top  Previous  Next

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 (":").

 

Medical record number

 

M1- xx xx xx

 

Dates

 

D1- yyyymmdd

D2        - June 9, 2001

D3        - mm/dd/yy

D4        - strip out "/" if blank date

D5        - yyyy mm dd

D6        - mmddyy

D7        - Tue December 31, 2002

D8        - mm-dd-yy

 

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

 

Provider Names

 

P1   - LAST, FIRST M, TITLE (uppercase)

P2   - Last, First M, TITLE (proper case)

P3   - Last name (proper case)

P4        - Initials

 

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