Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period associated with this record.	VARCHAR2(63)		SIRNIST	SIRNIST_TERM_CODE
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
ASSIGNMENT_TYPE	Assignment Type	Identifies the type of academic staff member assignment.	VARCHAR2(63)		SIRNIST	SIRNIST_ASTY_CODE
ASSIGNMENT_TYPE_DESC	Assignment Type Description	Faculty assignment type description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	College	College, faculty or school to which the non instructional responsibility is associated.	VARCHAR2(63)		SIRNIST	SIRNIST_COLL_CODE
COLLEGE_DESC	College Description	College, faculty or school name.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
CONTRACT_TYPE	Contract Type	Identifies the type of faculty contract assigned to the person. Included may be full time, adjunct or continuing education only, etc.	VARCHAR2(63)		SIRNIST	SIRNIST_FCNT_CODE
CONTRACT_TYPE_DESC	Contract Type Description	Type of faculty contract description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
DEPARTMENT	Department	Department responsible the academic instruction.	VARCHAR2(63)		SIRNIST	SIRNIST_DEPT_CODE
DEPARTMENT_DESC	Department Description	Department name.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ID	ID	Person's or organization's current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
JOB_SUFFIX	Job Suffix	Position number suffix.	VARCHAR2(2)		NA	NA
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
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NON_INSTRUCTIONAL_DESC	Non Instructional Description	Faculty member's non-instructional code description.	VARCHAR2(255)		STVNIST	STVNIST_DESC
NON_INSTRUCTIONAL_TYPE	Non Instructional Type	Non-instructional type code.	VARCHAR2(63)		SIRNIST	SIRNIST_NIST_CODE
NON_INSTRUCTIONAL_WORKLOAD	Non Instructional Workload	Non-instructional workload.	NUMBER		SIRNIST	SIRNIST_NIST_WORKLOAD
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		SIRNIST	SIRNIST_PIDM
POSITION	Position	Position.	VARCHAR2(6)		NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
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
TAXONOMY_OF_PROGRAM	Taxonomy Of Program	Government reporting code typically used for reporting of vocational technical courses or subjects.	VARCHAR2(63)		NA	NA
TAXONOMY_OF_PROGRAM_DESC	Taxonomy Of Program Description	Taxonomy of program code description.	VARCHAR2(255)		NA	NA
WEEKLY_CONTACT_HOURS	Weekly Contact Hours	Weekly contact hours.	NUMBER		NA	NA

Ver: 9.0