NEW DATABASES UPDATED EVERY WEEKNIGHT!
ASCE’S FTP SERVER SECTION AND BRANCH MEMBERSHIP DATABASE
(Revised August 2004)
OBTAINING, RENEWING OR REASSIGNING AN ACCOUNT
1. Designate an FTP account holder: Only one person may serve as account holder for each Section and/or Branch. 2. Submit signed Rules: Use Appendix A, or download a copy of the “Rules for Section and Branch Membership Records Use” from the FTP server at the following address (URL): ftp://gsd.asce.org/FTP%20MANUAL/ Fax a signed copy of the “Rules” to Michael Cook at 703-295-6141. 3. Obtain Username and Password: A Username and Password will be emailed to the account holder on receipt of the signed copy of the “Rules for Section and Branch Membership Records Use.” 4. Save Your Username and Password: You may bookmark your FTP Membership Database Account access information on your internet browser. Access information should not be shared with anyone. The database may be shared at the account holder’s discretion.
ACCESSING YOUR FTP DATABASE ACCOUNT
Open your internet browser
(Any internet browser may be used to access the database)
Enter access address: FTP://USERNAME:PASSWORD@GSD.ASCE.ORG
Step 3: Highlight (Doubleclick) the file you would like to obtain:
Section Accounts contain files for the Section and all of its Branches. Branch FTP Accounts contain only the Branch file.
Step 4: SAVE the database to your computer:
Open Your FTP Membership Database 1. Open Your MS EXCEL or another spreadsheet program, locate and open the downloaded file.
(The downloaded file is in comma delimited (.csv) format. You’ll need to change your “Files of Type” to “All Files” to locate the database.)
FTP Membership Database Content and Code Definitions Your FTP Membership Database contains ## fields. The fields and associated code definitions are found in the following table:
COLUMN A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT TITLE Section Branch Account Last Name First Name MI Business Position Employer Activity Code Job Title Code Address Code Primary Address 1 Primary Address 2 Primary Address 3 Primary City Primary State Primary Zip Primary Plus4 Primary Postal Code Primary Phone Secondary Address1 Secondary Address2 Secondary Address3 Secondary City Secondary State Secondary Zip Secondary Plus4 Secondary Postal Code Secondary Phone Company Name Date Last Updated Nick Name Sex Marital Status Spouse Last Name Spouse First Name Spouse MI Member Grade Life Member Code Dues Waiver Code Drop Code Election Date Grade Date Birth Date Life Year Expected Date of Graduation Drop Date CONTENT Section Number Branch Number Member’s ASCE Identification Number Members Last Name Member’s First Name Member’s Middle Initial Member’s Job Title See TABLE 1 See TABLE 2 See TABLE 3 Member’s Preferred Address (Line 1) Member’s Preferred Address (Line 2) Member’s Preferred Address (Line 3) Member’s Preferred Address (City) Member’s Preferred Address (State) Member’s Preferred Address (5 digit Zip Code) Member’s Preferred Address (for 9 digit Zip Codes) INACTIVE FIELD Member’s Preferred Telephone Number Member’s Secondary Address (Line 1) Member’s Secondary Address (Line 2) Member’s Secondary Address (Line 3) Member’s Secondary Address (City) Member’s Secondary Address (State) Member’s Secondary Address (5 digit Zip Code) Member’s Secondary Address (for 9 digit Zip Codes) INACTIVE FIELD Members Secondary Telephone Number Name of Member’s Place of Work Last Date Member’s Record Was Updated (YYYY/MM/DD) (Not applicable to dues payments) Member’s Nick Name Member’s Gender SEE TABLE 4 Last Name of Member’s Spouse First Name of Member’s Spouse Middle Initial of Member’s Spouse SEE TABLE 5 Y/N = Yes/No Field SEE TABLE 6 Members Dropped during current month SEE TABLE 7 Date of Election to ASCE Member Grade (YYYY/MM/DD) Date of Election to Current Grade (YYYY/MM/DD) Member’s Date of Birth (YYYY/MM/DD Anticipated Year for Life Member Status Approximate Graduation Date (YYYY/MM/DD) INACTIVE FIELD
COLUMN AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM BN BO BP BQ
TITLE Last National Dues Paid Year Last National Dues Paid Date Last Section Paid Year Last Section Paid Date Last Vol. Section Paid Year Last Vol. Section Paid Date Section Paid At Section Y/N Student Member School Code Enrollment 1 Degree of Interest 1 Enrollment 2 Degree of Interest 2 Enrollment 3 Degree of Interest 3 Enrollment 4 Degree of Interest 4 Enrollment 5 Degree of Interest 5 Enrollment 6 Degree of Interest 6 Fax Number Email Address Transaction Code
BS BT BU BV BW BX BY BZ CA CB CC
Institute 1 Institute 2 Institute 3 Institute 4 Institute 5 Institute 6 Institute 7 Institute 8 Name-Suffix Credentials Subscriber Y/N
CONTENT Last Year National Dues Were Paid Last Date National Dues Were Paid (YYYY/MM/DD) Last Year Section Dues Were Paid Last Date Section Dues Were Paid (YYYY/MM/DD) Last Year Voluntary Section Dues Were Paid Last Date Voluntary Section Dues Were Paid (YYYY/MM/DD) Section Dues Were Paid directly to the Section Yes/No Student Member’s School Code (Codes Defined on Request) Discipline Abbreviation – SEE TABLE 8 Degree of Interest in Enrollment 1 Discipline Abbreviation – SEE TABLE 8 Degree of Interest in Enrollment 2 Discipline Abbreviation – SEE TABLE 8 Degree of Interest in Enrollment 3 Discipline Abbreviation – SEE TABLE 8 Degree of Interest in Enrollment 4 Discipline Abbreviation – SEE TABLE 8 Degree of Interest in Enrollment 5 Discipline Abbreviation – SEE TABLE 8 Degree of Interest in Enrollment 6 Member’s Facsimile Phone Number Member’s Email Address Additions/Changes to database during the current month A = Additions to database during current month C = Record Change during current month Your ASCE District Director is included in your database. Please include your District Director in any Section/Branch correspondence. Member’s Institute affiliation - SEE TABLE 9 Member’s Institute affiliation - SEE TABLE 9 Member’s Institute affiliation - SEE TABLE 9 Member’s Institute affiliation - SEE TABLE 9 Member’s Institute affiliation - SEE TABLE 9 Member’s Institute affiliation - SEE TABLE 9 Member’s Institute affiliation - SEE TABLE 9 Member’s Institute affiliation - SEE TABLE 9 (Jr., Sr., III, etc.) (P.E., Ph.D., etc.) Y/N Field. A subscriber is a Member who is assigned to another Section but has chosen to also become a member of this Section.
TABLE 1 EMPLOYER ACTIVITY CODES
01 02 06 07 08 14 15 16 18 31 33 34 51 52 53 54 55 Architectural, Architectural-Engineering Firm, Architect, Architect-Engineer in Private Practice Consulting Engineering Firm, Engineer in Private Practice Commercial and/or Industrial Organizations (including transportation and privately owned utility companies) Producer of Building and Construction Materials (including cement, cement products, sand, gravel and other aggregates, clay products, and other raw materials) Manufacturer of Construction Equipment and Supplies Engineering School Student Educator-Professor, Instructor Library, Club, Professional or Trade Association Other Contractor Specializing in Building Construction Contractor Specializing in Construction Other than Buildings Contractor Engaged in Both Building Construction and Construction Other than Buildings Federal Government Regional Authority State Government Municipal, County, Township, and District Government Foreign
TABLE 2 JOB TITLE CODES
A. B. C. D. E. F. G. O. Owner, President, Vice President, General Manager, Military Officer, Consultant Project Manager & Coordinator, Chief and/or Staff Engineer Staff Architect, Designer, Draftsman Construction Superintendent, Supervisory Staff Personnel Department Manager and/or Department Head Other Titled Engineer, Non-Titled Engineer, Fully Retired Engineer Student Other Personnel, Library and/or Company Copies
TABLE 3 ADDRESS CODES
R F S Residence Firm/Business Suspended - Mail Sent to both Primary and Secondary Addresses has been returned to ASCE as “Undeliverable – No Forwarding Address”. The address record has been suspended until updated contact information is received. Sections and Branches are encouraged to try to contact members whose addresses have been marked as suspended.
TABLE 4 Marital Status Codes
Blank M S D Not Specified Married Single Divorced
TABLE 5 Member Grades
SM AM AF Student Member Associate Member Affiliate Member MB FE
TABLE 6 Dues Waiver Codes
0 00 01 02 03 04 05 06 07 Non-Dues Waived Active Member Non-Payment of Dues Deceased Resigned, Personal Reasons Resigned, Retired Resigned, Abandoned Civil Engineering Resigned, Lack of Interest Resigned, Dissatisfaction 08 09 1 2 3 4 9 99 Resigned, Dues Increase Resigned, No Cause Given One Year, Board of Direction Lifetime, Board of Direction Other, Executive Direction Honorary Member Life Member Waiver ASCE Administrative Delete
TABLE 7 Drop Codes
01 02 03 04 05 06 07 08 09 Nonpayment of Dues Deceased Resigned, Personal Reasons Resigned, Retired Resigned, Abandoned Civil Engineering Resigned, Lack of Interest Resigned, Dissatisfaction Resigned, Dues Increase Resigned, No Cause Given 10 11 12 13 14 15 16 17 18 Employer Won’t Pay Dues Resigned to join Institute Ethics Violation Other organization suited their needs Political Embargo Non-responsive Deactivate Resigned with prejudice Professional Degree Issue
TABLE 8 Discipline Abbreviations AE AI AS BS CA CB CE CO CP CR CS CT CV DC EA EC EE EM ET EW EY FD FE FP GD GM GT GV HW HY IC ID IF IS LD LE MA MN MT NW OC OO PH PL RI RS SA SC SI SR ST Architectural Engineering TB Tall Buildings Airport Infrastructure & Engineering TL Transportation and Land Development Aerospace TP Transportation Planning Bridges UR Urban Water Resources Research Architectural Engineering UT Urban Transportation Systems Commercial Buildings WH Watershed & Hydrology Coastal Engineering WR Water Resources Planning & Management Construction WW Waterways, Ports, Coasts Computer Practices Cold Regions Engineering Codes & Standards Computing & Information Technology Coasts, Oceans, Ports and Rivers Design Issues – Design/Build, Value Engineering, Temp Structures Electrical Equipment Issues – Types, Techniques, Safety Environmental Engineering Engineering Mechanics Electrical Transmission Environmental & Water Resources Energy Foundations & Dams Forensic Engineering Fire Protection Geotechnical Earthquake Engineering – Soil Dynamics Geomatics Geotechnical Engineering Geo-Environmental Engineering Highway Hydraulics & Waterways Site Issues – Management Practices, Safety, Project Rep Irrigation & Drainage Industrial Facilities Infrastructure Security and Disaster Mitigation Land Development Lifeline Earthquake Engineering Mechanical Metrication Materials – Wood, Concrete, Metal, Bituminous Navigational Waters Owner Issues – Contract Admin., Inspection, Environmental Ocean Offshore Ports & Harbors Pipeline Water Resources Infrastructure Residential Architectural Structural Soil/Site Characterization Soil Improvement and Retention Service Issues – Insurance, Bonding, Surety, Legal Structural Engineering NOTE: See ASCE Official Register for most current discipline abbreviations. 10
TABLE 9 INSTITUTES
AEI COPRI CI EWRI GEO SEI T&DI Architectural Engineering Institute Coast, Oceans, Ports, and Rivers Institute Construction Institute Environmental and Water Resources Institute Geo-Institute Structural Engineering Institute Transportation and Development Institute
ASCE MEMBERSHIP DATABASE FIELDS (Alphabetical Listing)
TITLE Account Address Code Birth Date Branch Business Position Company Name Credentials Date Last Updated Degree of Interest 1 Degree of Interest 2 Degree of Interest 3 Degree of Interest 4 Degree of Interest 5 Degree of Interest 6 District Director Drop Code Drop Date Dues Waiver Code Election Date Email Address Employer Activity Code Enrollment 1 Enrollment 2 Enrollment 3 Enrollment 4 Enrollment 5 Enrollment 6 Expected Date of Graduation Fax Number First Name Grade Date Institute Affiliation Job Title Code Last Name Last National Dues Paid Date Last National Dues Paid Year Last Section Paid Date Last Section Paid Year Last Vol. Section Paid Date Last Vol. Section Paid Year Life Member Code Life Year Marital Status Member Grade MI Name-Suffix Nick Name Primary Address 1 Primary Address 2 Primary Address 3 Primary City COLUMN C J AQ B G AC CB AD BD BF BH BJ BL BN BR AN AT AM AO BP H BC BE BG BI BK BM AS BO E AP BS-BZ I D AV AU AX AW AZ AY AL AR AG AK F CA AE K L M N
Primary Phone Primary Plus4 Primary Postal Code Primary State Primary Zip Secondary Address1 Secondary Address2 Secondary Address3 Secondary City Secondary Phone Secondary Plus4 Secondary Postal Code Secondary State Secondary Zip Section Section Paid At Section Y/N Sex Spouse First Name Spouse Last Name Spouse MI Student Member School Code Subscriber Y/N Transaction Code
S Q R O P T U V W AB Z AA X Y A BA AF AI AH AJ BB CC BQ
Appendix A RULES FOR SECTION & BRANCH
MEMBERSHIP RECORDS USE 1) ASCE membership data is the sole property of ASCE. ASCE at all times retains exclusive ownership rights of all data. Membership data must be held secure and in strict confidence, without disclosure to third parties. It is to be used only for official ASCE Section/Branch business. 2) This data should never be duplicated/transferred/copied/scanned/keyed/reused/provided/sold to nonmembers or distributed for any other purpose.
3) ASCE will provide specific membership data to the Section/Branch to conduct the typical business of the Section/Branch. ASCE reserves the right to reject any inappropriate mailing program(s), and ASCE’s approval of a specific mailing program does not guarantee approval of future requests. Questions regarding appropriate mailings or use of lists should be directed to the Geographic Services Department at 800-548-2723. a) Examples of “typical business” include but are not limited to: sending newsletters to Section/Branch members, marketing Section/Branch services and products, informing members of Section or Branch Board actions, networking, etc. b) Examples of “atypical business” include but are not limited to: giving/selling/bartering the list to anyone outside the Section/Branch for any reason, providing the lists to individuals for direct mailings relating to an ASCE election, sending information that conflicts with ASCE Policy Statements, etc. 4) The Section/Branch shall not use ASCE’s name, emblem or logo to promote any unofficial/inappropriate product or program. 5) The Section/Branch must not use membership data that is older than thirty days. 6) Access to membership data is to be regulated by the person (account holder) signing this form The account holder assumes the responsibility of proper use of the information contained in the database, as stipulated in these rules. Information contained in the database may be shared with Section and/or Branch officers of the subscribing Section and/or Branch provided they are cognizant of and adhere to these rules. 7) ASCE shall not be liable for any damages or loss sustained as a result of the use or nonuse of the database records. SEEN AND ACKNOWLEDGED: SIGNATURE: NAME: SECTION: E-MAIL: DATE: BRANCH:
PLEASE PROVIDE INFORMATION REQUESTED ABOVE AND FAX SIGNED COPY OF THIS DOCUMENT TO: MICHAEL COOK – (703) 295-6141