[Home] [Help] [Dependency Information]
Object Name: | IGSBV_UC_ENQUIRY_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_UC_ENQUIRY_DETAILS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base View for basic person details of a UCAS applicant making an Extra or Clearing application.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UCAS_APPLICANT_NUMBER | NUMBER | (8) | Yes | The UCAS applicant number |
SURNAME | VARCHAR2 | (150) | Surname of the Person. | |
GIVEN_NAMES | VARCHAR2 | (150) | Given name of the Person. | |
SEX_CODE | VARCHAR2 | (30) | Sex Code of the Person. | |
_LA:SEX_DESC | CHAR | (40) | ||
BIRTH_DATE | DATE | Birth Date of the Person | ||
PREFIX | VARCHAR2 | (60) | Title of the Person | |
ADDRESS_LINE1 | VARCHAR2 | (240) | First line of the Identifying Address | |
ADDRESS_LINE2 | VARCHAR2 | (240) | Second line of the Identifying Address | |
ADDRESS_LINE3 | VARCHAR2 | (240) | Third line of the Identifying Address | |
ADDRESS_LINE4 | VARCHAR2 | (240) | Fourth line of the Identifying Address | |
COUNTRY | VARCHAR2 | (60) | Country of the Identifying Address | |
POSTCODE | VARCHAR2 | (60) | Postal Code of the Identifying Address | |
VARCHAR2 | (240) | E-mail Address | ||
TELEPHONE | VARCHAR2 | (40) | Telephone Number | |
UCAS_SYSTEM_CODE | VARCHAR2 | (1) | UCAS System Code | |
EXTRA_PASSPORT_NUMBER | VARCHAR2 | (6) | Holds the applicants extra processing passport Number | |
REQUEST_APPL_DETAILS_IND | VARCHAR2 | (1) | Request Applicant Details Indicator | |
REQUEST_COPY_APPL_FORM_IND | VARCHAR2 | (1) | Request Copy Applicant Form Details Indicator | |
CLEARING_ENTRY_FORM_NUMBER | NUMBER | (9) | Applicant Clearing Entry Form Number | |
OSS_PERSON_IDENTIFIER | NUMBER | (15) | OSS Person 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 UCAS_APPLICANT_NUMBER
, SURNAME
, GIVEN_NAMES
, SEX_CODE
, _LA:SEX_DESC
, BIRTH_DATE
, PREFIX
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ADDRESS_LINE4
, COUNTRY
, POSTCODE
, EMAIL
, TELEPHONE
, UCAS_SYSTEM_CODE
, EXTRA_PASSPORT_NUMBER
, REQUEST_APPL_DETAILS_IND
, REQUEST_COPY_APPL_FORM_IND
, CLEARING_ENTRY_FORM_NUMBER
, OSS_PERSON_IDENTIFIER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_UC_ENQUIRY_DETAILS;
APPS.IGSBV_UC_ENQUIRY_DETAILS is not referenced by any database object
|
|
|