Savannah College of Art and Design
Data Entry Standards Manual
Revised February 2005
The following guidelines were established by the Information Management Steering Committee. The standards are reviewed and revised annually. For comments or questions regarding this document or the standards within, contact the Office of Information Services.
Table Of Contents 1 2 3
4
5 6 7
General Data Entry……………………………………………………………………… Creating Records……………………………………………………………………….. Names…………………………………………………………………………………….. 3.1 General 3.2 Last Name 3.2.1 Punctuation 3.2.2 Spaces in Last Names 3.2.3 Generational Designators 3.3 First Name 3.4 Middle Name 3.5 Prefix 3.6 Suffix 3.7 Preferred First Name 3.8 Non-person Names (vendors) Addresses………………………………………………………………………………… 4.1 Street Address 4.2 Secondary Unit Indicators 4.3 Compass Directions 4.4 Special Address Information 4.4.1 Care Of 4.4.2 Post Office Box 4.4.3 Rural Route 4.4.4 Slashes and Fractions 4.5 City 4.6 State or Province Names 4.7 County Names 4.8 Postal/ZIP Codes 4.8.1 US ZIP Codes 4.8.2 Canadian Postal Codes 4.9 International Addresses 4.9.1 Nation Codes 4.10 Military Addresses Telephone Numbers…………………………………………………………………… 5.1 International Telephone Numbers Dates……………………………………………………………………………………… General Person Information………………………………………………………….. 7.1 Citizenship Type 7.2 Social Security Number 7.3 Date of Birth 7.4 Ethnicity Codes 7.5 Marital Codes 7.6 Legacy Codes
Data Entry Standards Manual Revised December 2004
Page 4 Page 4 Page 4
Page 6
Page 9 Page 9 Page 9
2
7.7
8
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
Confidential Information Indicator 7.7.1 Students 7.7.2 Employees 7.8 Veteran File Number 7.9 Deceased Information Appendix A: Searching the Database for Existing Records…………………….. 8.1 Wildcard Search 8.2 Alternate ID and Name Change Records 8.3 No Records Retrieved Appendix B: Name Prefix Samples…………………………………………………… Appendix C: Street Designator Abbreviations……………………………………… Appendix D: Secondary Unit Indicator Abbreviations……………………………. Appendix E: Compass Direction Abbreviations…………………………………… Appendix F: City Abbreviations………………………………………………………. Appendix G: Two-letter State, Possession and Province Abbreviations……... Appendix H: Nation Codes…………………………………………………………….. Appendix I: International Telephone Codes………………………………………… Appendix J: Address Type Codes……………………………………………………. Appendix K: Telephone Type Codes………………………………………………… Appendix L: Ethnicity Codes………………………………………………………….. Appendix M: Citizenship Type Codes……………………………………………….. Appendix N: Legacy Codes…………………………………………………………… Appendix O: Marital Codes……………………………………………………………. Appendix P: Banner Navigation……………………………………………………….
Data Entry Standards Manual Revised December 2004
Page 11
Page 12 Page 13 Page 14 Page 14 Page 15 Page 17 Page 18 Page 21 Page 33 Page 34 Page 35 Page 36 Page 37 Page 37 Page 38
3
1 General Data Entry All data is to be entered using upper and lower case, using appropriate English format. Do not enter data in all upper case or all lower case. All data is to be spelled out whenever possible. If it is necessary to abbreviate data due to field space constraints, use the approved abbreviations found in the appendices of this document. Do not ever use periods after abbreviations. The pound sign (#) and the percent sign (%) must not be used in a data field.
2 Creating Records An exhaustive search must be performed prior to creating any person or non-person records. This is extremely important so as not create duplicate records in the system. For more information about searching records, see Appendix A. A person or non-person (vendor) record is created in the Identification Form. Each module has a unique identification form. FORM NAME
BANNER MODULE
SPAIDEN PPAIDEN FTMVEND FOAIDEN APAIDEN
Student Human Resources Finance (‘Non-Person’ Vendors) Finance (‘Person’ Vendors) Alumni/Development
3 Names 3.1 General Every identifier (ID) in Banner has a name associated with it. The name is either the name of a person or the name of a non-person. Names are entered or changed on one of the Identification forms (different for each module). All names are entered using upper and lower case letters in appropriate English format.
3.2 Last Name Spell out the complete last name as the individual spells it. Banner displays 20 characters of the last name on forms, but stores up to 60 characters.
3.2.1 Punctuation Enter last names that contain hyphens, apostrophes, or other punctuation as the person does in writing. Spell the name with upper and lower case without adding additional spaces. Examples: Data Entry Standards Manual Revised December 2004
MacArthur, Smith-Jones, O’Kelly, FitzWallace, Al-Rashad, Al Hamadi 4
3.2.2 Spaces in Last Names Last names containing a separate word (such as Van, Von, Da, de, di) should be spelled as the person spells it. If the person uses a space between the prefix and the last name, insert a space. Examples:
De Martino, Van Gogh, de la Camp, van der Roem, Garza Martinez
3.2.2 Generational Designators Generational designators such as Jr, Sr, III, etc. should be included in the suffix field (see section 3.6).
3.3 First Name Spell the entire first name as the person does. Hyphens and apostrophes may be used. Banner allows 15 characters for a first name or a middle name. If the person uses a single character as a first name, place the single character in the first name field without a period.
3.4 Middle Name The middle name should be entered, if known, for identification purposes. If only the middle initial is known, enter it in the middle name field without a period.
3.5 Prefix A prefix should be entered in the prefix field when used by the individual. Never enter prefixes in the first name field. Salutations (such as Dr, Rev, Mr, Mrs, Ms, etc.) are considered prefixes. Salutations should not be combined (to address more than one person) in the prefix field. Prefixes are entered in upper and lower case letters without a period. See Appendix B for a sample list of prefixes. Examples:
Dr Mr Mrs Rev
(acceptable)
Mr and Mrs Mr & Mrs
(unacceptable
3.6 Suffix A suffix is a generational and/or professional designation that follows a name. A suffix should be entered in the suffix space, not as part of the last name. A suffix should be entered without periods. If a person has both a generational and professional designator, include both in the suffix field separated by a comma. Examples:
Data Entry Standards Manual Revised December 2004
Jr DDS Jr, DDS
Generational designator Professional designator Generational and Professional designator
5
3.7 Preferred First Name Enter a preferred name in the preferred first name field when it is provided by the individual, but only if different from the First Name.
3.8 Non-person Names (Vendors) All information should be entered using upper and lower case letters with the exception of acronyms. Companies who are recognized by acronyms should be entered using the acronym. Do not use spaces or punctuation between letters. Acronyms that are not popularly recognized should not be entered into the corporate entity name. Examples:
IBM
AT&T
The ampersand (&) can only be used when part of the formal name. In all other cases, use the word “and.” Example:
Baltimore & Ohio Railroad
Abbreviations are allowed for company (Co), corporation (Corp), incorporated (Inc) or limited (Ltd) when used after the name of a corporate entity. All other forms of abbreviations should not be used for corporate entities. Government offices, such as state and county agencies, should be entered with the state or county included in the vendor name. Each department or agency should be listed as a separate address sequence. Example: For State of Georgia Department of Revenue, enter “Georgia Department of Revenue “ as the name. The second line of the address can be used for additional name text if necessary.
4 Addresses Each Banner address will have a type associated with it. See Appendix J for a complete list of address types, descriptions, and special instructions for creating or updating addresses. Do not use the pound sign (#), or apostrophe (‘) in an address. These signs are formatting commands that can confuse the entered data.
4.1 Street Address Banner allows three lines for street address information. Use address line 1 for street address unless a PO Box is being entered along with a street address. Spell out the words Street or Road whenever possible. If the entry is too long, use the approved abbreviations listed in the abbreviations table in Appendix C.
4.2 Secondary Unit Indicators If the address is a multi-unit apartment or building, or other specially designated location, place the information to the right of the street address on address line 1. If first line of the address is too long for any unit designation, enter the unit designation on the first line of the address and the street on the second line. Abbreviations may be used to provide additional space. Examples:
Data Entry Standards Manual Revised December 2004
345 North Jones Street Apartment 4
(preferred)
6
456 North Wilksborough Blvd Apt 4
(acceptable)
Apartment 4 3045 North Wilksborough Boulevard
(acceptable)
3045 N Wilksborough Blvd #4
(unacceptable)
See Appendix D for the approved list of abbreviations for secondary unit indicators.
4.3 Compass Directions Compass directions used as part of the name of a street should be spelled out. If the compass direction identifies the geographic areas of the city, it should always be abbreviated. Abbreviate compound directions as two letters without a space. See the approved list of abbreviations in Appendix E. Examples:
1130 North Harrison Street 187 Washington Boulevard, NW
4.4 Special Address Information 4.4.1 Care Of In care of should be placed on address line 1 and abbreviated as c/o. Example:
John Smith c/o James Jones
4.4.2 Post Office Box Post Office Box information should be entered as follows. Abbreviate post office as PO with no periods and no spaces. Example:
PO Box 498
If an address contains both a PO Box and a street address, enter the PO Box on the line below the address. Addresses are read by the post office from bottom to top. Mail is delivered to the address immediately above the City, State and Zip Code line. Post office box numbers should be entered on address line 2. Street address should be entered on address line 1. Examples:
10 Downing Street PO Box 498 New York, NY 10001 (Mail will be delivered to P O Box) PO Box 498 10 Downing Street New York, NY 10001 (Mail will be delivered to street address)
4.4.3 Rural Route Route and box numbers should be entered on the same line. Abbreviate rural route as RR using no periods and no spaces. A comma should not be placed between the RR Number and the box number. Example:
Data Entry Standards Manual Revised December 2004
RR 2 Box 99
7
4.4.4 Slashes and Fractions Slashes may be used when a fraction is used in the address or in international addresses. Examples:
112 ½ Taylor Street 123/N54 Ping Hung Road
4.5 City Spell out city names whenever possible. If the city name provided by the person is different than the name provided by Banner from the zip code field, change the name of the city to match the person’s preference. For city names exceeding 20 characters, use the approved abbreviations listed in Appendix F. Do not enter Canadian Provinces in the city field. Canadian Provinces have their own codes in Banner. You must include the city in the city field and the province in the state field. Please see the appendix for additional information.
4.6 State or Province Names A state or province code is required for all US, Canadian, and Australian addresses, including US Possessions and Military. See Appendix G for a complete list of codes. Other international states or provinces may be entered to the right of the city. If there is not enough space for both the city and foreign state on the city line, enter the state in the city line and enter the city on the last line of the street address.
4.7 County Names County codes are not required, but will be entered by Banner if the zip code field was entered prior to the city, state, or county.
4.8 Postal Codes/ZIP Codes Zip codes must be entered for all US and Canadian addresses.
4.8.1 US ZIP codes For US addresses, enter the five (5) -digit zip codes. Enter the ZIP+4 information if that information is available. The following web site may be used to verify zip code information: http://zip4.usps.com/zip4/welcome.jsp
4.8.2 Canadian Postal Codes Canadian six (6) -digit postal codes are also entered in the zip code field. Do not add spaces or hyphens between characters.
4.9 International Addresses Enter information for international addresses only on address lines 1 and 2.
4.9.1 Nation Codes A nation code is required for all non-US addresses. Do not enter a nation code for US addresses. Click on the Nation button to select the appropriate code. If a nation is not listed, contact the Office of Information Services. See Appendix H for nation codes.
4.10 Military Addresses Enter the APO or AFO code in the city field.
Data Entry Standards Manual Revised December 2004
8
In the state field enter: AE – Europe, Middle East, Africa, Canada AP – Pacific AA – The Americas (excluding Canada)
[ZIP=09nnn] [ZIP=96nnn] [ZIP=34nnn]
5 Telephone Numbers Enter a telephone number in the space provided on the address form. As with each address, each telephone will have a type associated with it. See Appendix J for a complete list of telephone types and descriptions. Enter the full telephone number including the area code and when available, the extension. Do not use hyphens or parentheses to separate the numbers.
5.1 International Telephone Numbers By clicking on the flashlight to the right of the telephone field, you can access the telephone summary form called SPATELE. For international phone numbers, enter the international city and country codes in the field to the right of the telephone number field in the space provided. Do not enter city and country codes in the telephone number field. See Appendix I for a list of international country and city codes.
6 Dates Dates may be entered in various manners, but are displayed in the following format: dd-mon-yyyy. If the date you are entering is prior to 1950, enter the entire year or make sure the year defaults to 19 rather than 20. Examples:
1/1/99 11/12/87
becomes becomes
01-Jan-99 12-Nov-87
7 General Person Information All general person information is entered on the General Person Form (SPAPERS).
7.1 Citizenship Type Citizen type is required for all students and employees. Click on the Citizen button on the SPAPERS form for the available citizenship types. See Appendix M for citizenship codes.
7.2 Social Security Number A Social Security Number is required for all students that are US citizens and all employees. If international students have a social security number it should be entered as soon as it is known. If the Social Security Number is unknown or if the person refuses to provide it, leave the field blank.
7.3 Date of Birth The date of birth is required for all students and all employees.
7.4 Ethnicity Codes Ethnicity Codes should be entered for all students and employees whenever possible. Click on the Ethnic button on the SPAPERS form for all available ethnic codes. See Appendix L for a list of ethnicity codes.
7.5 Marital Codes When known, a person's marital status is entered. See Appendix O for a list of marital codes.
Data Entry Standards Manual Revised December 2004
9
7.6 Legacy Codes The Legacy Code identifies a relative or friend with whom the Savannah College of Art and Design has a relationship. For example, if a person's mother is an alumnus of the College, the legacy would be mother. Click on the Legacy button on the SPAPERS form for available options. See Appendix N for a list of legacy codes.
7.7 Confidential Information Indicator If a person wishes to have their information marked "confidential" this field is checked. When the confidential field (box) is checked, this denotes that the person does not want address and telephone number information released to the public.
7.7.1 Students Checking this field is optional for students. When the information is marked confidential, no directory information is to be released. If the confidentiality indicator is not marked, the only directory information that may be released is: Name Affirmation of enrollment status Dates and terms of attendance Major field of study Degrees earned
7.7.2 Employees Employee's information is always confidential whether the field is checked or not.
7.8 Veteran File Number The Veteran File Number is used to maintain a person's veteran identification number. This information is collected and maintained for students by the Registrar's Office.
7.9 Deceased Information If a person is deceased, check the Deceased box and enter the date of death in the Deceased Date box on SPAPERS.
Data Entry Standards Manual Revised December 2004
10
8 Appendix A: Searching the Database for Existing Records An exhaustive search should be performed prior to creating any person or non-person records. A minimum of three wildcard searches should be performed before creating new records. To search for a person or non-person access the appropriate Identification Form (different for each module, see table below), click on the flashlight to the right of the field. A box appears with a list of person and non-person options. Double-click the appropriate selection. A screen with search options is displayed. FORM NAME
BANNER MODULE
SPAIDEN PPAIDEN FTMVEND FOAIDEN APAIDEN
Student Human Resources Finance (‘Non-Person’ Vendors) Finance (‘Person’ Vendors) Alumni/Development
Enter as much information as you have to perform a search. At the bottom of the screen you can enable or disable case sensitivity. After entering the information, hit the F8 key to perform the search.
8.1 Wildcard Search There are many methods of searching for information in the database. A wildcard search may be useful in finding records in Banner, especially if you are unsure of how the data was originally entered in the system. To perform a wildcard search, use the wildcard symbol (%) to replace the part or parts of a name that are unknown. Examples: Search Criteria
Result
A% B%ll
All people whose name begins with an A Ball, Bell, Bill, Boll and Bull as well as those with multiple characters between the “B” and the “ll”, such as Berell. Fox and Foxworth, as well as anyone with a hyphenated name such as Jameson-Fox or FoxMorris. DeMarco, deMarco de Marco, di Marco, D’Marco or Saltinmarco.
%Fox%
%marco
8.2 Alternate ID and Name Change Records Some persons may appear multiple times in a search result. In the name change indicator column (labeled Chg), there may be an “I” or an “N” indicating a name change. If you select a record with one of these indicators, it will automatically direct you to the correct record for that person.
8.3 No Records Retrieved If the message “Query caused no records to be retrieved. Re-enter” appears in the bottom left of the Banner screen, there is no record matching your search criteria in the system. Search again using only part of the name with the wildcard (%), and continue reducing your search criteria until you are certain the person or non-person does not exist in the system.
Data Entry Standards Manual Revised December 2004
11
9 Appendix B: Name Prefix Samples The following list of prefixes is not exhaustive. Cmdr Col Cpt Dr Fr Gov Hon Judge Miss Mr Mrs Ms Pres Prof Rabbi Rep Rev Sen
Data Entry Standards Manual Revised December 2004
Commander Colonel Captain Doctor Father Governor Honorable Judge Miss Mister Mistress Miss or Madame President Professor Rabbi Representative Reverend Senator
12
10 Appendix C: Street Designator Abbreviations Alley .....................Aly Annex................. Anx Arcade ................ Arc Avenue............... Ave Basement......... Bsmt Bayou................. Byu Beach................. Bch Bend .................. Bnd Bluff...................... Blf Bluffs ...................Blfs Bottom ............... Btm Boulevard...........Blvd Branch .................. Br Bridge ................. Brg Brook .................... Br Brooks............... Brks Burg ..................... Bg Burgs ................. Bgs Bypass ............... Byp Camp ................... Cp Canyon .............. Cyn Cape .................. Cpe Causeway ........Cswy Center ..................Ctr Centers .............. Ctrs Circle.................... Cir Circles ................ Cirs Cliff....................... Clf Cliffs ................... Clfs Club .................... Clb Common ........... Cmn Corner .................Cor Corners ............. Cors Course .............. Crse Court ..................... Ct Courts ................. Cts Cove .................... Cv Coves................. Cvs Creek .................. Crk Crescent............ Cres Crest .................. Crst Crossing............ Xing Crossroad ........... Xrd Curve ................ Curv Dale ...................... Dl Dam .................... Dm Divide .................. Div Drive .....................Dr Drives.................. Drs Estate.................. Est Estates ...............Ests Expressway.......Expy Extension ............ Ext Extensions .........Exts Fall ......................Fall Falls .....................Fls Ferry ................... Fry Field .....................Fld Fields .................Flds Flat........................Flt
Data Entry Standards Manual Revised December 2004
Flats.................... Flts Ford .....................Frd Fords .................Frds Forest .................Frst Forge ...................Frg Forges ...............Frgs Fork .....................Frk Forks ................. Frks Fort ........................Ft Freeway............. Fwy Garden .............. Gdn Gardens........... Gdns Gateway ...........Gtwy Glen.................... Gln Glens .................Glns Green ................. Grn Greens.............. Grns Grove.................. Grv Groves.............. Grvs Harbor ................ Hbr Harbors............. Hbrs Haven .................Hvn Heights ................Hts Highway............. Hwy Hill .........................Hl Hills......................Hls Hollow............... Holw Inlet...................... Inlt Island..................... Is Islands .................. Isl Isle...................... Isle Junction ............... Jct Junctions ............Jcts Key .......................Ky Keys ................... Kys Knoll ....................Knl Knolls................. Knls Lake...................... Lk Lakes.................. Lks Land ................. Land Landing............. Lndg Lane ..................... Ln Light..................... Lgt Lights................. Lgts Loaf ....................... Lf Lock.................... Lck Locks .................Lcks Lodge ................. Ldg Loop ................. Loop Loops................ Loop Mall.................... Mall Manor .................Mnr Manors ............. Mnrs Meadow............ Mdw Meadows .........Mdws Mews ...............Mews Mill ........................ Ml Mills .................... Mls Mission .............. Msn Motorway ..........Mtwy
Mount ................... Mt Mountain ............ Mtn Mountains .........Mtns Neck................... Nck Orchard .............Orch Oval................... Oval Overpass..........Opas Park................... Park Parks................. Park Parkway ........... Pkwy Pass ................. Pass Passage ........... Psge Path................... Path Pike ................... Pike Pine.................... Pne Pines ................ Pnes Place ..................... Pl Plain .................... Pln Plains ................ Plns Plaza ................... Plz Point...................... Pt Points .................. Pts Port ......................Prt Ports................... Prts Prairie....................Pr Radial................ Radl Ramp .............. Ramp Ranch............... Rnch Rapid..................Rpd Rapids.............. Rpds Rest..................... Rst Ridge..................Rdg Ridges.............. Rdgs River.................... Riv Road ....................Rd Roads................. Rds Route ..................Rte Row................... Row Rue ....................Rue Run ....................Run Shoal................... Shl Shoals ............... Shls Shore ..................Shr Shores............... Shrs Skyway............. Skwy Spring................. Spg Springs............. Spgs Spur ..................Spur Square ................. Sq Squares.............. Sqs Station................. Sta Stravenue...........Stra Stream ..............Strm Street .................... St Streets................. Sts Summit............... Smt Terrace................ Ter Throughway ......Trwy Trace................. Trce Track ................. Trak
Trafficway ...........Trfy Trail.......................Trl Tunnel................Tunl Turnpike............Tpke Underpass ....... Upas Union ................... Un Unions ............... Uns Valley................... Vly Valleys ............... Vlys Viaduct.................Via View..................... Vw Views ................. Vws Village..................Vlg Villages .............. Vlgs Ville........................Vl Vista.....................Vis Walk.................. Walk Walks................ Walk Wall.................... Wall Way ...................Way Ways................ Ways Well.......................Wl Wells...................Wls
13
11 Appendix D: Secondary Unit Indicator Abbreviations Apartment ............................. Apt Basement.............................. Bsmt** Building ................................. Bldg Carriage House..................... Car Hse** Department ........................... Dept Floor...................................... Fl Front ..................................... Frnt** Garage.................................. Grge** Hangar .................................. Hngr Lobby .................................... Lbby** Lot......................................... Lot Lower .................................... Lowr** Office .................................... Ofc Penthouse............................. Ph** Pier ....................................... Pier Rear ...................................... Rear** Room .................................... Rm Side....................................... Side** Slip........................................ Slip Space.................................... Spc Stop ...................................... Stop Suite...................................... Ste Trailer.................................... Trlr Unit ....................................... Unit Upper .................................... Uppr** ** Does not require secondary range number to follow.
12 Appendix E: Compass Direction Abbreviations East.....................................E North .................................. N Northeast ......................... NE Northwest........................ NW South ..................................S Southeast......................... SE Southwest ....................... SW West...................................W
Data Entry Standards Manual Revised December 2004
14
13 Appendix F: City Abbreviations ALASKA Denali National Park
Denali Natl Park
ARIZONA Marine Corps Air Station Pinnacle Peak Village
MCAS Pinnacle Peak Vlg
ARKANSAS Hot Springs National Park Hot Springs Univ. of Ark. at Monticell Monticello CALIFORNIA California Hot Springs Commerce Contract Station El Toro Marine Corp Air Sta. Kings Canyon National Park La Canada Flintridge Lemoore Naval Air Station Palos Verdes Estates Palos Verdes Peninsula Rancho Santa Margarita Rolling Hills Estates Sequoia National Park Yosemite National Park
Calif Hot Springs Cmrc Cntr Sta El Toro MCAS Kings Cyn Natl Park La Canada Flntrdg Lemoore NAS Palos Verdes Ests Palos Verdes Penin Rcho Snta Marg Rllng Hills Ests Sequoia Natl Park Yosemite Natl Park
COLORADO Mesa Verde National Park United States A. F. Acad.
Mesa Verde USAF Acad
DELAWARE Dover Air Force Base
Dover AFB
FLORIDA Kennedy Space Center Lauderdale by the Sea Mayport Naval Station Naval Air Station Unit 2 Naval Coastal Systems Lab Naval Training Center Recruit Training Command Saint Augustine Beach Saint Augustine South St. Petersburg Beach Silver Springs Shores Town and Country Plaza University of West Florida University Collection Warm Mineral Springs West Panama City Beach Worthington Springs GEORGIA Airport Mail Facility Centerville-Gwinnett Chestnut Mountain Gwinnett Mall Corners Pine Mountain Valley
Data Entry Standards Manual Revised December 2004
Kennedy Sp Ctr Lauderdale By Sea Mayport Naval Stn NAS Unit 2 Naval Cstl Sys Lab Naval Trng Ctr Recruit Trng Cmd St August Bch St August South St Peters Bch Silver Spgs Shores Town and Cntry Plz Univ West Florida Univ Collection Warm Minl Spgs W Pan City Bch Worthington Spgs
Airport Mail Facil Ctrville-Gwinnett Chestnut Mtn Gwin Mall Corners Pine Mtn Valley
HAWAII Hawaii National Park
Hawaii Natl Park
IDAHO Mountain Home A.F. Base
Mtn Home AFB
ILLINOIS National Stock Yards
Natl Stock Yards
INDIANA Culver Military Academy Fort Benjamin Harrison Grissom Air Force Base Saint Mary-of-the-Woods
Culver Mil Acad Ft Benj Harrison Grissom AFB St Mary of Woods
KENTUCKY Cold Springs Highland Hts. Cold Spgs High Hts Mammoth Cave National Park Mammoth Cave MAINE West Boothbay Harbor
W Boothbay Hbr
MARYLAND Aberdeen Proving Grounds Cockeysville/Hunt Valley Dundalk-Sparrows Point Farney Keedy Mem. Home Lutherville-Timonium Patuxent River Naval Air Stn.
Aber Pvng Grds Cockyvle Hunt Vly Dundalk-Sparr Pt Farney Keedy Home Lutherville-Timon NAS Patuxent Riv
MASSACHUSETTS Incoming Mail Center North Village of Nagog Woods
O’Neill Bldg Vlg Nagog Woods
MICHIGAN Houghton Lake Heights
Houghton Lake Hts
MINNESOTA Duluth Federal Prison Inver Grove Heights Marine on St. Croix South International Falls
Duluth Fed Prison Inver Grove Hts Marine St Croix South Inatl Falls
MISSISSIPPI Stennis Space Center
Stennis Space Ctr
MONTANA White Sulpher Springs
White Sulpher Spgs
NEW JERSEY Cape May Court House Point Pleasant Beach
Cape May CH Pt Pleasant Bch
NEW MEXICO High Rolls Mountain Park Holloman Air Force Base Truth or Consequences White Sands Missile Range
High Rolls Mtn Park Holloman AFB Truth or Consequen White Sands
15
NEW YORK Farmersville Station Port Jefferson Station Shelter Island Heights Thousand Island Park Veterans Administration
Farmersville Sta Port Jefferson Sta Shelter Island Hts Thousand Is Park Veterans Admin
NORTH CAROLINA Black Mountain Sanatorium Gardner Webb College RDU International AMF Research Triangle Park Seymour Johnson A F B
Black Mtn Sanator Gardner Webb Coll RDU Inatl ADF Res Triangle Park Johnson AFB
OHIO Colonial Flower Shop Lakeside-Marblehead Washington Court House
Colnl Flower Shop Lksd Marblehead Washington CH
OREGON Mount Hood-Parkdale
Mt Hood Parkdale
PENNSYLVANIA Columbia Cross Roads Greater Pittsburgh Airport Mount Pleasant Mills Pennsylvania Furnace Pocono Lake Preserve Veterans Administration Hosp.
Columbia X Rds Gr Pittsburgh Airpt Mt Pleasant Mills Pa Furnace Pocono Lk Preserve Veterans Adm Hosp
TENNESSEE Naval Air Station Memphis
NAS Memphis
TEXAS Big Bend National Park Wilford Hall U.S.A.F. Hosp.
Big Bend Natl Park Hall USA Hosp
Data Entry Standards Manual Revised December 2004
VERMONT East Saint Johnsbury Hartland Four Corners Saint Johnsbury Center White River Junction
E St Johnsbury Hartland Four Crns St. Johnsbury Ctr White River Jct
VIRGINIA Charlotte Court House King and Queen Court House Natural Bridge Station Naval Amphibious Base Naval Weapons Station Rappahannock Academy Virginia State University Washington’s Birthplace
Charlotte CH King and Queen CH Natural Bridge Sta Naval Amphib Base Naval Wpns Sta Rappahannock Acad Virginia State Univ Washgtn’s Brthpl
WASHINGTON Fairchild Air Force Base Fairchild AFB Spokane International Airport Spokane Inatl Apt Whidbey Island Naval Air Sta. Whidbey Is NAS WEST VIRGINIA Green Sulphur Springs Newton D. Baker V.A. Center Nutter Fort Stonewood White Sulphur Springs
Green Sulphur Spgs Baker VA Center Stonewood White Sulphur Spgs
WISCONSIN Howards Grove Millersville
Millersville
WYOMING Yellowstone National Park
Yellwstn Natl Park
16
14 Appendix G: Two-letter State, Possession and Province Abbreviations MILITARY APO/AFO Americas............................AA APO/AFO Europe, Middle East, Canada and Africa...........................AE APO/AFO Pacific ................................AP AUSTRALIAN STATES Australian Capital Territory .............. ACT New South Wales ...........................NSW Queensland .....................................QLD South Australia ...................................SA Tasmania ......................................... TAS Victoria.............................................. VIC CANADIAN PROVINCES Alberta ................................................AB British Columbia................................. BC Manitoba ............................................ MB New Brunswick .................................. NB Newfoundland and Labrador ..............NL Northwest Territories ......................... NT Nova Scotia ....................................... NS Nunavat ............................................. NU Ontari ON Prince Edward Island..........................PE Quebec ..............................................QC Saskatchewan ....................................SK Yukon Territory ...................................YT US STATES Alabama.............................................. AL Alaska .................................................AK Arkansas............................................ AR Arizona................................................AZ California............................................ CA Colorad CO Connecticut........................................ CT Delaware............................................ DE District of Columbia ........................... DC Florida................................................. FL Georgia .............................................. GA Hawaii ..................................................HI Idah ID Illinois................................................... IL Indiana .................................................IN Iowa ..................................................... IA Kansas................................................KS
Data Entry Standards Manual Revised December 2004
Kentucky ............................................ KY Louisiana.............................................LA Maine .................................................ME Maryland ........................................... MD Massachusetts ...................................MA Michigan.............................................. MI Minnesota ......................................... MN Mississippi..........................................MS Missouri............................................. MO Montana .............................................MT Nebraska............................................ NE Nevada............................................... NV New Hampshire .................................NH New Jersey .........................................NJ New Mexic NM New York ........................................... NY North Carolina....................................NC North Dakota......................................ND Ohi OH Oklahoma...........................................OK Oregon ...............................................OR Pennsylvania...................................... PA Rhode Island....................................... RI South Carolina ................................... SC South Dakota ..................................... SD Tennessee ......................................... TN Texas ................................................. TX Utah ................................................... UT Vermont ............................................. VT Virginia ............................................... VA Washington ....................................... WA West Virginia..................................... WV Wisconsin............................................WI Wyoming ........................................... WY US POSSESSIONS American Samoa ............................... AS Canal Zone ........................................ CZ Federated Micronesia ........................FM Guam .................................................GU North Mariana Islands........................MP Marshall Islands ................................ MH Palau Islands .................................... PW Puerto Ric PR Trust Territories...................................TT Virgin Islands .......................................VI
17
15 Appendix H: Nation Codes 300 1 2 3 204 4 5 301 222 6 7 170 171 221 8 9 172 302 11 303 304 12 13 225 223 14 15 16 173 17 18 305 175 19 306 20 197 21 22 158 23 24 25 26 27 307 28 176 29 30 31 32 308 309
Abu Dhabi Afghanistan Albania Algeria American Samoa Andorra Angola Anguilla Antartica Antigua and Barbuda Argentina Armenia Aruba Ashmore and Cartier Islands Australia Austria Azerbaijan Azores Bahrain Baker Island Balearic Islands Bangladesh Barbados Bassa Da India Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnia-Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory Brunei Darussalam Bulgaria Burkina Faso Burma (Myanmar) Burundi Cambodia Cameroon Canada Canary Islands Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Clipperton Island
Data Entry Standards Manual Revised December 2004
310 34 35 36 311 312 313 37 75 177 38 314 39 40 41 42 43 44 315 381 45 46 47 316 48 380 179 49 317 318 319 50 51 52 379 378 377 53 54 320 180 181 57 376 321 58 322 59 203 60 61 323 375 374
Cocos (Kelling) Islands Colombia Comoros Congo Cook Islands Coral Sea Islands Territory Corsica Costa Rica Cote D Ivoire Croatia Cuba Curacao Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic Dubai East Timor Ecuador Egypt El Salvador Eleuthera Island Equatorial Guinea Ertrea Estonia Ethiopia Europa Island Falkland Islands Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern/Antartic Lands Gabon Gambia Gaza Strip Georgia Germany Ghana Gibraltar Glorioso Islnds Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau
18
63 64 324 65 183 325 66 67 68 69 70 71 72 326 73 74 76 327 77 328 329 330 78 331 373 79 332 80 333 334 83 184 84 185 85 86 87 88 89 186 90 372 371 91 92 93 94 95 96 335 336 97 98 337 99 338
Guyana Haiti Heard/McDonald Islands Honduras Hong Kong Howland Island Hungary Iceland India Indonesia Iran (Islamic Republic of) Iraq Ireland Isle of Man Israel Italy Jamaica Jan Mayen Japan Jarvis Island Jersey Johnston Atoll Jordan Juan de Nova Island Kazakhstan Kenya Kingman Reef Kiribati Kosovo Kurile Kuwait Kyrgyzstan Lao People Democratic Republic Latvia Lebanon Lesotho Liberia Libyan Arab Jamahiriya Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia, Federated States of
Data Entry Standards Manual Revised December 2004
339 370 100 101 340 187 102 103 226 104 224 105 106 188 369 107 108 109 110 368 341 81 342 111 112 113 343 344 114 115 345 116 117 118 346 119 120 347 121 348 349 122 154 123 350 124 125 126 127 128 353 129 130 190 131 132
Midway Islands Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Namibia Nauru Navassa Island Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island North Korea Northern Island Norway Oman Pakistan Palau Palmyra Atoll Panama Papua New Guinea Paracel Islands Paraguay Peru Philippines Pitcairn Island Poland Portugal Puerto Rico Qatar Redonda Reunion Romania Russian Federation Rwanda Ryukyu Islands Saint Kitts and Nevis Saint Lucia Saint Vincent and Grenadines San Marino Sao Tome and Principe Sarawak Saudi Arabia Senegal Serbia Seychelles Sierra Leone 19
133 191 192 134 135 136 354 82 137 355 138 351 352 139 140 356 141 142 143 144 194 367 145 146 10 147 357 148 358 149
Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia South Korea Spain Spratly Islands Sri Lanka St. Helena St.Pierre and Miquelon Sudan Suriname Svalbard (Spitsbergen) Swaziland Sweden Switzerland Syrian Arab Republic Taiwan Tajikistan Tanzania Thailand The Bahamas Togo Tokelau Tonga Tortola Trinidad and Tobago
Data Entry Standards Manual Revised December 2004
359 150 151 193 220 152 153 195 155 156 157 159 360 160 361 161 162 206 214 362 366 363 365 163 364 196 166 167 168 169
Tromelin Island Tunisia Turkey Turkmenistan Turks and Caicos Island Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States of America Uruguay Uzbekistan Vanuatu Vatican City Venezuela Viet Nam Virgin Islands (British) Virgin Islands (U.S.) Wake Island Wallis and Futuna West Bank Western Sahara Western Samoa Windward Island Yemen Yugoslavia Zaire Zambia Zimbabwe
20
16 Appendix I: International Telephone Codes Afghanistan 93 Albania 355 Algeria 213 Algiers 2 Annaba 8 Constantine 4 Essenia 6 Oran 6 American Samoa 684 Andorra 376 Angola 244 Anguilla 809 Antarctica 672 Antigua and Barbuda 1 268 Argentina 54 Azul 281 Bahia Blanca 91 Buenos Aires 1 Chilvilcoy 341 Comodoro Rivadavia 967 Cordoba 51 Corrientes 783 La Plata 21 Las Flores 244 Mar Del Plata 23 Medoza 61 Merio 220 Moreno 228 Posadas 752 Resistencia 722 Rio Cuarto 586 Rosario 41 San Juan 64 San Rafael 627 Santa Fe 42 Tandil 293 Villa Maria 531 Armenia 374 Ashtarak 43 Yerevan 2 Aruba 297 All Points 8 Ascension 247 Australia 61 Adelaide 8 Albury 60 Alice Springs 89 Armidale 67 Ballerat 53 Brisbane 7 Cairns 70 Canberra 62 Darwin 89 Geelong 52 Gold Coast 75 Hamilton 55 Hobart 02 Launceston 03 Melbourne 39 Mildura 50
Data Entry Standards Manual Revised December 2004
Newcastle 49 Perth 9 Sydney 2 Toowoomba 76 Townsville 77 Wollongong 42 Austria 43 Baden Bei Wien 2252 Badgastein 6434 Graz 316 Horn 2982 Innsbruck 512 Kitzbuehel 5356 Klagenfurt 4222 Klosterneuburg 2243 Krems An Der Donau 2732 Linz 70 Linz Donau 732 Lofer 6588 Neunkirchen Niederosterreich 2635 Salzburg 662 Sankt Polten 2742 Thuringen 5550 Velden Am Wother See 4274 Vienna 1 Weis 7242 Zell Am See 6542 Azerbaijan 994 Baku 12 -BBahamas 1 242 Bahrain 973 Bangladesh 880 Chittagong 31 Dhaka (Dacca) 2 Khulna 41 Rangpur 521 Barbados 1 246 Belarus 375 Brest 162 Minsk 172 Novopolotsk 2144 Sosny 172 Belgium 32 Antwerp 3 Bruges 50 Brussels 2 Charleroi 71 Ghent 9 Hasselt 11 Knokke 50 Kortrijk 56 La Louviere 64 Leuven 16 Libramont 61 Liege 4 Malines 15
Mons 65 Namur 81 Oostende 59 Verviers 87 Waregem 56 Belize 501 Belize City 2 Belmopan 8 Corozal Town 4 Orange Walk 3 Benin 229 Bermuda 1+441 or 809 Bhutan 975 Bolivia 591 Cochabamba 42 La Paz 2 Santa Cruz 33 Bosnia and Herzegovina 387 Sarajevo 71 Botswana 267 Brazil 55 Aracajú 79 Belem 91 Belo Horizonte 31 Boa Vista 95 Botucatu 14 Brasilia 61 Campinas 19 Campo Grande 84 Canoas 51 Cuiabá 65 Curitiba 41 Diadema 11 Florianópolis 48 Fortaleza 85 Goiania 62 Guarulhos 11 João Pessoa 83 Juiz de Fora 32 Jundiai 11 Londrina 43 Macapá 96 Maceió 82 Manaus 92 Natal 84 Niteroi 21 Nova Hamburgo 51 Palmas 63 Paranagua 41 Pelotas 532 Porto Alegre 51 Porto Velho 69 Recife 81 Ribeirao Preto 16 Rio de Janeiro 21 Salvador 71 Santo Andre 11 Santos 13 São Bernardo do Campo 11 São Jose dos Campos 12
21
São Luiz 98 São Paulo 11 Teresina 86. Vitoria 27 British Virgin Islands 284 Brunei 673 Bandar Seri Behawan 2 Kuala Belait 3 Tutong 4 Bulgaria 359 Burgas 56 Cherven Bryag 659 Gabrovo 66 Pleven 64 Plovdiv 32 Ruse 82 Shoumen 2 Sofia 2 Varna 52 Burkina Faso 226 Burundi 257 -CCambodia 855 Cameroon 237 Bahenda 36 Buea 32 Veliko Turnovo 62 Yaounde 23 Canada 1 Alberta 403 British Columbia 250 Vancouver and the Lower Mainland 604 Victoria (and the rest of the province) 250 Manitoba 204 New Brunswick 506 Newfoundland 709 Nova Scotia 902 Prince Edward Island 902 Ontario Fort William 807 Hamilton 905 London 519 Kingston 613 Mississauga 905 North Bay 705 Ottawa 613 Sault Ste. Marie 705 Thunder Bay 807 Toronto 416 Windsor 519 Quebec Montreal 514 Montreal Surburban 450 Quebec City 418 Sherbrooke 819 Trois-Rivieres 819 Saskatchewan 306
Data Entry Standards Manual Revised December 2004
The Northwest Territories 819, 867 and 403 Yukon 403, 867 Cape Verde Islands 238 Cayman Islands 345 Central African Republic 236 Chad 235 Chatham Island (New Zealand) 64 Chile 56 Antofagasta 55 Arica 58 Calama 56 Chiquayante 41 Concepcion 41 Iquique 57 Penco 41 Puerto Montt 65 Punta Arenas 61 Rancagua 72 Tecreo 31 San Bernardo 2 Santiago 2 Talca 71 Talcahuano 41 Temuco 45 Valparaiso 32 Vina Del Mar 32 China 86 Anqing 556 Anshan 412 Baicheng 436 Baoan Xian 755 Baoding 312 Baoji 917 Beihai 779 Beijing (Peking) 10 Bengbu 552 Cangzhou 317 Changchun 431 Changde 736 Changle 5041 Changsha 731 Changzhou 519 Chaoyang 7644 Chaozhou 7681 Chengde 314 Chengdu 28 Chongan 5098 Chongqing 811 Conghua 2092 Dagang 22 Dalian 411 Dandong 415 Daqing 4610 Deyang 8241 Dongguan 7620 Foshan 757 Fuding 5033 Fuxin 418 Fuzhou 591 Gaoming 7650
Gongzhuling 438 Guangzhou 20 Guilin 773 Guiyang 851 Gutian 5037 Haikou 750 Handan 310 Hangu 22 Hangzhou 571 Hankou 27 Harbin 451 Hefei 551 Hengshui 318 Hengyang 734 Hepu 7892 Heshan 7680 Huanggang 713 Huangshi 714 Huaxian 20 Huian 5051 Huizhou 752 Huzhou 572 Jiamusi 454 Jiangmen 7682 Jianou 5094 Jianyang 590 Jiaxing 573 Jilin 432 Jinan 531 Jinhua 579 Jining 537 Jinjiang 595 Jinzhou 416 Kaifeng 378 Kaiping 7658 Kunming 871 Langfang 316 Lanzhou 931 Lianyungang 518 Liaoyang 419 Liaoyuan 437 Lishui 578 Liuzhou 772 Longgang 755 Longhai 5062 Longyan, Fujian 597 Luoyang 379 Luzhou 8400 Maanshan 555 Mawei 591 Meizhou 753 Mianyang 816 Minqing 5046 Mudanjiang 453 Nanan 5053 Nanching 791 Nanchong 817 Nanjing 25 Nanning 771 Nanping 599 Nantong 513 Nantou 755
22
Nanyang 377 Ningbo 574 Ningde 593 Panjin 4271 Panyu 2096 Pingdingshan 375 Pingtan 5043 Pucheng 5091 Puning 7649 Putian 594 Qingdao 532 Qinhuangdao 335 Qinzhou 777 Quanzhou 595 Quzhou 570 Sanming 598 Sanshui 7652 Shanghai 21 Shangqiu 370 Shantou 754 Shaoguan 751 Shaowu 5096 Shaoxing 575 Shaxian 5081 Shekou 755 Shenyang 24 Shenzhen 755 Shijiazhuang 311 Shishi 595 Shuangcheng 4615 Shunde 7653 Sihui 7663 Siping 434 Suihua 455 Suxian 557 Suzhou 512 Taian 538 Taiyuan 351 Taizhou 576 Tanggu 22 Tangshan 315 Tianjin 22 Tianshui 938 Tieling 410 Tongan 5021 Tonghua 435 Urumqi 991 Weifang 536 Wenjiang 815 Wenzhou 577 Wuhan 27 Wuhu 553 Wuxi 510 Xiamen 592 Xi'an 29 Xiangtan 732 Xiaogan 712 Xiaolan 7654 Xiapu 5034 Xichang 834 Xingtai 319 Xinhui 7656
Data Entry Standards Manual Revised December 2004
Xining 971 Xinxiang 373 Xuchang 374 Xuzhou 516 Yanan 911 Yancheng 515 Yangzhou 514 Yanji 433 Yantai 535 Yibin 831 Yinchuan 951 Yiyang 737 Yongan 5084 Yongzhou 7401 Yueyang 730 Yulin 755 Zhangjiakou 313 Zhangpu 5063 Zhangzhou 596 Zhanjiang 759 Zhaoqing 758 Zhengzhou 371 Zhenjiang 511 Zherong 5032 Zhongshan 7654 Zhuhai 756 Zhuzhou 733 Zibo 533 Zigong 813 Christmas Island 672 Cocos Islands 672 Colombia 57 Armenia 60 Barranquila 53 Bogota 1 Bucaramanga 76 Cali 2 Cartagena 59 Cartago 66 Cucuta 70 Giradot 832 Ibague 82 Manizales 69 Medellin 4 Neiva 80 Palmira 31 Pereira 61 Santa Marta 56 Villavicencio 86 Comoros 269 Congo 242 Cook Islands 682 Costa Rica 506 Croatia 385 Bakar 51 Dubrovnik 20 Pula 52 Rijeka 51 Split 21 Varazdin 42 Zadar 23 Zagreb 1
Cuba 53 Cyprus 357 Famagusta 3 Larnaca 4 Limassol 5 Nicosia 2 Paphos 6 Czech Republic 420 Breclav 2067 Brno 5 Havirov 6994 Hlucin 69 Karlsbad 17 Liberec 48 Olomoue 68 Ostrava 69 Pilsen 19 Prague 2 Zlin 67 -DDenmark 45 Diego Garcia 246 Djibouti 253 Dominica 767 Dominican Republic 809 -EEaster Island 56 Ecuador 593 Ambato 2 Cayambe 2 Cuenca 7 Esmeraldas 2 Guayaquil 4 Ibarra 3 Loja 7 Machachi 2 Machala 4 Manta 4 Portoviejo 4 Quevedo 4 Quito 2 Salinas 4 Santo Domingo 2 Tulcan 2 Egypt 20 Alexandria 3 Aswan 97 Asyut 88 Benhas 13 Cairo 2 Damanhour 45 El Mahallah 43 El Mansoura 50 Luxor 95 Mahalah El Kobra 43 Port Said 66 Oena 96 Shebin El Kom 48
23
Sohag 93 Suez 62 Tanta 40 El Salvador 503 Equatorial Guinea 240 Eritrea 291 Estonia 372 Haapsalu 47 Jõgeva 77 Kärdla 46 Kohtla-Järve 33 Kuressaare 45 Narva 35 Paide 38 Pärnu 44 Põlva 79 Rakvere 32 Rapla 48 Sillamäe 39 Tallinn 2 (variable) Tartu 7 Valga 76 Viljandi 43 Võru 78 Ethiopia 251 Addis Adaba 1 Assab 3 Dire Dawa 5
Biarritz 559 Bordeaux 556 Cannes 493 Cherbourg 233 Corsica 495 Grenoble 476 Le Havre 235 Lille 320 Lourdes 562 Lyon 472-478 Marseille 491 Montpellier 467 Nantes 240 Nice 493 Paris 1 Reims 326 Rouen 235 St. Etienne 477 St. Tropez 494 Strasbourg 388 Toulon 494 Toulouse 561 Tours 247 Vichy 470 French Antilles 596 French Guyana 594 French Polynesia 689 Fyrom (Macedonia) 389 Skopje 91
-F-GFalkland Islands 500 Faroe Islands 298 Fiji 679 Finland 358 Espoo-Esbo 9 Forssa 3 Helsinki 9 Joensuu 13 Jyvaskyla 14 Kajaani 8 Kemi 16 Kotka 5 Kuopio 17 Kuusamo 8 Lahti 3 Lappeenranta 5 Mariehamn 18 Mikkeli 15 Oulu 8 Pori 2 Rovaniemi 10 Savonlinna 15 Tammefors 3 Tampere 3 Turku 2 Uleaborg 8 Vassa 6 Vanda, Vanta 9 Varkaus 17 France 33 Aix-En-Provence 442
Data Entry Standards Manual Revised December 2004
Gabon 241 Gambia 220 Georgia 995 Germany 49 Achim 241 Augsberg 821 Baden-Baden 7221 Bayreuth 921 Berlin 30 Bonn 228 Bremen 421 Bremerhaven 471 Cologne (Koln) 221 Dortmund 231 Dresden 351 Dussledorf 211 Essen 201 Frankfurt 69 Friedrichshafen 7541 Hamburg 40 Hanover 511 Heidelberg 6221 Hof 9281 Karlsruhe 721 Kassel 561 Kiel 431 Koblenz 261 Leipzig 341 Magdeburg 391 Muenster 6071
Munich 89 Nurnberg 911 Oberhausen 208 Pforzheim 7231 Solingen 212 Stuttgart 711 Trier 651 Wiesbaden 611 Wuerzburg 931 Ghana 233 Accra 21 Koforidua 81 Kumasi 51 Tamale 71 Gibraltar 350 Greece 30 Alexandroupolis 551 Argos 751 Athens 1 Chania, Crete 821 Corfu 661 Corinth 741 Crete 821 Elevsis 1 Heraklion 81 Hydra 298 Kalamata 721 Kavala 51 Kos 242 Larissa 41 Mikonos Island 289 Milos 287 Mytilene 251 Patras 61 Piraeus 1 Rhodes 241 Salonika 31 Samos Island 273 Skiathos 424 Sparta 731 Thessaloniki 31 Tripolis 71 Volos 421 Zagora 426 Greenland 299 Grenada and Carriacuou 473 Grenadin Islands 784 Bequia Mustique Palm Island Union Island Guadeloupe 590 Guam 671 Guantanamo Bay 53 All Points 99 Guatemala 502 Antigua 9 Guatemala City 2 Quezaltenango 9 Guiana 594 Guinea 224
24
Guinea-Bissau 245 Guyana 592 Bartica 5 Georgetown 2 New Amsterdam 3 -HHaiti 509 Honduras 504 Hong Kong 852 Hungary 36 Abasar 37 Balatonaliga 84 Budapest 1 Debrecan 52 Dorgicxe 80 Fertoboz 99 Gyongyos 37 Gyor 96 Kaposvar 82 Kazincbarcik 48 Komio 72 Miskolc 46 Nagulamsozsa 93 Szekesfehervar 22 Szeged 62 Szolnok 56 Varpalota 80 Veszprem 80 Zalaegerszeg 92 -IIceland 354 India 91 Ahmedabad 79 Amristsar 183 Bangalore 80 Baroda 265 Bhopal 755 Bombay 22 Calcutta 33 Chandigarh 172 Delhi 11 Hyderabad 40 Jaipur 141 Jullundur 181 Kanpur 512 Madras 44 New Delhi 11 Poona 212 Surat 261 Indonesia 62 Ambona 911 Balikpapan 542 Bandung 22 Blitar 342 Cipanas 255 Cirebon 231 Denpasar 361 Jakarta 21
Data Entry Standards Manual Revised December 2004
Jayapura 967 Kupang 391 Madiun 351 Malang 341 Medan 61 Padang 751 Palembang 711 Semarang 24 Solo city 271 Surabaya 31 Tanjungkarang 721 Yogyakarta 274 Inmarsat: East Atlantic Ocean 871 Indian Ocean 873 Pacific Ocean 872 West Atlantic Ocean 874 Iran 98 Isfahan 31 Mashhad 51 Tabriz 41 Tehran 21 Iraq 964 Ireland 353 Arklow 402 Cork 21 Dingle 66 Donegal 73 Drogheda 41 Dublin 1 Dundalk 42 Ennis 65 Galway 91 Kildare 45 Kilkenny 56 Killarney 64 Limerick 61 Sligo 71 Tipperary 62 Tralee 65 Tullamore 506 Waterford 51 Wexford 53 Israel 972 Acre 4 Afula 6 Arad 7 Ariel 3 Ashdod 8 Ashkelon 7 Azur 3 Bat Yam 3 Beer Sheva 7 Beit Shean 6 Beit Shemesh 2 Bnei Brak 3 Carmiel 4 Dimona 7 Eilat 7 Even Yehuda 9 Givatayim 3 Hadera 6
Haifa 4 Herzliya 9 Hod Hasharon 9 Holon 3 Jerusalem 2 Karkur 6 Kfar Saba 9 Kiryat Ata 4 Kiryat Bialik 4 Kiryat Gat 7 Kiryat Malachi 8 Kiryat Motzkin 4 Kiryat Ono 3 Kiryat Shmona 6 Kiryat Tivon 4 Kiryat Yam 4 Lod 8 Maale Adumim 2 Maalot Tarshiha 4 Mevasseret Zion 2 Mount Carmel 2 Nahariya 4 Nazereth 6 Nes Ziona 8 Netanya 9 Netivot 7 Or Akiva 6 Pardes Hana 6 Petah Tikva 3 Raanana 9 Ramle 8 Ramat Gan 3 Ramat Hasharon 3 Rehovot 8 Rishon Lezion 3 Rosh Haayin 3 Safed 6 Tel Aviv-Jaffa 3 Tiberias 6 Yavne 8 Zichron Yaacov 6 Italy 39 Bari 80 Bergamo 35 Bologna 51 Brindisi 831 Cagliari 70 Capri 81 Catania 95 Como 31 Florence 55 Genoa 10 Messina 90 Milan 2 Modena 59 Naples 81 Padova 49 Palermo 91 Pantelleria 923 Perugia 75 Pescara 85 Pisa 50
25
Pompei 81 Portofino 185 Reggio Clabria 965 Rome 6 Sorrento 81 Sondrio 342 Taranto 99 Triesto 40 Turin 11 Vatican City 6 Venice 41 Verona 45 Vicenza 444 Ivory Coast 225 -JJamaica 876 Japan 81 Aichi 562 Akita 188 Amagasaki 6 Chiba 472 Chuoko 3 Fuchu 423 Fukuoka 92 Gifu 582 Hiroshima 82 Kagoshima 992 Kanagawa 44 Kawasaki 44 Kobe 78 Kochi 888 Kyoto 75 Mitatoku Tokyo 3 Miyazaki 985 Nagasaki 958 Nagoya 52 Naha (Okinawa) 988 Niigata 25 Nishinomiya 798 Okayama 862 Osaka 6 Saitamatan 48 Sapporo 11 Sasebo 956 Sendai 22 Tachikawa 425 Takamatsu 878 Tokyo 3 Toyama 764 Toyota 565 Yokohama 45 Yokosuka 468 Jerusalem 2 Jordan 962 Al-sareeh 2 Amman 6 Aqaba 3 Irbid 2 Jerash 4 Karak 3
Data Entry Standards Manual Revised December 2004
Matraq 6 Ramtha 2 Zargu 9 -KKazakhstan 7 Almaty 327 Karaganda 3212 Kustanay 3142 Shymkent 3252 Zhezkazgan 3102 Kenya 254 Busia 321, 366 Eldorel 321 Kajiado 301 Kisumu 35 Maseno 35 Mombasa 11 Nairobi 2 Nakuru 37 Kiribati 686 South Korea 82 Anyang 343 Cheju 64 Chungju 441 Gumi 546 Icheon 336 Inchon 32 Jeonju 52 Kwangju 62 Kyonggi-do 2 Masan 55 Osan 339 Pohang 562 Pusan 51 Seongnam 2 Seoul 2 Suwon 331 Taegu 53 Ulsan 522 Wonju 371 Kuwait 965 Safat 252, 5 Kygyzstan 996 Bishkek 2 Karakol 31922 Osh 3322 -LLaos 856 Latvia 371 Jelgava 30 Liepajas Rajons 34 Riga 2 if the number only contains 6 digits. Valmiera 42 Lebanon 961 Ajaltoun - Keserwan 09 Aley 05
Baabdat 04 Bartoun - North 06 Beirut 01 Beit Mery 04 Bhamdoun 05 Bikfaya - Metn 04 Broumana 04 Faraya 09 Jounieh 09 Jubail 09 North Bartoun 06 Saidon 07 South Tyre 07 Tripoli 06 Tyre - South - 07 Zahle - Bekaa 08 Zghorta 06 Zouk Mikael 9 Mobile (Cellular) 03 Lesotho 266 Liberia 231 Libya 218 Benghazi 61 Misurata 51 Tripoli 21 Zawia 23 Liechtenstein 41 All Points 75 Lithuania 370 Klaipeda 61 Kaunas 7 Vilnius 2, 122 Luxembourg 352 Diedrich 45 Han/Lesse 84 Howard 352 Kirchberg 352 Plateau de Kirchberg 352 Rameldange 352 -MMacau 853 Macedonia, Federal Republic of 389 Bitola 97 Gostivar 94 Ohrid 96 Prilep 98 Skopje 1, 91 Strumica 902 Tetova 94 Madagascar 261 Malawi 265 Domasi 531 Malaysia 60 Alor Setar 4 Baranang 3 Cheras 3 Degil 3 Ipoh 5 Joho Baharu 7
26
Kajang 3 Kepala Betas 4 Kuala Lumpur 3 Kuala Terengganu 96 Machang 97 Malacca 6 Maran 95 Palau Pinang 4 Penang 4 Petaling Jaya 3 Port Dickson 6 Sclangor 3 Semenyih 3 Seremban 6 Serlang 3 Shah Alan 3 Sungei Besi 3 Sungei Renggam 3 Sungei 07 Tawau, Sabah 89 Maldives 960 Mali 223 Malta 356 Valletta 626 Mariana Islands 670 Marshall Islands 692 Martinique 596 Mauritania 222 Mauritius 230 Mayotte 269 Mexico 52 Acapulco 74 Cancun 988 Celaya 461 Chihuahua 14 Ciudad Juarez 16 Cozumel 987 Culiacan 671 Guadalajara 3 Hermosillo 621 La Paz 682 Mazatlan 678 Merida 99 Mexicali 65 Mexico City 5 Monterrey 83 Puebla 22 Puerto Vallarta 322 San Luis Potosi 481 Tampico 121 Tecate 665 Tijuana 66 Torreon 17 Veracruz 29 Micronesia, Federated States 691 Midway Islands 808 Miquelon 508 Moldova 373 Chisinau 2 Monaco 377 All Points 93
Data Entry Standards Manual Revised December 2004
Mongolia 976 All Points 1 Montserrat 664 Morocco 212 Casablanc 2 Marrakech 44 Rabat 7 Tangiers 99 Mozambique 258 Myanmar 95 -NNamibia 264 Keetmanshoop 631 Tsumeb 671 Windhoek 61 Nauru 674 Nepal 977 Netherlands 31 Amsterdam 20 Arnhem 85 Breda 76 Delft 15 Dordrecht 78 Eindhoven 40 Enschede 53 Gouda 1820 Groningen 50 Haarlem 23 Heemstede 23 Heerlen 45 Hillegersberg 10 Hilversum 35 Hoensbroek 45 Hoogkerk 50 Hoogvliet 10 Leeuwarden 58 Leiden 71 Loosduinen 70 Maastricht 43 Nijmegen 80 Oud Zuilen 30 Rotterdam 10 The Hague 70 Tilburg 13 Utrecht 30 Neth. Antilles 599 Bonaire 7 Curacao 9 St. Eustatius 38 St. Maarten 5 Nevis 869 New Caledonia 687 New Zealand 64 Auckland 9 Bay of Plenty 7 Christchurch 3 Dunedin 3 Hamilton 7 Hastings 6 Invercargill 3
Manawatu 6 Napier 6 Nelson 3 New Plymouth 6 Palmerston North 6 Queenstown 3 Rotorua 7 The South Island 3 Tauranga 6 Timaru 3 Wairarapa 6 Wanganui 6 Wellington 4 Whangarei 9 Nicaragua 505 Chinandega 341 Diriamba 42 Leon 311 Managua 2 Niger 227 Nigeria 234 Abeokuta 90 Abuja 9 Benin City 52 Calabar 87 Edo State 52 Enugu 42 Ibadan 2 Ikoyi 1 Ile-Ife 36 Jos 73 Kaduna 62 Lagos 1 Nsukka 42 Owerri 83 Port-Harcourt 84 Zaria 69 Niue 683 Norfolk Island 672 North Korea 850 Norway 47 Bergen 5 Drammen 32 Halden 69 Lysaker 67 Oslo 22 Tromso 77 -O, POman 968 Pakistan 92 Hyderabad 221 Islamabad 51 Karachi 21 Lahore 42 Palau 680 Palestinian Territories Al-Toufah 7 Beit-Jala 2 Beit Sahour 2 Bethlehem 2
27
Birzeit 2 Hebron 2 Nablus 9 Ramallah 2 Panama 507 Papua New Guinea 675 Paraguay 595 Asuncion 21 Concepcion 31 Peru 51 Arequipa 54 Callao 14 Cusco84 Huancayo 64 Ica34 Iquitos94 Lima 1 Piura / Chiclayo 74 Trujillo 44 Philippines 63 Angeles, Luzon 455 Bacolod 34 Baguio 74 (Benguet Province) Cebu 32 ClarkField 45 (Pampanga Province) Dagupan 75 (Pangasinan Province) Davao 82 Iloilo 33 Lucena, Luzon 42 Makati, Luzon 2 Manila 2 Ozamiz City 88 SanFernando 72 (LaUnion Province) San Fernando Pampanga 45 SanPablo 49 or 49560 (Laguna Province) Subic 47 (Zambales Province) Tarlac 452 or 45 (Tarlac Province) Zamboanga 62 Poland 48 Bialystok 85 Bielsko-Biala 33 Bydogoszcz 52 Bytom 32 Gdansk 58 Gdynia 58 Gliwice 32 Gora 75 Jozefow 22 Katowice 32 Koszecin 34 Koszalin 94 Krakow 12 Legnica 76 Leszno 60 Lodz 42
Data Entry Standards Manual Revised December 2004
Lomianki 22 Lublin 81 Myslenice 115 Olsztyn 89 Opole 77 Ostrowiec 47 Poznan 61 Pruszkow 22 Radom 48 Sejny 87 Sopot 58 Sosnowiec 32 Szczecin 91 Torun 56 Tychy 32 Warsaw 22 Wroclaw 71 Portugal 351 Almada 1 Angra Do Heroismo 95 Aviero 34 Barreiro 1 Beja 84 Braga 53 Caldas Da Rainha 62 Cascais 1 Coimbra 39 Cova da Picade 1 Estoril 1 Evora 66 Faro 89 Figueira Da Foz 33 Funchal 90 Horta 92 Lagos 82 Lajes 95 Leiria 44 Lisbon 1 Madalena 92 Madeira Islands 91 Montijo 1 Nazare 62 Oeiras 1 Peniche 62 Ponta Delgada 96 Portela-Lrs 1 Porto 2 Porto Santo 91 Riba de Ave 52 Santa Cruz 92 Santarem 43 Setubal 65 Sintra 1 Velas 95 Viana Do Castelo 58 Villa Real 59 Vita Do Porto 96 Viseu 32 Principe 239 Puerto Rico 1 787 -Q, R-
Qatar 974 Reunion Island 262 Romania 40 Alba-Iulia 58 Arad 57 Bacau 34 Baia-Mare 62 Bistrita Nasaud 63 Botosani 31 Braila 39 Brasov 68 Bucuresti (Bucharest) 1 Buzau 38 Calarasi 42 Cernavoda 41 Chisineu Cris 960 Cluj 64 Cluj-Napoca 64 Constanta 41 Craiova 51 Deva 54 Drobeta Turnu-Severin 52 Efarie 41 Focsani 37 Galati 36 Giurgiu 46 Iasi 32 Lipova 57 Marnaia 41 Miercurea-Ciuc 66 Odorheiu 59 Oradea 59 Orsova 52 Piatra-Neamt 33 Pitesti 48 Ploiesti 44 Radauti 30 Ramnicu-Valcea 50 Resita 55 Satu-Mare 61 Sfantu-Gheorghe 67 Sibiu 69 Sighisoara 65 Slatina 49 Slobozia 43 Suceava 30 Szatmar 997 Targoviste 45 Targu-Jiu 53 Tirgu-Mures 65 Timisoara 56 Tulcea 40 Turnu Magurele 47 Vaslui 35 Zalau60 Russia 7 Irkutsk 3952 Kazan 8432 Krasnodar 8612 Moscow 095 Nizhny Novgorod 8312
28
Novosibirsk 3832 St. Petersburg 812 Vladivostok 4232 Volgograd 8442 Voronezh 0732 Yakutsk 411 Yaroslavl 0852 Yekaterinburg 3432 Rwanda 250 -SSt. Helena 290 St. Kitts 869 St. Lucia 758 St Pierre et Miquelon 508 St. Vincent 784 Saipan 670 Rota 532 Susupe 234 Tinlan 433 San Marino 378 Sao Tome 239 Saudi Arabia 966 Abha 7 Abqaiq 3 Al Khobar 3 Al Markazi 2 Al Ulaya 1 Damman 3 Dhahran 3 Hofuf 3 Jeddah 2 Khamis Mushaait 7 Mecca 2 Medina 4 Najran 7 Qatif 3 Riyadh 1 Tabuk 4 Taif 2 Yenbu 4 Senegal Republic + 221 Serbia, Republic of + 381 Seychelles + 248 Sierra Leone + 232 Bo 22 Freetown 22 Makeni 22 Singapore 65 Slovakia 421 Banska Bystrica 88 Bratislava 7 Dolny Kubin 845 Dunajská Luzná 7 Jinan 53 Kosice 95 Nitra 87 Pezinok 7 Poniky 88 Presov 91 Stará Turá 834
Data Entry Standards Manual Revised December 2004
Topolcany 815 Trnava 805 Zilina 89 Slovenia 386 Dob 61 Domzale 1 Kamnik 64 Kranj 64 Ljubljana 61 Maribor 62 Menges 61 Naklo 64 Skofja Loka 64 Trboulje 61 Solomon Islands + 677 Somalia + 252 Mogadishu 1 South Africa + 27 Acornhock 1127 Alberton 21 Alice 404 Amanzimtoti 31 Athlone 21 Auckland Park 11 Belville 21 Berea 11 Bloenfortein 51 Boksburg 11 Braamfontein 11 Cape Town 21 Centurion 12 Crawford 21 Dalbridge 31 Daveyton 11 Dube 11 Durban 31 East London 431 Emmarentia 11 Empangeni 351 Fort Beaufort 21 Gauteng 11 George 441 Giyani 158 Grahamstown 461 Johannesburg 11 Kenwyn 21 King Williams 404 Klerksdorp 18 La Montagne 12 Lady Smith 361 Lenasia 11 Lenyene 152 Mangauno 51 Mankurwane 531 Maraisburg 11 Mitchells Plain 21 Mulbarton 11 Natal 351 Nigel 11 Parkview 11 Pietersburg 152 Pietermaritzburg 331
Pinelands 21 Pinetown 31 Port Elizabeth 219 Pretoria 12 Rethabile 12 Rivonia 11 Rondebosch 21 Salt River 21 Sandton 11 Scottsville 331 Seshego 152 Sovenga 152 Soweto 11 Umtata 471 Valezia 158 Vlaeberg 21 Wits 11 Spain + 34 All numbers are not 9 digits Sri Lanka + 94 Battargmulb 55 Boralesgamuwa 1 Colombo Central 1 Deniwala 1 Kandy 8 Kelaniya 1 Kohuwela 1 Kotte 1 Maharagana 1 Mattara 41 Moratuwa 1 Nuggoda 1 Peradeniya 8 Wattala 1 Sudan + 249 Khartoum 11 Suriname + 597 Swaziland + 268 Sweden + 46 Alingsas 322 Boras 33 Borlange 243 Bramma 8 Brottby 8 Danderud 8 Djursholm 8 Eskilstuna 16 Gamleby 493 Goteborg 31 Farsta 8 Halmstad 35 Hässelby 8 Handen 8 Helsingborg 42 Hovas 31 Johanneshov 8 Jonkoping 36 Kalmar 480 Karlskoga 586 Karlstad 54 Kista 8 Knivsta 18
29
Kullavik 31 Kungalv 303 Linkoping 13 Ljungsbro 13 Lund 46 Malmo 40 Mölnbö 158 Norrkoping 11 Norrtälje 175 Nykoping 155 Orebro 19 Ostersund 63 Ranea 924 Sala 224 Saltsjöbaden 8 Sigtuna 760 Skelleftea 910 Skondal 8 Södertälje 8 Solna 8 Stockholm 8 Sundsvall 60 Täby 8 Trelleborg 410 Trosa 156 Umea 90 Uppsala 18 Vänersborg 521 Vallingby 8 Vasteras 21 Vasterhaninge 8 Vaxholm 764 Vaxjo 470 Velinge 40 Vreta Kloster 13 Switzerland + 41 Baar 42 Baden 56 Basle (Basel, Bale, Basilea) 61 Batel 61 Begnins 22 Belg 31 Bellevue 22 Belp 31 Berne (Bern, Berna) 31 Biel (Bienne) 32 Blonay 21 Bogis-Bassel 22 Bollingen 31 Bottmingen bei Basel 161 Brug 56 Carouge 22 Chambesy 22 Château d'Oex 26 Chur (Coire, Coira) 81 Crans 22 Dardagny 22 Davos 81 Feldmeilen 1 Fribourg (Freiburg, Friburgo) 26
Data Entry Standards Manual Revised December 2004
Froideville 21 Gattikon 1 Geneva (Geneve, Genf, Ginevra) 22 Grand-Lancy 22 Grandes-Paccot 37 Grenchen 65 Gruet 1 Gstaad 33 Henggart 52 Hilterfingen 31 Horgen 1 Interlaken 33 Ittingen 31 Kilchberg 1 Kriens 41 La Chaux-de-Fonds 32 Lausanne (Losanna) 21 Locarno 91 Lugano 91 Lucerne (Luzern, Lucerna) 41 Mannedorf 1 Mettmensletten 1 Metzerlen 61 Montreux 21 Muri 31 Neuchatel (Neuenburg) 32 Nyon 22 Oberdiesbach 31 Oberwil 61 Opfikon 61 Port 51 Pragassona 91 Pully 21 Riehen 61 Rivaz 22 Sankt Moritz (St. Moritz) 81 Sankt Gallen (St. Gallen, StGall, S. Gallo) 71 Schofthauser 52 Seftigen 33 Sion (Sitten) 27 Solothurn (Soleure, Soletta) 32 Stetten 52 Sursee 45 Vessy 22 Vevey 21 Wabern 31 Weggis 41 Wengen 33 Windish 56 Winterthur 52 Yverdom les Bains 24 Zell 52 Zermatt 27 Zollikerberg 1 Zug 42 Zumikon 1 Zurich (Zuerich, Zurigo) 1 Zurzach 56
Syria + 963 Aleppo (Halab) 21 Baniyas (Banias) 43 Bloudan 13 Damascus 11 Dera (Dera'a) 15 Deir al-Zour (Dayr az-Zoor) 51 Hamah 33 al-Hasakah (Hasake) 52 Homs 31 Idleb (Edleb) 23 Jableh (Jebleh, Gableh) 41 Jisr al-Shughur (Jesr ashShugoor) 44 Kordaha (Kardaha, Kerdaha) 41 Latakia (Lattakia, alLadhakiya) 41 Ma'anbej 25 Ma'arret al-Nouman (Maarretannoman) 24 al-Nabk (Nabek, Annabk) 12 Palmyra (Tadmor) 31 al-Qamishli (Kamishly) 53 Quneitra (al-Quneitera, Kuneitra) 19 al-Raqqah (Rakka) 22 Safita 43 Sweida (Sweda) 16 Tartous (Tartus) 43 Yabroud 12 Zabadani 13 -TTaiwan + 886 Changhua 47 Chiy-Yi 5 Chungli 34 Chunan 36 Chunghsing-Hsintsun 49 Fengyuan 4 Hualien 38 Huwei 56 Ilan 39 Kaohsiun 7 Keelung 32 Lotung 39 Lukang 47 Makung 6 Miaoli 37 Nantou 49 Panchiao 2 Pingtung 8 Sunchung 2 Taichung 2 Tainan 6 Taipei 2 Taitung 89 Taoyuan 33 Tchou-Nan 36
30
Wuchi 46 Yungho 2 Tajikistan + 7 Isfara 37962 Karubadam 3772 Khujad 377 Tanzania + 255 Dar es Salaam 51 Dodma 61 Mtwara 59 Mwanza 68 Tanga 53 Zanzibar 54 Thailand + 66 Bangkok 2 Buriram 44 Chiang Mai 53 Chaing Rai 54 Chon Buri 38 Chanthaburi 39 Hatyai 74 Lampang 54 Nakhon Sawan 56 Nong Khai 42 Pathumthani 2 Pattaya Beach38 Phetchaburi 32 Phitsanulok 55 Ratchaburi 32 Sara Buri 36 Phuket 76 Songkhia 74 Tak 55 Trang 75 Ubon Ratchathani 45 Udon Thani 42 Togo + 228 Tokelau + 690 Tonga + 676 Trinidad and Tobago 868 Cascade 868 Port of Spain 868 Tunapa 868 Tunisia + 216 Ariana 1 Bizerte 2 Carthage 1 Cite El Khadhra 1 Dar Chaabane 2 El Menzah 1 Hammon Luif 1 Kairouan 7 La Manouba 1 Marsaville 1 Megrine Coteaux 1 Menzel Bourguiba 2 Port El Kantaoui 3 Sfax 4 Tunis 1 Turkey + 90 Adana 322 Adiyaman 416
Data Entry Standards Manual Revised December 2004
Afyon 272 Agri 472 Aksaray 382 Amasya 358 Ankara 312 Antalya 242 Ardahan 478 Artvin 466 Aydin 256 Balikesir 266 Bartin 378 Batman 488 Bayburt 458 Bilecik 228 Bingo l426 Bitus 434 Bolu 374 Bornoua 232 Burdur 248 Bursa 224 Canakkale 286 Cankiri 376 Corum 364 Denizli 258 Diyarbakir 412 Edirne 284 Elazig 424 Erzincan 446 Erzurum 442 Eskisehir 222 Gaziantep 342 Giresun 454 Gumushane 456 Hatay 326 Hakkari 438 Igdir 476 Isparta 246 Icel (Mersin) 324 Istanbul (European Side) 212 Istanbul (Asian Side) 216 Izmir 232 Kahramanmaras 344 Karaman 338 Kars 474 Kastamonu 366 Kayseri 352 Kirikkale 318 Kirklareli 288 Kirsehir 386 Kocaeli (Izmit) 262 Konya 332 Kutahya 274 Lefkosa 392 Malatya 422 Manisa 236 Mardin 482 Mersin 392 Mugla 252 Mus 436 Nevsehir 384 Nigde 388 Ordu 452
Rize 464 Sakarya (Adapazari) 264 Samsun 362 Siirt 484 Sinop 368 Sivas 346 Sanliurfa 414 Sirnak 486 Tekirdag 282 Tokat 356 Trabzon 462 Tunceli 428 Usak 276 Van 432 Yozgat 354 Zonguldak 372 Turkmenistan + 993 Ashgabad 12 Turks and Caicos Islands 649 Tuvalu + 688 -UUganda +256 Entebbe 42 Jinja 43 Kalisizo 481 Kampala 41 Kyambogo 41 Masaka 481 Ukraine + 380 Cherkassy 472 Chernivitsi 3722 Crimea 652 Denepropetrovsk 562 Donetsk 622 Ivano-Frankiusk 3422 Kharkov 572 Kiev 44 Kirovohrad 552 Lugansk 642 Lviv 322 Mykolaiv 512 Odessa 482 Slavyansk 6262 Ternopil 3522 Umani 4744 Vinnytsia 432 Zhitomir 41 United Arab Emirates 971 Abu Dhabi 2 Ajman 6 Al ain 3 Asab 5 Aweir 49 Bita Zayed 5 Buhasa 5 Dhayd 6 Dibba 70 Dubai 4 Falaj-Al-Moalia 6
31
Fujairah 70 Habshan 5 Jebel Ali 84 Jebel Dhana 52 Khawanij 58 Mafrak 5 Ras-Al-Khaimah 77 Sharjah 6 Tarif 53 Umm-ai-Quwain 6 Wadi Hatta 49 United Kingdom + 44 Aberdeen 1224 Aberystwyth 1970 Alderney, Channel Islands 148182 Bangor 1248 Bath 1225 Belfast 1232 Birmingham 121 Blackpool 1253 Bournemouth 1202 Bradford 1274 Brighton 1273 Bristol 117 Cambridge 1223 Canterbury 1227 Cardiff 1222 Carlisle 1228 Carmarthenshire 1558 Coventry 1203 Dover 1304 Dundee 1382 Durham 1385 Edinburgh 131 Exeter 1392 Fife 1334 Glasgow 141 Gloucester 1452 Greenock 1475 Guernsey, Channel Islands 1481 Haddington 1620 Harrogate 1423 Hull 1482 Ipswich 1473 Jersey, Channel Islands 1534 Kenilworth 1926 Leeds 113 Leicester 116 Liverpool 151 London 171 or 181 Londonderry 1504 Manchester 161 Newcastle 1632 Northampton 1604 Norwich 1603 Nottingham 115 Oban 1631 Oxford 1865 Penzance 1736
Data Entry Standards Manual Revised December 2004
Plymouth 1752 Portsmouth 1705 Prestwick 1292 Reading 1734 Sheffield 114 Southampton 1703 Swansea 1792 United States +1 Uruguay + 598 Canelones 332 Mercedes 532 Montevideo 2 U.S. Virgin Islands 340 Uzbekistan +7 Ferghana 3722 Samarkand 3662 Tashkent 3712 Urgench 3620 -VVanuatu + 678 Vatican city + 39 All Points 66982 Venezuela + 58 Barcelona 81 Barquisimeto 51 Cabimas 64 Caracas 2 Cuidad Bolivar 85 Coro 68 Cumana 93 Guanare 57 Los Teques 32 Maiquetia 31 Maracaibo 61 Maracay 43 Maturin 91 Merida 74 Miranda 2 Puerto Cabello 42 Punto Fijo 69 San Cristobal 76 San Juan De Los Morros 46 Valencia 41 Zaraza 38 Vietnam, Socialist Republic of + 84 Da Nang City 518 Hanoi 4 Ho Chi Minh City 8
Mukalla 5 Sana'a 1 Taiz 4 Thumar 6 Yarim 4 Zabid 3 Yugoslavia+ 381 Ada 24 Belgrade 11 Nis 18 Novi Beograd 11 Novi Sad 21 Subotica 24 Zemun 11 Zaire + 243 Kinshasa 12 Lubumbashi 2 Zambia + 260 Chingola 2 Kitwe 2 Luanshya 2 Lusaka 1 Ndola 2 Zanzibar +259 Zimbabwe + 263 Bulawayo 9 Chiredzi 31 Harare 4 Mutare 20
-W, X, Y, & ZWake Island + 808 Wallis & Futuna Islands + 681 Western Samoa + 685 Yemen+ 967 Aden 2 Amran 2 Hodeidah 3
32
17 Appendix J: Address Type Codes AP
Accounts Payable A vendor’s accounts payable or remittance address.
NP
Newspaper A person’s home newspaper address.
AR
Account’s Receivable A vendor’s accounts receivable second billing address.
OF
Office Savannah College of Art and Design employee’s office address.
BI*
Billing A student billing address if different from MA address.
PR*
Permanent A person's permanent home address.
BU
Business Only for Alumni/Development use, this is a person or non-person’s employer or business address.
P1*
Parent/Guardian 1 The address of a student’s parent or relative with whom the student resides if different from PR address.
CA*
Campus Savannah College of Art and Design campus address for a student.
P2*
FA
Financial Aid Address to which student financial aid information is sent, if different from MA address.
Parent/Guardian 2 Additional parent address if both parents do not reside together and if different from PR and P1 address(es).
PU
Purchasing A vendor’s purchasing address, to be used only by Purchasing for placing orders.
TM
Temporary A temporary or leave-of-absence address for any person* record. This is not the same as a seasonal or vacation address.
VI
Visa Exclusively used for SEVIS. Should only contain international address information.
LC*
MA
Local For non-resident students only. This is a student’s local off-campus address if different from MA address. Mailing Address where the person wishes to receive mail.
Every entity must have an active MA address.
When Updating Addresses: When Creating New Addresses: Every new entity regardless of its type (parent, student, staff, company, vendor, donor, etc.) must have an active MA address entry. You must create an MA address even if it is the same as some other type you are creating. *All student records will contain PR and MA addresses. If parents are separated, P2 may also be populated.
Data Entry Standards Manual Revised December 2004
1. If the MA address is invalid, and you have a source for a new MA address, inactivate the old MA and create a new MA with the updated information. 2. If there is no new source for a valid MA then DO NOT inactivate the MA address; simply put RVEW in the source field. 3. If you receive an indication from the post office that an address is not valid and you do not have a good address, put BAD in the source field.
33
18 Appendix K: Telephone Type Codes AP
Accounts Payable A vendor’s accounts payable or remittance telephone number.
PR
Permanent The permanent home telephone number.
AR
Account’s Receivable A vendor’s accounts receivable second telephone number.
P1H
Parent/Guardian 1 Home This is the home telephone number of a student’s parent or relative with whom the student resides.
BI
Billing A person’s billing telephone number.
P1W
Parent/ Guardian 1 Work This is the work telephone number of a student's parent or guardian with whom the student resides.
P2H
Parent/Guardian 2 Home This is the home telephone number of a student’s parent or relative with whom the student does not reside.
P2W
Parent/Guardian 2 Work This is the home telephone number of a student's parent or relative with whom the student does nor reside.
PU
Purchasing A vendor’s purchasing telephone number, to be used only by Purchasing for placing orders.
TL
Telematch For use ONLY by the Alumni/Development module.
TM
Temporary A temporary or leave-of-absence telephone number for any person* record, this is not the same as a seasonal or vacation telephone number.
SE
Seasonal A vacation or seasonal telephone number, this is to be used for recurring seasonal addresses as opposed to temporary address changes.
SW
Student Work This is the work telephone number of a student.
BU
CA
EG
FA
Business Only for Alumni/Development use, this is a person or non-person’s employer or business telephone number. Campus Savannah College of Art and Design campus telephone number for a student. Emergency Telephone number to contact in case of an emergency, if different from the MA telephone number. Financial Aid Telephone number to contact regarding student financial aid information, if different from the MA number.
FX
Fax Facsimile phone number.
LC
Local For non-resident students only, this is a student’s home telephone number who does not live on campus or at his/her mailing address.
MA
Main This is the telephone number where the person wishes to receive calls.
MOB
Mobile (Cell Phone) For cellular phone numbers.
OF
Office Office phone number for a Savannah College of Art and Design employee.
Data Entry Standards Manual Revised December 2004
34
19 Appendix L: Ethnicity Codes Ethnicity Codes must be entered for all students and employees. A person's ethnicity is entered on the general person form SPAPERS. Valid values are found in the validation table STVETHN. These codes conform to the IPEDS ethnicity codes and are used in IPEDS reporting. CODE
DESCRIPTION
EXPLANATION
1
White, Non-Hispanic
A person having origins in any of the original people of Europe, North Africa or the Middle east (except those of Hispanic origin).
2
Black, Non-Hispanic
All persons having origins in any of the black racial groups of Africa (except those of Hispanic origin).
3
Hispanic
A person of Mexican, Puerto Rican, Cuban, Central or South American, or other Spanish culture or origin, regardless of race.
4
Asian/Pacific Islander
All persons having origins in any of the original people of the Far east, Southeast Asia, the Indian Subcontinent, or Pacific Islands. This includes people from China, Japan, Korea, the Philippine Islands, American Samoa, India and Vietnam.
5
American Indian/Alaskan Native
All persons having origins in any of the original people of North America, and who maintain cultural identification through tribal affiliation or community recognition.
6
Unknown
This is used ONLY If the person does not indicate a racial or ethnic designation, AND the institution finds it impossible to place the person in one of the aforementioned racial/ethnic categories.
Data Entry Standards Manual Revised December 2004
35
20 Appendix M: Citizenship Type Codes Citizen type is required for all students and employees. A person's citizenship is entered on the General Person Form SPAPERS. Valid values are found in the validation table STVCITZ. CODE
DESCRIPTION
EXPLANATION
US
United States Citizen
A person who is a citizen of the United States.
RA
Resident Alien
A person who is not a citizen of the United States but has been admitted as a legal immigrant for the purpose of obtaining lawful permanent residency or Green Card status. Verification includes an alien registration card [Form I-551 or I-151], a Temporary Resident Card [Form I-688], or an Arrival-Departure Record [Form I-94] with a notation that conveys legal immigrant status such as Section 207 Refugee, Section 208 Asylee, Conditional Entrant Parolee or Cuban-Haitian.
NR
Non-Resident Alien
A person who is not a citizen of the United States and who is in this country on a temporary basis.
DC
Dual Citizenship
A person who maintains United States citizenship and citizenship in another country.
Data Entry Standards Manual Revised December 2004
36
21 Appendix N: Legacy Codes CODE
DESCRIPTION
EXPLANATION
A
Aunt
Sister of parent.
B
Brother
Blood brother or step brother.
C
Cousin
Aunt or uncle’s child.
F
Father
Person student considers father.
G
Grandparent
Mother or father of parent.
O
Spouse
Spouse.
M
Mother
Person student considers mother.
P
Parents
When mother and father are not mutually exclusive.
S
Sister
Blood sister or step sister.
U
Uncle
Brother of parent.
X
Multiple
Multiple relatives/relationships.
22 Appendix O: Marital Codes CODE
DESCRIPTION
EXPLANATION
D
Divorced
Once married but now legally divorced.
M
Married
Legally married.
P
Separated
Legally married but living apart.
S
Single
Never legally married.
U
Unknown
Unkonwn.
W
Widowed
Legally married and spouse is deceased.
Data Entry Standards Manual Revised December 2004
37
23 Appendix P: Banner Navigation Function
Menu Option
Keystroke Option
Toolbar Button
Next Record
Record / Next
Down Arrow
Previous Record
Record / Previous
Up Arrow
Delete Record
Record / Remove
Shift + F6
Insert Record
Record / Insert
F6
Next Block
Block / Next
Ctrl + Page + Down
Previous Block
Block / Previous
Ctrl + Page + Up
Enter Query
Query / Enter
F7
Execute Query
Query / Execute
F8
Cancel Query
Query / Cancel
Ctrl + q
Rollback
File / Rollback
Shift + F7
Save or Commit
File / Save
F10
Next Field
Field / Next
Tab
None
Previous Field
Field / Previous
Shift + Tab
None
Exit
File / Exit
Ctrl + q
Select
File / Select
Shift + F3
Data Entry Standards Manual Revised December 2004
38