MCOM Residency Match Data Model Glossary
- Karen Taylor
Data Model
Fields Description
Field | Description | Expression |
|---|---|---|
External ID | Unique Id for Match Students. | AAMC ID |
Match Type | Type of Match | Values are : |
Match Year | Year they participated in Match |
|
Match Year Cohort | Indicates if the student graduation year is the same as the match year | Values are: |
Matched % | Percent students matched | Matched Count/Student Count |
Matched Count | Students matched | Count of records when Program name is not null |
Student Count | Count of students | Count of records when SOAP is either Y or N |
Unmatched % | Students unmatched percent | (Student Count-Matched Count)/Student Count |
Unmatched Count | Students unmatched count | Student Count-Matched Count |
Program Institution Name | Program Institution Name |
|
Program name | Program name |
|
Program state | Program state |
|
Program type code | Program type code from NRMP file | Values are P, C, M, R, A |
Program type description | Program type description from NRMP file | Values are Preliminary, Categorical, Reserved, Primary, Advanced |
Program year type |
| Values are: |
Program Zip | Program Zip Code |
|
SOAP | Matched through SOAP Indicator | Values are Y or N |
First Name | First Name | Name comes from Banner. If there is no match for AAMC ID in Banner, name from match file is displayed |
Last Name | Last Name | Name comes from Banner. If there is no match for AAMC ID in Banner, name from match file is displayed |
Middle Initial | Middle Initial | Name comes from Banner. If there is no match for AAMC ID in Banner, name from match file is displayed |
Match Graduation Date | Student graduation date as entered into NRMP |
|
Graduation Cohort Code Current | Student graduation cohort code from Banner |
|
Graduation Cohort Current | Student graduation cohort from Banner |
|
Graduation Date Current | Student graduation date from Banner |
|
Matriculation Term Code Current | Student matriculation term code from Banner | This field identifies the term student was first admitted to institution |
Student Attribute Code Current | Code of a student attribute from Banner |
|
Student Attribute Current | Description of Student Attribute code from Banner |
|
Student Status Description | To identify active or inactive students from Banner | Active |
U Number | Student U number from Banner |
|
Program Code | Curriculum Program Code from Banner |
|
Resident | Residency classification from Banner |
|
NRMP ID | NRMP ID from match files |
|