eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_UC_APP_ADDRESES

Object Details

Object Name:	IGS_UC_APP_ADDRESES
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_UC_APP_ADDRESES
Subobject Name:
Status:	VALID

Holds UCAS Applicant Address details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_APP_ADDRESES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	APP_NO
IGS_UC_APP_ADDRESES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SENT_TO_OSS_FLAG
IGS_UC_APP_ADDRESES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AD_BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APP_NO	NUMBER	(22)	Yes	Unique identifier , Applicant Number
ADDRESS_AREA	VARCHAR2	(1)		Address area
ADDRESS1	VARCHAR2	(50)		Correspondence Address line 1
ADDRESS2	VARCHAR2	(50)		Correspondence Address line 2
ADDRESS3	VARCHAR2	(50)		Correspondence Address line 3
ADDRESS4	VARCHAR2	(50)		Correspondence Address line 4
POST_CODE	VARCHAR2	(8)		Post code
MAIL_SORT	VARCHAR2	(5)		Mail sort
TELEPHONE	VARCHAR2	(35)		Telephone number
FAX	VARCHAR2	(1)		Facsimile
EMAIL	VARCHAR2	(60)		Email address
HOME_ADDRESS1	VARCHAR2	(50)		Home Address line 1
HOME_ADDRESS2	VARCHAR2	(50)		Home Address line 2
HOME_ADDRESS3	VARCHAR2	(50)		Home Address line 3
HOME_ADDRESS4	VARCHAR2	(50)		Home Address line 4
HOME_POSTCODE	VARCHAR2	(8)		Home Post code
HOME_PHONE	VARCHAR2	(24)		Home telephone number
HOME_FAX	VARCHAR2	(1)		Home facsimile
HOME_EMAIL	VARCHAR2	(1)		Home email address
SENT_TO_OSS_FLAG	VARCHAR2	(1)	Yes	Sent to OSS indicator
AD_BATCH_ID	NUMBER	(15)		Admissions Import Batch ID
AD_INTERFACE_ID	NUMBER	(15)		Admissions Import Interface ID
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
MOBILE	VARCHAR2	(35)		Mobile Phone number
COUNTRY_CODE	VARCHAR2	(3)		Correspondence Country Code
HOME_COUNTRY_CODE	VARCHAR2	(3)		Home Address Country Code

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APP_NO
,      ADDRESS_AREA
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      POST_CODE
,      MAIL_SORT
,      TELEPHONE
,      FAX
,      EMAIL
,      HOME_ADDRESS1
,      HOME_ADDRESS2
,      HOME_ADDRESS3
,      HOME_ADDRESS4
,      HOME_POSTCODE
,      HOME_PHONE
,      HOME_FAX
,      HOME_EMAIL
,      SENT_TO_OSS_FLAG
,      AD_BATCH_ID
,      AD_INTERFACE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MOBILE
,      COUNTRY_CODE
,      HOME_COUNTRY_CODE
FROM IGS.IGS_UC_APP_ADDRESES;

Dependencies

[top of page]

IGS.IGS_UC_APP_ADDRESES does not reference any database object

IGS.IGS_UC_APP_ADDRESES is referenced by following:

APPS: IGS_UC_APP_ADDRESES