Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period or time frame associated with this application requirement record.	VARCHAR2(6)		SARCHKL	SARCHKL_TERM_CODE_ENTRY
ACADEMIC_PERIOD_DESC		Academic period description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR		Academic year associated with the academic period on this record.	VARCHAR2(4)		STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC		Academic year description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
APPLICATION_NUMBER		Application number for the admission application record for a specific academic period.	NUMBER(2)		SARCHKL	SARCHKL_APPL_NO
COMPLETED_IND		This field indicates whether the	VARCHAR2(1)		SARCHKL	SARCHKL_RECEIVE_DATE
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
FIRST_REQUEST_DATE		Date on which the requirement was first requested from the applicant.	DATE		SARCHKL	SARCHKL_REQ_DATE1
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
MOST_RECENT_REQUEST_DATE		Date on which the requirement was last requested from the applicant.	DATE		SARCHKL	SARCHKL_REQ_DATE2
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		SARCHKL	SARCHKL_PIDM
REQUIREMENT		Document or other checklist requirement assigned to this type of applicant.	VARCHAR2(4)		SARCHKL	SARCHKL_ADMR_CODE
REQUIREMENT_ACTIVITY_DATE	Requirement Activity Date		DATE
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(30)		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	Requirement Origin		VARCHAR2(15)
REQUIREMENT_ORIGIN_DESC	Requirement Origin Description		VARCHAR2(30)
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(3)		SARCHKL	SARCHKL_REQ_COUNT
REQUIREMENT_REQUIRED_BY_INST		Indicates whether this requirement is mandatory or optional.	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(4000)
REQUIREMENT_STATUS	Requirement Status		VARCHAR2(15)
REQUIREMENT_STATUS_DESC	Requirement Status Description		VARCHAR2(30)
SUB_ACADEMIC_PERIOD		A session, portion or part of the academic period.	VARCHAR2(0)		NA	NA
SUB_ACADEMIC_PERIOD_DESC		Sub academic period description.	VARCHAR2(0)		NA	NA
WAIVED_IND		Indicates whether the requirement was waived.	VARCHAR2(0)		NA	NA
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: