SSR_CLSF_FND_VW (SQL View)	Index Back
Valid funding for course class Prompt against course classification.

SSR_CLSF_FND_VW

(SQL View)

Valid funding for course class

Prompt against course classification.

SELECT A.SSR_CRSE_CLASIF , A.EFFDT , A.SSR_FUNDING_CODE , B.DESCR FROM PS_SSR_C_CLSF_FNDC A , PS_SSR_FUNDING_CAT B WHERE A.SSR_FUNDING_CODE = B.SSR_FUNDING_CODE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_SSR_FUNDING_CAT B1 WHERE B1.SSR_FUNDING_CODE = B.SSR_FUNDING_CODE AND B1.EFFDT <=%CurrentDateIn) AND B.EFF_STATUS = 'A'

Related Language Record: SSR_CLSFND_VWLN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SSR_CRSE_CLASIF Character(4) VARCHAR2(4) NOT NULL BBWW6YW - SDR ver 2.00 changes. It is course classification field.

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 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.
Default Value: SSR_FUNDING_CAT.SSR_FUNDING_CODE
Prompt Table: SSR_FUNDING_CAT
Set Control Field: DESCR

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_CRSE_CLASIF	Character(4)	VARCHAR2(4) NOT NULL	BBWW6YW - SDR ver 2.00 changes. It is course classification field.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	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. Default Value: SSR_FUNDING_CAT.SSR_FUNDING_CODE Prompt Table: SSR_FUNDING_CAT Set Control Field: DESCR
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description