Page Name

Description:

The Instructor's Portion of Fundable Student Credit Hours.

Coding Instructions:

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

For detail WORKLOAD_ACTIVITIES records:
- if INSTR_RESRCH_ACT 01509 = 11,12,43 (lower,upper,grad I) then INSTR_FND_SCH 01516 = FNDBL_CRS_CRED_HRS 01511 * PORT_SECTN_WKLD 01129
- if INSTR_RESRCH_ACT 01509 = 44 (grad II) then INSTR_FND_SCH 01516 = FNDBL_GRAD_DOC_HRS 01529 * 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
Expenditure Analysis (EA)	EXPENDITURE_ANALYSIS_EXTRACT (EAE)	INSTR_FND_SCH	182	653	43	Expenditure Analysis
Instruction & Research (IRD)	WORKLOAD_ACTIVITIES (WKA)	INSTR_FND_SCH	182	1621	28	Instruction & Research

1 - 2

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
IRD	WORKLOAD_ACTIVITIES	0211	If COURSE_DISCIPLINE = 28 or 29, then INSTR_FND_SCH cannot be greater than 0.	9	Critical Error: may cause submission to be rejected

1 - 4

Physical Description:

NUMBER(6,1)

Short Name:

SCHFND

Column Name:

SCHFND

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Instructor Portion of Fundable SCHs for the Course Section - 01516

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: