SSR_HE_QEXT_VW

(SQL View)
 Index Back

Qual extract view


SELECT A.INSTITUTION ,A.SSR_HE_RET_NAME ,A.SSR_HE_QUALID ,A.SSR_HE_ACTIVE ,B.SSR_HE_RET_TYPE ,B.SSR_HE_PRD_CODE ,A.SSR_HE_TITLE ,A.SSR_HE_ENT_STATUS FROM PS_SSR_HE_QUAL_EXT A , PS_SSR_HE_INST_HER B WHERE A.INSTITUTION= B.INSTITUTION AND A.SSR_HE_RET_NAME= B.SSR_HE_RET_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 SSR_HE_RET_NAME Character(30) VARCHAR2(30) NOT NULL Return Name

Prompt Table: SSR_HE_STURETVW

3 SSR_HE_QUALID Character(50) VARCHAR2(50) NOT NULL Qualification ID
4 SSR_HE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active

Y/N Table Edit

Default Value: Y

5 SSR_HE_RET_TYPE Character(10) VARCHAR2(10) NOT NULL Return Type
6 SSR_HE_PRD_CODE Character(10) VARCHAR2(10) NOT NULL Reporting Period
7 SSR_HE_TITLE Character(250) VARCHAR2(250) NOT NULL HESA Title
8 SSR_HE_ENT_STATUS Character(1) VARCHAR2(1) NOT NULL Entity Status
A=Amended
D=Delete
E=Error
I=Identify
N=New
U=Unchanged