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_FI_1098T_SETUP

Object Details

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

Stores 1098-T reporting requirements setup information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_1098T_SETUP_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TAX_YEAR_NAME
IGS_FI_1098T_SETUP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TAX_YEAR_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_YEAR_NAME	VARCHAR2	(30)	Yes	Name of the Tax Year, as defined by the user.
OBJECT_VERSION_NUMBER	NUMBER		Yes	This column is used for locking rows in the database.
TAX_YEAR_CODE	VARCHAR2	(30)	Yes	The Calendar Year corresponding to the Tax Year Name.
START_DATE	DATE		Yes	Stores the Start Date of the Tax Year, the first day of the calendar year.
END_DATE	DATE		Yes	Stores the End Date of the Tax Year, the last day of the calendar year.
REPORTING_MTHD_CODE	VARCHAR2	(30)	Yes	The Institution's reporting method - i.e. Total payments received OR Total amounts billed.
TRANS_PARTY_SITE_ID	NUMBER	(15)	Yes	Party Site Identifier setup for the 1098-T Reporting Transmitter
TRANS_RELATIONSHIP_ID	NUMBER	(15)	Yes	Relationship Identifier setup as the 1098-T Reporting Transmitter Contact
TRANS_CONTACT_POINT_ID	NUMBER	(15)	Yes	Unique identifier of the Transmitter Contact Phone
FILER_PARTY_SITE_ID	NUMBER	(15)	Yes	Party Site Identifier setup for the 1098-T Reporting Filer
VENDOR_PARTY_SITE_ID	NUMBER	(15)	Yes	Party Site Identifier setup for the 1098-T Reporting Vendor
VENDOR_RELATIONSHIP_ID	NUMBER	(15)	Yes	Relationship Identifier setup as the 1098-T Reporting Vendor Contact
VENDOR_CONTACT_POINT_ID	NUMBER	(15)	Yes	Unique identifier of the Vendor Contact Phone
PERM_PARTY_SITE_USE_CODE	VARCHAR2	(30)	Yes	Party Site Usage Code which serves as the permanent address
TEMP_PARTY_SITE_USE_CODE	VARCHAR2	(30)	Yes	Temporary Party Site Usage Code which serves as the temporary address
CONTROL_CODE	VARCHAR2	(5)	Yes	The alphanumeric Transmitter Control Code assigned by the Internal Revenue Service to the Transmitter
EXCL_NON_RES_ALIEN_FLAG	VARCHAR2	(1)	Yes	Indicates that the 1098-T tuition statement need not be reported for an individual who is a Non Resident Alien during the calendar year
EXCL_NON_CREDIT_COURSE_FLAG	VARCHAR2	(1)	Yes	Indicates that the 1098-T tuition statement need not be reported for any programs for which, no academic credit is offered by the institution
EXCL_TUIT_WAIV_FLAG	VARCHAR2	(1)	Yes	Indicates that the 1098-T tuition statement need not be reported for individuals whose qualified tuition and related expenses are entirely waived or entirely paid by scholarships
TRANS_TIN	VARCHAR2	(20)	Yes	Tax Identification Number of the Transmitter
FILER_TIN	VARCHAR2	(20)	Yes	Tax Identification Number of the Filer
TRANS_FOREIGN_ENTITY_FLAG	VARCHAR2	(1)	Yes	Indicates that the Transmitter is a non U.S (foreign) institution
FILER_FOREIGN_ENTITY_FLAG	VARCHAR2	(1)	Yes	Indicates that the Filer is a non U.S (foreign) institution
VENDOR_FOREIGN_ENTITY_FLAG	VARCHAR2	(1)	Yes	Indicates that the Vendor is a non U.S (foreign) institution
SERVICE_PARTY_SITE_ID	NUMBER	(15)		Party Site Identifier setup for the 1098-T Reporting Service Provider
FILER_CONTACT_POINT_ID	NUMBER	(15)		Unique identifier of the Filer Contact Phone
SERV_CONTACT_POINT_ID	NUMBER	(15)		Unique identifier of the Service Provider Contact Phone.
NAME_CONTROL_CODE	VARCHAR2	(4)		The name control of the Filer
PERSON_ID_TYPE	VARCHAR2	(10)		The user defined person Id type, which maps to the system person ID type of 'Tax Payer ID'
SEC_PHONE_NUMBER	VARCHAR2	(40)		The Secondary Phone Number of the filer, which is printed on the 1098-T Tuition Statement.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Query Text

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


SELECT TAX_YEAR_NAME
,      OBJECT_VERSION_NUMBER
,      TAX_YEAR_CODE
,      START_DATE
,      END_DATE
,      REPORTING_MTHD_CODE
,      TRANS_PARTY_SITE_ID
,      TRANS_RELATIONSHIP_ID
,      TRANS_CONTACT_POINT_ID
,      FILER_PARTY_SITE_ID
,      VENDOR_PARTY_SITE_ID
,      VENDOR_RELATIONSHIP_ID
,      VENDOR_CONTACT_POINT_ID
,      PERM_PARTY_SITE_USE_CODE
,      TEMP_PARTY_SITE_USE_CODE
,      CONTROL_CODE
,      EXCL_NON_RES_ALIEN_FLAG
,      EXCL_NON_CREDIT_COURSE_FLAG
,      EXCL_TUIT_WAIV_FLAG
,      TRANS_TIN
,      FILER_TIN
,      TRANS_FOREIGN_ENTITY_FLAG
,      FILER_FOREIGN_ENTITY_FLAG
,      VENDOR_FOREIGN_ENTITY_FLAG
,      SERVICE_PARTY_SITE_ID
,      FILER_CONTACT_POINT_ID
,      SERV_CONTACT_POINT_ID
,      NAME_CONTROL_CODE
,      PERSON_ID_TYPE
,      SEC_PHONE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_1098T_SETUP;

Dependencies

[top of page]

IGS.IGS_FI_1098T_SETUP does not reference any database object

IGS.IGS_FI_1098T_SETUP is referenced by following:

APPS: IGS_FI_1098T_SETUP