SSR_FUNDING_CAT (SQL Table)	Index Back
Funding category Funding categories defined by the New Zealand Ministry of Education

SSR_FUNDING_CAT

(SQL Table)

Funding category

Funding categories defined by the New Zealand Ministry of Education

Related Language Record: SSR_FUND_CAT_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SSR_FUNDING_CODE Character(2) VARCHAR2(2) NOT NULL Code defined by the New Zealand Ministry of Education to identify courses that are funded at the same level.

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

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 SSR_FUNDING_AMT Number(8,2) DECIMAL(7,2) NOT NULL The funding level provided by the New Zealand Ministry of Education for a particular funding category.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_FUNDING_CODE	Character(2)	VARCHAR2(2) NOT NULL	Code defined by the New Zealand Ministry of Education to identify courses that are funded at the same level.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	SSR_FUNDING_AMT	Number(8,2)	DECIMAL(7,2) NOT NULL	The funding level provided by the New Zealand Ministry of Education for a particular funding category.