[Home] [Help] [Dependency Information]
Object Name: | IGS_HE_VERIFY_DATA_T |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_HE_VERIFY_DATA_T |
Subobject Name: | |
Status: | VALID |
Temp table to store data during the 'Verify HESA Return' concurrent process
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | Person ID | ||
COURSE_CD | VARCHAR2 | (6) | Course code | |
CRV_VERSION_NUMBER | NUMBER | (3) | Course version number | |
CAL_TYPE | VARCHAR2 | (10) | Calendar type | |
LOCATION_CD | VARCHAR2 | (10) | Location code | |
ATTENDANCE_MODE | VARCHAR2 | (2) | Attendance mode | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Attendance type | |
UNIT_SET_CD | VARCHAR2 | (10) | Unit set code | |
US_VERSION_NUMBER | NUMBER | (3) | Unit set version number | |
UNIT_CD | VARCHAR2 | (10) | Unit Code | |
U_VERSION_NUMBER | NUMBER | (3) | Unit version number | |
FIELDS_AFFECTED | VARCHAR2 | (30) | Fields affected by the association code | |
ASSOCIATION_CODE | VARCHAR2 | (30) | Association Code | |
DISPLAY_TITLE | VARCHAR2 | (80) | Display Title of Code | |
OSS_VALUE | VARCHAR2 | (80) | Unmapped OSS value | |
SPA_FLAG | VARCHAR2 | (1) | Flag to indicate existence of HESA SPA details | |
QUALAIM_FLAG | VARCHAR2 | (1) | Flag to indicate existence of HESA SPA Qualaim details | |
SIN_FLAG | VARCHAR2 | (1) | Flag to indicate existence of Student Instance Number | |
SUSA_FLAG | VARCHAR2 | (1) | Flag to indicate existence of HESA SUSA details | |
PROG_FLAG | VARCHAR2 | (1) | Flag to indicate existence of HESA PROG details | |
POOUS_FLAG | VARCHAR2 | (1) | Flag to indicate existence of HESA POOUS Flag | |
UNIT_FLAG | VARCHAR2 | (1) | Flag to indicate existence of HESA Unit details | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, CRV_VERSION_NUMBER
, CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, UNIT_SET_CD
, US_VERSION_NUMBER
, UNIT_CD
, U_VERSION_NUMBER
, FIELDS_AFFECTED
, ASSOCIATION_CODE
, DISPLAY_TITLE
, OSS_VALUE
, SPA_FLAG
, QUALAIM_FLAG
, SIN_FLAG
, SUSA_FLAG
, PROG_FLAG
, POOUS_FLAG
, UNIT_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM IGS.IGS_HE_VERIFY_DATA_T;
IGS.IGS_HE_VERIFY_DATA_T does not reference any database object
IGS.IGS_HE_VERIFY_DATA_T is referenced by following:
|
|
|