Created
December 12, 2014 16:10
-
-
Save jcreed/a13c1e9413e3ca16475f to your computer and use it in GitHub Desktop.
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
| Administrator (Qa) | |
| [email protected] | |
| Dashboard | |
| Account | |
| Logout | |
| Applicant successfully ETL'd | |
| Organizations & Users | |
| CASs | |
| Institutions | |
| Organizations | |
| Programs | |
| Users | |
| Admin Links | |
| Document Setup | |
| ETL Viewer | |
| FAQ's | |
| CAS GPA Calculations | |
| Features | |
| Help Text | |
| Lookups Manager | |
| Pages | |
| Scoring Stats | |
| Splash Message | |
| Status | |
| CAS 3 ETL Status | |
| CAS3 ---> WebAdMIT ETL Status Page | |
| One-button ETL | |
| Last Applicant Transfered XML | |
| Last Applicant Loaded YAML | |
| --- | |
| - table_name: applicants | |
| id: &29000960 | |
| - id-proxy | |
| - 8d9c0354-ee41-4d88-9b87-c96787041596 | |
| identifier: '6150443515' | |
| cas_id: '6150443515' | |
| association_id: &28995720 | |
| - lookup-proxy | |
| - cas_by_cas3_identifier | |
| - '10152014' | |
| first_name: test | |
| last_name: applicant2090 | |
| middle_name: V | |
| suffix: '' | |
| email: [email protected] | |
| visible_for_advisor: true | |
| __recordname: UNICAS | |
| - table_name: details | |
| id: | |
| - id-proxy | |
| - 290dbaa5-62cc-4f72-9137-9a9039668d15 | |
| applicant_id: *29000960 | |
| gender_id: | |
| - lookup-proxy | |
| - gender_by_code | |
| - MALE | |
| revision_tag: details | |
| materials_under_another_name: false | |
| phone_type_preference_id: | |
| - lookup-proxy | |
| - phone_preferences | |
| - Work | |
| __recordname: UNICAS/details | |
| - table_name: contacts | |
| id: | |
| - id-proxy | |
| - 9b2c0814-03d6-4af2-b1f3-58b63cd62f47 | |
| applicant_id: *29000960 | |
| owner_id: *29000960 | |
| owner_type: Applicant | |
| identifier: __preferred | |
| contact_type_id: | |
| - lookup-proxy | |
| - contact_types | |
| - preferred | |
| work_phone: '+18772321121' | |
| phone: '+18772321121' | |
| revision_tag: preferred_contact | |
| phone_preference: '+18772321121' | |
| phone_type_id: 4149 | |
| __recordname: UNICAS/0/Biographicinfo/0/ContactInfo/0/Address/preferred | |
| - table_name: designations | |
| id: | |
| - id-proxy | |
| - b60db995-4bf1-4641-a83e-df56802cbccd | |
| applicant_id: *29000960 | |
| association_id: *28995720 | |
| application_status_id: | |
| - lookup-proxy | |
| - application_statuses | |
| - In Progress | |
| identifier: 7751 | |
| school_code: '3865' | |
| program_id: | |
| - lookup-proxy | |
| - programs | |
| - '7751' | |
| __recordname: UNICAS/0/Designations/0/Program/7751 | |
| - table_name: designations | |
| id: | |
| - id-proxy | |
| - 9f814c83-e0a5-4186-be47-8f668540537a | |
| applicant_id: *29000960 | |
| association_id: *28995720 | |
| application_status_id: | |
| - lookup-proxy | |
| - application_statuses | |
| - In Progress | |
| identifier: 5240 | |
| school_code: '3976' | |
| program_id: | |
| - lookup-proxy | |
| - programs | |
| - '5240' | |
| __recordname: UNICAS/0/Designations/0/Program/5240 | |
| - table_name: college_attendeds | |
| id: &28823640 | |
| - id-proxy | |
| - 52a85234-5a4c-490f-9b00-b5f24f818625 | |
| identifier: 33624 | |
| type: GeneralCollege | |
| applicant_id: *29000960 | |
| college_id: &28812160 | |
| - lookup-proxy | |
| - colleges | |
| - '25986' | |
| start_date: 2002-03-01 | |
| end_date: 2006-06-01 | |
| primary: true | |
| unlisted_name: '' | |
| __recordname: UNICAS/0/AcademicHistory/0/CollegesAttended/0/CollegeAttended/33624 | |
| - table_name: applicant_degrees | |
| id: &28796680 | |
| - id-proxy | |
| - 724872c3-f633-4d0e-ac30-8dafbd0890df | |
| applicant_id: *29000960 | |
| college_attended_id: *28823640 | |
| identifier: '19422' | |
| degree_id: | |
| - lookup-proxy | |
| - degrees | |
| - '491' | |
| degree_status_id: | |
| - lookup-proxy | |
| - degree_statuses | |
| - 431 | |
| award_date: 2006-04-01 | |
| __recordname: UNICAS/0/AcademicHistory/0/CollegesAttended/0/CollegeAttended/33624/Degree/19422 | |
| - table_name: applicant_majors | |
| id: | |
| - id-proxy | |
| - 04c79995-8666-48d1-8a58-2f6c0d5cd588 | |
| applicant_id: *29000960 | |
| association_id: *28995720 | |
| applicant_degree_id: *28796680 | |
| index: 1 | |
| major_id: | |
| - lookup-proxy | |
| - majors_by_name | |
| - Astronomy | |
| __recordname: UNICAS/0/AcademicHistory/0/CollegesAttended/0/CollegeAttended/33624/Degree/19422/major_/0/AcademicHistory/0/CollegesAttended/0/CollegeAttended/33624/Degree/19422 | |
| - table_name: applicant_minors | |
| id: | |
| - id-proxy | |
| - 6d71c045-a489-46d6-925d-8dd14c955b67 | |
| applicant_id: *29000960 | |
| association_id: *28995720 | |
| applicant_degree_id: *28796680 | |
| minor_number: 1 | |
| minor_id: | |
| - lookup-proxy | |
| - majors_by_name | |
| - Art | |
| __recordname: UNICAS/0/AcademicHistory/0/CollegesAttended/0/CollegeAttended/33624/Degree/19422/minor_/0/AcademicHistory/0/CollegesAttended/0/CollegeAttended/33624/Degree/19422 | |
| - table_name: academic_sessions | |
| id: &28737400 | |
| - id-proxy | |
| - 69a205d5-a66e-40ba-b404-c213858369f6 | |
| identifier: 108583 | |
| applicant_id: *29000960 | |
| association_id: *28995720 | |
| college_id: *28812160 | |
| term_id: | |
| - lookup-proxy | |
| - terms | |
| - 470 | |
| term_type_id: | |
| - lookup-proxy | |
| - term_types | |
| - 466 | |
| year: 2002 | |
| academic_year_id: &28720000 | |
| - lookup-proxy | |
| - academic_years | |
| - '459' | |
| session_status: Completed | |
| last_modified: 2014-12-09 | |
| verified: false | |
| __recordname: UNICAS/0/AcademicHistory/0/CollegesAttended/0/CollegeAttended/33624/Term/108583 | |
| - table_name: courses | |
| id: &28711000 | |
| - id-proxy | |
| - 0a867b90-e1f5-4cf8-904e-33f0a60f00ec | |
| applicant_id: *29000960 | |
| academic_session_id: *28737400 | |
| verified: false | |
| identifier: '365356' | |
| prefix: PHY 101 | |
| title: Introduction to Physics | |
| subject_id: | |
| - lookup-proxy | |
| - subjects_by_name | |
| - Physics | |
| classification_id: | |
| - lookup-proxy | |
| - course_classifications_by_name | |
| - Advanced Placement | |
| academic_year_id: *28720000 | |
| application_grade: B+ | |
| grade: B+ | |
| verified_grade: | |
| credits: '3.0' | |
| verified_credits: | |
| __recordname: UNICAS/course/365356 | |
| - table_name: courses | |
| id: &28708080 | |
| - id-proxy | |
| - ff6d2580-4398-41db-93b1-51f65ae7d6be | |
| applicant_id: *29000960 | |
| academic_session_id: *28737400 | |
| verified: false | |
| identifier: '365357' | |
| prefix: CHEM 101 | |
| title: Introduction to Chemistry | |
| subject_id: | |
| - lookup-proxy | |
| - subjects_by_name | |
| - Chemical Math | |
| classification_id: | |
| - lookup-proxy | |
| - course_classifications_by_name | |
| - Not Applicable | |
| academic_year_id: *28720000 | |
| application_grade: A | |
| grade: A | |
| verified_grade: | |
| credits: '4.0' | |
| verified_credits: | |
| __recordname: UNICAS/course/365357 | |
| - table_name: courses | |
| id: &28705060 | |
| - id-proxy | |
| - cab88b1d-9069-47f7-997b-53473cc86a90 | |
| applicant_id: *29000960 | |
| academic_session_id: *28737400 | |
| verified: false | |
| identifier: '365358' | |
| prefix: BIO 101 | |
| title: Introduction to Biology | |
| subject_id: | |
| - lookup-proxy | |
| - subjects_by_name | |
| - Biology | |
| classification_id: | |
| - lookup-proxy | |
| - course_classifications_by_name | |
| - Not Applicable | |
| academic_year_id: *28720000 | |
| application_grade: A- | |
| grade: A- | |
| verified_grade: | |
| credits: '2.0' | |
| verified_credits: | |
| __recordname: UNICAS/course/365358 | |
| - table_name: courses | |
| id: | |
| - id-proxy | |
| - e8322fa2-c800-496e-8cf8-5204e210c577 | |
| applicant_id: *29000960 | |
| academic_session_id: *28737400 | |
| verified: false | |
| identifier: '365359' | |
| prefix: ETH 101 | |
| title: Ethics | |
| subject_id: | |
| - lookup-proxy | |
| - subjects_by_name | |
| - Ethics | |
| classification_id: | |
| - lookup-proxy | |
| - course_classifications_by_name | |
| - Not Applicable | |
| academic_year_id: *28720000 | |
| application_grade: A+ | |
| grade: A+ | |
| verified_grade: | |
| credits: '3.0' | |
| verified_credits: | |
| __recordname: UNICAS/course/365359 | |
| - table_name: transcripts | |
| id: | |
| - id-proxy | |
| - e9e8ea00-97c4-4e75-8c98-eb27fa85b205 | |
| applicant_id: *29000960 | |
| association_id: *28995720 | |
| identifier: 35045 | |
| college_attended_id: *28823640 | |
| college_id: *28812160 | |
| barcode: 6150443515-33624-X | |
| received: false | |
| __recordname: UNICAS/0/AcademicHistory/0/CollegesAttended/0/CollegeAttended/33624/Transcript/35045 | |
| - table_name: licenses | |
| id: &28466220 | |
| - id-proxy | |
| - 4889e210-c8c8-4640-a30c-a880d97851be | |
| applicant_id: *29000960 | |
| identifier: '5764' | |
| licensing_organization: Test Organization 1 | |
| expiration_date: 2019-10-31 | |
| license_type_id: '5654' | |
| state: | |
| - lookup-proxy | |
| - state_abbreviations_by_name | |
| - Delaware | |
| issued_date: 2007-06-06 | |
| narrow_field_type: Registered Nurse | |
| in_good_standing: true | |
| __recordname: UNICAS/0/SupportingInformation/0/LicensesCertifications/0/Licenses/5764 | |
| - table_name: licenses | |
| id: &28463460 | |
| - id-proxy | |
| - b26fabdd-0a22-4359-9ddd-12584ed6f985 | |
| applicant_id: *29000960 | |
| identifier: '5765' | |
| licensing_organization: Test Organization 2 | |
| expiration_date: 2030-11-22 | |
| license_type_id: '5655' | |
| state: | |
| - lookup-proxy | |
| - state_abbreviations_by_name | |
| - California | |
| issued_date: 2012-02-02 | |
| narrow_field_type: Licensed Practical Nurse (Licensed Vocational Nurse) | |
| in_good_standing: false | |
| __recordname: UNICAS/0/SupportingInformation/0/LicensesCertifications/0/Licenses/5765 | |
| - table_name: cas_attachments | |
| id: | |
| - id-proxy | |
| - 4faec47f-e573-44b0-a5e4-9c18698ec469 | |
| applicant_id: *29000960 | |
| identifier: '7312' | |
| scope_type: cas | |
| filename: URLS.txt | |
| url: /mnt/nas/CAS30/CAS_UPLOAD/TMP6150443515_1a811bb5-609e-4288-848b-57beeb07bac4.pdf | |
| uploaded_at: '2014-12-03' | |
| description: Licensure | |
| owner_id: *28466220 | |
| owner_type: License | |
| __recordname: UNICAS/0/SupportingInformation/0/LicensesCertifications/0/Licenses/5764/Attachment/7312 | |
| - table_name: cas_attachments | |
| id: | |
| - id-proxy | |
| - b25029de-0e4d-42ab-ad92-7fb2ddad0e6a | |
| applicant_id: *29000960 | |
| identifier: '7313' | |
| scope_type: cas | |
| filename: Test1.txt | |
| url: /mnt/nas/CAS30/CAS_UPLOAD/TMP6150443515_4d83c8c3-9220-45b6-99ea-0f09a783307a.pdf | |
| uploaded_at: '2014-12-03' | |
| description: Licensure | |
| owner_id: *28463460 | |
| owner_type: License | |
| __recordname: UNICAS/0/SupportingInformation/0/LicensesCertifications/0/Licenses/5765/Attachment/7313 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - ef8343db-c399-4fb7-b40b-74ee4565291a | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - custom_questions | |
| - '12712' | |
| string_value: '' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/CustomQuestions/0/Question/12712 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - e5400add-5185-4749-bd0c-dc278e0f022d | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - custom_questions | |
| - '12713' | |
| string_value: '' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/CustomQuestions/0/Question/12713 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - 59c2295a-84b5-44bd-8ce1-bdb898fa57d9 | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - custom_questions | |
| - '12714' | |
| string_value: '' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/CustomQuestions/0/Question/12714 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - 007e4037-7ad4-4702-8404-8fce7b03da70 | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - custom_questions | |
| - '12715' | |
| string_value: '' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/CustomQuestions/0/Question/12715 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - dc0ece81-3d4c-4211-8168-f9da4d38c87e | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - custom_questions | |
| - '12717' | |
| string_value: '' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/CustomQuestions/0/Question/12717 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - 925ea70d-d845-4994-b8ea-e963752dda51 | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - custom_questions | |
| - '12719' | |
| string_value: '' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/CustomQuestions/0/Question/12719 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - 2aa5d215-6255-4aef-ab53-8c01f002d131 | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - custom_questions | |
| - '12866' | |
| string_value: '' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/CustomQuestions/0/Question/12866 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - f7bb1120-075c-4220-9cd6-c7c379d0dc3e | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - supplemental_questions | |
| - '14712' | |
| string_value: 'No' | |
| supplemental_lookup_id: | |
| - lookup-proxy | |
| - supplemental_answers | |
| - '28577' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/Designations/0/Program/5240/SupplementalQuestions/0/Question/14712 | |
| - table_name: answer_bases | |
| id: | |
| - id-proxy | |
| - 6f5784aa-41b2-4c64-a0f2-e21c8c5547bf | |
| type: SupplementalAnswer | |
| applicant_id: *29000960 | |
| question_base_id: | |
| - lookup-proxy | |
| - supplemental_questions | |
| - '15845' | |
| string_value: 'Yes' | |
| supplemental_lookup_id: | |
| - lookup-proxy | |
| - supplemental_answers | |
| - '30563' | |
| revision_tag: answer_bases | |
| __recordname: UNICAS/0/Designations/0/Program/5240/SupplementalQuestions/0/Question/15845 | |
| - table_name: applicant_requirements | |
| id: &28190340 | |
| - id-proxy | |
| - b9dde072-7805-4c46-8840-75c517b472f7 | |
| applicant_id: *29000960 | |
| fulfilled: true | |
| requirement_id: | |
| - lookup-proxy | |
| - requirements | |
| - '7751' | |
| requirement_type: Prerequisite | |
| __recordname: UNICAS/requirement/7751 | |
| - table_name: applicant_criteria | |
| id: &28178520 | |
| - id-proxy | |
| - c753ccaf-a1d9-41b2-a62f-d2b054f4d8cb | |
| applicant_id: *29000960 | |
| applicant_requirement_id: *28190340 | |
| criterion_id: | |
| - lookup-proxy | |
| - criteria | |
| - '4191' | |
| fulfilled: true | |
| __recordname: UNICAS/requirement/applicant_criterion/4191 | |
| - table_name: applicant_criteria | |
| id: &28175560 | |
| - id-proxy | |
| - d7c336bb-9f11-48a6-987e-046ff95f68de | |
| applicant_id: *29000960 | |
| applicant_requirement_id: *28190340 | |
| criterion_id: | |
| - lookup-proxy | |
| - criteria | |
| - '4192' | |
| fulfilled: true | |
| __recordname: UNICAS/requirement/applicant_criterion/4192 | |
| - table_name: applicant_criteria | |
| id: &28172600 | |
| - id-proxy | |
| - 9e578bd1-fda2-4ea4-b195-93873ce88283 | |
| applicant_id: *29000960 | |
| applicant_requirement_id: *28190340 | |
| criterion_id: | |
| - lookup-proxy | |
| - criteria | |
| - '4193' | |
| fulfilled: true | |
| __recordname: UNICAS/requirement/applicant_criterion/4193 | |
| - table_name: applicant_criteria | |
| id: &28169780 | |
| - id-proxy | |
| - afb823f2-9d17-43ee-905e-54e3a12009e8 | |
| applicant_id: *29000960 | |
| applicant_requirement_id: *28190340 | |
| criterion_id: | |
| - lookup-proxy | |
| - criteria | |
| - '4194' | |
| fulfilled: true | |
| __recordname: UNICAS/requirement/applicant_criterion/4194 | |
| - table_name: applicant_criteria_courses | |
| id: | |
| - id-proxy | |
| - ae523c37-0e21-4921-a610-53858c097b85 | |
| applicant_id: *29000960 | |
| applicant_criterion_id: *28178520 | |
| course_id: *28711000 | |
| __recordname: UNICAS/0/Designations/0/Program/7751/Prerequisites/0/Requirement/4191/CourseAssignment/0/Course/365356 | |
| - table_name: applicant_criteria_courses | |
| id: | |
| - id-proxy | |
| - c8237ec7-84a8-4b95-95e2-d2962d28d3ac | |
| applicant_id: *29000960 | |
| applicant_criterion_id: *28175560 | |
| course_id: *28708080 | |
| __recordname: UNICAS/0/Designations/0/Program/7751/Prerequisites/0/Requirement/4192/CourseAssignment/0/Course/365357 | |
| - table_name: applicant_criteria_courses | |
| id: | |
| - id-proxy | |
| - c1bb1a13-bc5e-41a1-a6cd-5a35aa35ccb7 | |
| applicant_id: *29000960 | |
| applicant_criterion_id: *28172600 | |
| course_id: *28705060 | |
| __recordname: UNICAS/0/Designations/0/Program/7751/Prerequisites/0/Requirement/4193/CourseAssignment/0/Course/365358 | |
| - table_name: applicant_criteria_courses | |
| id: | |
| - id-proxy | |
| - d9a46e63-694c-471b-a6e2-3c933adfd254 | |
| applicant_id: *29000960 | |
| applicant_criterion_id: *28169780 | |
| course_id: *28711000 | |
| __recordname: UNICAS/0/Designations/0/Program/7751/Prerequisites/0/Requirement/4194/CourseAssignment/0/Course/365356 | |
| © 2009–2014 Academic Software Plus — a subsidiary of Liaison International — All Rights Reserved | |
| Qa: deployed on wa-app-q0 revision d82198a8b 3 days ago. vVv features | |
| User 4, User Identity 1 | |
| qa |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment