Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	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	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	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	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 and curriculum sequence.	VARCHAR2(1)		SORLCUR	SORLCUR_CURRENT_CDE
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	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	Expected graduation date.	DATE		SORLCUR	SORLCUR_EXP_GRAD_DATE
GRAD_ACADEMIC_PERIOD_INTENDED	Graduation 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	Graduation 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	Leave From Date	Start date of the student leave.	DATE		SORLCUR	SORLCUR_LEAV_FROM_DATE
LEAVE_DATE_TO	Leave To Date	End date of the student leave.	DATE		SORLCUR	SORLCUR_LEAV_TO_DATE
LEAVE_REASON	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	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	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 Description	Site or location name.	VARCHAR2(30)		FUNCTION	SOKODSF.F_SITE
SITE_NATION	Site Nation	Nation/country code associated with the site address.	VARCHAR2(5)		FUNCTION	SOKODSF.F_SITE
SITE_NATION_DESC	Site Nation Description	Description for the nation/country associated with the site address.	VARCHAR2(30)		FUNCTION	SOKODSF.F_SITE
SITE_POSTAL_CODE	Site Postal Code	Postal code associated with the site address.	VARCHAR2(63)		FUNCTION	SOKODSF.F_SITE
SITE_STATE_PROVINCE	Site State Province	Identifies the state or province associated with this address.	VARCHAR2(3)		FUNCTION	SOKODSF.F_SITE
SITE_STATE_PROVINCE_DESC	Site State Province Description	Name of the state/province.	VARCHAR2(30)		FUNCTION	SOKODSF.F_SITE
SITE_STREET_LINE1	Site Street Line 1	First line of the site address.	VARCHAR2(255)		FUNCTION	SOKODSF.F_SITE
SITE_STREET_LINE2	Site Street Line 2	Second line of the site address.	VARCHAR2(255)		FUNCTION	SOKODSF.F_SITE
SITE_STREET_LINE3	Site Street Line 3	Third line of the site address.	VARCHAR2(255)		FUNCTION	SOKODSF.F_SITE
SITE_STREET_LINE4	Site Street Line 4	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	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	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	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(3)		NA	NA
SUB_ACADEMIC_PERIOD_ADMITTED	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	Sub Academic Period Admit Description	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	Sub academic period description.	VARCHAR2(30)		NA	NA
SUB_ACADEMIC_PERIOD_MATRIC	Sub Academic Period Matric	Matriculation sub-academic period of the student.	VARCHAR2(3)		NA	NA
SUB_ACAD_PERIOD_MATRIC_DESC	Sub Academic Period Matric Description	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	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	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

Ver: