TRANSFORMATION OF SEFSC TIP DATA INTO TIPONLINE DATA

This document explains the transformation that were applied to the old TIP data
to bring it into the new TIPONLINE format.

This is best viewed in Internet Explorer.
If your display is set at 1024 x 768 pixels, you can still see the entire screen if you set
the text size to the smallest size possible. This will spare you the need to scroll. Another alternative is to set your desktop to 1280 x 1024 pixels, and medium text size.

In Internet Explorer, a cyan line separates fields.
Each field has at least one line for the information in the old system
followed by the information in the new system
and then a comment on the transformation.
If the field is a coded item, the code tables will have the old values on one line
and the new value on the next line.
When either the code or the description of the code changed from the old system to the new system
that change will be highlighted in yellow.

• VARCHAR2(3) means character data up to 3 characters wide
  
• NUMBER(3) means numeric data up to 3 digits wide
  
• NUMBER means numeric data with 38 digits of precision, more than is needed for TIP data. You decide how many decimal places to add.
  
• NUMBER(7,2) means 7 total digits, 5 whole numbers and 2 decimal digits. The plus or minus sign and the decimal point don't count.
  
• DATE means a field that has Month, Date, Century, Year encoded into it.
  

TABLE OF CONTENTS