GFA ASCII

More Help

The ASCII File Format specification described below will allow you to import your GFA assessment file and credit information into the GFA Tracking System. Each line of the ASCII file represents one assessment. Each amount in the ASCII file is separated by a tab. Each field can be any length. Fields with no amounts should contain zero (0). Negative numbers should have a minus sign (-) immediately preceding the number (-10000). The format for each line is as follows:

Col. 1	Line of Business (PC/LIFE/AH/ANN)
Col. 2	State Abbreviation
Col. 3	Assessment Date
Col. 4	Date Paid
Col. 5	Description
Col. 6	Check Box for Class A Assessments (-1 = include, 0 = exclude)
Col. 7	Class A Assessment Amount
Col. 8	Check Box for Class B Assessments (-1 = include, 0 = exclude)
Col. 9	Class B Assessment Amount
Col. 10	Check Box for Class C Assessments (-1 = include, 0 = exclude)
Col. 11	Class C Assessment Amount

A sample line looks like the following:

AH CT 01/01/2011 01/15/2011 Description 0 1000 -1 2000 -1 3000

The above line will enter the Health assessment in the CT Assessment Schedule and will transfer $1000 into Class A, $2000 into Class B, $3000 into Class C. The columns for Class B and C will be checked to indicate that you may receive credit for the assessment amount.