SSR_HE_EQSB_EXT

(SQL Table)
Index Back

HESA Entry Qual Sbj Extract

HESA Entry Qualification Subject Extract

# 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_INST_HER

3 SSR_HE_SID Character(20) VARCHAR2(20) NOT NULL Student Identifier
4 SSR_HE_ENTRYQUALID Character(50) VARCHAR2(50) NOT NULL HESA Entry Qualification Award ID
5 SSR_HE_SUBJECTID Character(6) VARCHAR2(6) NOT NULL HESA Subject ID
6 SSR_HE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active

Y/N Table Edit

7 SSR_HE_ENT_STATUS Character(1) VARCHAR2(1) NOT NULL Entity Status
A=Amended
D=Delete
E=Error
I=Identify
N=New
U=Unchanged