SSR_HE_CRSFLDVW (SQL View)	Index Back
Module Fields View View to display Module HESA fields

SSR_HE_CRSFLDVW

(SQL View)

Module Fields View

View to display Module HESA fields

SELECT ID.INSTITUTION , ID.SSR_HE_FIELD ,ID.DESCR FROM PS_SSR_HE_INST_DAT ID , PS_SSR_HE_FIELDS F WHERE ID.SSR_HE_FIELD = F.SSR_HE_FIELD AND F.SSR_HE_ACTIVE = 'Y' AND ID.SSR_HE_MODULE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SSR_HE_FIELD Character(20) VARCHAR2(20) NOT NULL Field

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SSR_HE_FIELD	Character(20)	VARCHAR2(20) NOT NULL	Field
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description