To view samples of actual formats, click on the acronym for the format you wish to view.
For further information or to place your email on our distribution list, please contact us at UCC.Dept@state.mn.us
UCC and Business Services Product Formats
In the following examples, the bold numbers at the top and the plus sign at the end are not in the actual data received. The bold numbers across the top are use in the example to show the field sizes by showing the column positions. The plus at the end, is used to show where the record line ends. In computer language, this would be a carriage return and line feed.
The following example shows how a FXC format would appear. Columns 6, 10, 19, 37, 54 and 66 would have a space in them to separate the fields. As you see in the last field, which is a 4 character field, the spaces after the ST, AVE and CIR are removed. This saves some space on the media that it is written to, however, if a program expects that the file should have 71 characters, it will fail when it only gets 69 or 70.
11111111112222222222333333333344444444445555555555666666666677 12345678901234567890123456789012345678901234567890123456789012345678901 01973 005 735 763 BRIGHTON ST+01974 005 505 1003 BRISBIN ST+ 05357 005 700 710 BRYANT AVE+ 01983 005 3303 3357 BRYANT AVE+ 01984 005 3503 3649 BRYANT AVE+ 01985 005 3700 3750 BRYANT CIR+
The following example shows how a FXCS format would appear. Columns 6, 10, 19, 37, 54 and 66 would have a space in them to separate the fields. As you see in the last field, which is a 4 character field, the spaces after the ST, AVE and CIR are kept in the file. This takes more space on the media that it is written to, but it guarantees that all records have 71 characters.
11111111112222222222333333333344444444445555555555666666666677 12345678901234567890123456789012345678901234567890123456789012345678901 01973 005 735 763 BRIGHTON ST +01974 005 505 1003 BRISBIN ST + 05357 005 700 710 BRYANT AVE + 01983 005 3303 3357 BRYANT AVE + 01984 005 3503 3649 BRYANT AVE + 01985 005 3700 3750 BRYANT CIR +
The following example shows how a TFC format would appear. Columns 6, 10, 19, 37, 54 and 66 would have a Tab Set in them to separate the fields. As you see in the last field, which is a 4 character field, the spaces after the ST, AVE and CIR are removed. This saves some space on the media that it is written to, however, if a program expects that the file should have 71 characters, it will fail when it only gets 69 or 70.
The following example shows how a TFCS format would appear. Columns 6, 10, 19, 37, 54 and 66 would have a Tab Set in them to separate the fields. As you see in the last field, which is a 4 character field, the spaces after the ST, AVE and CIR are kept in the file. This takes more space on the media that it is written to, but it guarantees that all records have 71 characters.
The following example shows how a CS format would appear. As you see in all the fields, the spaces at the end are removed. This saves a lot of space on the media that it is written to, however, if the data fields could have commas in them, this could throw of the count of fields per record.
11111111112222222222333333333344444444445555555555666666666677 12345678901234567890123456789012345678901234567890123456789012345678901 01973,005,735,763,BRIGHTON,ST+01974,005,505,1003,BRISBIN,ST+ 05357,005,700,710,BRYANT,AVE+ 01983,005,3303,3357,BRYANT,AVE+ 01984,005,3503,3649,BRYANT,AVE+ 01985,005,3700,3750,BRYANT,CIR+
The following example shows how a CSQ format would appear. As you see in all the fields, the spaces at the end are removed and quotes surround the field. This takes up more space than the CS format, but still saves a lot of space on the media that it is written to. This method identifies the fields no matter what characters are in the field (the odds that a field would have a quote and a comma right after it is small).
11111111112222222222333333333344444444445555555555666666666677 12345678901234567890123456789012345678901234567890123456789012345678901 “01973”,”005”,”735”,”763”,”BRIGHTON”,”ST”+“01974”,”005”,”505”,”1003”,”BRISBIN”,”ST”+ “05357”,”005”,”700”,”710”,”BRYANT”,”AVE”+ “01983”,”005”,”3303”,”3357”,”BRYANT”,”AVE”+ “01984”,”005”,”3503”,”3649”,”BRYANT”,”AVE”+ “01985”,”005”,”3700”,”3750”,”BRYANT”,”CIR”+
TIF (TIFF) specifies the file format in which the scanned image is stored. There is an associated index file for these images. The format of the index has not been determined at this time.