Read the CAP name-validation table from S3

Reads the coaching action plan (CAP) name-validation table produced by the create_cap_folders_in_google_drive automation. The table records whether each sheet's file name has the correct three-part structure (School_Teacher_Subject) and whether each part passes roster / master-list checks.

Usage

get_validation_table(cycle = 1L, full = FALSE)

Arguments

cycle

Integer scalar (1, 2, or 3). Which coaching cycle's validation table to return. Defaults to 1.

full

Logical. When TRUE, returns the full validation table (from the coaching-data-tl bucket) that also includes has_data, has_valid_structure, and modified_time columns. When FALSE (default), returns the lighter name-only table (from the tl-monday bucket) used by the Monday.com dashboard.

Value

A tibble.