Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period associated with this record.	VARCHAR2(63)	SIRNIST	SIRNIST_TERM_CODE
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
ASSIGNMENT_TYPE	Identifies the type of academic staff member assignment.	VARCHAR2(63)	SIRNIST	SIRNIST_ASTY_CODE
ASSIGNMENT_TYPE_DESC	Faculty assignment type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	College, faculty or school to which the non instructional responsibility is associated.	VARCHAR2(63)	SIRNIST	SIRNIST_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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	Type of faculty contract description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DEPARTMENT	Department responsible the academic instruction.	VARCHAR2(63)	SIRNIST	SIRNIST_DEPT_CODE
DEPARTMENT_DESC	Department name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
JOB_SUFFIX	Position number suffix.	VARCHAR2(2)	NA	NA
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
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NON_INSTRUCTIONAL_DESC	Faculty member's non-instructional code description.	VARCHAR2(255)	STVNIST	STVNIST_DESC
NON_INSTRUCTIONAL_TYPE	Non-instructional type code.	VARCHAR2(63)	SIRNIST	SIRNIST_NIST_CODE
NON_INSTRUCTIONAL_WORKLOAD	Non-instructional workload.	NUMBER	SIRNIST	SIRNIST_NIST_WORKLOAD
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SIRNIST	SIRNIST_PIDM
POSITION	Position.	VARCHAR2(6)	NA	NA
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	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
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 code description.	VARCHAR2(255)	NA	NA
WEEKLY_CONTACT_HOURS	Weekly contact hours.	NUMBER	NA	NA

Ver: 8.1