Subject RE: RE: [ib-support] Non-technical database question
Author Cassandra Harley
Alan,

Thanks, I will look into those comments, they are appreciated.

>You're obviously writing for Australia... is there a state here by the name
>'OTH' ????
It is part of the ATO specs for ELS lodgement of PAYG summaries.

>You might want to think some more about postcode being an integer and not a
>varchar...
Oops, I think I meant to do this.

>You want Country but only provide for Australian states (except 'Oth') and
>if it's other countries are what you want you'll definitely lose out on an
>integer postcode field.
These are good points, I must admit that I just blindly followed what the
ATO requirements were. Perhaps a bit more thought would be better.