Skip to content

Instantly share code, notes, and snippets.

@jcreed
Created December 12, 2014 16:10
Show Gist options
  • Save jcreed/a13c1e9413e3ca16475f to your computer and use it in GitHub Desktop.
Save jcreed/a13c1e9413e3ca16475f to your computer and use it in GitHub Desktop.
Administrator (Qa)
admin@ams.com
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: testapplicant2090@ams.com
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