SSR_HE_PRGOFR (SQL Table)	Index Back
HESA Program Offering Lists HESA Program Offering entity fields and their associated academic load.

SSR_HE_PRGOFR

(SQL Table)

HESA Program Offering

Lists HESA Program Offering entity fields and their associated academic load.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time

5 SSR_HE_FTECALC_TYP Character(1) VARCHAR2(1) NOT NULL FTE Calculation Type
M=Derive load from Modules
P=Derive load from Program

6 SSR_HE_FTE_LOAD Number(3,0) SMALLINT NOT NULL FTE Load
Default Value: 0

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	ACAD_LOAD_APPR	Character(1)	VARCHAR2(1) NOT NULL	Approved Academic Load B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time
5	SSR_HE_FTECALC_TYP	Character(1)	VARCHAR2(1) NOT NULL	FTE Calculation Type M=Derive load from Modules P=Derive load from Program
6	SSR_HE_FTE_LOAD	Number(3,0)	SMALLINT NOT NULL	FTE Load Default Value: 0