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(63)	SGRDISA	SGRDISA_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
DISABILITY	Disability type describing the area affected by the handicap.	VARCHAR2(63)	SGRDISA SPRMEDI	SGRDISA_DISA_CODE SPRMEDI_DISA_CODE	NO NO	NO
DISABILITY_DESC	Disability type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DISABILITY_ON_SET_AGE	Age noted when the disability began.	NUMBER	SPRMEDI	SPRMEDI_ONSET_AGE	NO	NO
DISABILITY_SERVICES	Disability service available to the person from the institution because of the disability noted.	VARCHAR2(63)	SGRDISA SPRMEDI	SGRDISA_SPSR_CODE SPRMEDI_SPSR_CODE	NO NO	NO
DISABILITY_SERVICES_DESC	Disability service provided description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
MEDICAL_COMMENT	Free format comments associated with the medical condition or disability.	VARCHAR2(4000)	SPRMEDI	SPRMEDI_COMMENT	NO	NO
MEDICAL_EQUIPMENT_TYPE	Medical equipment associated with the person's medical problem.	VARCHAR2(63)	SPRMEDI	SPRMEDI_MDEQ_CODE	NO	NO
MEDICAL_EQUIPMENT_TYPE_DESC	Medical equipment type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MEDICAL_TYPE	Major medical condition associated with the person.	VARCHAR2(63)	SGRDISA SPRMEDI	SGRDISA_MEDI_CODE SPRMEDI_MEDI_CODE	NO NO	NO
MEDICAL_TYPE_DESC	Person's medical code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SGRDISA SPRMEDI	SGRDISA_PIDM SPRMEDI_PIDM	NO NO	NO
PRIMARY_DISABILITY_IND	This field denotes whether this disability is the primary disability.	VARCHAR2(1)	SGRDISA SPRMEDI	SGRDISA_PRIMARY_IND SPRMEDI_DISB_IND	NO NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Subacademic period description.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2