Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
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(63)
|
ROBINST RORTPRD STVTERM
|
ROBINST_CURRENT_TERM_CODE RORTPRD_TERM_CODE STVTERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
AID_PERIOD
|
Aid Period
|
Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc.
|
VARCHAR2(63)
|
RORTPRD
|
RORTPRD_APRD_CODE
|
AID_PERIOD_DESC
|
Aid Period Description
|
Financial Aid period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
END_DATE
|
End Date
|
Official end date for the year based on the year type.
|
DATE
|
STVTERM
|
STVTERM_END_DATE
|
END_YEAR
|
End Year
|
Year and century of the End date. Example: If the End Date = 30-JUN-1991, then Year End Year = 1991.
|
NUMBER
|
ROBINST
|
ROBINST_AIDY_END_YEAR
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
READMIT_ACADEMIC_PERIOD
|
Readmit Academic Period
|
Readmit academic period associated with this year type definition.
|
VARCHAR2(63)
|
SOBTERM
|
SOBTERM_READMIT_REQ
|
READMIT_ACADEMIC_PERIOD_DESC
|
Readmit Academic Period Description
|
Readmit academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
START_DATE
|
Start Date
|
Official start date for the year based on the year type.
|
DATE
|
STVTERM
|
STVTERM_START_DATE
|
START_YEAR
|
Start Year
|
Year and century of the Start date. Example: If the Start Date = 01-JUL-1990, then Start Year = 1990.
|
NUMBER
|
ROBINST
|
ROBINST_AIDY_START_YEAR
|
YEAR_CODE
|
Year Code
|
Year value to be associated this record. This may be from any of the year validations in the system.
|
VARCHAR2(63)
|
ROBINST RORTPRD STVTERM STVTERM
|
ROBINST_AIDY_CODE RORTPRD_AIDY_CODE STVTERM_ACYR_CODE STVTERM_FA_PROC_YR
|
YEAR_CODE_DESC
|
Year Code Description
|
Year value and type description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
YEAR_TYPE
|
Year Type
|
Type of year being defined. This may be an academic, financial aid, fiscal or calendar year type.
|
VARCHAR2(63)
|
CONSTANT CONSTANT CONSTANT CONSTANT
|
'ACYR' 'AIDY' 'FA_PROC_YR' 'INST_AIDY'
|
YEAR_TYPE_DESC
|
Year Type Description
|
Year type description. For example, fiscal, academic, calendar, financial aid year.
|
VARCHAR2(255)
|
CONSTANT CONSTANT CONSTANT CONSTANT
|
'ACADEMIC YEAR' 'AID YEAR' 'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD' 'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD'
|