[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_CVNAME_INTS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_UC_CVNAME_INTS |
Subobject Name: | |
Status: | VALID |
Holds prospective applicants information loaded from UCAS
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPNO | NUMBER | (22) | Yes | Application Number |
CHECKDIGIT | NUMBER | (22) | Yes | Check digit for the application number |
NAMECHANGEDATE | DATE | Name change date | ||
TITLE | VARCHAR2 | (4) | Yes | Title |
FORENAMES | VARCHAR2 | (24) | First name | |
SURNAME | VARCHAR2 | (18) | Yes | Surname |
INDEXSURN | VARCHAR2 | (18) | Yes | Surname index |
CANCELLED | VARCHAR2 | (1) | Cancelled indicator | |
WITHDRAWN | VARCHAR2 | (1) | Withdrawn indicator | |
STATUS | VARCHAR2 | (1) | Yes | Status |
BIRTHDATE | DATE | Date of birth | ||
SEX | VARCHAR2 | (1) | Yes | Gender |
CHOICESALLTRANSPARENT | VARCHAR2 | (1) | Applications Choices are visible to institution or not | |
EXTRASTATUS | NUMBER | (22) | Indicates whether the applicant is in extra processing |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, CHECKDIGIT
, NAMECHANGEDATE
, TITLE
, FORENAMES
, SURNAME
, INDEXSURN
, CANCELLED
, WITHDRAWN
, STATUS
, BIRTHDATE
, SEX
, CHOICESALLTRANSPARENT
, EXTRASTATUS
FROM IGS.IGS_UC_CVNAME_INTS;
IGS.IGS_UC_CVNAME_INTS does not reference any database object
IGS.IGS_UC_CVNAME_INTS is referenced by following:
|
|
|