Created
April 30, 2015 16:58
-
-
Save jcreed/ca4f416c988b0edca1ad to your computer and use it in GitHub Desktop.
mcat attachment transformations
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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