You may need to manually translate values in a field |
Join from the table that has a code in the source field |
Set FIELDNAME equal to the name of the field from the source table. |
Join FIELDVALUE to the source field |
Most field names match. One exception is academic level. From STDNT_CAR_TERM join ACAD_LEVEL_BOT to the FIELDVALUE, set FIELDNAME = 'ACADEMIC_LEVEL' |