[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_IVGSTARK_2007_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_IVGSTARK_2007_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View for IVGSTARK for the UCAS 2007 Cycle
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPNO | NUMBER | (22) | Application Number | |
TIMESTAMP | DATE | Time stamp - date and time of last change | ||
APPLICATIONDATE | DATE | Application Date | ||
CODEDCHANGEDATE | DATE | Coded information changed date | ||
RESCAT | VARCHAR2 | (1) | Residency category code | |
FEEPAYER | NUMBER | (22) | Fee Payer Code see cvRefFee | |
APR | NUMBER | (22) | Refers to cvrefAPR - all values | |
COUNTRYBIRTH | NUMBER | (22) | Refers to cvrefAPR - Countries | |
NATIONALITY | NUMBER | (22) | Refers to cvrefAPR - Countries | |
WITHDRAWN | VARCHAR2 | (1) | Null - not withdrawn, C - candidate withdrew, R - reinstated, W - UF withdrawal | |
WITHDRAWNDATE | DATE | Date candidate withdrew or was reinstated | ||
EAS | VARCHAR2 | (1) | Y - Applied through EAS | |
SPECIALNEEDS | VARCHAR2 | (1) | 0 - No disability, 1 - Dyslexia, 2 - Blind or partial sight, 3 - Deaf or partial hearing, 4 - Wheelchair or mobility, 5 - Personal care, 6 - Mental health, 7 - Unseen disability, 8 - Multiple disabilities, 9 - Other disability | |
UKENTRYDATE | DATE | Date of first entry to UK | ||
STATUS | VARCHAR2 | (3) | See cvRefStatus | |
FIRMNOW | NUMBER | (22) | Firm choice number | |
EXTRASTATUS | NUMBER | (22) | Indicates whether the applicant is in extra processing | |
DISABILITY | VARCHAR2 | (1) | See cvRefDis |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, APPLICATIONDATE
, CODEDCHANGEDATE
, RESCAT
, FEEPAYER
, APR
, COUNTRYBIRTH
, NATIONALITY
, WITHDRAWN
, WITHDRAWNDATE
, EAS
, SPECIALNEEDS
, UKENTRYDATE
, STATUS
, FIRMNOW
, EXTRASTATUS
, DISABILITY
FROM APPS.IGS_UC_IVGSTARK_2007_V;
|
|
|