Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	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	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	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	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	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	Application number for the admission application record for a specific academic period.	NUMBER	SARCHKL	SARCHKL_APPL_NO
COMPLETED_IND	Completed Indicator	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	First Request Date	Date on which the requirement was first requested from the applicant.	DATE	SARCHKL	SARCHKL_REQ_DATE1
MOST_RECENT_REQUEST_DATE	Most Recent Request Date	Date on which the requirement was last requested from the applicant.	DATE	SARCHKL	SARCHKL_REQ_DATE2
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SARCHKL	SARCHKL_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REQUIREMENT	Requirement	Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(63)	SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT_ACTIVITY_DATE	Requirement Activity Date	Identifies the last date the record was updated.	DATE	SARCHKL	SARCHKL_ACTIVITY_DATE
REQUIREMENT_COMMENT	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	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	Requirement description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
REQUIREMENT_LETTER_PRINT_IND	Requirement Letter Print Indicator	Indicates whether this checklist requirement was printed in a letter sent to the applicant.	VARCHAR2(1)	SARCHKL	SARCHKL_PRINT_IND
REQUIREMENT_MANDATORY_IND	Requirement Mandatory Indicator	Indicates whether this requirement is mandatory or optional.	VARCHAR2(1)	SARCHKL	SARCHKL_MANDATORY_IND
REQUIREMENT_ORIGIN	Requirement Origin	Identifies the process or origination of the checklist item.	VARCHAR2(63)	SARCHKL	SARCHKL_CKSR_CODE
REQUIREMENT_ORIGIN_DESC	Requirement Origin Description	Requirement origin description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
REQUIREMENT_RECEIVED_DATE	Requirement Received Date	Date the requirement was received from the applicant.	DATE	SARCHKL	SARCHKL_RECEIVE_DATE
REQUIREMENT_REQUESTED_COUNT	Requirement Requested Count	Number of times the specific requirement has been requested from the applicant.	NUMBER	SARCHKL	SARCHKL_REQ_COUNT
REQUIREMENT_REQUIRED_BY_INST	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	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	Requirement source description.	VARCHAR2(255)	DECODE OR FUNCTION	DECODE (SARCHKL_SOURCE, 'S', 'SYSTEM', 'U', 'USER')
REQUIREMENT_STATUS	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	Requirement status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	NA	NA
WAIVED_IND	Waived Indicator	Indicates whether the requirement was waived.	VARCHAR2(1)	NA	NA

Ver: 9.2