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

TABLE: IGS.IGS_UC_APP_STATS

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


Holds applicant data required for HESA purpose . It synchronizes with 'ivStarH' & 'ivStarX'


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_APP_STATS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPP_STAT_ID
IGS_UC_APP_STATS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPP_NO
Columns
Name Datatype Length Mandatory Comments
APP_STAT_ID NUMBER
Yes Unique Record Identifier
APP_ID NUMBER
Yes Unique applicant identifier
APP_NO NUMBER (8) Yes UCAS application number
IVSTARH_TIMESTAMP DATE

Timestamp to synchronize with UCAS view ivStarH - Obsolete
STARH_ETHNIC NUMBER (2)
Ethnic code synchronized with UCAS view ivStarH
STARH_SOCIAL_CLASS VARCHAR2 (1)
Social class code, synchronized with UCAS view ivStarH
STARH_POCC_EDU_CHG_DT DATE

Parental occupation or last educational institution attended changed date, synchronized with UCAS view ivStarH
STARH_POCC VARCHAR2 (4)
Parental occupation code, synchronized with UCAS view ivStarH
STARH_POCC_TEXT VARCHAR2 (30)
Parental occupation description, synchronized with UCAS view ivStarH
STARH_LAST_EDU_INST NUMBER

Last education institution attended, synchronized with UCAS view ivStarH
STARH_EDU_LEAVE_DATE NUMBER

Education leaving date, synchronized with UCAS view ivStarH
STARH_LEA NUMBER (3)
Local Education Authority synchronized with ivStarH
IVSTARX_TIMESTAMP DATE

Timestamp to synchronize with UCAS view ivStarX - Obsolete
STARX_ETHNIC NUMBER (2)
Ethnic code synchronized with UCAS view ivStarX
STARX_POCC_EDU_CHG DATE

Parental occupation or last educational institution attended changed date, synchronized with UCAS view ivStarX
STARX_POCC VARCHAR2 (4)
Parental occupation code, synchronized with UCAS view ivStarX
STARX_POCC_TEXT VARCHAR2 (30)
Parental occupation description, synchronized with UCAS view ivStarX
SENT_TO_HESA VARCHAR2 (1) Yes Record exported to HESA (Y - yes, N - no)
STARH_SOCIO_ECONOMIC NUMBER (1)
Socio Economic classification
STARX_SOCIO_ECONOMIC NUMBER (1)
Socio Economic classification
STARX_OCC_BACKGROUND VARCHAR2 (22)
Occupation background
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
IVSTARH_DEPENDANTS NUMBER (2)
NMAS - Number of Dependants
IVSTARH_MARRIED VARCHAR2 (1)
NMAS - Marital Status
IVSTARX_RELIGION NUMBER (1)
SWAS - Religion , 1 - Protestant, 2-Catholic , 3- Other
IVSTARX_DEPENDANTS NUMBER (2)
NMAS - Number of Dependants
IVSTARX_MARRIED VARCHAR2 (1)
NMAS - Marital Status , S- single , M - Married , D- Divorced , W - Widowed , Blank - not known
Query Text

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


SELECT APP_STAT_ID
,      APP_ID
,      APP_NO
,      IVSTARH_TIMESTAMP
,      STARH_ETHNIC
,      STARH_SOCIAL_CLASS
,      STARH_POCC_EDU_CHG_DT
,      STARH_POCC
,      STARH_POCC_TEXT
,      STARH_LAST_EDU_INST
,      STARH_EDU_LEAVE_DATE
,      STARH_LEA
,      IVSTARX_TIMESTAMP
,      STARX_ETHNIC
,      STARX_POCC_EDU_CHG
,      STARX_POCC
,      STARX_POCC_TEXT
,      SENT_TO_HESA
,      STARH_SOCIO_ECONOMIC
,      STARX_SOCIO_ECONOMIC
,      STARX_OCC_BACKGROUND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      IVSTARH_DEPENDANTS
,      IVSTARH_MARRIED
,      IVSTARX_RELIGION
,      IVSTARX_DEPENDANTS
,      IVSTARX_MARRIED
FROM IGS.IGS_UC_APP_STATS;

Dependencies

[top of page]

IGS.IGS_UC_APP_STATS does not reference any database object

IGS.IGS_UC_APP_STATS is referenced by following:

SchemaAPPS
SynonymIGS_UC_APP_STATS