Reference sheet · ALE columns

The 29 ALE columns, and what each one is worth

Every column, and how far you can lean on it.

ColumnWhat fills itHow far you can lean
NameDeterministic clip name: 31 characters, ASCII; falls back to scene / shot / take when no shot name was recordedA marker, not a file key
TracksV MOS · A1A2 wild · VA1A2 sync · blank when the row holds no sound factNever defaults to sync
StartThe recorded timecode — in-point if present, else the take's ownThe strongest time cell in the file
EndThe out-point you copied off the camera's screen at stop; empty when nobody typed one, and never back-calculatedA transcription, not an automatic measurement
DurationThe frame-accurate span between Start and End, head and tail included; empty if either reading is missingDerived — review it against the two readings
SceneScene number, ASCII onlyNon-Latin empties it
TakeThe take numberAs entered
Reel #Card number, digits onlyBlank if the card holds any letter
SoundrollSound roll, normalised (letters and digits, upper case, ≤31)Blank if not transcribed
FPSOnly where that row declares a rateBlank ≠ any default rate
SlateX DescriptionShot summary, description and notes joined with | , ASCII onlyNon-Latin empties the cell; verbatim in the CSV
SlateX CommentsTake notes, ASCII onlyNon-Latin empties the cell
TapeThe card you typed, normalisedThe matching key you recognise
CameraCamera labelA label, not media
Camera NotesCamera note text, ASCII onlyNon-Latin empties the cell
VFX_CountBlank: the column exists, no entry path todayCarries no claim
VFX_TypeThat camera's flags joined with + — VFX · Plate · Clean · RefFlags you set
Shoot DayDay 7 formBlank = belongs to no shooting day
DirectorDirector name, ASCII onlyNon-Latin empties the cell
Sound TCSound timecode, verbatim; shape judged only, never trimmedVerbatim, not validated against a report
Source File NameTranscribed file name, ASCII onlyBlank if not typed
Source FileTranscribed path, ASCII onlyBlank if not typed
CamrollCard verbatim, ASCII onlyNon-Latin empties this cell; the verbatim text stays in the CSV
Shoot dateyyyy-MM-ddThe date column, separate from Shoot Day
UnitUnit name, ASCII onlyYours to name
RatingThe on-set mark — Circle · Keep · Hold · N/G; blank if unmarkedA decision about the take
Circled takeTRUE / FALSEA second question, its own column
TC ModeDF only where the camera's drop-frame menu was readBlank = no declaration, not NDF
SlateX Set TimeYour stopwatch value as stored — how long the action actually ranA second ruler, meant to sit beside Duration, not replace it

Three standing boundaries. The last ten columns are ours — a receiving system may not read them as semantic fields, so check them before relying on them. The file is ASCII end to end, so a value written in non-Latin characters is a blank cell here and verbatim in the CSV. And we have run no import acceptance against any editing system: this sheet describes what we write, not what someone else will do with it.

Full detail: What to Check Before Using an ALE for Matching.