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.

[Home] [Help]

View: IGS_AD_CONTACTS_INT

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TAB.ROWID ROW_ID
, TAB.PHONE_EXTENSION PHONE_EXTENSION
, TAB.STATUS STATUS
, TAB.MATCH_IND MATCH_IND
, TAB.ERROR_CODE ERROR_CODE
, TAB.DUP_CONTACT_POINT_ID DUP_CONTACT_POINT_ID
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.REQUEST_ID REQUEST_ID
, TAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TAB.PROGRAM_ID PROGRAM_ID
, TAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TAB.ORG_ID ORG_ID
, TAB.INTERFACE_CONTACTS_ID INTERFACE_CONTACTS_ID
, TAB.INTERFACE_ID INTERFACE_ID
, TAB.CONTACT_POINT_TYPE CONTACT_POINT_TYPE
, TAB.EMAIL_ADDRESS EMAIL_ADDRESS
, TAB.EMAIL_FORMAT EMAIL_FORMAT
, TAB.PRIMARY_FLAG PRIMARY_FLAG
, TAB.PHONE_LINE_TYPE PHONE_LINE_TYPE
, TAB.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, TAB.PHONE_AREA_CODE PHONE_AREA_CODE
, TAB.PHONE_NUMBER PHONE_NUMBER
FROM IGS_AD_CONTACTS_INT_ALL TAB

Columns

Name
ROW_ID
PHONE_EXTENSION
STATUS
MATCH_IND
ERROR_CODE
DUP_CONTACT_POINT_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ORG_ID
INTERFACE_CONTACTS_ID
INTERFACE_ID
CONTACT_POINT_TYPE
EMAIL_ADDRESS
EMAIL_FORMAT
PRIMARY_FLAG
PHONE_LINE_TYPE
PHONE_COUNTRY_CODE
PHONE_AREA_CODE
PHONE_NUMBER