| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Valid academic period codes within the year selected.
|
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
|
Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, 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)
|
CALCULATION CALCULATION
|
DECODE('AIDY','AIDY','AIDY',NULL) DECODE('INST_AIDY','INST_AIDY','INST_AIDY',NULL)
|
|
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
|