ACCEPTED STRUCTURE FOR ELECTRONIC FILING
ACCEPTED FORMATS = EXCEL
FOXPRO DATABASE
SDF TEXT FILE (STANDARD DATA FORMAT)
CLAIMANT IDENTIFICATION INFORMATION:
FIELD FORMAT
TAX ID NUMBER CHARACTER 11
LAST NAME CHARACTER 30
FIRST NAME CHARACTER 20
MIDDLE INITIAL CHARACTER 1
PARTNER (JOINT NAME) CHARACTER 40
ENTITY CHARACTER 20
ACCOUNT NUMBER CHARACTER 25
ATTENTION CHARACTER 40
ADDRESS CHARACTER 35
ADDRESS 2 CHARACTER 35
CITY CHARACTER 20
STATE CHARACTER 2
ZIPCODE CHARACTER 5
ZIP4 CHARACTER 4
COUNTRY CHARACTER 35
EMAIL CHARACTER 35
TELEPHONE NUMBER - DAY CHARACTER 14
TELEPHONE NUMBER - EVENING CHARACTER 14
BEGINNING BALANCE - Close of Buisness March 15, 2005 NUMERIC 15 5
NUMBER OF PURCHASE TRANSACTIONS NUMERIC 7 0
TOTAL SECURITIES PURCHASED NUMERIC 15 5
NUMBER OF SALES TRANSACTIONS NUMERIC 7 0
TOTAL SECURITIES SOLD ON OR BEFORE May 21, 2007 NUMERIC 15 5
CLOSING BALANCE - May 21, 2007 NUMERIC 15 5
NUMBER OF PURCHASE TRANSACTIONS - After May 21, 2007 NUMERIC 7 0
TOTAL SECURITIES PURCHASED - After May 21, 2007 NUMERIC 15 5
NUMBER OF SALES TRANSACTIONS - After May 21, 2007 NUMERIC 7 0
TOTAL SECURITIES SOLD - After May 21, 2007 NUMERIC 15 5
Closing Balance - Current (Date of File) "CURBAL" NUMERIC 15 5
ACCEPTED STRUCTURE FOR ELECTRONIC FILING
TRANSACTIONS:
FIELD FORMAT
TAX ID NUMBER CHARACTER 11
ACCOUNT NUMBER CHARACTER 25
TRANSACTION TYPE CHARACTER 1
SECURITY TYPE CHARACTER 1
TRANSACTION DATE DATE 10
NUMBER OF SHARES NUMERIC 15 5
PRICE PER SHARE NUMERIC 15 5
TOTAL PRICE NUMERIC 15 2
SHORT SALE/COVERING PURCHASE CHARACTER 1
NOTES:
1. DO NOT USE DOLLAR SIGNS OR COMMAS IN NUMERIC FIELDS
2. DO NOT USE ANY FANCY FORMATTING, UNDERLINING OR BOLDING, SHADING, ETC
3. AN SDF FILE HAS FIXED FIELDS WITH NO DELIMITERS
4. THE TOTAL NUMBER OF PURCHASE AND SALE TRANSACTIONS IN THE TRANSACTION
FILE SHOULD BE THE SAME AS LISTED IN THE CLAIMANT INFO FILE FOR EACH CLAIMANT
5. THE TOTAL SECURITIES LISTED AS PURCHASED AND SOLD IN THE TRANSACTION
FILE SHOULD BE THE SAME AS LISTED IN THE CLAIMANT INFO FILE FOR EACH CLAIMANT
RE FOR ELECTRONIC FILING
XT FILE (STANDARD DATA FORMAT)
FICATION INFORMATION:
FORMAT
99-9999999 OR 999-99-9999
JT TEN
TEN ENT
IRA
TRUST
CUSTODIAN
MOSTLY FOR USE BY INSTITUTIONS
NAME - MOSTLY FOR CLAIMS BY OTHER THAN INDIVIDUAL
(999) 999-9999
(999) 999-9999
RE FOR ELECTRONIC FILING
SACTIONS:
FORMAT
99-9999999 OR 999-99-9999
MOSTLY FOR USE BY INSTITUTIONS
P = PURCHASE
S = SALE
E = EXPIRED
X = EXERCISED
D = DELIVERD IN
T = TRANSFERRED OUT
S = COMMON STOCK
C = CALLS
P = PUTS
D = DEBENTURES
B = BONDS
R = PREFERRED STOCK
M = MONTHLY INSURED PREFERRED SECURITIES
00/00/0000 - MUST BE TRADE DATE
999999999.99999
999999999.99999
999999999.99999
X
NOTES:
G, SHADING, ETC
THE TRANSACTION
E FOR EACH CLAIMANT
TRANSACTION
E FOR EACH CLAIMANT
SSN EIN ACCTNUM TRXTYPE SECTYPE TRXDATE TRXSHARES
EXAMPLE 999-99-9999 99-9999999 P S 7/15/1998 100.00000
TRXPRICE TRXTOTAL
10.50000 1050.000
LNAME FNAME MI PARTNER ENTITY ATTN ACCTNUM ADDR1 ADDR2 CITY STATE ZIP ZIP4 COUNTRY EMAIL EIN SSN DPHONE OPEN0031505 NUMPUR TOTPUR NUMSALE TOTSALE CLOS052107 NUMPUR2 TOTPUR2 NUMSALE2 TOTSALE2 CURBAL
EXAMPLE PUBLIC MARY Q JOHN Q PUBLIC JT TEN 1234 MAIN STREET YOUR TOWN PA 19134 4308 99-9999999 999-99-9999 215-999-9999 100.00000 1 100.00000 0 0.00000 200.00000 1 100.00000 0 0.00000 300.00000