SSR_HE_MST_CIDN

(SQL Table)
Index Back

HESA Course Identifier Master

Contains HESA Course Identifier Master 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_COUDELID Character(50) VARCHAR2(50) NOT NULL Course Delivery ID
7 SSR_HE_LN_NBR Number(5,0) INTEGER NOT NULL Line Number
8 SSR_HE_CDREF_ID Character(2) VARCHAR2(2) NOT NULL Course Delivery Reference ID
9 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
10 SSR_HE_ENT_STATUS Character(1) VARCHAR2(1) NOT NULL Entity Status
A=Amended
D=Delete
E=Error
I=Identify
N=New
U=Unchanged