input extract {
    type: "csv";
    columns: {
        POLNUM <string>;
        ISSUE_DATE <date "%Y-%m-%d">;
        'ISSUE AGE'n <int>;
        "Is Qualified" <bool>;
        OPEN_SEGMENT_YEARS <float>;
    }
}

table policy_metadata {
    nrows: extract;
    columns: {
        polnum <string> : extract.POLNUM[t];
        issue_year <int> : $year(extract.ISSUE_DATE[t]);
        issue_month <int> : $month(extract.ISSUE_DATE[t]);
        issue_day <int> : $day(extract.ISSUE_DATE[t]);
        issue_date_reconstructed <date> : $date(
            self.issue_year[t], 
            self.issue_month[t], 
            self.issue_day[t]
        );
        open_segment_full_years <float> : 
            $floor(extract.OPEN_SEGMENT_YEARS[t]);
    }
}