Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame associated with this non instructional assignment record.	VARCHAR2(6)	SIRNIST	SIRNIST_TERM_CODE
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
ASSIGNMENT_TYPE	Identifies the type of academic staff member assignment.	VARCHAR2(4)	SIRNIST	SIRNIST_ASTY_CODE
ASSIGNMENT_TYPE_DESC	Faculty assignment type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	College, faculty or school to which the course instructional responsibility is associated.	VARCHAR2(2)	SIRNIST	SIRNIST_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(30)	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(2)	SIRNIST	SIRNIST_FCNT_CODE
CONTRACT_TYPE_DESC	Type of faculty contract description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DEPARTMENT	Department responsible the academic instruction.	VARCHAR2(4)	SIRNIST	SIRNIST_DEPT_CODE
DEPARTMENT_DESC	Department name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
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
NONINSTRUCTIONAL_TYPE	Non-instructional type code.	VARCHAR2(4)	SIRNIST	SIRNIST_NIST_CODE
NONINSTRUCTIONAL_TYPE_DESC	Faculty member's non-instructional code description.	VARCHAR2(30)	STVNIST	STVNIST_DESC
NONINSTRUCTIONAL_WORKLOAD	Non-instructional workload.	NUMBER(9, 3)	SIRNIST	SIRNIST_NIST_WORKLOAD
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	SIRNIST	SIRNIST_PIDM
POSITION_NUMBER	Position number.	VARCHAR2(6)	SIRNIST	SIRNIST_POSN
POSITION_NUMBER_SUFFIX	Position number suffix.	VARCHAR2(2)	SIRNIST	SIRNIST_SUFF
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
TOPS	Taxonomy of program code used for grouping courses or subjects and to accommodate reporting.	VARCHAR2(6)	SIRNIST	SIRNIST_TOPS_CODE
TOPS_DESC	Taxonomy of program code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
WEEKLY_CONTACT_HOURS	Weekly contact hours.	NUMBER(9, 3)	SIRNIST	SIRNIST_WEEKLY_HRS
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: 8.1