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

TABLE: IGS.IGS_UC_ISTARX_INTS

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


Holds Extra Statistics information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_ISTARX_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnAPPNO
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (22)
Application Number
ETHNIC NUMBER (22)
Ethnic origin
POCCEDUCHANGEDATE DATE

Date of change of Parental Occupation details
SOCIALCLASS VARCHAR2 (1)
Social Class - pre 2000
POCC VARCHAR2 (4)
Parental Occupation Group
POCCTEXT VARCHAR2 (22)
EAS Parental Occupation Text
SOCIOECONOMIC VARCHAR2 (1)
Socio-economic classification
OCCBACKGROUND VARCHAR2 (22)
Occupation background
RELIGION NUMBER (22)
SWAS - Religion. 1 - Protestant, 2 - Catholic, 3 - Other
DEPENDANTS NUMBER (22)
NMAS - Number of Dependants
MARRIED VARCHAR2 (1)
NMAS - Marital Status. S - Single, M - Married, D - Divorced, W - Widowed, Blank - Not Known
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
Query Text

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


SELECT APPNO
,      ETHNIC
,      POCCEDUCHANGEDATE
,      SOCIALCLASS
,      POCC
,      POCCTEXT
,      SOCIOECONOMIC
,      OCCBACKGROUND
,      RELIGION
,      DEPENDANTS
,      MARRIED
,      RECORD_STATUS
,      ERROR_CODE
FROM IGS.IGS_UC_ISTARX_INTS;

Dependencies

[top of page]

IGS.IGS_UC_ISTARX_INTS does not reference any database object

IGS.IGS_UC_ISTARX_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_ISTARX_INTS