Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Base View for HESA extract data |
Implementation/DBA Data: | Not implemented in this database |
SELECT LN.RN_DAT_LN_ID HESA_RETURN_LINE_ID
, LN.EXTRACT_RUN_ID EXTRACT_RUN_ID
, LN.RECORD_ID RECORD_ID
, LN.LINE_NUMBER LINE_NUMBER
, LN.PERSON_ID PERSON_ID
, LN.STUDENT_INST_NUMBER STUDENT_INSTANCE_NUMBER
, LN.COURSE_CD PROGRAM_CODE
, LN.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, LN.UNIT_CD UNIT_CODE
, LN.UV_VERSION_NUMBER UNIT_VERSION_NUMBER
, LN.MANUALLY_INSERTED MANUALLY_INSERTED_FLAG
, LN.EXCLUDE_FROM_FILE EXCLUDE_FROM_FILE_FLAG
, LN.RECALCULATE_FLAG RECALCULATE_FLAG
, LN.CREATED_BY CREATED_BY
, LN.CREATION_DATE CREATION_DATE
, LN.LAST_UPDATED_BY LAST_UPDATED_BY
, LN.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_EX_RN_DAT_LN LN WITH READ ONLY