| |
Division of
Finance
MORTGAGE BUSINESS SCHOOL
GENERAL INSTRUCTIONS FOR SUBMITTING STUDENT LISTS
|
|
|
Rule
69V-40.027(4), F.A.C., provides that within five (5) days of completion of each twenty-four (24) hour Mortgage Business Course, the school shall submit to the
Office a typed list of all students who successfully completed the course; The list shall include the full name of the student, the social security number of each student, the school's name, the school's license number and completion date; In lieu of a typed list, the school may submit the list in these formats:
OFR Website: Via the Internet, access the Office's website at
www.flofr.com/Finance/MB-Schools.htm; You must have a School ID and Password to access your school's records.
E-mail:. Submit the list in an e-mail message to:
electronic_licensing. Be sure to include the following identifying information in your e-mail message: Mortgage Business School Certificate Number, School Name, name of person submitting the file, phone number and e-mail address.
Under Florida law,
e-mail addresses are public records. If you do not want your
e-mail address released in response to a public-records
request, do not send electronic mail to this entity.
Instead, contact this office by phone or in writing.
Data File: Prepare the list in a data or text file and submit it via e-mail or diskette. For either method, be sure the data file is accompanied by the following information: Mortgage Business School Certificate Number, School Name, name of person submitting the file, phone number and e-mail address. The only file formats we can accept are: MS Excel (97 or higher); ASCII text (tab delimited); Lotus 1-2-3 (extension WK1 and WK3 only); The file layout is provided below.
FILE LAYOUT FOR DATA
| Field Name | Field Type | Field Width or Format | Required | | SchoolID | Text | 3 | Yes | | StudentLastName | Text | 25 | Yes | | StudentFirstName | Text | 15 | Yes | | StudentMiddleName | Text | 10 | No | | Append | Text | 3 | No | | SSN | Text | 9 | Yes | | DateComplete | Date | MM/DD/YY | Yes |
SAMPLE RECORDS
| SchoolID | StudentLastName | StudentFirstName | StudentMiddleName | Append | SSN | DateComplete | | 003 | SMITH | MICHELLE | ANN | | 000999999 | 08/09/99 | | 003 | JOHNSON | ALFRED | EVERETT | JR | 889999998 | 08/09/99 |
DESCRIPTION AND EXPLANATION OF FIELDS
| SCHOOL ID | Last 3 digits of Mortgage Broker School Certificate Number (If certificate no. is MB 20003, enter 003) | | STUDENT LAST NAME | Last Name only | | STUDENT FIRST NAME | First Name only | | STUDENT MIDDLE NAME | Middle Name only | | APPENDIX | Use for appendices such as JR, SR, or III [no punctuation] | | SSN | Social Security Number: 091489999 [no hyphens or spaces] | | DATE COMPLETE | Course Completion Date; MM/DD/YY |
We can only accept the following file formats: MS Excel (97 or higher); ASCII Text (tab delimited); Lotus 1-2-3 (extension WK1 and WK3 only). The
Office will be using Microsoft Access version 7.0 for Windows 2000 to convert the files and check them for errors. |
|
