| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
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
|
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
|
Organization-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
|