Page Name

Description:

The instructor's portion of the total number of student credit hours for the course section. is determined by multiplying total student credit hours for course section by portion of section workload.

Coding Instructions:

This element should be coded zeros for summary-type records on WORKLOAD_ACTIVITIES table.

For detail WORLOAD_ACTIVITIES records:
- If INSTR_RESRCH_ACT 01509 = 11,12,43 (Lower,Upper,Grad I) then INSTR_TOT_SCH 01515 = (TOTAL_CRS_CRED_HRS 01510 - DOC_STU_GRAD_HRS 01288) * PORT_SECTN_WKLD 01129
- if INSTR_RESRCH_ACT 01509) = 44 (Grad II) then INSTR_TOT_SCH 01515 = DOC_STU_GRAD_HRS 01288 * PORT_SECTN_WKLD 01129

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

16-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Instruction & Research (IRD)	WORKLOAD_ACTIVITIES (WKA)	INSTR_TOT_SCH	181	1619	28	Instruction & Research

1 - 1

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
IRD	WORKLOAD_ACTIVITIES	0173	Must be greater than zero when CRS_PREFIX not equal to '999' and INSTR_RESRCH_ACT is instruction	5	Warning: possible error that should be checked
IRD	WORKLOAD_ACTIVITIES	0207	Must be zero when and CRS_PREFIX equal '999'	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_ACTIVITIES	0210	Must be 0 when INSTR_RESRCH_ACT is not Instruction	9	Critical Error: may cause submission to be rejected

1 - 3

Physical Description:

NUMBER(6,1)

Short Name:

SCHTOT

Column Name:

SCHTOT

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Instructor Portion of Total SCHs for the Course Section - 01515

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: