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)
|
ROBINST RORTPRD
|
ROBINST_CURRENT_TERM_CODE RORTPRD_TERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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(6)
|
RORTPRD
|
RORTPRD_APRD_CODE
|
AID_PERIOD_DESC
|
Financial Aid period description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
END_DATE
|
End date for the year based on the year type.
|
DATE
|
STVTERM
|
STVTERM_END_DATE
|
END_YEAR
|
Year and century of the year end date. For Example, if the year end date is 30-JUN-1991, then year end year = 1991.
|
NUMBER
|
ROBINST
|
ROBINST_AIDY_END_YEAR
|
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
|
START_DATE
|
Official start date of the year.
|
DATE
|
STVTERM
|
STVTERM_START_DATE
|
START_YEAR
|
Year and century of the year start date. E.g., if the year start date = 01-JUL-1990, then year start year = 1990.
|
NUMBER
|
ROBINST
|
ROBINST_AIDY_START_YEAR
|
YEAR_CODE
|
Year value to be associated this record. This may be from any of the year validations in the system.
|
VARCHAR2(4)
|
ROBINST RORTPRD
|
ROBINST_AIDY_CODE RORTPRD_AIDY_CODE
|
YEAR_CODE_DESC
|
Description for this year value and type.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
YEAR_TYPE
|
Identifies the type of year being defined. This may be an academic, financial aid, fiscal or calendar year type.
|
VARCHAR2(9)
|
|
|
YEAR_TYPE_DESC
|
Year type description. For example, fiscal, academic, calendar, financial aid year.
|
VARCHAR2(48)
|
CONSTANT CONSTANT
|
'AID YEAR' 'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD'
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|