VIEW: APPS.IGSBV_HESA_EXT_RUN_DAT_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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