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(6)	SARCHKL	SARCHKL_TERM_CODE_ENTRY	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SARCHKL	SARCHKL_APPL_NO	NO	NO
COMPLETED_IND	This field indicates whether the .	VARCHAR2(1)	SARCHKL	SARCHKL_RECEIVE_DATE	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
FIRST_REQUEST_DATE	Date on which the requirement was first requested from the applicant.	DATE	SARCHKL	SARCHKL_REQ_DATE1	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MOST_RECENT_REQUEST_DATE	Date on which the requirement was last requested from the applicant.	DATE	SARCHKL	SARCHKL_REQ_DATE2	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARCHKL	SARCHKL_PIDM	NO	NO
REQUIREMENT	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(4)	SARCHKL	SARCHKL_ADMR_CODE	NO	NO
REQUIREMENT_ACTIVITY_DATE		DATE				NO
REQUIREMENT_COMMENT	Brief comment test related to this specific admission application requirement.	VARCHAR2(30)	SARCHKL	SARCHKL_COMMENT	NO	NO
REQUIREMENT_DEADLINE_DATE	Date the specific requirement must be received from an applicant to continue admissions processing.	DATE	SARCHKL	SARCHKL_DEADLINE_DATE	NO	NO
REQUIREMENT_DESC	Requirement description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
REQUIREMENT_LETTER_PRINT_IND	Indicates whether this checklist requirement was printed in a letter sent to the applicant.	VARCHAR2(1)	SARCHKL	SARCHKL_PRINT_IND	NO	NO
REQUIREMENT_MANDATORY_IND	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND	NO	NO
REQUIREMENT_ORIGIN		VARCHAR2(15)				NO
REQUIREMENT_ORIGIN_DESC		VARCHAR2(30)				NO
REQUIREMENT_RECEIVED_DATE	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE	NO	NO
REQUIREMENT_REQUESTED_COUNT	Number of times the specific requirement has been requested from the applicant.	NUMBER	SARCHKL	SARCHKL_REQ_COUNT	NO	NO
REQUIREMENT_REQUIRED_BY_INST	Indicates whether this requirement is mandatory or optional.	VARCHAR2(10)	SARCHKL	SARCHKL_CODE_VALUE	NO	NO
REQUIREMENT_SOURCE	Indicates whether the checklist item was added automatically by the system based on institution rules or manually by a user.	VARCHAR2(1)	SARCHKL	SARCHKL_SOURCE	NO	NO
REQUIREMENT_SOURCE_DESC		VARCHAR2(4000)				NO
REQUIREMENT_STATUS		VARCHAR2(15)				NO
REQUIREMENT_STATUS_DESC		VARCHAR2(30)				NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(0)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(0)	NA	NA	NO	NO
WAIVED_IND	Indicates whether the requirement was waived.	VARCHAR2(0)	NA	NA	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: