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

VIEW: APPS.IGSBV_UC_APPLICANT_STATISTICS

Object Details
Object Name: IGSBV_UC_APPLICANT_STATISTICS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_UC_APPLICANT_STATISTICS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Base View for Applicant data required for HESA purpose


[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICANT_STAT_IDENTIFIER NUMBER
Yes Unique Record Identifier
UCAS_APPLICANT_NUMBER NUMBER (8) Yes UCAS application number
IVSTARH_ETHNIC_CODE NUMBER (2)
Ethnic code synchronized with UCAS view ivStarH
IVSTARH_SOCIAL_CLASS_CODE VARCHAR2 (1)
Social class code, synchronized with UCAS view ivStarH
IVSTARH_POCC_EDU_CHANGE_DATE DATE

Parental occupation or last educational institution attended changed date, synchronized with UCAS view ivStarH
IVSTARH_POCC_CODE VARCHAR2 (4)
Parental occupation code, synchronized with UCAS view ivStarH
IVSTARH_POCC_TEXT VARCHAR2 (30)
Parental occupation description, synchronized with UCAS view ivStarH
IVSTARH_LAST_EDU_INSTITUTION NUMBER

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

Education leaving date, synchronized with UCAS view ivStarH
IVSTARH_LEA NUMBER (3)
Local Education Authority synchronized with ivStarH
IVSTARH_SOCIO_ECONOMIC_CODE NUMBER (1)
Socio Economic classification Code in IvStarH
IVSTARH_DEPENDANTS NUMBER (2)
NMAS - Number of Dependants
IVSTARH_MARRIED VARCHAR2 (1)
NMAS - Marital Status
IVSTARX_ETHNIC_CODE NUMBER (2)
Ethnic code synchronized with UCAS view ivStarX
IVSTARX_POCC_EDU_CHANGE_DATE DATE

Parental occupation or last educational institution attended changed date, synchronized with UCAS view ivStarX
IVSTARX_POCC_CODE VARCHAR2 (4)
Parental occupation code, synchronized with UCAS view ivStarX
IVSTARX_POCC_TEXT VARCHAR2 (30)
Parental occupation description, synchronized with UCAS view ivStarX
IVSTARX_SOCIO_ECONOMIC_CODE NUMBER (1)
Socio Economic classification Code in IvStarX
IVSTARX_OCC_BACKGROUND VARCHAR2 (22)
Occupation background
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
SENT_TO_HESA VARCHAR2 (1) Yes Record exported to HESA (Y - yes, N - no)
APPLICANT_IDENTIFIER NUMBER
Yes Unique applicant identifier
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
Query Text

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


SELECT APPLICANT_STAT_IDENTIFIER
,      UCAS_APPLICANT_NUMBER
,      IVSTARH_ETHNIC_CODE
,      IVSTARH_SOCIAL_CLASS_CODE
,      IVSTARH_POCC_EDU_CHANGE_DATE
,      IVSTARH_POCC_CODE
,      IVSTARH_POCC_TEXT
,      IVSTARH_LAST_EDU_INSTITUTION
,      IVSTARH_EDU_LEAVE_DATE
,      IVSTARH_LEA
,      IVSTARH_SOCIO_ECONOMIC_CODE
,      IVSTARH_DEPENDANTS
,      IVSTARH_MARRIED
,      IVSTARX_ETHNIC_CODE
,      IVSTARX_POCC_EDU_CHANGE_DATE
,      IVSTARX_POCC_CODE
,      IVSTARX_POCC_TEXT
,      IVSTARX_SOCIO_ECONOMIC_CODE
,      IVSTARX_OCC_BACKGROUND
,      IVSTARX_RELIGION
,      IVSTARX_DEPENDANTS
,      IVSTARX_MARRIED
,      SENT_TO_HESA
,      APPLICANT_IDENTIFIER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_UC_APPLICANT_STATISTICS;

Dependencies

[top of page]

APPS.IGSBV_UC_APPLICANT_STATISTICS references the following:

SchemaAPPS
SynonymIGS_UC_APP_STATS

APPS.IGSBV_UC_APPLICANT_STATISTICS is not referenced by any database object