SSR_HE_MST_CRIN

(SQL Table)
Index Back

HESA Master Course Init

Contains HESA Master Course Initiative Extract Records

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SSR_HE_RET_TYPE Character(10) VARCHAR2(10) NOT NULL Return Type
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 SSR_HE_COURSEID Character(10) VARCHAR2(10) NOT NULL Course ID
6 SSR_HE_CRS_INIT Character(3) VARCHAR2(3) NOT NULL Course Initiative ID
7 SSR_HE_VALID_FROM Date(10) DATE HESA Valid From
8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
9 SSR_HE_ENT_STATUS Character(1) VARCHAR2(1) NOT NULL Entity Status
A=Amended
D=Delete
E=Error
I=Identify
N=New
U=Unchanged