DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_UC_ISTARN_INTS

Object Details
Object Name: IGS_UC_ISTARN_INTS
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_UC_ISTARN_INTS
Subobject Name:
Status: VALID


Holds applicant name information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_ISTARN_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnAPPNO
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (22)
Application Number
CHECKDIGIT NUMBER (22)
Application number check digit
NAMECHANGEDATE DATE

Date the Name Changed
TITLE VARCHAR2 (4)
Title, Mr, Miss, Ms, Mrs, Lord etc ..
FORENAMES VARCHAR2 (50)
Forenames
SURNAME VARCHAR2 (30)
Surnames
BIRTHDATE DATE

Date of birth
SEX VARCHAR2 (1)
M - Male, F - Female
AD_BATCH_ID NUMBER (15)
Admissions Import Batch ID
AD_INTERFACE_ID NUMBER (15)
Admissions Interface Import ID
AD_API_ID NUMBER (15)
Admissions Import API ID
RECORD_STATUS VARCHAR2 (1)
Status of the interface record , takes values N, O, D etc
ERROR_CODE VARCHAR2 (4)
Code for the error encountered during processing of this interface record data
PERSONALID VARCHAR2 (10)
Unique Personal Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPNO
,      CHECKDIGIT
,      NAMECHANGEDATE
,      TITLE
,      FORENAMES
,      SURNAME
,      BIRTHDATE
,      SEX
,      AD_BATCH_ID
,      AD_INTERFACE_ID
,      AD_API_ID
,      RECORD_STATUS
,      ERROR_CODE
,      PERSONALID
FROM IGS.IGS_UC_ISTARN_INTS;

Dependencies

[top of page]

IGS.IGS_UC_ISTARN_INTS does not reference any database object

IGS.IGS_UC_ISTARN_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_ISTARN_INTS