Dancer Table - Fields

All dancers must be listed in the Dancer Table.

First Name and Last Name

• The dancer's first name and last name.

Role

• The dancer's role: Boy, Girl, or Any (bi-dansual).`
• Any means the dancer is willing to dance either as a Boy or a Girl.

Preferred Role

• This field only applies to dancer's whose role is Any.
• Dancer's preferred role: Boy, Girl, or Any (don't care).
• The program attempts to use the dancer's preferred role whenever the dancer dances as a single.

Category

• Dancer's category: Normal, Student, or Angel.
   
• In most cases, the category field should be set to Normal.
   
• Normal is anyone who isn't a Student or an Angel.
• Student indicates the dancer is in the class.
  • Students are dancers who are weak or just learning the level.
• Angel indicates the dancer is helping out.
  • Angels should be competent dancers and willing to assist newer dancers.
   
• Rotation Preferences allow
  • students to dance every tip;
  • even distribution of students among squares;
  • angels to dance only if needed;
  • even distribution of angels among squares.

Partner

• The dancer's desired partner, if any.
• To be assigned a partner, both dancers must be in the Dancer Table.
• The partner must not already be assigned to another dancer.

Couple Name

• The displayed couple name when the dancer is dancing with their desired partner.

OK w/Single

• When checked, the dancer is willing to dance as necessary with a single dancer.

Vaccinated

• When checked, the dancer has shown proof of Covid-19 vaccination.

Flags

• Flags assigned to the dancer to assist in locating the dancer in the database.
• Flags can be the dancer's dance level, the group to which they belong, or other attributes.
   
• Flags are created and edited via the Flag Table.

Tag

• A short comment field. (A large comment field, 'Notes', is available within the 'Notes' tab.)
• The Tag field is often used for the dancer's upper level.

Single Name

• The dancer's displayed name when dancing as a single, or when not dancing with their desired partner.

Short Name

• An abbreviated (short) name of the dancer, used to save screen space for large dances.
• The default short name is the first three letters of the Last Name followed by a comma and the first letter of the First Name.
• The operator must choose to display the short name.

Attributes

• How to treat the dancer for special considerations.

• Always in Square N
  • Indicates the dancer will always be placed in square # N.
  • Only one dancer in the rotation may have this attribute.
  • It is intended for a dancer such as the rotation computer operator who always needs to be by the computer, or perhaps for a dancer who is hard of hearing who needs to be in the square closest the speaker.
  • The value of N is set via Preferences - this Rotation.
   
• In N, Out M
  • The dancer will be in (Ready to dance) for N tips in a row, then out (Absent) for M tips in a row.
  • The program is smart enough to know that after a long break (e.g. a dinner break) to reset the dancer's "In" counter to zero.
  • Always available means In N, Out M is disabled.

ID

• The unique ID of the dancer within the Dancer Table.
• This ID is local to the computer. See also Global ID.

Global ID

• The ID from the Global Database, uniquely identifies this dancer to all copies of SQROT.
• The Global ID is particularly useful for bar codes so the dancer can check-in/out at multiple dances.

Last modified

• Date and time this dancer's data was last modified.

Notes

• Any notes about the dancer.

Country, State, City, Postal Code, Address, Phone1, Phone2, Email1, Email2

• These fields can be used to save dancer's contact data.

Prefer Partners

• A list of preferred partners for the current dancer.

Avoid Partners

• A list of dancers to avoid being partnered with.

Prefer Dancers

• A list of dancers with whom the current dancer would like to dance.
• Note: this option is currently not implemented.

Avoid Dancers

• A list of dancers to avoid being in the same square as the current dancer.