Generated File Name : "NOCD" + "(SysDate,DDMMYY)" + ".txt"
Field Name Length
1 NOTARY_DATA
Record Header 2
Commission_Number 8
Status_ID 2
OK_Address_ID 13
NonResident_Address_ID 13
Mailing_Address_ID 13
Mailing_Address_Option 1
Current Commisson Date 8
Expiration_Date 8
Notary_Last_Name 50
Notary_First_Name 50
Notary_Middle_Name  50
Notary_Name_Suffix_ID 2
Notary_Name_Preffix_ID 2
Oklahoma_Resident_Flag 1
Mailing_Business_Name 50
Mailing_Name_Prefix_ID 2
Mailing_First_Name 50
Mailing_Middle_Name 50
Mailing_Last_Name 50
Mailing_Name_Suffix_ID 2
E_mail 64
Telephone_Number 16
Former_Commission_Flag 1
Inactive_Date 8
2 NOTARY_ADDRESS
Record Header 2
Address_ID 13
Address1 50
Address2 50
Zip_Code 9
Zip_Extension 6
City 64
County 64
State 64
3 NOTARY_BOND
Record Header 2
Document Number 13
Commission_Number 8
Bond Number 6
Bond Date 8
Bond_Status_ID 2
4 NOTARY_FILING
Record Header 2
Filing_Type_ID 13
Commission_Number 8
Document Number 13
Filing_Date 8
Entry_User_ID 20
Entry_Date 8
Last_Modified_Date 8
Last_Modified_User_ID 20
Comments
Page Count 2
Imaged 1
Inactive_date 8
5 NOTARY_FILING_TYPE
Record Header 2
NOTARY_FILING_ID 13
NOTARY_FILING_DESCRIPTION 96
6 NOTARY_STATUS
Record Header 2
notary_status_id 13
notary_status_description 50
7 BOND_STATUS
Record Header 2
Bond_Status_ID 13
Bond_Status_Description 50
8 PREFIX
Record Header 2
PREFIX_ID 13
PREFIX_DESCRIPTION 50
9 SUFFIX
Record Header 2
Suffix_ID 13
Suffix 50
10 NOTARY_AUDIT_LOG
Record Header 2
Document_Number 13
Reference_Number 8
Audit_Date 8
Current_User_ID 20
Previous_User_ID 20
Module_ID 5
Reference_Type_ID 3
Table_ID 4
Field_ID 4
Previous_Value 300
Current_Value 300
Action 20
Audit_Comment 23
11 FILE FOOTER
99 2
99999999 8
Process Date 8
Total number of notary record 12
Total number of notary address record 12
Total number of notary bond record 12
Total number of notary filings record 12
Total number of notary auditlog record 12