[Home] [Help] [Dependency Information]
Object Name: | IGSFV_HESA_EXT_RUN_DAT_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_HESA_EXT_RUN_DAT_LINES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for HESA extract data
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HESA_RETURN_LINE_ID | NUMBER | Yes | Sequence number uniquely identifying the HESA return line | |
EXTRACT_RUN_ID | NUMBER | Yes | Unique identifier for the HESA extract run | |
SUBMISSION_NAME | VARCHAR2 | (50) | Yes | HESA submission name |
USER_RETURN_SUBCLASS | VARCHAR2 | (50) | Yes | User return sub class |
USER_RETURN_SUB_CLASS_DESC | VARCHAR2 | (200) | User return sub class description | |
RETURN_NAME | VARCHAR2 | (50) | Yes | User return name |
REPORTING_PERIOD_START_DATE | DATE | Yes | Reporting period start date | |
REPORTING_PERIOD_END_DATE | DATE | Yes | Reporting period end date | |
RECORD_ID | VARCHAR2 | (6) | Yes | HESA Record ID, uniquely identifying the type of HESA return and extract |
SYSTEM_RETURN_CLASS_TYPE | VARCHAR2 | (50) | System return class | |
LINE_NUMBER | NUMBER | Yes | Unique identifier for each line in the Extract file | |
PERSON_ID | NUMBER | Unique person identifier, populated if combined or student return | ||
PERSON_NUMBER | VARCHAR2 | (30) | Unique Person Number | |
PERSON_SURNAME | VARCHAR2 | (150) | Surname | |
PERSON_GIVEN_NAMES | VARCHAR2 | (150) | Given names | |
PERSON_FULL_NAME | VARCHAR2 | (450) | Full name | |
STUDENT_INSTANCE_NUMBER | VARCHAR2 | (20) | Student instance number, returned as HESA NUMHUS, populated if combined or student return | |
PROGRAM_CODE | VARCHAR2 | (6) | Unique identifier for Program of study student enrolled on, populated if combined or student return | |
PROGRAM_VERSION_NUMBER | NUMBER | (3) | Program of study Version number, populated if combined or student return | |
PROGRAM_TITLE | VARCHAR2 | (90) | Program of study Title | |
PROGRAM_SHORT_TITLE | VARCHAR2 | (40) | Program of study Short Name | |
PROGRAM_ABBREVIATION | VARCHAR2 | (20) | Program of study Abbreviation | |
UNIT_CODE | VARCHAR2 | (10) | Unique identifier for a Unit | |
UNIT_VERSION_NUMBER | NUMBER | (3) | Version Number of Unit | |
UNIT_TITLE | VARCHAR2 | (90) | Unit Title | |
UNIT_SHORT_TITLE | VARCHAR2 | (40) | Unit short title | |
UNIT_ABBREVIATION | VARCHAR2 | (20) | Unit abbreviation | |
MANUALLY_INSERTED_FLAG | VARCHAR2 | (3) | Yes | Flag indicating that the record has been manually inserted into the HESA return |
EXCLUDE_FROM_FILE_FLAG | VARCHAR2 | (3) | Yes | Flag indicating that record is to be excluded from the Extract Flat file |
RECALCULATE_FLAG | VARCHAR2 | (1) | Yes | Flag indicating that record is to be recalculated |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column indicates who created this record |
CREATION_DATE | DATE | Yes | Standard WHO column indicates when this record was created | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column indicates who updated this record last |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column indicates when this record was last updated |
Cut, paste (and edit) the following text to query this object:
SELECT HESA_RETURN_LINE_ID
, EXTRACT_RUN_ID
, SUBMISSION_NAME
, USER_RETURN_SUBCLASS
, USER_RETURN_SUB_CLASS_DESC
, RETURN_NAME
, REPORTING_PERIOD_START_DATE
, REPORTING_PERIOD_END_DATE
, RECORD_ID
, SYSTEM_RETURN_CLASS_TYPE
, LINE_NUMBER
, PERSON_ID
, PERSON_NUMBER
, PERSON_SURNAME
, PERSON_GIVEN_NAMES
, PERSON_FULL_NAME
, STUDENT_INSTANCE_NUMBER
, PROGRAM_CODE
, PROGRAM_VERSION_NUMBER
, PROGRAM_TITLE
, PROGRAM_SHORT_TITLE
, PROGRAM_ABBREVIATION
, UNIT_CODE
, UNIT_VERSION_NUMBER
, UNIT_TITLE
, UNIT_SHORT_TITLE
, UNIT_ABBREVIATION
, MANUALLY_INSERTED_FLAG
, EXCLUDE_FROM_FILE_FLAG
, RECALCULATE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_HESA_EXT_RUN_DAT_LINES;
APPS.IGSFV_HESA_EXT_RUN_DAT_LINES is not referenced by any database object
|
|
|