SCC_HE_PERBFLVW (SQL View)	Index Back
Person Data fields view View to display HESA Person Data

SCC_HE_PERBFLVW

(SQL View)

Person Data fields view

View to display HESA Person Data

SELECT SSR_HE_FIELD ,DESCR FROM PS_SSR_HE_FIELDS WHERE SSR_HE_STUDENT_FLG = 'Y' AND SSR_HE_SEPARATE IN ('OTH' ,'RES') AND SSR_HE_ACTIVE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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