Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(6)	SGBSTDN	SGBSTDN_TERM_CODE_EFF	NO	NO
ACADEMIC_PERIOD_ADMITTED	Academic period or time frame associated with the information on the student record.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_ADMIT	NO	NO
ACADEMIC_PERIOD_ADMITTED_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
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	NO	NO
ACADEMIC_PERIOD_MATRIC_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
ACTIVE_IND	Indicates whether the student is active in this curriculum.	VARCHAR2(1)	SOBCACT	SOBCACT_ACTIVE_IND	NO	NO
ACTIVITY_DATE	Date record was inserted or updated.	DATE	SORLCUR	SORLCUR_ACTIVITY_DATE	NO	NO
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	NO	NO
ADMISSIONS_POPULATION_DESC	Admission population description.	VARCHAR2(30)	STVADMT	STVADMT_DESC	NO	NO
AGE_ADMITTED	Calculated age of the person at the time of admission to the institution.	NUMBER	FUNCTION	SOKODSF.F_CALCULATE_AGE_ADMIT	NO	NO
APPLICATION_CURRIC_SEQUENCE	Sequence number of the application curriculum the learner curriculum was created from.	NUMBER	SORLCUR	SORLCUR_APPL_SEQNO	NO	NO
APPLICATION_NUMBER	Application number the learner curriculum was created from.	NUMBER	SORLCUR	SORLCUR_APPL_KEY_SEQNO	NO	NO
CAMPUS	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(3)	SORLCUR	SORLCUR_CAMP_CODE	NO	NO
CAMPUS_DESC	Institution campus name.	VARCHAR2(30)	STVCAMP	STVCAMP_DESC	NO	NO
CATALOG_ACADEMIC_PERIOD	Catalog academic period used to measure completion requirements for the outcome.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_CTLG	NO	NO
CATALOG_ACADEMIC_PERIOD_DESC	Catalog academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(2)	SORLCUR	SORLCUR_COLL_CODE	NO	NO
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
CURRENT_IND	Indicates whether this is the most recent curriculum record for this academic period and curriculum sequence.	VARCHAR2(1)	SORLCUR	SORLCUR_CURRENT_CDE	NO	NO
CURRICULUM_ACTIVITY_STATUS	Identifies the student current status or activity within this curriculum.	VARCHAR2(15)	SORLCUR	SORLCUR_CACT_CODE	NO	NO
CURRICULUM_ACTIVITY_STAT_DESC	Curriculum activity status description.	VARCHAR2(30)	STVCACT	STVCACT_DESC	NO	NO
CURRICULUM_PRIORITY	Identifies the significanct ranking for a curricula.	NUMBER	SORLCUR	SORLCUR_PRIORITY_NO	NO	NO
CURRICULUM_SEQUENCE	System generated one-up number assigned to a student or learner for a curriculum or curriculum changes.	NUMBER	SORLCUR	SORLCUR_SEQNO	NO	NO
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.	VARCHAR2(6)	SORLCUR	SORLCUR_DEGC_CODE	NO	NO
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	NO	NO
DEGREE_AWARD_CATEGORY_DESC	Degree award category description.	VARCHAR2(30)	STVACAT	STVACAT_DESC	NO	NO
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(30)	STVDEGC	STVDEGC_DESC	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
END_DATE	Date the student became inactive in this curriculum.	DATE	SORLCUR	SORLCUR_END_DATE	NO	NO
EXPECTED_GRADUATION_DATE	Expected graduation date.	DATE	SORLCUR	SORLCUR_EXP_GRAD_DATE	NO	NO
GRAD_ACADEMIC_PERIOD_INTENDED	Intended academic period of graduation for the student.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_GRAD	NO	NO
GRAD_ACAD_PERIOD_INTENDED_DESC	Intended graduation term description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
GRAD_YEAR_INTENDED	Intended year of graduation.	VARCHAR2(4)	SORLCUR	SORLCUR_ACYR_CODE	NO	NO
GRAD_YEAR_INTENDED_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
LAST_ACADEMIC_PERIOD_DESC	Field of study last active academic period desc.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
LAST_ACTIVE_ACADEMIC_PERIOD	Field of study last active academic period.	VARCHAR2(6)	SORLCUR	SORLCUR_TERM_CODE_END	NO	NO
LEAVE_DATE_FROM	Start date of the student leave.	DATE	SORLCUR	SORLCUR_LEAV_FROM_DATE	NO	NO
LEAVE_DATE_TO	End date of the student leave.	DATE	SORLCUR	SORLCUR_LEAV_TO_DATE	NO	NO
LEAVE_REASON	Leave code of the student for this academic period.	VARCHAR2(1)	SORLCUR	SORLCUR_LEAV_CODE	NO	NO
LEAVE_REASON_DESC	Student's leave code description for this term.	VARCHAR2(30)	STVLEAV	STVLEAV_DESC	NO	NO
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)	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
OUTCOME_NUMBER	Degree or award sequence number for this academic outcome for the student.	NUMBER	SORLCUR	SORLCUR_ROLLED_SEQNO	NO	NO
OUTCOME_ROLL_IND	Indicates if the learner curriculum should roll to academic history when courses are rolled.	VARCHAR2(1)	SORLCUR	SORLCUR_ROLL_IND	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORLCUR	SORLCUR_PIDM	NO	NO
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(12)	SORLCUR	SORLCUR_PROGRAM	NO	NO
PROGRAM_DESC	Program or course of study description.	VARCHAR2(30)	SMRPRLE	SMRPRLE_PROGRAM_DESC	NO	NO
SITE	Site or location to which applicant is applying.	VARCHAR2(3)	SORLCUR	SORLCUR_SITE_CODE	NO	NO
SITE_CARRIER_ROUTE	Carrier route associated with the site address for barcode mailings.	VARCHAR2(4)	NA	NA	NO	NO
SITE_CITY	City, town or municipality associated with the site address.	VARCHAR2(63)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_CORRECTION_DIGIT	Correction digit associated with the site address for barcode mailings.	VARCHAR2(1)	NA	NA	NO	NO
SITE_COUNTY_CODE	County associated with the site address.	VARCHAR2(5)	NA	NA	NO	NO
SITE_COUNTY_CODE_DESC	Descriptions of the county associated with the site address.	VARCHAR2(30)	NA	NA	NO	NO
SITE_DELIVERY_POINT	Delivery point associated with the site address for barcode mailings.	VARCHAR2(2)	NA	NA	NO	NO
SITE_DESC	Site or location name.	VARCHAR2(30)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_NATION	Nation/country code associated with the site address.	VARCHAR2(5)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_NATION_DESC	Description for the nation/country associated with the site address.	VARCHAR2(30)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_POSTAL_CODE	Postal code associated with the site address.	VARCHAR2(63)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_STATE_PROVINCE	Identifies the state or province associated with this address.	VARCHAR2(3)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_STATE_PROVINCE_DESC	Name of the state/province.	VARCHAR2(30)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_STREET_LINE1	First line of the site address.	VARCHAR2(255)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_STREET_LINE2	Second line of the site address.	VARCHAR2(255)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_STREET_LINE3	Third line of the site address.	VARCHAR2(255)	FUNCTION	SOKODSF.F_SITE	NO	NO
SITE_STREET_LINE4	Fourth line of the site address.	VARCHAR2(255)	NA	NA	NO	NO
SOURCE	Administrative system source for this record. For example, recruiting, admissions, learner, academic outcome.	VARCHAR2(15)	SORLCUR	SORLCUR_LMOD_CODE	NO	NO
SOURCE_DESC	Student or learner source description.	VARCHAR2(30)	STVLMOD	STVLMOD_DESC	NO	NO
SOURCE_SEQUENCE_NUMBER	Sequence number of the source key record.	NUMBER	SORLCUR	SORLCUR_KEY_SEQNO	NO	NO
START_DATE	Date the student became active in this curriculum.	DATE	SORLCUR	SORLCUR_START_DATE	NO	NO
START_DATE_ADMITTED	Date the student began to study courses within this academic study.	DATE	STVTERM	STVTERM_START_DATE	NO	NO
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	NO	NO
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(2)	SORLCUR	SORLCUR_LEVL_CODE	NO	NO
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(30)	STVLEVL	STVLEVL_DESC	NO	NO
STUDENT_POPULATION	Identifies the category this student that will be used for governmental reporting. The typical VALUES are new first time, transfer, continuing, etc.	VARCHAR2(1)	SORLCUR	SORLCUR_STYP_CODE	NO	NO
STUDENT_POPULATION_DESC	Student population or type description.	VARCHAR2(30)	STVSTYP	STVSTYP_DESC	NO	NO
STUDENT_RATE	Identifies any specific assessment rate to be used to determine the charges for this student.	VARCHAR2(5)	SORLCUR	SORLCUR_RATE_CODE	NO	NO
STUDENT_RATE_DESC	Description for the rate code.	VARCHAR2(30)	STVRATE	STVRATE_DESC	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(3)	NA	NA	NO	NO
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	NO	NO
SUB_ACADEMIC_PERIOD_ADMIT_DESC	Description of the session or part of the academic period associated with the session code.	VARCHAR2(30)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(30)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_MATRIC	Matriculation sub-academic period of the student.	VARCHAR2(3)	NA	NA	NO	NO
SUB_ACAD_PERIOD_MATRIC_DESC	Sub-academic period description.	VARCHAR2(30)	NA	NA	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	SORLCUR	SORLCUR_USER_ID	NO	NO
YEAR_ADMITTED	Academic year the student was admitted to this academic study.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
YEAR_ADMITTED_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
YEAR_MATRICULATED	Academic year the student matriculated to this academic study.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
YEAR_MATRICULATED_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: