Skip to content

Instantly share code, notes, and snippets.

@jcreed
Created April 30, 2015 16:58
Show Gist options
  • Save jcreed/ca4f416c988b0edca1ad to your computer and use it in GitHub Desktop.
Save jcreed/ca4f416c988b0edca1ad to your computer and use it in GitHub Desktop.
mcat attachment transformations
# Official MCAT After Jan 31 2015 Attachments
- RecordTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment'
:table_name: 'cas_attachments'
:relative_recordname: 'mcat_score_attachment'
- SharedContentTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment'
:column: 'applicant_id'
:source_relative_recordname: '1'
:source_column: 'id'
:relative_recordname: 'mcat_score_attachment'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment/@id'
:column: 'identifier'
:relative_recordname: 'mcat_score_attachment'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment/FileName'
:column: 'filename'
:relative_recordname: 'mcat_score_attachment'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment/LinkToFile'
:column: 'url'
:relative_recordname: 'mcat_score_attachment'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment/DateUploaded'
:column: 'uploaded_at'
:relative_recordname: 'mcat_score_attachment'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment/Comments'
:column: 'description'
:relative_recordname: 'mcat_score_attachment'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment'
:column: 'scope_type'
:literal: 'mcat_graph'
:relative_recordname: 'mcat_score_attachment'
# MCAT Official After Jan 31 2015:
- RecordTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015'
:table_name: 'test_scores_mcat_official_after_jan_31_2015'
:relative_recordname: 'scores_official'
- SharedContentTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/Attachment'
:column: 'mcat_graph_document_id'
:source_relative_recordname: '0/mcat_score_attachment'
:source_column: 'id'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/CPBSScore'
:relative_recordname: 'scores_official'
:column: 'chemical_and_physical'
:formatter: 'IntegerParser'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/CPBSSectionDetails/ConfidenceBandLow'
:column: 'chemical_and_physical_low_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/CPBSSectionDetails/ConfidenceBandHigh'
:column: 'chemical_and_physical_high_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/CPBSSectionDetails/PercentileRank'
:column: 'chemical_and_physical_percentile'
:formatter: 'FloatParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/CARSScore'
:relative_recordname: 'scores_official'
:column: 'analysis_and_reasoning'
:formatter: 'IntegerParser'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/CARSSectionDetails/ConfidenceBandLow'
:column: 'analysis_and_reasoning_low_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/CARSSectionDetails/ConfidenceBandHigh'
:column: 'analysis_and_reasoning_high_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/CARSSectionDetails/PercentileRank'
:column: 'analysis_and_reasoning_percentile'
:formatter: 'FloatParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/BBFLScore'
:relative_recordname: 'scores_official'
:column: 'biological_and_biochemical'
:formatter: 'IntegerParser'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/BBFLSectionDetails/ConfidenceBandLow'
:column: 'biological_and_biochemical_low_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/BBFLSectionDetails/ConfidenceBandHigh'
:column: 'biological_and_biochemical_high_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/BBFLSectionDetails/PercentileRank'
:column: 'biological_and_biochemical_percentile'
:formatter: 'FloatParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/PSBBScore'
:relative_recordname: 'scores_official'
:column: 'behavior'
:formatter: 'IntegerParser'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/PSBBSectionDetails/ConfidenceBandLow'
:column: 'behavior_low_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/PSBBSectionDetails/ConfidenceBandHigh'
:column: 'behavior_high_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/PSBBSectionDetails/PercentileRank'
:column: 'behavior_percentile'
:formatter: 'FloatParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/TotalScore'
:relative_recordname: 'scores_official'
:column: 'total'
:formatter: 'IntegerParser'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/TotalScore'
:relative_recordname: 'scores_official'
:column: 'overall_result'
:formatter: 'IntegerParser'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/TotalSectionDetails/ConfidenceBandLow'
:column: 'total_low_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/TotalSectionDetails/ConfidenceBandHigh'
:column: 'total_high_band'
:formatter: 'IntegerParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/TotalSectionDetails/PercentileRank'
:column: 'total_percentile'
:formatter: 'FloatParser'
:relative_recordname: '-2/scores_official'
- ValueTransformation:
:keypath: '/UNICAS/AcademicHistory/OfficialTests/MCATScore2015/AAMCId'
:relative_recordname: 'scores_official'
:column: 'aamc_id_number'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment