SMaSCH data mapping notes

person

• legacy_id 327: Manually changed 5th character in first name to cedilla.  As Lam notes

The special character in 327 does not display properly in my shell screen, nor in xdb (shows as ? in my shell, and a square box with dotted line in xdb.  I used the ascii function in sybase to get the character code 135 (extended ascii 135 is the minuscule c-cedilla ç, which makes sense in this context).  The html code ‡ will give you the double chross character.

• legacy_id 4708: middle name is <?>. Record loaded OK.
• Until we are on 2.2 version, we need to convert parens in display names to another character.  For now square brackets will be used.  This will require data cleaning later.

organization

• Legacy org 4331 corresponds to person legacy_id 327 and must be manually updated with cedilla to match!
• Until we are on 2.2 version, we need to convert parens in display names to another character.  For now square brackets will be used.  This will require data cleaning later.