Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
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)
|
SORLFOS
|
SORLFOS_TERM_CODE
|
ACADEMIC_PERIOD_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 field of study.
|
VARCHAR2(1)
|
SOBCACT
|
SOBCACT_ACTIVE_IND
|
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
SORLFOS
|
SORLFOS_ACTIVITY_DATE
|
AID_ELIGIBILITY_IND
|
Indicates the field of study is eligible for financial assistance or aid from the institution.
|
VARCHAR2(1)
|
STVMAJR
|
STVMAJR_AID_ELIGIBILITY_IND
|
CATALOG_ACADEMIC_PERIOD
|
Catalog academic period used to measure completion requirements for the outcome.
|
VARCHAR2(6)
|
SORLFOS
|
SORLFOS_TERM_CODE_CTLG
|
CATALOG_ACADEMIC_PERIOD_DESC
|
Catalog academic period description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
CONCENTRATION_MAJOR
|
Identifies the major subject area when the field of study type is a concentration.
|
VARCHAR2(4)
|
SORLFOS
|
SORLFOS_MAJR_CODE_ATTACH
|
CONCENTRATION_MAJOR_DESC
|
Major subject area name.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_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 field of study record for this academic period and curriculum sequence.
|
VARCHAR2(1)
|
SORLFOS
|
SORLFOS_CURRENT_CDE
|
CURRENT_TIME_STATUS
|
Time status for the academic period based on institution rules. For example, full time, part time, etc.
|
VARCHAR2(2)
|
SORLFOS
|
SORLFOS_TMST_CODE
|
CURRENT_TIME_STATUS_DESC
|
Current time status description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
CURRICULUM_CHANGE_REASON
|
Reason a curriculum was changed or new record created. For example, a curriculum may be denied, sought, inprogress, awarded, applied, etc.
|
VARCHAR2(15)
|
SORLFOS
|
SORLFOS_CSTS_CODE
|
CURRICULUM_CHANGE_REASON_DESC
|
Curriculum change reason description.
|
VARCHAR2(30)
|
STVCSTS
|
STVCSTS_DESC
|
CURRICULUM_SEQUENCE
|
System generated one-up number assigned to a student or learner for a curriculum or curriculum changes.
|
NUMBER
|
SORLFOS
|
SORLFOS_LCUR_SEQNO
|
DEPARTMENT
|
Department responsible for the major subject area of a student course or associated with the major within the student academic study.
|
VARCHAR2(4)
|
SORLFOS
|
SORLFOS_DEPT_CODE
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_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 field of study.
|
DATE
|
SORLFOS
|
SORLFOS_END_DATE
|
FIELD_OF_STUDY
|
Identifies the field of study, for example, major, concentration, minor within this record.
|
VARCHAR2(4)
|
SORLFOS
|
SORLFOS_MAJR_CODE
|
FIELD_OF_STUDY_ACTIVITY_DESC
|
Field of study activity status description.
|
VARCHAR2(30)
|
STVCACT
|
STVCACT_DESC
|
FIELD_OF_STUDY_ACTIVITY_STATUS
|
Identifies the student current status or activity within this field of study.
|
VARCHAR2(15)
|
SORLFOS
|
SORLFOS_CACT_CODE
|
FIELD_OF_STUDY_DESC
|
Field of study description.
|
VARCHAR2(30)
|
STVMAJR
|
STVMAJR_DESC
|
FIELD_OF_STUDY_TYPE
|
Type of field of study such as major, minor, concentration, vocational.
|
VARCHAR2(15)
|
SORLFOS
|
SORLFOS_LFST_CODE
|
FIELD_OF_STUDY_TYPE_DESC
|
Field of study type description.
|
VARCHAR2(30)
|
GTVLFST
|
GTVLFST_DESC
|
LAST_ACADEMIC_PERIOD_DESC
|
Field of study last active academic period desc.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
LAST_ACTIVE_ACADEMIC_PERIOD
|
Field of study last active academic period.
|
VARCHAR2(6)
|
SORLFOS
|
SORLFOS_TERM_CODE_END
|
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
|
SORLFOS
|
SORLFOS_ROLLED_SEQNO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SORLFOS
|
SORLFOS_PIDM
|
PRIORITY
|
Identifies the significance within ranking this field of study for a curricula.
|
NUMBER
|
SORLFOS
|
SORLFOS_PRIORITY_NO
|
PROGRAM_CLASSIFICATION
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.
|
VARCHAR2(6)
|
STVMAJR
|
STVMAJR_CIPC_CODE
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
SEQUENCE_NUMBER
|
System generated one-up number assigned to a field of study for the student or learner.
|
NUMBER
|
SORLFOS
|
SORLFOS_SEQNO
|
START_DATE
|
Date the student became active in this field of study.
|
DATE
|
SORLFOS
|
SORLFOS_START_DATE
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
SORLFOS
|
SORLFOS_USER_ID
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|