Lookup and Lookup Value Definitions and Seeded Values
Lookups
CAMPSITEMAXSIZE
General Information

The lookup controls the max size values that can be selected on a campsite.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A 0 0                


Back To Top
CAMPSITERESTROOMS
General Information

The lookup controls the choices for restrooms in a campsite.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A N/A -1                
B Male Male                
C Female Female                
D Female and Male Female and Male                


Back To Top
MYREQUESTTYPE
General Information

The lookup controls the request types on the My Requests page.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A Full Course Request FULLCOURSE                
B General Request GENERAL                
C Product Enhancement PRODUCT                


Back To Top
XX_ADMINMENU
General Information

The lookup controls the admin menu.  WARNING! modifying this lookup can result in items being removed from the menu structure.  It is recommended that the admin menu not be modified unless directed by support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
APPPURGE Application Purge ~/Admin/ApplicationPurge.aspx 2 ZZ_OTHER            
APPSEQUENCE App Sequences ~/Admin/ManageApplicationSequences.aspx 1              
CAMPS Camps ~/admin/ManageCamps.aspx 1              
CREATEUSER CreateUser ~/admin/CreateAccount.aspx 1              
CREATEROLE Create Role ~/admin/CreateRoles.aspx 1              
LOOKUPS Lookups ~/admin/ManageLookups.aspx 1              
LOOKUP VALUES Lookup Values ~/admin/ManageLookupValues.aspx 1              
ORGANIZATIONS Organizations ~/admin/ManageOrganizations.aspx 1              
PEOPLEPURGE People Purge ~/Admin/PeoplePurge.aspx 2 ZZ_OTHER            
REGPURGE Registration Purge ~/Admin/RegistrationPurge.aspx 2 ZZ_OTHER            
SYSTEMPARAMETERS System Parameters ~/admin/ManageSystemParameters.aspx 1              
USERS Users ~/admin/ManageUsers.aspx 1              
Z_REPORTS Reports ~/Admin/Default.aspx 1              
A_REPORTS All Users Report ~/Admin/AllUsersReport.aspx 2 Z_REPORTS            
L_REPORTS Lookup Import Report ~/Admin/LookupsImportReport.aspx 2 Z_REPORTS            
LA_REPORTS Lookup Values Imp. Report ~/Admin/LookupvaluesImportReport.aspx 2 Z_REPORTS            
SA_REPORTS Sys. Param Import Rpt. ~/Admin/SystemParametersImportReport.aspx 2 Z_REPORTS            
ZZ_OTHER Other ~/admin/Default.aspx 1              
MASSADDITIONS Mass Additions ~/admin/Import.aspx 2 ZZ_OTHER            
ADMININFO Admin Information ~/admin/AdminInfo.aspx 2 ZZ_OTHER            
INITIALASSIGNMENTS Initial Assignments ~/UnitUser/AddInitialAssignments.aspx 2 ZZ_OTHER            
RESETCRSCOMPLETION Reset Course Completion ~/Admin/ResetCourseCompletionRecords.aspx 2 ZZ_OTHER            
UNITPURGE Unit Purge ~/Admin/UnitPurge.aspx 2 ZZ_OTHER            
VIEWAPPLOGTABLE View AppLog ~/Admin/ViewAppLog.aspx 2 ZZ_OTHER            
VIEWAPPSTATTABLE View AppStat ~/Admin/ViewAppStat.aspx 2 ZZ_OTHER            


Back To Top
XX_AREAMAXSIZE
General Information

The lookup controls the max size drop down list on an area.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A 0 0                


Back To Top
XX_AREARESTROOMS
General Information

The lookup controls the restrooms drop down list on an area.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A N/A -1                
B Male Male                
C Female Female                
D Female and Male Female and Male                


Back To Top
XX_CAMPADMINMENU
General Information

The lookup controls the camp admin menu.  WARNING! modifying this lookup can result in items being removed from the menu structure.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
AREAS Areas ~/CampAdmin/ManageAreas.aspx 1              
CAMPSITES Campsites ~/CampAdmin/ManageCampsites.aspx 1              
COURSES Courses ~/CampAdmin/ManageCourses.aspx 1              
COURSE REQS Course Reqs ~/CampAdmin/ManageCourseReqs.aspx 1              
DEPARTMENTS Departments ~/CampAdmin/ManageDepartments.aspx 1              
EVENTPRICING Event Pricing ~/CampAdmin/ManageEventPricing.aspx 1              
EVENTS Events ~/CampAdmin/ManageEvents.aspx 1              
LOCATIONS Locations ~/CampAdmin/ManageLocations.aspx 1              
REGIONS Regions ~/CampAdmin/ManageRegions.aspx 1              
SUB-CAMPS Sub-Camps ~/CampAdmin/ManageSubCamps.aspx 1              
UNIT Unit ~/CampAdmin/ManageUnit.aspx 1              
ZZ_OTHER Other ~/CampAdmin/Default.aspx 1              
INACTIVATECOURSE Inactivate Courses ~/CampAdmin/InactivateCourses.aspx 2 ZZ_OTHER            
MASSADDITIONS Mass Additions ~/CampAdmin/Import.aspx 2 ZZ_OTHER            
Z_REPORTS Reports ~/CampAdmin/Default.aspx 1              
CA_REPORTS Campsite Import Report ~/CampAdmin/CampsiteImportReport.aspx 2 Z_REPORTS            
CH_REPORTS Crs Import Report ~/CampAdmin/CourseImportReport.aspx 2 Z_REPORTS            
CRA_REPORTS Crs Req Extract - Camp ~/CampAdmin/CourseReqsForACampReport.aspx 2 Z_REPORTS            
CRB_REPORTS Crs Req Extract - Course ~/CampAdmin/CourseReqsForACourseReport.aspx 2 Z_REPORTS            
EV_REPORTS Event Import Report ~/CampAdmin/EventImportReport.aspx 2 Z_REPORTS            
UN_REPORTS Unit Import Report ~/CampAdmin/UnitImportReport.aspx 2 Z_REPORTS            
X_CAMPANALYTICS Camp Analytics ~/CampAdmin/Default.aspx 1              
C_CAMPANALYTICS Camp Analytics Transfer ~/CampAdmin/TransferToFulfillment.aspx 2 X_CAMPANALYTICS            
U_CAMPANALYTICS Unit Leader Access ~/CampAdmin/CreateCampAnalyticsUnitLeader.aspx 2 X_CAMPANALYTICS            


Back To Top
XX_CAMPUSERMENU
General Information

The lookup controls the camp user menu.  WARNING! modifying this lookup can result in items being removed from the menu structure.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
ADDRESSES Addresses ~/CampUser/ManageAddress.aspx 1              
EVENT COURSE Event Course ~/CampUser/ManageEventCourseRelationships.aspx 1              
MESSAGE Messages ~/CampUser/SendMessage.aspx 1              
PEOPLE People ~/CampUser/ManagePerson.aspx 1              
PERSON2 Person Org ~/CampUser/ManagePersonOrgAssignments.aspx 1              
PERSON3 Person Unit ~/CampUser/ManagePersonUnitAssignments.aspx 1              
PERSON4 Person Info ~/CampUser/PersonInfo.aspx 1              
REGISTRATION Registration ~/CampUser/ManageRegistration.aspx 1              
UNIT EVENT Unit Event ~/CampUser/ManageUnitEventRelationships.aspx 1              
USER PREFERENCES User Preferences ~/CampUser/ManageUserPreferences.aspx 1              
W_CAMPANALYTICS Camp Analytics ~/CampUser/Default.aspx 1              
A_CAMPANALYTICS Course Compl. Report ~/CampUser/CampAnalyticsCourseCompletionReport.aspx 2 W_CAMPANALYTICS            
F_CAMPANALYTICS Course Compl. Excel Sum ~/CampUser/CampAnalyticsCourseCompletionSumReport.aspx 2 W_CAMPANALYTICS            
N_CAMPANALYTICS Course Compl. Excel Dtl ~/CampUser/CampAnalyticsCourseCompletionExcelDetailReport.aspx 2 W_CAMPANALYTICS            
W_EVENTCHARGES Event Charges ~/CampUser/Default.aspx 1              
D_EVENTCHARGE Finalize Order ~/CampUser/FinalizeOrder.aspx 2 W_EVENTCHARGES            
G_EVENTCHARGE Create Event Charge ~/CampUser/CreateEventChargeTransactions.aspx 2 W_EVENTCHARGES            
X_EVENTCHARGE Calculate Event Charges ~/CampUser/CalculateEventCharges.aspx 2 W_EVENTCHARGES            
X_COURSECOMPLETION Course Completion ~/CampUser/Default.aspx 1              
CRSCOMPLETION_A Completion Transfer ~/CampUser/TransferToCompletion.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_D Completion Summary ~/CampUser/ManageCompletion.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_F Completion Detail ~/CampUser/ManageCompletionDetail.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_K Unprocessed Report ~/CampUser/CourseCompletionUnprocessedReport.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_N Sync Summary To Detail ~/CampUser/CourseCompletionSyncHeaderToDetail.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_P Incomplete By Unit ~/CampUser/EventIncompleteReportByUnit.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_Q Incomplete By Course ~/CampUser/EventIncompleteReportByCourse.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_S Final Posting ~/CampUser/FinalizeCompletionPostingStatus.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_V UnPosted Report ~/CampUser/CourseCompletionUnPostedReport.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_W Unit Completion Report ~/CampUser/UnitCourseCompletionReport.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_X Unit Com. Excel - Sum ~/CampUser/UnitCrsComplExcelSumReport.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_Y Unit Com. Excel - Det ~/CampUser/UnitCrsComplExcelDtlReport.aspx 2 X_COURSECOMPLETION            
CRSCOMPLETION_YY Sync Person Information ~/CampUser/CourseCompletionSyncPersonInfo.aspx 2 X_COURSECOMPLETION            
Z_REPORTS Reports ~/CampUser/Default.aspx 1              
A_REPORTS Activity Totals Report ~/CampUser/ActivityPercentFullByEvent.aspx 2 Z_REPORTS            
AG_REPORTS Campsite Assignment ~/CampUser/CampsiteAssignmentByEvent.aspx 2 Z_REPORTS            
AM_REPORTS Campsite Assgn Excel ~/CampUser/CampsiteAssignmentByEventExcel.aspx 2 Z_REPORTS            
AP_REPORTS Course Application ~/CampUser/CourseApplication.aspx 2 Z_REPORTS            
AT_REPORTS Course App with Reqs ~/CampUser/CourseAppWithReqs.aspx 2 Z_REPORTS            
AV_REPORTS Course Req. Checklist ~/CampUser/CourseRequirementsChecklist.aspx 2 Z_REPORTS            
AX_REPORTS Course Reqs By Event ~/CampUser/CourseReqsByEventReport.aspx 2 Z_REPORTS            
BA_REPORTS Course Restriction Report ~/CampUser/CourseRestrictionReport.aspx 2 Z_REPORTS            
BB_REPORTS Course Roster ~/CampUser/CourseRoster.aspx 2 Z_REPORTS            
BC_REPORTS Course Roster Excel ~/CampUser/CourseRosterExcelReport.aspx 2 Z_REPORTS            
BE_REPORTS Course Totals Report ~/CampUser/CourseTotalsReport.aspx 2 Z_REPORTS            
C_REPORTS Crs Comp Import ~/CampUser/CourseCompletionImport.aspx 2 Z_REPORTS            
E_REPORTS Crs Comp Sum Import ~/CampUser/CourseCompletionSummaryImport.aspx 2 Z_REPORTS            
J_REPORTS Event Charge Details ~/CampUser/EventChargesDetailByPerson.aspx 2 Z_REPORTS            
M_REPORTS My Unit Person Import ~/CampUser/MyUnitPersonExtract.aspx 2 Z_REPORTS            
N_REPORTS People in Camp ~/CampUser/PeopleInCamp.aspx 2 Z_REPORTS            
NG_REPORTS Num Reg. By Event ~/CampUser/NumberRegisteredByEvent.aspx 2 Z_REPORTS            
NR_REPORTS Num Reg. By Region ~/CampUser/NumRegisteredPerRegionByEvent.aspx 2 Z_REPORTS            
NU_REPORTS Num Reg. By Unit ~/CampUser/NumRegisteredPerUnitByEvent.aspx 2 Z_REPORTS            
O_REPORTS Order Status Report ~/CampUser/EventChargesOrderStatusReport.aspx 2 Z_REPORTS            
P_REPORTS People in Camp ~/CampUser/PeopleInCamp.aspx 2 Z_REPORTS            
PH_REPORTS Person Import For Org ~/CampUser/PersonImportForOrgReport.aspx 2 Z_REPORTS            
PU_REPORTS Person Unit Import ~/CampUser/PersonUnitAssignmentImportReport.aspx 2 Z_REPORTS            
RC_REPORTS Req Code Checklist ~/CampUser/CourseReqCodeChecklist.aspx 2 Z_REPORTS            
RE_REPORTS Req Code Checklist (S) ~/CampUser/CourseReqCodeChecklistShort.aspx 2 Z_REPORTS            
U_REPORTS Unit Balance By Event ~/CampUser/UnitBalanceByEventReport.aspx 2 Z_REPORTS            
V_REPORTS Unit Event Import Rpt ~/CampUser/UnitEventImportReport.aspx 2 Z_REPORTS            
W_REPORTS Unit Schedule By Event ~/CampUser/UnitScheduleByEventReport.aspx 2 Z_REPORTS            
WW_REPORTS Unit Sch. By Person ~/CampUser/UnitScheduleByPersonReport.aspx 2 Z_REPORTS            
Y_REPORTS Unit Schedule Report ~/CampUser/UnitScheduleReport.aspx 2 Z_REPORTS            
ZZ_OTHER Other ~/CampUser/Default.aspx 1              
MASSADDITIONS Mass Additions ~/CampUser/Import.aspx 2 ZZ_OTHER            
RETRIEVEFILES Retrieve Files ~/CampUser/RetrieveFiles.aspx 2 ZZ_OTHER            
SEEDCOURSEREQCHECK Seed Req Code Checklist ~/CampUser/PopulateCourseReqsChecklist.aspx 2 ZZ_OTHER            


Back To Top
XX_CAMPUSERREPORTS
General Information

(Obsoleted) - As of build 2.9, the report manager  has been replaced by standard menu items unders the reports menu.

This lookup controls the Camp User Report Manager. Attribute1 is the name of the report. Attribute2 is the path to the report. Attribute3 controls the validation group, which is used to prompt the user as to which parameters are required in order to run the report. Validation Group 1 requires organization, camp, event year, and event.  Validation Group 2 requires organization, camp, event year, event, region and unit. Validation Group 3 requires organization, region, and unit.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A Activity Percent Full By Event ~/CampUser/ActivityPercentFullByEvent.aspx VALIDATIONGROUP1              
C Course MB Application ~/UnitUser/CourseMBApplication.aspx?reporttype=CAMPUSER VALIDATIONGROUP2              
CC Course App with Requirements ~/UnitUser/CourseAppWithReqs.aspx?reporttype=CAMPUSER VALIDATIONGROUP2              
J Course Req. Checklist ~/UnitUser/CourseRequirementsChecklist.aspx?reporttype=CAMPUSER VALIDATIONGROUP2              
K Course Restriction Report ~/UnitUser/CourseRestrictionReport.aspx?reporttype=CAMPUSER VALIDATIONGROUP1              
Q Course Totals Report ~/UnitUser/CourseTotalsReport.aspx?reporttype=CAMPUSER VALIDATIONGROUP1              
S Person Extract Report ~/UnitUser/MyUnitPersonExtract.aspx?reporttype=CAMPUSER VALIDATIONGROUP3              
U Unit Schedule Report ~/UnitUser/UnitScheduleReport.aspx?reporttype=CAMPUSER VALIDATIONGROUP2              


Back To Top
XX_COMPLETIONSTATUS
General Information

The lookup controls the completion status drop down list used in course completion.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
B Complete COMPLETE                
C Incomplete INCOMPLETE                


Back To Top
XX_COUNTRY
General Information

The lookup controls the Country drop down list on an address.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A United States US                
Z Other Other                


Back To Top
XX_COURSEAGEHIGH
General Information

The lookup controls the Age High drop down list on a course. It is used by the Registration Engine to determine the maximum grade required to enroll in the course. The values in attribute2 must be a number. When course value remains ninety-nine, the registration engine does not evaluate the course maximum requirement.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A 99 99                


Back To Top
XX_COURSEAGELOW
General Information

The lookup controls the Age Low drop down list on a course. It is used by the Registration Engine to determine the minimum age required to enroll in the course. The values in attribute2 must be a number. When the course value remains zero, the registration engine does not evaluate the course minimum requirement.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
Z 0 0                


Back To Top
XX_COURSEBEGINTIME
General Information

The lookup controls the begin time drop down list on a course as the start time of the course each day. It is used by the Registration Engine to determine time constraints in the registration process. This lookup must be configured in the initial application setup.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
                     


Back To Top
XX_COURSECOMPLETIONCRSXFER
General Information

The lookup controls the course completion transfer for the course.  A value of N/A will not transfer to course completion.  A value of Summary will only transfer at the course level.  A value of detail will transfer the course and course requirements.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A N/A -1                
D Detail DETAIL                
S Summary SUMMARY                


Back To Top
XX_COURSECOMPLETIONRPTDETAIL
General Information

This lookup controls the list of values used to show either summary or detail reports on course completion unprocessed and unposted reports.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A Summary SUMMARY                
D Detail DETAIL                


Back To Top
XX_COURSEENDTIME
General Information

The lookup controls the end time drop down list on a course as the end time of the course each day. It is used by the Registration Engine to determine time constraints in the registration process. This lookup must be configured in the initial application setup.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
                     


Back To Top
XX_COURSEGRADEHIGH
General Information

The lookup controls the Grade High drop down list on a course. It is used by the Registration Engine to determine the maximum grade required to enroll in the course. The values in attribute2 must be a number. When course value remains ninety-nine, the registration engine does not evaluate the course maximum requirement.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
Z 99 99                


Back To Top
XX_COURSEGRADELOW
General Information

The lookup controls the Grade Low drop down list on a course. It is used by the Registration Engine to determine the minimum grade required to enroll in the course. The values in attribute2 must be a number. When course value remains zero, the registration engine does not evaluate the course minimum requirement.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
Z 0 0                


Back To Top
XX_COURSEMAXSIZE
General Information

The lookup controls the max size drop down list on a course. It is used by the Registration Engine to determine if a course is full during registration. This lookup must be configured in the initial application setup.  Attribute1 and attribute2 should have the same value and should be a number.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A 0 0                
S 30 30                


Back To Top
XX_COURSERANK
General Information

The lookup controls the Rank drop down list on a course. It is used by the Registration Engine to determine the minimum rank required to enroll in the course. Attribute1 and attribute2 should be the same name for this to function correctly. Attribute3 is used as a hierarcy for the rank and should always be a number with the higher ranks having higher numbers. Thus, once you have obtained the minimumn rank to register for the course or a higher rank, the course should be available for registration. This list should have the same values as the XX_PERSONRANK list.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A N/A -1 -1              


Back To Top
XX_COURSEREQDEFCOMPLETION
General Information

The lookup controls the type of course requirement default course completion status.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
B Complete COMPLETE                
C Incomplete INCOMPLETE                


Back To Top
XX_COURSEREQTYPE
General Information

The lookup controls the type of course requirement being added. 

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A Prerequisite PREREQ                
C Requirement REQ                
H Post Requirement POSTREQ                


Back To Top
XX_COURSEYEARATCAMP
General Information

The lookup controls the year at camp drop down list on a course. It is used by the registration engine to determine the minimum year at camp required to enroll in the course. The values in attribute2 must be a number.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
1 1 1                


Back To Top
XX_CREATEUSERACCTTYPE
General Information

The lookup controls the roles that can be selected during account creation.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
C Unit User UNITUSER                
H Parent PARENT                
INDIVIDUAL Individual INDIVIDUAL                


Back To Top
XX_CRSCOMPLETIONREPROCESS
General Information

The lookup controls the drop down list on the Reset Course Completion Form.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
PERSON Person Person                
COURSE Course Course                
EVENT Event Event                
A_REGISTRATION Registration Registration                


Back To Top
XX_CUEVENTCHGPAYMETHOD
General Information

The lookup controls the list of payment methods on the event charge transactions screen.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A Cash or Check CASHCHECK                
E Online ONLINE                
K Counter COUNTER                


Back To Top
XX_EMERCONTACTRELATIONSHIP
General Information

The lookup controls the emergency contact relationship on the person record.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 N/A -1                
1 Mother Mother                
2 Father Father                
3 Brother Brother                
4 Sister Sister                
6 Wife Wife                
7 Husband Husband                
8 Other Other                


Back To Top
XX_EVENTCHGORDERSTAT
General Information

The lookup controls the list how an camp user can search in the finalize order screen.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
C Pending PENDING                
H Posted POSTED                
M Initiated INITIATED                


Back To Top
XX_EVENTCHGPAYMETHOD
General Information

The lookup controls the list of payment methods on the calculate payment screen.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A Cash or Check CASHCHECK                
E Online ONLINE                


Back To Top
XX_EVENTCHGUPDATETYPE
General Information

The lookup controls the types of event charges a camp user can use to create event charge transactions.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
B Payment PAYMENT                
J Credit CREDIT                
P Refund REFUND                
R Manual Fee MANUALFEE                
U Late Fee LATEFEE                


Back To Top
XX_EVENTCHRGTYPE
General Information

The lookup controls the list of order statuses that a camp user can search in the finalize order screen.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
C Pending PENDING                
H Posted POSTED                
M Initiated INITIATED                


Back To Top
XX_EVENTYEAR
General Information

The lookup controls the Event Year lookups for Events

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
Current Year Current Year Current Year                


Back To Top
XX_EVENTYEAR
General Information

The lookup controls the Event Year lookups for Events

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
Current Year Current Year Current Year                


Back To Top
XX_FILEUPLOADEMAILLIST
General Information

The lookup creates an email distribution list for file uploads from unit leaders.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
Recipient Name Recipient Name Email Address                


Back To Top
General Information

The lookup contains the list of links for each page in the application. It is used to direct the end user when a I need Help link is clicked.

Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
10 parent Default.aspx http://www.summercampsystems.com/docs/Parent/Default.aspx              
100 unituser ManageMyRegistrations.aspx http://www.summercampsystems.com/docs/UnitUser/UnitUserRegisteringForCourses.aspx              
101 unituser CreateUserAccount.aspx http://www.summercampsystems.com/docs/General/CreatingAnUserAccount.aspx              
102 unituser AddInitialAssignments.aspx http://www.summercampsystems.com/docs/General/SettingInitialPreferences.aspx              
103 unituser ManageMyAccount.aspx http://www.summercampsystems.com/docs/UnitUser/UpdateAccountInformation.aspx              
104 unituser ManageMyAddresses.aspx http://www.summercampsystems.com/docs/UnitUser/UnitUserMyAddresses.aspx              
105 unituser ManageMyPeople.aspx http://www.summercampsystems.com/docs/UnitUser/People.aspx              
106 unituser ManageMyUnit.aspx http://www.summercampsystems.com/docs/UnitUser/AddingUnitLeaderInformation.aspx              
107 unituser ManageMyUserPrefs.aspx http://www.summercampsystems.com/docs/General/SetUserPreferences.aspx              
108 unituser ProcessPaymentByPerson.aspx http://www.summercampsystems.com/docs/UnitUser/ProcessingPayments.aspx              
109 unituser MyRequests.aspx http://www.summercampsystems.com/docs/UnitUser/MyRequests.aspx              
110 unituser UnitMessaging.aspx http://www.summercampsystems.com/docs/UnitUser/CommunicatingSchedules1.aspx              
200 campuser manageaddresses.aspx http://www.summercampsystems.com/docs/CampUser/ManageAddresses.aspx              
201 campuser manageeventcourserelationships.aspx http://www.summercampsystems.com/docs/CampUser/EventCourseRel.aspx              
202 campuser manageperson.aspx http://www.summercampsystems.com/docs/CampUser/ManagePeople.aspx              
203 campuser managepersonorgassignments.aspx http://www.summercampsystems.com/docs/CampUser/AddPersonOrgRelationship.aspx              
204 campuser managepersonunitassignments.aspx http://www.summercampsystems.com/docs/CampUser/AddPersonUnitRelationships.aspx              
205 campuser manageregistration.aspx http://www.summercampsystems.com/docs/CampUser/AddRegistrations.aspx              
206 campuser manageuniteventrelationships.aspx http://www.summercampsystems.com/docs/CampUser/UnitEventRel.aspx              
207 campuser manageuserpreferences.aspx http://www.summercampsystems.com/docs/CampUser/UserPreferences.aspx              
208 campuser finalizeorder.aspx http://www.summercampsystems.com/docs/CampUser/FinalizeOrder.aspx              
209 campuser createeventchargetransactions.aspx http://www.summercampsystems.com/docs/CampUser/CreateEventCharge.aspx              
210 campuser calculateeventcharges.aspx http://www.summercampsystems.com/docs/CampUser/CalculateEventCharges.aspx              
211 campuser transfertocompletion.aspx http://www.summercampsystems.com/docs/CampUser/TransferToCourseCompletion.aspx              
212 campuser managecompletion.aspx http://www.summercampsystems.com/docs/CampUser/ProcessCourseCompletion.aspx              
213 campuser managecompletiondetail.aspx http://www.summercampsystems.com/docs/CampUser/ProcessCourseCompletion.aspx              
214 campuser coursecompletionsyncheadertodetail.aspx http://www.summercampsystems.com/docs/CampUser/SyncSummaryToDetail.aspx              
215 campuser finalizecompletionpostingstatus.aspx http://www.summercampsystems.com/docs/CampUser/CourseCompletionFinalPosting.aspx              
216 campuser courseroster.aspx http://www.summercampsystems.com/docs/CampUser/CourseRoster.aspx              
217 campuser peopleincamp.aspx http://www.summercampsystems.com/docs/CampUser/PeopleInCamp.aspx              
218 campuser courserosterexcelreport.aspx http://www.summercampsystems.com/docs/CampUser/CourseRosterExcel.aspx              
219 campuser sendmessage.aspx http://www.summercampsystems.com/docs/CampUser/Messaging.aspx              
300 campadmin ManageUnit.aspx http://www.summercampsystems.com/docs/CampAdmin/Units.aspx              
301 campadmin manageregions.aspx http://www.summercampsystems.com/docs/CampAdmin/Regions.aspx              
302 campadmin manageevents.aspx http://www.summercampsystems.com/docs/CampAdmin/Events.aspx              
303 campadmin ManageCourses.aspx http://www.summercampsystems.com/docs/CampAdmin/Courses.aspx              
400 admin peoplepurge.aspx http://www.summercampsystems.com/docs/Admin/PurgePeople.aspx              
401 admin unitpurge.aspx http://www.summercampsystems.com/docs/Admin/UnitPurge.aspx              


Back To Top
XX_LOCATIONMAXSIZE
General Information

The lookup controls the max size attribute attached to a location.  It is used for reporting purposes.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A 0 0                


Back To Top
XX_LOCATIONRESTROOMS
General Information

This lookup controls the values in the HasRestrooms attribute for locations.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A N/A -1                
B Male Male                
C Female Female                
D Female and Male Female and Male                


Back To Top
XX_MESSAGELIST
General Information

This lookup controls the values in the message list for sending messages. It is used to select various groups who can be sent messages.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
ORGANIZATION Organization ORG                
USERENTERED User Entered USER                
DISTRIBUTIONLIST Distribution List DISTRIBUTIONLIST                
USERS Users USERS                
CAMP Camp CAMP                
EVENT Event EVENT                
REGION Region REGION                


Back To Top
XX_MESSAGETYPE
General Information

This lookup controls the type of message being sent.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
B_HTMLEMAIL HTML Email HTMLEMAIL                
A_TEXTEMAIL Text Email TEXTEMAIL                
C_TEXTMSGEMAIL Text Msg From Email TEXTMSGEMAIL                


Back To Top
XX_PAGINATIONLIST
General Information

This lookup controls the list of values for paging on a gridview control.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
D 5 5                
J 10 10                
P 25 25                
T 50 50                
Z 100 100                


Back To Top
XX_PARENTMENU
General Information

This lookup controls the parent menu.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
CHANGEPASSWORD Change Password ~/UnitUser/ChangePassword.aspx                


Back To Top
XX_PAREVENTCHGPAYMETHOD
General Information

The lookup controls the list of payment methods on the event charge transactions screen.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A Cash or Check CASHCHECK                
E Online ONLINE                


Back To Top
XX_PERSONGENDER
General Information

This lookup controls the values in the gender drop down list for courses and people.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 N/A -1                
1 Male M                
2 Female F                


Back To Top
XX_PERSONGRADE
General Information

The lookup controls the grade drop down list on a person. It is used by the registration engine to determine the minimum grade required to enroll in the course. The values in attribute2 must be a number. It is also printed on the course application report.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A N/A -1                
C 1 1                
D 2 2                
F 3 3                
H 4 4                
J 5 5                
K 6 6                
M 7 7                
P 8 8                
R 9 9                
S 10 10                
U 11 11                
W 12 12                


Back To Top
XX_PERSONINFOSEARCHTYPE
General Information

The lookup controls the drop down list on the person info page for searching people.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
PERSON Person PERSON                
PERSONORG Person Org PERSONORG                
PERSONUNIT Person Unit PERSONUNIT                


Back To Top
XX_PERSONMOBILECARRIER
General Information

This lookup controls the mobile phone carriers on the person record.  It also controls the suffix used for phone carrier email gateways in attribute3.  It is appended to the mobile number to send an email message as a text message.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
ATT ATT ATT @txt.att.net              
SPRINT Sprint SPRINT @messaging.sprintpcs.com              
TMOBILE T-Mobile TMOBILE @tmomail.net              
VERIZON Verizon VERIZON @vtext.com              
A N/A -1 -1              


Back To Top
XX_PERSONPREFIX
General Information

The lookup controls the person prefix drop down list on a person.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 N/A -1                
1 Mr. Mr.                
2 Ms. Ms,                
3 Mrs. Mrs.                
4 Dr. Dr.                


Back To Top
XX_PERSONPRIMARYPHONETYPE
General Information

The lookup controls the person primary phone type drop down list on a person.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 N/A -1                
1 Mobile Mobile                
2 Home Home                
3 Work Work                


Back To Top
XX_PERSONPURGEACTIONS
General Information

The lookup specifies the purge action on the purge people page.  The action determines the criteria used to select people for the purge process.  For example, select all people within an unit or all inactive people.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
APURGEID Purge Person By ID PERSONID PERSON              
PURGEINACTIVEBYUNIT Purge Inactive People within an Unit. INACTIVEPEOPLEWITHINUNIT UNIT              
PURGEINACTIVEPEOPLE Purge Inactive People INACTIVEPEOPLE ALL              
PURGEPEOPLEINUNIT Purge all people in Unit PEOPLEWITHINUNIT UNIT              


Back To Top
XX_PERSONRANK
General Information

The lookup controls the rank drop down list on a person. It is used by the registration engine to compare the person's rank against the minimum rank required to enroll in the course. Attribute1 and attribute2 should be the same name for this to function correctly. Attribute3 is used as a hierarcy for the rank and should always be a number with the higher ranks having higher numbers. Thus, once you have obtained the minimumn rank to register for the course or a higher rank, the course should be available for registration. This list should have the same values as the XX_COURSERANK list.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A N/A -1                


Back To Top
XX_PERSONSECONDARYPHONETYPE
General Information

The lookup controls the person secondary phone type drop down list on a person.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 N/A -1                
1 Mobile Mobile                
2 Home Home                
3 Work Work                


Back To Top
XX_PERSONSUFFIX
General Information

The lookup controls the person secondary phone type drop down list on a person.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 N/A -1                
1 Jr. Jr.                
2 Sr. Sr.                
3 III III                


Back To Top
XX_PERSONYEARATCAMP
General Information

The lookup controls the year-at-camp drop down list on a person. It is used by the registration engine to compare the person's year at camp against the minimum year at camp required to enroll in the course. Attribute1 and attribute2 should be the same name for this to function correctly. This list should have the same values as the XX_COURSEYEARATCAMP list.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A 1 1                
C 2 2                
E 3 3                
G 4 4                
J 5 5                


Back To Top
XX_POSTINGSTATUS
General Information

The lookup provides the list of values for posting status in the course completion process.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
D Draft DRAFT                
S Posted POSTED                
P Processed PROCESSED                


Back To Top
XX_PRICINGTYPE
General Information

The lookup provides the list of values for pricing in the event pricing process..

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
CAMPFEE Camp Fee CAMPFEE                
COURSEFEE Course Fee COURSEFEE                


Back To Top
XX_PRIMARYPHONETYPE
General Information

The lookup controls the address primary phone type drop down list on an address.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 N/A -1                
1 Mobile Mobile                
2 Home Home                
3 Work Work                
5 Main Main                


Back To Top
XX_REGISTRATIONPURGEACTIONS
General Information

The lookup controls the purge actions for purging registration information from the database.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
APURGEID Purge Registration By ID REGISTRATIONID REGISTRATION              
PURGEUNIT Purge registration records for an unit. PURGEUNIT UNIT              
PURGEUNITEVENT Purge registration records for a unit within an event. PURGEUNITEVENT ALL              
PURGEEVENT Purge registration records for an event. PURGEEVENT EVENT              


Back To Top
XX_SECONDARYPHONETYPE
General Information

The lookup controls the address secondary phone type drop down list on an address.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
1 N/A -1                
2 Mobile Mobile                
3 Home Home                
4 Work Work                
5 Main Main                


Back To Top
XX_STATE
General Information

The lookup controls the states displayed on addresses.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 NC NC                
2 VA VA                
3 SC SC                
4 TN TN                
5 GA GA                
6 FL FL                


Back To Top
XX_UNITPURGEACTIONS
General Information

The lookup controls the actions an end user can take to purge units.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
AUNITID Purge Unit By ID UNITID ID              
UNIT Purge Selected Unit UNITSELECTED UNIT              
REGION Purge Units In A Region REGIONSELECTED REGION              


Back To Top
XX_UNITUSERMENU
General Information

The lookup controls the unit user menu.  WARNING! modifying this lookup can result in items being removed from the menu structure.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
CHANGEPASSWORD Change Password ~/UnitUser/ChangePassword.aspx 1              
D_MESSAGING Messages ~/UnitUser/UnitMessaging.aspx 1              
MANAGEMYACCOUNT My Account ~/UnitUser/ManageMyAccount.aspx 1              
MANAGEMYADDRESSES My Addresses ~/UnitUser/ManageMyAddresses.aspx 1              
MANAGEMYPEOPLE My People ~/UnitUser/ManageMyPeople.aspx 1              
MANAGEMYREG My Registrations ~/UnitUser/ManageMyRegistrations.aspx 1              
MANAGEMYREQUEST My Requests ~/UnitUser/MyRequests.aspx                
MANAGEMYUNIT My Unit ~/UnitUser/ManageMyUnit.aspx 1              
MANAGEMYUSERPREF My User Preferences ~/UnitUser/ManageMyUserPrefs.aspx 1              
Z_REPORTS Reports ~/UnitUser/Default.aspx 1              
COURSEAPP Course Application ~/UnitUser/CourseMBApplication.aspx 2 Z_REPORTS            
COURSEAPPREQS Course App With Reqs ~/UnitUser/CourseAppWithReqs.aspx 2 Z_REPORTS            
COURSEREQCHECKLIST Course Req Checklist ~/UnitUser/CourseRequirementsChecklist.aspx 2 Z_REPORTS            
COURSERESTRICTRPT Course Restriction Report ~/UnitUser/CourseRestrictionReport.aspx 2 Z_REPORTS            
COURSETOTALRPT Course Totals Report ~/UnitUser/CourseTotalsReport.aspx 2 Z_REPORTS            
MYUNITPERSONDOWN My Unit Person Import ~/UnitUser/MyUnitPersonExtract.aspx 2 Z_REPORTS            
UNITSCHEDULERPT Unit Schedule Report ~/UnitUser/UnitScheduleReport.aspx 2 Z_REPORTS            
ZZ_OTHER Other ~/UnitUser/Default.aspx 1              
MASSADDITIONS Mass Additions ~/UnitUser/Import.aspx 2 ZZ_OTHER            
SYSTEMINFO System Information ~/UnitUser/SystemInfo.aspx 2 ZZ_OTHER            
UPLOADFILES Upload Files ~/UnitUser/SendFile.aspx 2 ZZ_OTHER            
CURRENTSESSION Current Session ~/CurrentSession.aspx 2 ZZ_OTHER            
MANAGEUNAPPLIED Manage Unapplied ~/UnitUser/ManageUnappliedPayments.aspx 2 ZZ_OTHER            
COURSECOMUNITRPT Course Compl. Report ~/UnitUser/CourseCompletionUnitReport.aspx 2 Z_REPORTS            
COURSECOMUNITRPTEXCELDTL Course Compl. Excel Dtl ~/UnitUser/CourseCompletionUnitExcelDtl.aspx 2 Z_REPORTS            
COURSECOMUNITRPTEXCELSUM Course Compl. Excel Sum ~/UnitUser/CourseCompletionUnitExcelSum.aspx 2 Z_REPORTS            
EVENTCHGDTLBYPERSON Event Charge Details ~/UnitUser/EventChargesDetailByPerson.aspx 2 Z_REPORTS            
UNITBALANCERPT Unit Balance Report ~/UnitUser/EventChargesUnitBalanceReport.aspx 2 Z_REPORTS            
UNITSCHEDULERPTBYPERSON Unit Sch. By Person ~/UnitUser/UnitScheduleByPersonReport.aspx 2 Z_REPORTS            
ZZZ_CAMPANALYTICS
Camp Analytics
~/UnitUser/Default.aspx 1              
E_CACRSCOMPLETIONRPT Course Compl. Report ~/UnitUser/CampAnalyticsCourseCompletionReport.aspx 2 ZZZ_CAMPANALYTICS            
J_CACRSCOMPLETIONRPT Course Compl. Excel Sum ~/UnitUser/CampAnalyticsCourseCompletionSumReport.aspx 2 ZZZ_CAMPANALYTICS            
P_CACRSCOMPLETIONRPT Course Compl. Excel Dtl ~/UnitUser/CampAnalyticsCourseCompExcelDetailReport.aspx 2 ZZZ_CAMPANALYTICS            


Back To Top
ZZ_ADDRESSTYPE
General Information

This lookup controls the type of address shown in the address form.  This list also controls the SQL statement executed.  It should not be modified without authorization from support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 Address Address                
1 Person Person                
2 Camp Camp                
3 Organization ORG                


Back To Top
ZZ_ADMINISTRATORIMPORT
General Information

The lookup primary controls the import types for aministrator mass additions. This lookup should not be modified without authorization from support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
C Lookups Lookups                
E Lookup Values Lookup Values                
S System Parameters System Parameters                
U Delete User USER                


Back To Top
ZZ_CAMPADMINIMPORT
General Information

The lookup primary controls the import types for camp admin mass additions. This lookup should not be modified without authorization from support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
A Area AREA                
CAS Campsite CAMPSITE                
CO Course CRS                
CR Course Requirement CRSREQ                
E Event EVENT                
J Location LOC                
S Unit UNIT                


Back To Top
ZZ_CAMPUSERIMPORT
General Information

The lookup primary controls the import types for camp user mass additions. This lookup should not be modified without authorization from support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
C Course Completion CRSCOMPLETE                
D Course Compl. Summary CRSCOMPLETESUM                
H Event Course Assignment ECR                
P Person With Assignments PERSON                
PU Person Unit Assignment PERSONUNIT                
S Unit Event Assignment Unit Event Assignment                


Back To Top
ZZ_EVENTREGTYPE
General Information

The lookup controls the event type drop down lists when defining a new event. This lookup should not be modified without authorization from support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 Unit UNIT                
1 Individual INDIVIDUAL                


Back To Top
ZZ_MYADDRESSTYPE
General Information

The lookup primary controls the type of address being searched for in the my addresses page.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
0 Person Person                
1 Unassigned Address Address                


Back To Top
ZZ_UNITUSERIMPORT
General Information

The lookup primary controls the import types for unit users. This lookup should not be modified without authorization from support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
PERSON Person PER                
                     


Back To Top
ZZ_YESNO
General Information

The lookup primary controls drop down lists with Yes or No values. This lookup should not be modified without authorization from support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
1 Yes Y                
2 No N                


Back To Top
ZZ_YESNO_NOFIRST
General Information

The lookup primary controls drop down lists with Yes or No values. This lookup orders the values, so that No is first in the list. This lookup should not be modified without authorization from support.

Seeded Values
Lookup Value Code Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7 Attribute8 Attribute9 Attribute10
1 No N                
2 Yes Y                


Back To Top