[Home] [Help] [Dependency Information]
Object Name: | IGSFV_UC_APPLICANT_STATISTICS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_UC_APPLICANT_STATISTICS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for Applicant data required for HESA purpose
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_ETHNIC_DESC | VARCHAR2 | (300) | Description for Ethnic code in ivStarH | |
IVSTARH_SOCIAL_CLASS_CODE | VARCHAR2 | (1) | Social class code, synchronized with UCAS view ivStarH | |
IVSTARH_SOCIAL_CLASS_DESC | VARCHAR2 | (300) | Description for Social Class Code in 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_SOCIO_ECONOMIC_DESC | VARCHAR2 | (300) | Socio Economic classification description | |
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_ETHNIC_DESC | VARCHAR2 | (300) | Description for Ethnic code in 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_SOCIO_ECONOMIC_DESC | VARCHAR2 | (300) | Socio Economic classification description | |
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) |
OSS_PERSON_IDENTIFIER | NUMBER | (15) | OSS Person Identifier | |
OSS_PERSON_NUMBER | VARCHAR2 | (30) | OSS Person Number | |
OSS_PERSON_NAME | VARCHAR2 | (360) | OSS Person Name | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICANT_STAT_IDENTIFIER
, UCAS_APPLICANT_NUMBER
, IVSTARH_ETHNIC_CODE
, IVSTARH_ETHNIC_DESC
, IVSTARH_SOCIAL_CLASS_CODE
, IVSTARH_SOCIAL_CLASS_DESC
, 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_SOCIO_ECONOMIC_DESC
, IVSTARH_DEPENDANTS
, IVSTARH_MARRIED
, IVSTARX_ETHNIC_CODE
, IVSTARX_ETHNIC_DESC
, IVSTARX_POCC_EDU_CHANGE_DATE
, IVSTARX_POCC_CODE
, IVSTARX_POCC_TEXT
, IVSTARX_SOCIO_ECONOMIC_CODE
, IVSTARX_SOCIO_ECONOMIC_DESC
, IVSTARX_OCC_BACKGROUND
, IVSTARX_RELIGION
, IVSTARX_DEPENDANTS
, IVSTARX_MARRIED
, SENT_TO_HESA
, OSS_PERSON_IDENTIFIER
, OSS_PERSON_NUMBER
, OSS_PERSON_NAME
, APPLICANT_IDENTIFIER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_APPLICANT_STATISTICS;
APPS.IGSFV_UC_APPLICANT_STATISTICS is not referenced by any database object
|
|
|