Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame associated with this application requirement record.	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	Organization-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_COMMENT	Brief comment test related to this specific admission application requirement.	VARCHAR2(30)	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_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 a requirement that is required from a specific institution.	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
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: 8.1