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)	SARCHKL	SARCHKL_TERM_CODE_ENTRY	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
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SARCHKL	SARCHKL_APPL_NO	NO	NO
COMPLETED_IND	Indicates the requirement is complete. Indicator is based on a the entry of the received date.	VARCHAR2(1)	FUNCTION SARCHKL	DECODE(SARCHKL_RECEIVE_DATE) SARCHKL_RECEIVE_DATE	NO NO	NO
FIRST_REQUEST_DATE	Date on which the requirement was first requested from the applicant.	DATE	SARCHKL	SARCHKL_REQ_DATE1	NO	NO
MOST_RECENT_REQUEST_DATE	Date on which the requirement was last requested from the applicant.	DATE	SARCHKL	SARCHKL_REQ_DATE2	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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARCHKL	SARCHKL_PIDM	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
REQUIREMENT	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE	NO	NO
REQUIREMENT_ACTIVITY_DATE	Identifies the last date the record was updated.	DATE	SARCHKL	SARCHKL_ACTIVITY_DATE	NO	NO
REQUIREMENT_COMMENT	More specifics information for the detail identified by the requirement required by instituiton value. For example, the name of institution to send a transcript before and after the transcript is received, the date the date the test was taken when the score is recorded or the visa type description when the visa type is entered.	VARCHAR2(4000)	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(255)	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	Identifies the process or origination of the checklist item.	VARCHAR2(63)	SARCHKL	SARCHKL_CKSR_CODE	NO	NO
REQUIREMENT_ORIGIN_DESC	Requirement origin description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	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	Identifies details of the admissions requirement. For example, a transcript from a specific institution, test score for test or a visa entry to satisfy the requiement.	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	Requirement source description.	VARCHAR2(255)	DECODE OR FUNCTION	DECODE (SARCHKL_SOURCE, 'S', 'SYSTEM', 'U', 'USER')	NO	NO
REQUIREMENT_STATUS	Defines an additional status of the checklist item that is important to communicate.	VARCHAR2(63)	SARCHKL	SARCHKL_CKST_CODE	NO	NO
REQUIREMENT_STATUS_DESC	Requirement status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA	NO	NO
WAIVED_IND	Indicates whether the requirement was waived.	VARCHAR2(1)	NA	NA	NO	NO

Ver: 9.2