SSR_HE_PLAN

(SQL Table)
Index Back

HESA Plan

Lists HESA Plans and whether the Plan should be included in HESA Reporting.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 SSR_HE_FLAG Character(1) VARCHAR2(1) NOT NULL Report to HESA flag

Y/N Table Edit

Default Value: N

5 SSR_HE_OVRSEA_FLAG Character(1) VARCHAR2(1) NOT NULL Offshore Sub-Plan

Y/N Table Edit

Default Value: N

6 SSR_HE_CTITLE Character(254) VARCHAR2(254) NOT NULL HESA Course Title
7 SSR_HE_FTECALC_TYP Character(1) VARCHAR2(1) NOT NULL FTE Calculation Type
M=Derive load from Modules
P=Derive load from Program
8 SSR_HE_FTE_LOAD Number(3,0) SMALLINT NOT NULL FTE Load

Default Value: 0

9 SSR_HE_TITLEK Character(254) VARCHAR2(254) NOT NULL KIS Title
10 SSR_HE_KISTYPE Character(1) VARCHAR2(1) NOT NULL KIS Type

Prompt Table: SSR_HE_KISCDVW3

11 SSR_HE_ASSURL Character(254) VARCHAR2(254) NOT NULL Assessment Methods URL
12 SSR_HE_CRSEURL Character(254) VARCHAR2(254) NOT NULL Course Page URL
13 SSR_HE_EMPLOYURL Character(254) VARCHAR2(254) NOT NULL Employment Details URL
14 SSR_HE_LTURL Character(254) VARCHAR2(254) NOT NULL Learning/Teaching Methods URL
15 SSR_HE_SUPPORTURL Character(254) VARCHAR2(254) NOT NULL Support Details URL
16 SSR_HE_QUALID Character(50) VARCHAR2(50) NOT NULL Qualification ID

Prompt Table: SSR_HE_QUAL_VW

17 SSR_HE_CRSECSTURL Character(254) VARCHAR2(254) NOT NULL HESA Course Costs URL