Page Name

Description:

An indicator used by the universities to uniquely identify a session of less than 10 weeks within a summer term OR
less than full term for fall and spring terms.

Coding Instructions:

Each university should establish an identifier for each summer session which is less than 10 weeks and for each fall and spring session which is less than the entire term.

For a summer session of 10 or more weeks or a fall/spring sessions which lasts the entire term this field should be coded zero.
---
For Summer Sessions, if a university has two summer sessions of less than 10 weeks, each session should have a unique indicator (e.g. The first 'A' and the second 'B') while the sessions of 10 or more weeks should all be coded zero.
---
For Fall and Spring Sessions, if a university has two sessions which are less than the entire term, each session should have a unique indicator.

Load programs on WORKLOAD_ACTIVITIES table for IRD will NULL value when INSTR_RESRCH_ACT is not instruction.

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

12-JUN-2012

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Instruction & Research (IRD)	WORKLOAD_ACTIVITIES (WKA)	SESSION_ID	237	1613	28	Instruction & Research
Student Instruction (SIF)	COURSE_MEETINGS (MEET)	SESSION_ID	237	1151	21	Student Instruction
Student Instruction (SIF)	INSTRUCTIONAL_ACTIVITY (IAF)	SESSION_ID	237	1073	20	Student Instruction
Student Instruction (SIF)	STIPENDS (STIP)	SESSION_ID	237	209	12	Student Instruction
Student Instruction Preliminary (SIFP)	STIPENDS (STIP)	SESSION_ID	237	209	12	Student Instruction Preliminary

1 - 5

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'0	0	Long Term For Summer-Session greater than or equal to 10weeks. For Fall/Spring-Session which lasts the entire term.
'1	1	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'2	2	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'3	3	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'4	4	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'5	5	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'6	6	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'7	7	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'8	8	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'9	9	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'A	A	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'B	B	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'C	C	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'D	D	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'E	E	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'F	F	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'G	G	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'H	H	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'I	I	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'J	J	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'K	K	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'L	L	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'M	M	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'N	N	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'O	O	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'P	P	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'Q	Q	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'R	R	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-
'S	S	Short Term For Summer-Session less than 10weeks. For Fall/Spring-Session which lasts less than the full term.	-

Download

Select Pagination

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
IRD	WORKLOAD_ACTIVITIES	4154	Frequency of Values for WORKLOAD_ACTIVITIES.SESSION_ID	0	Frequency Distribution: not an indication of an error
IRD	WORKLOAD_ACTIVITIES	6243	SESSION_ID is nulled if INSTR_RESRCH_ACT NOT IN ('11', '12', '43', '44', '15', '19', '20', '21', '16', '17', '25')	1	Generated or Modified during SUDS Edit Process
SIF	COURSE_MEETINGS	4155	Frequency of Values for COURSE_MEETINGS.SESSION_ID	0	Frequency Distribution: not an indication of an error

1 - 3

Physical Description:

VARCHAR2(2)

Short Name:

SESSFLG

Column Name:

SESS_FLG

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Session Flag - 01405

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: