[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_IVSTARH_2003_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_IVSTARH_2003_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
From 2004, application statistics information will be held in different Hercules views for different systems. This View selects the application statistics information belonging to all the systems.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPNO | NUMBER | (22) | Application Number | |
TIMESTAMP | DATE | Time stamp - date and time of last change | ||
ETHNIC | NUMBER | (22) | Ethnic code | |
SOCIALCLASS | VARCHAR2 | (1) | Social Class - pre 2000 | |
POCCEDUCHANGEDATE | DATE | Date of change of Parental Occupation or Education details | ||
POCC | VARCHAR2 | (4) | Parental Occupation Group | |
POCCTEXT | VARCHAR2 | (22) | EAS Parental Occupation Text | |
LASTEDUCATION | NUMBER | (22) | Last educational establishment: Last school attended (DFE number) Last HE inst attended (HESA code) Zero if no details of leaving | |
EDUCATIONLEAVEDATE | NUMBER | (22) | Year of leaving | |
LEA | VARCHAR2 | (1) | ** NO LONGER USED ** | |
SOCIALECONOMIC | VARCHAR2 | (1) | Socio-economic classification |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, ETHNIC
, SOCIALCLASS
, POCCEDUCHANGEDATE
, POCC
, POCCTEXT
, LASTEDUCATION
, EDUCATIONLEAVEDATE
, LEA
, SOCIALECONOMIC
FROM APPS.IGS_UC_IVSTARH_2003_V;
|
|
|