Person Mass Addition Information

Person Template

The Camp User person import uses the same template as the Unit User one. A few validations are changed to allow the camp staff to import people into multiple units.

The camp staff member must be associated to the organization that is being updated.

Position HeaderName 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   Validated against the Organization Name in the Organization Table. Either the Organization Name or Organization Code is required. Must be 256 characters or less.
2 OrganizationCode No   Validated against the Organization Code in Organization Table. Either the Organization Name or Organization Code is required. Must be 40 Characters or less.
3 RegionName Yes   Validated against the Region Code in the Region Table. Must be 256 characters or less. If the Region Name, Region Code, Unit Name, and Unit Code are empty, the import will not create a person unit assignment.
4 RegionCode Yes   Validated against the Region Code in the Region Table. Must be 40 characters or less. If the Region Name, Region Code, Unit Name, and Unit Code are empty, the import will not create a person unit assignment.
5 UnitName Yes   Validated against the Unit Name in the Unit Table. Must be 256 characters or less. If the Region Name, Region Code, Unit Name, and Unit Code are empty, the import will not create a person unit assignment.
6 UnitCode Yes   Validated against the Unit Code in the Unit Table. Used to determine the unit ID. Must be 40 characters or less. If the Region Name, Region Code, Unit Name, and Unit Code are empty, the import will not create a person unit assignment.
7 PersonID Conditional   Required if an update record. Must be numeric. Must be a valid person ID.
8 UserName Yes   If entered, it must be a valid user name that is not attached to another person record.
9 PersonNo Yes   Person Number. Must be 40 characters or less.
10 PersonPrefix Yes   Validated against the XX_PERSONPREFIX lookup value. If value is left empty, it is assumed to be N/A.
11 FirstName No   First Name of the person. Must be 128 Characters or less.
12 LastName No   Last Name of the person. Must be 128 Characters or less.
13 MiddleName Yes   Middle Name of the person. Must be 128 Characters or less.
14 PersonSuffix Yes   Validated against the XX_PERSONSUFFIX lookup value. If value is left empty, it is assumed to be NA.
15 Birthdate Conditional   Must be a valid date. This value is used to calculate course age restrictions. If XX_REQUIREBIRTHDATEFORCAMPUSER System Parameter is set to Yes, a birth date is required. In addition, it must be greater than the date is XX_MINIMUMBIRTHDATE.
16 Gender Yes Male, Female, N/A Validated against the XX_PERSONGENDER lookup value. If value is left empty, it is assumed to be N/A.
17 EmergencyContactName Yes   Name of emergency contact for the person. Must be 256 characters or less.
18 EmergencyContactPhone Yes   Phone of emergency contact for the person. Must be 50 characters or less.
19 EmergencyContactEmail Yes   Email of the emergency contact for the person. Must be 256 character or less.
20 EmergencyContactRelationship Yes   Validated against the XX_EMERCONTACTRELATIONSHIP lookup value. If value is left empty, it is assumed to be N/A. Must be 128 Character or less.
21 LegacyPersonIdentifier Yes   Field used to identify a person in a legacy system. Must be 48 characters or less.
22 Attribute1 Yes   Must be 128 characters or less.
23 Attribute2 Yes   Must be 128 characters or less.
24 Attribute3 Yes   Must be 128 characters or less.
25 Attribute4 Yes   Must be 128 characters or less.
26 Attribute5 Yes   Must be 128 characters or less.
27 Attribute6 Yes   Must be 128 characters or less.
28 Attribute7 Yes   Must be 128 characters or less.
29 Attribute8 Yes   Must be 128 characters or less.
30 Attribute9 Yes   Must be 128 characters or less.
31 Attribute10 Yes   Must be 128 characters or less.
32 StartDate Yes   Must be a valid date. If set, it will only treat the person as active from this date.
33 EndDate Yes   Must be a valid date. If set, it will only treat the person as active to this date.
34 ActiveFlag No Yes or No If field provided empty, the loader assumes No. Validates against the ZZ_YESNO lookup value. Must be 128 characters or less.
35 PrimaryPhoneNumber Yes   Primary Phone number of the person. Must be 48 characters or less.
36 PrimaryPhoneNumberType Yes   Validated against the XX_PERSONPRIMARYPHONETYPE lookup value. If value is left empty, it is assumed to be N/A. Must be 128 Character or less.
37 SecondaryPhoneNumber Yes   Secondary Phone number of the person. Must be 48 characters or less.
38 SecondaryPhoneNumberType Yes   Validated against the XX_PERSONSECONDARYPHONETYPE lookup value. If value is left empty, it is assumed to be N/A. Must be 128 Character or less.
39 PrimaryEmail Yes   Primary Email for the person. Must be 256 Characters or less.
40 SecondaryEmail Yes   Secondary Email for the person. Must be 256 Characters or less.
41 Grade No   Grade Person is going into or currently in. Must Be 128 Characters or less. Validated against XX_PERSONGRADE lookup value.
42 YearAtCamp No   Must be Numeric. Validated against XX_PERSONYEARATCAMP Lookup Value.
43 UnitLeader Yes Yes or No Valiated against ZZ_YESNO Lookup Values. If value is left empty, it is assumed to be No. Must be 128 Characters or less.
44 Instructor Yes Yes or No Valiated against ZZ_YESNO Lookup Values. If value is left empty, it is assumed to be No. Must be 128 Characters or less.
45 Rank Yes   Validated against the XX_PERSONRANK lookup values. If value is left empty, it is assumed to be N/A. Must be 128 Characters or less.
46 Address1 Yes   If Address1 is empty, the entire address record is ignored. Must be 256 character or less.
47 Address2 Yes   Must be 256 character or less.
48 Address3 Yes   Must be 256 character or less.
49 Address4 Yes   Must be 256 character or less.
50 City Yes   Must be 128 characters or less.
51 State Yes   Validated against the XX_STATE lookup values. Must be 128 characters or less.
52 PostalCode Yes   Must be 128 characters or less.
53 County Yes   Must be 128 characters or less.
54 Country Yes   Validated agains the XX_COUNTRY lookup values. Must be 128 characters or less.
55 ReceiveTextMsg Yes Yes or No If value is empty, it is defaulted to No.  Validated against the ZZ_YESNO lookup values.
56 PrimMobileCarrier Yes   If value is empty, it is defaulted to N/A.  Validated against the XX_PERSONMOBILECARRIER lookup values.
57 PrimMobileVerified Yes   If value is empty, it is defaulted to No. 
58 SecMobileCarrier Yes   If value is empty, it is defaulted to N/A.  Validated against the XX_PERSONMOBILECARRIER lookup values.
59 SecMobileVerified Yes   If value is empty, it is defaulted to No.
60 RcvEmailMessages Yes Yes or No If value is empty, it is defaulted to No.  Validated against the ZZ_YESNO lookup values.
61 PrimEmailVerified Yes   If value is empty, it is defaulted to No.
62 SecEmailVerified Yes   If value is empty, it is defaulted to No.
63 CampStaff Yes   No value required at this time.  It is currently derived.
64 AllowDelete Yes Yes or No If value is empty, it is defaulted to Yes.  It is validated against the ZZ_YESNO lookup values.
65 Comments Yes   Must be 1024 characters or less.