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(63)	SARCHKL	SARCHKL_TERM_CODE_ENTRY
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SARCHKL	SARCHKL_APPL_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
FIRST_REQUEST_DATE	Date on which the requirement was first requested from the applicant.	DATE	SARCHKL	SARCHKL_REQ_DATE1
MOST_RECENT_REQUEST_DATE	Date on which the requirement was last requested from the applicant.	DATE	SARCHKL	SARCHKL_REQ_DATE2
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARCHKL	SARCHKL_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REQUIREMENT	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT_ACTIVITY_DATE	Identifies the last date the record was updated.	DATE	SARCHKL	SARCHKL_ACTIVITY_DATE
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
REQUIREMENT_DEADLINE_DATE	Date the specific requirement must be received from an applicant to continue admissions processing.	DATE	SARCHKL	SARCHKL_DEADLINE_DATE
REQUIREMENT_DESC	Requirement description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
REQUIREMENT_LETTER_PRINT_IND	Indicates whether this checklist requirement was printed in a letter sent to the applicant.	VARCHAR2(1)	SARCHKL	SARCHKL_PRINT_IND
REQUIREMENT_MANDATORY_IND	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_ORIGIN	Identifies the process or origination of the checklist item.	VARCHAR2(63)	SARCHKL	SARCHKL_CKSR_CODE
REQUIREMENT_ORIGIN_DESC	Requirement origin description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
REQUIREMENT_RECEIVED_DATE	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_REQUESTED_COUNT	Number of times the specific requirement has been requested from the applicant.	NUMBER	SARCHKL	SARCHKL_REQ_COUNT
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
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
REQUIREMENT_SOURCE_DESC	Requirement source description.	VARCHAR2(255)	DECODE OR FUNCTION	DECODE (SARCHKL_SOURCE, 'S', 'SYSTEM', 'U', 'USER')
REQUIREMENT_STATUS	Defines an additional status of the checklist item that is important to communicate.	VARCHAR2(63)	SARCHKL	SARCHKL_CKST_CODE
REQUIREMENT_STATUS_DESC	Requirement status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA
WAIVED_IND	Indicates whether the requirement was waived.	VARCHAR2(1)	NA	NA

Ver: 9.1