ESS - Address Change Form

Welcome to LawsonTalk. We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. After registration, please check your e-mail within 24 hours for an message from us, read it, and reply to it.

Join our community!

If you're already a member please log in to your account to access all of our features:

ESS - Address Change Form; ESS - Address Change Form
Topic Started: Sep 10 2009, 09:46 AM (205 Views)
mhobson	Sep 10 2009, 09:46 AM Post #1
Newbie Posts: 1 Group: Members Member #364 Joined: January 20, 2006	Has anyone applied any formatting or programming changes to the Address Change Form in ESS in order to ensure employees enter their addresses correctly? ie. Spacing, Capitalization



KarenPloof	Sep 11 2009, 08:52 AM Post #2
Advanced Member Posts: 75 Group: Members Member #114 Joined: January 12, 2006	We didn't modify the form, but we did add a trigger to the file so all address changes from any of the forms, goes through zip+4 (I think that's what it's called) for cleansing.



3monkeys	Sep 16 2009, 12:04 PM Post #3
Super Member Posts: 168 Group: Members Member #240 Joined: January 13, 2006	Same here - used database triggers to store it in all caps. That way it also gets stored right if entered on HR11. We didn't get fancy with making sure "Street" becomes "ST" or "Road" is "RD", but it would be the same method.



bbhiemer	Nov 17 2009, 04:49 PM Post #4
Member Posts: 25 Group: Members Member #4,835 Joined: February 21, 2008	We added formatting tips on SEA, sent an all employee email, and will be running a query monthly and then changing any that are not correct.


« Previous Topic · HR/Payroll · Next Topic »