How can we help?

    Mapping Document (Club Hub)

    Follow

    Anytime Mapping Documentation

     

     

    Translation from Anytime Member

    Club OS Field

    Anytime Field

    Notes

    externalSystemId

    id

     

    firstName

    firstName

     

    lastName

    lastName

     

    email

    email

     

    dateOfBirth

    dateOfBirth

     

    gender

    gender

    if anytime gender is "female" club os gender is "F"

    otherwise club os gender is "M"

    homePhone

    homePhone

     

    workPhone

    workPhone

     

    mobilePhone

    mobilePhone

     

    marketingSource

    marketingSource

     

    occupation

    occupation

     

    employer

    employer

     

    barcode

    keyfob

     

    isWebLead

    isDigitalLead

     

    lastVisit

    lastVisitDate

     

    isOptOutEmail

    CommunicationPreferences.marketing

     

    addressLine1

    address

     

    addressLine2

    address2

     

    city

    city

     

    state

    stateProvince

     

    zip

    postCode

     

    country

    country

     

    createdDatetimeLocal

    created

     

    joinDate

    membershipSignDate

    if membershipSignDate is empty then createdDatetimeLocal

    Membership.systemId

    Contract.id

     

    Membership.agreementName

    Contract.type, Agreement.statusMessage

    If statusMessage is "Pay Per Visit", agreementName will be "Pay Per Visit"

    Otherwise it will be type

    Membership.agreementType

    Contract.type

     

    Membership.isPrimaryAgreement

     

    Membership is always primary agreement

    Membership.recurringPayment

    membershipMonthlyDues

     

    Membership.downPayment

    membershipDownPayment

     

    Membership.saleDate

    membershipSaleDate

    if membershipSaleDate is empty then membershipSignDate

    Membership.startDate

    membershipStartDate

     

    Membership.endDate

    membershipEndDate

     

    Membership.isAutoRenew

    Contract.isAutoRenew

     

    Membership.AgreementAlert

    Contract.status, Agreement.statusMessage

    if Contract.status is 2 AgreementAlert is canceled

    if Contract.status is 3 AgreementAlert is expired

    if Contract.status is 4 AgreementAlert is collections

    if Contract.status is 5 AgreementAlert is freeze

    if Agreement.statusMessage is "Member is pending cancel" AgreementAlert is pending_cancel

    Membership.pastDueBalance

    Agreement.statusMessage, Agreement.color

    If statusMessage contains "delinquent" or color is yellow and statusMessage is one of the following:

    "Member has a billing problem"

    "Invalid billing information"

    "Past due more than 30 days"

    "Invalid CCD Information"

    photoUrl

    personPhoto

     

    Translation from Anytime Employee

    Club OS Field

    Anytime Field

    Notes

    externalSystemId

    Id

     

    firstName

    firstName

     

    middleName

    middleInitial

     

    lastName

    lastName

     

    email

    email

     

    Translation from Anytime Prospect

    Club OS Field

    Anytime Field

    Notes

    externalSystemId

    id

     

    firstName

    firstName

     

    lastName

    lastName

     

    email

    email

     

    dateOfBirth

    dateOfBirth

     

    gender

    gender

    if "female" or "F" then Club OS gender is "F"

    otherwise Club OS gender is "M"

    homePhone

    homePhone

     

    workPhone

    workPhone

     

    mobilePhone

    mobilePhone

     

    marketingSource

    marketingSource

    if marketingSource is empty then default_marketing_source

    occupation

    occupation

     

    employer

    employer

     

    barcode

    keyfob

     

    isWebLead

    isDigitalLead

     

    addressLine1

    address

     

    addressLine2

    address2

     

    city

    city

     

    state

    stateProvince

     

    zip

    postCode

     

    country

    country

     

    createdDatetimeLocal

    created

     

    guestPassStart

    membershipStartDate

    only if prospect is trial member (isTrialMember)

    guestPassEnd

    membershipEndDate

    only if prospect is trial member (isTrialMember)

    archivedDatetimeLocal

    rating, created

    if rating is not interested, archivedDatetimeLocal is created date

    isOptOutEmail

    CommunicationPreferences.marketing

     

    photoUrl

    personPhoto

     

    Translation to Anytime Prospect

    Club OS Field

    Anytime Field

    Notes

    externalSystemId

    id

     

    clubSystemId

    clubId

     

    email

    email

     

    firstName

    firstName

     

    lastName

    lastName

     

    barcode

    keyfob

     

    gender

    gender

     

    dateOfBirth

    dateOfBirth

     

    employer

    employer

     

    homePhone

    PhoneResource

    PhoneResource label of "Home" and number of homePhone

    workPhone

    PhoneResource

    PhoneResource label of "Work" and number of workPhone

    mobilePhone

    PhoneResource

    PhoneResource label of "Mobile" and number of mobilePhone

    archivedDatetime

    rating

    Rating is set to Not Interested if archivedDatetime exists

    addressLine1

    address

     

    addressLine2

    address2

     

    city

    city

     

    state

    stateProvince

     

    country

    country

     

    zip

    postCode

     

    isOptOutEmail

    CommunicationPreferences.marketing

     

    Translation from Anytime Appointment (Club Visit)

    Club OS Field

    Anytime Field

    Notes

    systemId

    appointmentId

     

    assignedToSystemId

    staffId

     

    createdBySystemId

    createdByStaffId

     

    visitType

    isAppt, isClubTour

    if isAppt then visitType is APPT

    if isClubTour then visitType is WALKIN

    Translation to Anytime Appointment

    Club OS Field

    Anytime Field

    Notes

    systemId

    id

     

    clubSystemId

    clubId

     

    note

    note

     

    eventType

    topic

    if eventType is LEAD TopicResource is 4

    if eventType is ASSESSMENT Topic Resource is 6

    if eventType is ORIENTATION TopicResource is 30

    if eventType is TRAINING_SESSION TopicResource is 7

    if eventType is GROUP_CLASS TopicResource is 29

    otherwise TopicResource is 32

    effectiveStatus

    outcome

    if effectiveStatus is ACTIVE or CONFIRMED OutcomeResource is 6

    if effectiveStatus is CANCELED, CANCELED_CHARGE, or RESCHEDULED OutcomeResource is 18

    if effectiveStatus is NO_SHOW or NO_SHOW_CHARGE OutcomeResource is 5

    if effectiveStatus is COMPLETED OutcomeResource is 7

    effectiveStatus

    status

    if effectiveStatus is ACTIVE or CONFIRMED status is 1

    otherwise status is 2

    effectiveStatus

    completed

    completed is true if effectiveStatus code is COMPLETED

    startDatetime

    dateScheduled

     

    startDatetime

    dueDate

     

    endDatetime

    endDate

     

    startDatetime, endDatetime

    lengthInMinutes

    endDatetime - startDatetime in minutes

    attendeeSystemId

    memberId

     

    assignedToSystemId

    assignedToId

     

    createdBySystemId

    createdById

     

    statusChangedDatetime

    confirmed

     

    statusChangedBySystemId

    confirmedBy

     

    Translation from Anytime Call Activity

    Club OS Field

    Anytime Field

    Notes

    note

    note

     

    msgType

     

    Always Call

    noteType

     

    Always Lead

    createdBySystemId

    createdBy.id

     

    createdDatetime

    dateCompleted or dateCreated

    If dateCompleted exists createdDatetime is set to dateCompleted

    Otherwise dateCreated is used

    clubSystemId

    clubId

     

    userSystemId

    recipient.id

     

    Translation to Anytime Call Activity

    Club OS Field

    Anytime Field

    Notes

    userSystemId

    id

     

    createdBySystemId

    createdBy

     

    createdBySystemId

    assignedTo

     

    clubSystemId

    clubId

     

    userPhone

    phoneNumber

     

    note

    note

     

    createdDatetime

    dateCreated

     

    createdDatetime

    dateCompleted

     

    createdDatetime

    dueDate

     

    createdDatetime

    endDate

     
     

    allDay

    always true

     

    outcome

    OutcomeResource.id is always 7

     

    status

    status is always 2

    Translation from Anytime Check-In

    Club OS Field

    Anytime Field

    Notes

    systemId

    id

     

    systemClubId

    Member.clubId

     

    checkInTimestamp

    date

     

    Translation from Anytime Email Activity

    Club OS Field

    Anytime Field

    Notes

    note

    note

     

    msgType

     

    Always set to Email

    noteType

     

    Always set to Lead

    createdBySystemId

    createdBy.id

     

    clubSystemId

    clubId

     

    userSystemId

    recipient.id

     

    Translation to Anytime Email Activity

    Club OS Field

    Anytime Field

    Notes

    userSystemId

    id

     

    createdBySystemId, createdByRoleId

    createdBy, assignedTo

    If createdByRoleId is a Client, createdBy and assignedTo get set to a default member ID

    Otherwise if createdByRoleId points to staff member, createdBy and assignedTo get set to createdBySystemId

    If createdBySystemId is empty, createdBy and assignedTo get set to a default staff ID

    clubSystemId

    clubId

     

    userPhone

    emailAddress

    if msgType is SMS_MSG_TYPE

    userEmailAddress

    emailAddress

    if msgType is not SMS_MSG_TYPE

    note

    note

     

    createdDatetime

    dateCreated

     

    createdDatetime

    dueDate

     

    createdDatetime

    endDate

     
     

    allDay

    always true

     

    outcome

    OutcomeResource.id is always 7

     

    status

    status is always 2

    Translation to Anytime Email Activity for Campaign Emails

    This is only used when translating a campaign email from Club OS

    Club OS Field

    Anytime Field

    Notes

    recipientEmail

    emailAddress

     

    note

    subject

     

    sendDate

    dateCreated

     

    sendDate

    dueDate

     

    sendDate

    endDate

     
     

    allDay

    Always set to true

     

    Outcome.id

    Always set to 7

     

    status

    Always set to 2

    Translation from Anytime Note

    Club OS Field

    Anytime Field

    Notes

    note

    text

     

    msgType

     

    Always set to General

    noteType

     

    Always set to Lead

    createdBySystemId

    createdBy

     

    createdDatetime

    dateCreated

     

    clubSystemId

    clubId

     

    userSystemId

    memberId

     

    Translation to Anytime Note

    Club OS Field

    Anytime Field

    Notes

    Club OS Field

    Anytime Field

    Notes

    userSystemId

    id

     

    createdBySystemId, createdByRoleId

    createdBy, assignedTo

    If createdByRoleId is a Client, createdBy and assignedTo get set to a default member ID

    Otherwise if createdByRoleId points to staff member, createdBy and assignedTo get set to createdBySystemId

    If createdBySystemId is empty, createdBy and assignedTo get set to a default staff ID

    clubSystemId

    clubId

     

    text

    note

     

    createdDatetime

    dateCreated

     
     

    status

    status is always 2

    Translation from Anytime Note from Appointment

    This is used to create a note in Club OS that is attached to appointments from Club OS

    Club OS Field

    Anytime Field

    Notes

    note

    note

     

    msgType

     

    Always set to General

    noteType

     

    Always set to Lead

    createdBySystemId

    assignedToId

     

    createdDatetime

    dateCompleted, dateScheduled

    If dateCompleted exists createdDatetime is set to dateCompleted

    Otherwise if dateScheduled exists createdDatetime is set to dateCompleted

    If neither exists createdDatetime is set to current time

    clubSystemId

    clubId

     

    userSystemId

    memberId

     

     

    Was this article helpful?
    0 out of 0 found this helpful

    Comments