Child pages
  • Tool: Main-Details

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ParameterExternal TableLocationField NameDescriptionExample
genderexternal_personMain-DetailsGenderStudent's genderM
marital_statusexternal_personMain-DetailsMarital StatusStudent's marital status. Note that unlike student_type_code, the value in marital_status is expected to be a screen-displayable name.Separated
ethnicityexternal_personMain-DetailsEthnicityStudent's ethnicity. Note that unlike student_type_code, the value in ethnicity is expected to be a screen-displayable name.Other
race_codeexternal_personMain-DetailsRaceStudent's race. Like student_type_code, the value displayed on-screen is the name of the reference item, which is not necessarily the same as its code (e.g. "White" vs "W"). The external data should contain the code, not the actual value. 
residency_countyexternal_persnoMain-DetailsResidencyThe county of residenceHamilton
F1_statusexternal_personMain-Dashboard
Main-Details
MAP-FinancialAid
F1Y or N, indicates if the student has an F1 Visa on fileY
gradelocal_point_averagegpaexternal_student_transcriptMain-Dashboard
Main-Details
MAP-FinancialAid
GPAThe calculated cumulative GPA valueCustom gpa traditionally used for resident credit only1.82
program_gpaexternal_student_transcriptMain-DetailsProgram GPACustom gpa traditionally used for program/major credit only3.00
codecareer_decision_statusMain-DetailsCareer StatusA code to represent and match the Career Decision Status configured optionsCP
academic_standingexternal_student_transcriptMain-Dashboard
Main-Details MAP-FinancialAid
StandingCurrent academic standing of the studentProbation
current_restrictionsexternal_student_transcriptMain-Dashboard
Main-Details
MAP-FinancialAid
RestrictionsList of any restrictions or holds on the student recordie. Dismissed, Hold, Fine
program_nameexternal_student_academic_programMain-Dashboard
Main-Details
Academic ProgramFormatted program name used for display in SSPAssociates of Science in Automotive Technology
intended_program_at_admitexternal_student_academic_programMain-DetailsIntended ProgramFrom the Admissions application, the intended program of student formatted program name used for display in SSP.Associates of Science in Automotive Technology
campus_codeexternal_personMain-DetailsHome CampusThe home campus for the student. The code value must match a configured reference item in Early Alert campus.DAY
<Anticipated Start Term>     

credit_earned

credit_type

external_student_transcript_course

Main-Details
Main-Transcript
MAP-Transcript

Transfer Hrs

The number of transfer hours the student has completed.
Including or excluding this value from the Hrs Earned Value is optional.

ie. Institutional, Transfer, Proficiency, Placement
<Plan Program>     
<Plan Catalog Year>     
statusexternal_person_planning_statusMain-Dashboard
Main-Details
MAP-MainPage
Plan StatusThe status of the active plan. Valid values are On and Off.Off Plan

<Plan Name>

     
<Plan Owner>     
<Plan Updated>     
<Plan Ends>     
credit_completion_rateexternal_student_transcriptMain-Dashboard
Main-Details
MAP-FinancialAid
Comp RateCompletion rate of hours attempted86%
credit_hours_attemptedexternal_student_transcriptMain-Details
MAP-FinancialAid

Hrs AttemptedThe total value of credit hours attempted whether or not included in the hours for GPA or hours earned.36
credit_hours_earnedexternal_student_transcriptMain-Details
MAP-FinancialAid
Hrs EarnedThe total value of credit hours successfully completed or earned31
grade_point_averageexternal_student_transcriptMain-Dashboard
Main-Details
MAP-FinancialAid
GPAThe calculated cumulative GPA value1.82
term_codeexternal_registration_status_by_termMain-Dashboard
Main-DetailsMAP-FinancialAid
RegList of current and future terms for which the student is registeredFA2013
credit_hours_attemptedexternal_student_transcript_termMain-Details
MAP-FinancialAidTranscript

Hrs AttemptedThe total value of credit hours attempted36
credit_hours_earnedexternal_student_transcript_termMain-Details
MAP-FinancialAidTranscript
Hrs EarnedThe total value of credit hours successfully completed31
grade_point_averageexternal_student_transcript_termMain-Dashboard
Main-Details
MAP-FinancialAid
GPAThe calculated GPA value (not cumulative) 1.82
tuition_paidexternal_registration_status_by_termMain-Dashboard
Main-Details
MAP-FinancialAid
PaymentY or N, indicates payment status of tuition for the termFA2013=N

...