| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Academic period or time frame this person applied to study at this institution.
|
VARCHAR2(6)
|
SGBSTDN
|
SGBSTDN_TERM_CODE_EFF
|
|
ACADEMIC_PERIOD_ADMITTED
|
Academic period or time frame associated with the information on the student record.
|
VARCHAR2(6)
|
SORLCUR
|
SORLCUR_TERM_CODE_ADMIT
|
|
ACADEMIC_PERIOD_ADMITTED_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_PERIOD_MATRICULATED
|
Academic period or time frame in which the student was matriculated in this curriculum. The time period when they began formal study in this academic study.
|
VARCHAR2(6)
|
SORLCUR
|
SORLCUR_TERM_CODE_MATRIC
|
|
ACADEMIC_PERIOD_MATRIC_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(4)
|
STVTERM
|
STVTERM_ACYR_CODE
|
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
|
ACTIVE_IND
|
Indicates whether the student is active in this curriculum.
|
VARCHAR2(1)
|
SOBCACT
|
SOBCACT_ACTIVE_IND
|
|
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
SORLCUR
|
SORLCUR_ACTIVITY_DATE
|
|
ADMISSIONS_POPULATION
|
Identifies an admission population such as early admit, mature, adult and continuing education, etc., associated with the person and application.
|
VARCHAR2(2)
|
SORLCUR
|
SORLCUR_ADMT_CODE
|
|
ADMISSIONS_POPULATION_DESC
|
Admission population description.
|
VARCHAR2(30)
|
STVADMT
|
STVADMT_DESC
|
|
AGE_ADMITTED
|
Calculated age of the person at the time of admission to the institution.
|
NUMBER
|
FUNCTION
|
SOKODSF.F_CALCULATE_AGE_ADMIT
|
|
APPLICATION_CURRIC_SEQUENCE
|
Sequence number of the application curriculum the learner curriculum was created from.
|
NUMBER(4)
|
SORLCUR
|
SORLCUR_APPL_SEQNO
|
|
APPLICATION_NUMBER
|
Application number the learner curriculum was created from.
|
NUMBER(2)
|
SORLCUR
|
SORLCUR_APPL_KEY_SEQNO
|
|
CAMPUS
|
Campus to which applicant is applying.
|
VARCHAR2(3)
|
SORLCUR
|
SORLCUR_CAMP_CODE
|
|
CAMPUS_DESC
|
Institution campus name.
|
VARCHAR2(30)
|
STVCAMP
|
STVCAMP_DESC
|
|
CATALOG_ACADEMIC_PERIOD
|
Catalog academic period used to measure completion requirements for the outcome.
|
VARCHAR2(6)
|
SORLCUR
|
SORLCUR_TERM_CODE_CTLG
|
|
CATALOG_ACADEMIC_PERIOD_DESC
|
Catalog academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
|
COLLEGE
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(2)
|
SORLCUR
|
SORLCUR_COLL_CODE
|
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(30)
|
STVCOLL
|
STVCOLL_DESC
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
|
CURRENT_IND
|
Indicates whether this is the most recent curriculum record for this academic period.
|
VARCHAR2(1)
|
FUNCTION
|
SB_CURRICULUM.F_FIND_CURRENT_ALL_IND
|
|
CURRICULUM_ACTIVITY_STATUS
|
Identifies the student current status or activity within this curriculum.
|
VARCHAR2(15)
|
SORLCUR
|
SORLCUR_CACT_CODE
|
|
CURRICULUM_ACTIVITY_STAT_DESC
|
Curriculum activity status description.
|
VARCHAR2(30)
|
STVCACT
|
STVCACT_DESC
|
|
CURRICULUM_PRIORITY
|
Identifies the significanct ranking for a curricula.
|
NUMBER(4)
|
SORLCUR
|
SORLCUR_PRIORITY_NO
|
|
CURRICULUM_SEQUENCE
|
System generated one-up number assigned to a student or learner for a curriculum or curriculum changes.
|
NUMBER(4)
|
SORLCUR
|
SORLCUR_SEQNO
|
|
DEGREE
|
Degree or award code associated with the academic study.
|
VARCHAR2(6)
|
SORLCUR
|
SORLCUR_DEGC_CODE
|
|
DEGREE_AWARD_CATEGORY
|
Award category associated with the degree used for reporting by type of awards. Includes 2 year awards, 4 year, professional, etc.
|
VARCHAR2(2)
|
STVDEGC
|
STVDEGC_ACAT_CODE
|
|
DEGREE_AWARD_CATEGORY_DESC
|
Degree award category description.
|
VARCHAR2(30)
|
STVACAT
|
STVACAT_DESC
|
|
DEGREE_DESC
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(30)
|
STVDEGC
|
STVDEGC_DESC
|
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
|
END_DATE
|
Date the student became inactive in this curriculum.
|
DATE
|
SORLCUR
|
SORLCUR_END_DATE
|
|
EXPECTED_GRADUATION_DATE
|
Expected graduation date.
|
DATE
|
SORLCUR
|
SORLCUR_EXP_GRAD_DATE
|
|
GRAD_ACADEMIC_PERIOD_INTENDED
|
Intended academic period of graduation for the student.
|
VARCHAR2(6)
|
SORLCUR
|
SORLCUR_TERM_CODE_GRAD
|
|
GRAD_ACAD_PERIOD_INTENDED_DESC
|
Intended graduation term description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
|
GRAD_YEAR_INTENDED
|
Intended year of graduation.
|
VARCHAR2(4)
|
SORLCUR
|
SORLCUR_ACYR_CODE
|
|
GRAD_YEAR_INTENDED_DESC
|
Academic year description.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
|
LAST_ACADEMIC_PERIOD_DESC
|
Field of study last active academic period desc.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
|
LAST_ACTIVE_ACADEMIC_PERIOD
|
Field of study last active academic period.
|
VARCHAR2(6)
|
SORLCUR
|
SORLCUR_TERM_CODE_END
|
|
LEAVE_DATE_FROM
|
Start date of the student leave.
|
DATE
|
SORLCUR
|
SORLCUR_LEAV_FROM_DATE
|
|
LEAVE_DATE_TO
|
End date of the student leave.
|
DATE
|
SORLCUR
|
SORLCUR_LEAV_TO_DATE
|
|
LEAVE_REASON
|
Leave code of the student for this academic period.
|
VARCHAR2(1)
|
SORLCUR
|
SORLCUR_LEAV_CODE
|
|
LEAVE_REASON_DESC
|
Student's leave code description for this term.
|
VARCHAR2(30)
|
STVLEAV
|
STVLEAV_DESC
|
|
MATRICULATED_IND
|
Indicates whether the student has matriculated, and was formally admitted to a degree granting academic study or program.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,N,Y)
|
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
|
OUTCOME_NUMBER
|
Degree or award sequence number for this academic outcome for the student.
|
NUMBER(4)
|
SORLCUR
|
SORLCUR_ROLLED_SEQNO
|
|
OUTCOME_ROLL_IND
|
Indicates if the learner curriculum should roll to academic history when courses are rolled.
|
VARCHAR2(1)
|
SORLCUR
|
SORLCUR_ROLL_IND
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER(8)
|
SORLCUR
|
SORLCUR_PIDM
|
|
PROGRAM
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.
|
VARCHAR2(12)
|
SORLCUR
|
SORLCUR_PROGRAM
|
|
PROGRAM_DESC
|
Program or course of study description.
|
VARCHAR2(30)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
|
SITE
|
Site or location to which applicant is applying.
|
VARCHAR2(3)
|
SORLCUR
|
SORLCUR_SITE_CODE
|
|
SITE_CARRIER_ROUTE
|
Carrier route associated with the site address for barcode mailings.
|
VARCHAR2(4)
|
NA
|
NA
|
|
SITE_CITY
|
City, town or municipality associated with the site address.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_CORRECTION_DIGIT
|
Correction digit associated with the site address for barcode mailings.
|
VARCHAR2(1)
|
NA
|
NA
|
|
SITE_COUNTY_CODE
|
County associated with the site address.
|
VARCHAR2(5)
|
NA
|
NA
|
|
SITE_COUNTY_CODE_DESC
|
Descriptions of the county associated with the site address.
|
VARCHAR2(30)
|
NA
|
NA
|
|
SITE_DELIVERY_POINT
|
Delivery point associated with the site address for barcode mailings.
|
VARCHAR2(2)
|
NA
|
NA
|
|
SITE_DESC
|
Site or location name.
|
VARCHAR2(30)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_NATION
|
Nation/country code associated with the site address.
|
VARCHAR2(5)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_NATION_DESC
|
Description for the nation/country associated with the site address.
|
VARCHAR2(30)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_POSTAL_CODE
|
Postal code associated with the site address.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_STATE_PROVINCE
|
Identifies the state or province associated with this address.
|
VARCHAR2(3)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_STATE_PROVINCE_DESC
|
Name of the state/province.
|
VARCHAR2(30)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_STREET_LINE1
|
First line of the site address.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_STREET_LINE2
|
Second line of the site address.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_STREET_LINE3
|
Third line of the site address.
|
VARCHAR2(255)
|
FUNCTION
|
SOKODSF.F_SITE
|
|
SITE_STREET_LINE4
|
Fourth line of the site address.
|
VARCHAR2(255)
|
NA
|
NA
|
|
SOURCE
|
Administrative system source for this record. For example, recruiting, admissions, learner, academic outcome.
|
VARCHAR2(15)
|
SORLCUR
|
SORLCUR_LMOD_CODE
|
|
SOURCE_DESC
|
Student or learner source description.
|
VARCHAR2(30)
|
STVLMOD
|
STVLMOD_DESC
|
|
SOURCE_SEQUENCE_NUMBER
|
Sequence number of the source key record.
|
NUMBER(2)
|
SORLCUR
|
SORLCUR_KEY_SEQNO
|
|
START_DATE
|
Date the student became active in this curriculum.
|
DATE
|
SORLCUR
|
SORLCUR_START_DATE
|
|
START_DATE_ADMITTED
|
Date the student began to study courses within this academic study.
|
DATE
|
STVTERM
|
STVTERM_START_DATE
|
|
START_DATE_MATRICULATED
|
Date the student was official accepted or matriculated into this academic study. It may be individual for the person or taken from the start date for the academic period in which the person was matriculated.
|
DATE
|
STVTERM
|
STVTERM_START_DATE
|
|
STUDENT_LEVEL
|
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
|
VARCHAR2(2)
|
SORLCUR
|
SORLCUR_LEVL_CODE
|
|
STUDENT_LEVEL_DESC
|
Student level description.
|
VARCHAR2(30)
|
STVLEVL
|
STVLEVL_DESC
|
|
STUDENT_POPULATION
|
Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc.
|
VARCHAR2(1)
|
SORLCUR
|
SORLCUR_STYP_CODE
|
|
STUDENT_POPULATION_DESC
|
Student population or type description.
|
VARCHAR2(30)
|
STVSTYP
|
STVSTYP_DESC
|
|
STUDENT_RATE
|
Identifies any specific assessment rate to be used to determine the charges for this student.
|
VARCHAR2(5)
|
SORLCUR
|
SORLCUR_RATE_CODE
|
|
STUDENT_RATE_DESC
|
Description for the rate code.
|
VARCHAR2(30)
|
STVRATE
|
STVRATE_DESC
|
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(3)
|
NA
|
NA
|
|
SUB_ACADEMIC_PERIOD_ADMITTED
|
Session or part of the academic period associated with the information on the academic study information record.
|
VARCHAR2(3)
|
NA
|
NA
|
|
SUB_ACADEMIC_PERIOD_ADMIT_DESC
|
Description of the session or part of the academic period associated with the session code.
|
VARCHAR2(30)
|
NA
|
NA
|
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(30)
|
NA
|
NA
|
|
SUB_ACADEMIC_PERIOD_MATRIC
|
Matriculation sub-academic period of the student.
|
VARCHAR2(3)
|
NA
|
NA
|
|
SUB_ACAD_PERIOD_MATRIC_DESC
|
Sub-academic period description.
|
VARCHAR2(30)
|
NA
|
NA
|
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
SORLCUR
|
SORLCUR_USER_ID
|
|
YEAR_ADMITTED
|
Academic year the student was admitted to this academic study.
|
VARCHAR2(4)
|
STVTERM
|
STVTERM_ACYR_CODE
|
|
YEAR_ADMITTED_DESC
|
Academic year description.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
|
YEAR_MATRICULATED
|
Academic year the student matriculated to this academic study.
|
VARCHAR2(4)
|
STVTERM
|
STVTERM_ACYR_CODE
|
|
YEAR_MATRICULATED_DESC
|
Academic year description.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|