Here is a complete list of the column headings along with any required values:

Column Heading

Possible Values

Additional Remarks

Week

Date in format dd/MM/yyyy.

This is the Monday for the Week.

MidweekMeeting

Y | N

Not currently used.

WeekendMeeting

Y | N

Not currently used.

NumClasses

0 | 1 | 2 | 3

We don’t validate this field.

Host

Name or empty


Cohost

Name or empty


ZoomAttendant

Name or empty


Chairman

Name or empty


AuxCounsellor1

Name or empty


AuxCounsellor2

Name or empty


PrayerOpen

Name or empty


Treasures_Name

Name or empty


Treasures_Theme



Treasures_Method

T | TV | TVS

Read the Methods help topic for an explanation of the Method abbreviations.

Gems_Name

Name or empty


Teaching

Y | N


Teaching_Class1_Name

Name or empty


Teaching_Class2_Name

Name or empty


Teaching_Class3_Name

Name or empty


BibleReading_Study

0 to 20


StudentItem1_Study

0 to 20


StudentItem2_Study

0 to 20


StudentItem3_Study

0 to 20


StudentItem4_Study

0 to 20


StudentItem1_Description

IC_Video | RV_Video
IC | RV | BS | T | "Anything else"

Read the Methods help topic for an explanation of the Method abbreviations.

StudentItem2_Description

IC | RV | BS | T | "Anything else"

Read the Methods help topic for an explanation of the Method abbreviations.

StudentItem3_Description

IC | RV | BS | T | "Anything else"

Read the Methods help topic for an explanation of the Method abbreviations.

StudentItem4_Description

IC | RV | BS | T | "Anything else"

Read the Methods help topic for an explanation of the Method abbreviations.

BibleReading_Class1_Name

Name or empty


BibleReading_Class2_Name

Name or empty


BibleReading_Class3_Name

Name or empty


StudentItem1_Class1_Name

Name or empty


StudentItem1_Class1_Assistant

Name or empty


StudentItem2_Class1_Name

Name or empty


StudentItem2_Class1_Assistant

Name or empty


StudentItem3_Class1_Name

Name or empty


StudentItem3_Class1_Assistant

Name or empty


StudentItem4_Class1_Name

Name or empty


StudentItem4_Class1_Assistant

Name or empty


StudentItem1_Class2_Name

Name or empty


StudentItem1_Class2_Assistant

Name or empty


StudentItem2_Class2_Name

Name or empty


StudentItem2_Class2_Assistant

Name or empty


StudentItem3_Class2_Name

Name or empty


StudentItem3_Class2_Assistant

Name or empty


StudentItem4_Class2_Name

Name or empty


StudentItem4_Class2_Assistant

Name or empty


StudentItem1_Class3_Name

Name or empty


StudentItem1_Class3_Assistant

Name or empty


StudentItem2_Class3_Name

Name or empty


StudentItem2_Class3_Assistant

Name or empty


StudentItem3_Class3_Name

Name or empty


StudentItem3_Class3_Assistant

Name or empty


StudentItem4_Class3_Name

Name or empty


StudentItem4_Class3_Assistant

Name or empty


Living1_Name

Name or empty


Living1_Theme



Living1_Method

V | T | TVS | TV | TD | TI | TDI | 

QA |QAD | QAI | QADI | 

D | DD | DI | DDI | DV | DVS

Read the Methods help topic for an explanation of the Method abbreviations.

Living2_Name

Name or empty


Living2_Theme



Living2_Method

V | T | TVS | TV | TD | TI | TDI | 

QA |QAD | QAI | QADI | 

D | DD | DI | DDI | DV | DVS

Read the Methods help topic for an explanation of the Method abbreviations.

Living3_Name

Name or empty


Living3_Theme



Living3_Method

V | T | TVS | TV | TD | TI | TDI | 

QA |QAD | QAI | QADI | 

D | DD | DI | DDI | DV | DVS

Read the Methods help topic for an explanation of the Method abbreviations.

CBS_Conductor

Name or empty


CBS_Reader

Name or empty


PrayerClose

Name or empty


Weekend_Host

Name or empty


Weekend_Cohost

Name or empty


Weekend_ZoomAttendant

Name or empty


Weekend_Chairman

Name or empty


Weekend_PrayerOpen

Name or empty


Weekend_PT_Speaker

Name or empty


Weekend_PT_Theme



Weekend_PT_Number



Weekend_PT_Hospitality

Name or empty


Weekend_PT_Interpreter

Name or empty


Weekend_AT1_Name

Name or empty


Weekend_AT2_Name

Name or empty


Weekend_WT_Conductor

Name or empty


Weekend_WT_Reader

Name or empty


Weekend_WT_BibleVersesReader

Name or empty


Weekend_PrayerClose

Name or empty


Weekend_Misc





a