[Home] [Help]
View: IGSBV_HESA_EXT_RUN_DAT_FIELDS
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Base View for HESA extract data fields |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT FD.RN_DAT_FD_ID HESA_RETURN_FIELD_ID
, FD.EXTRACT_RUN_ID EXTRACT_RUN_ID
, FD.LINE_NUMBER LINE_NUMBER
, FD.FIELD_NUMBER FIELD_NUMBER
, FD.VALUE VALUE
, FD.OVERRIDE_VALUE OVERRIDE_VALUE
, FD.CREATED_BY CREATED_BY
, FD.CREATION_DATE CREATION_DATE
, FD.LAST_UPDATED_BY LAST_UPDATED_BY
, FD.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_EX_RN_DAT_FD FD WITH READ ONLY
Columns
| Name |
| HESA_RETURN_FIELD_ID |
| EXTRACT_RUN_ID |
| LINE_NUMBER |
| FIELD_NUMBER |
| VALUE |
| OVERRIDE_VALUE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |