Location Mass Addition Information

Location Mass Addition Template

Position Header Name Can Import Empty Suggested Values Notes
0 InsertOrUpdate No Insert or Update Use Insert to create a new record. Use Update to update an existing record. Header Row must begin with an asterisk (*).
1 OrganizationName Yes   Name of organization. Currently not used by Loader. Added for future use.
2 OrganizationCode No   Validated against the organization code in organization table. Used to determine the organization ID for the course. Must be 40 characters or less.
3 CampName Yes   Name of Camp. Currently not used by loader. Added for future use.
4 CampCode No   Validated against the camp code from the camp table. Used to determine the camp ID for the course. Must be 40 characters or less.
5 LocationCode No   Must be a unique value. Must be 256 characters or less.
6 LocationName No   Must be a unique value. Must be 256 characters or less.
7 LocationDesc Yes   Must be 256 characters or less.
8 MaxSize No   Must be 128 characters or less. Validated against the XX_LOCATIONMAXSIZE Lookup Values.  Default value is zero.
9 HasPower Yes   If left empty, assumed to be No. Must be 128 characters or Less. Validated against the ZZ_YESNO lookup values.
10 HasWater Yes   If left empty, assumed to be No. Must be 128 characters or Less. Validated against the ZZ_YESNO lookup values.
11 HasRestrooms No   Must be 128 characters or less. Validated against the XX_LOCATIONRESTROOMS lookup values.  Default value is N/A.
12 ActiveFlag No Yes or No Validated against the ZZ_YESNO lookup value. Must be 128 characters or less.
13 Attribute1 Yes   Must be 128 characters or less.
14 Attribute2 Yes   Must be 128 characters or less.
15 Attribute3 Yes   Must be 128 characters or less.
16 Attribute4 Yes   Must be 128 characters or less.
17 Attribute5 Yes   Must be 128 characters or less.
18 Attribute6 Yes   Must be 128 characters or less.
19 Attribute7 Yes   Must be 128 characters or less.
20 Attribute8 Yes   Must be 128 characters or less.
21 Attribute9 Yes   Must be 128 characters or less.
22 Attribute10 Yes   Must be 128 characters or less.
23 NewLocationCode Conditional   Must be 40 characters are less. Use this field when the location code value needs to be changed.
24 HandicappAccessible Yes   If left empty, assumed to be No. Must be 128 Characters or Less. Validated against the ZZ_YESNO lookup values.
Related Topics
Location Information
Maintaining Locations