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

TABLE: IGS.IGS_FI_1098T_DATA

Object Details
Object Name: IGS_FI_1098T_DATA
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_FI_1098T_DATA
Subobject Name:
Status: VALID


Stores 1098-T tuition statement details, used for reporting to the Internal Revenue Service


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_1098T_DATA_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTU_1098T_ID
Columns
Name Datatype Length Mandatory Comments
STU_1098T_ID NUMBER
Yes Sequence generated identifier for a Student 1098-T record.
OBJECT_VERSION_NUMBER NUMBER
Yes This column is used for locking rows in the database.
TAX_YEAR_NAME VARCHAR2 (30) Yes Name of the Tax Year, as defined by the user.
PARTY_ID NUMBER (15) Yes Student identifier for 1098-T reporting
EXTRACT_DATE DATE
Yes The date when the 1098-T Data is extracted from the student account tables and the 1098-T transaction is created.
PARTY_NAME VARCHAR2 (360) Yes Student's Name (Stored here along with Party ID since the Party Name is updateable from SWS)
TAXID VARCHAR2 (20)
Student's Social Security Number or Tax Identification Number. (Originally,API_PERSON_ID from the IGS_PE_ALT_PERS_ID Table)
STU_NAME_CONTROL VARCHAR2 (20)
Student's Name Control (Originally, API_PERSON_ID from the IGS_PE_ALT_PERS_ID Table)
BILLED_AMT NUMBER
Yes Box 2 amount. Amounts billed for qualified tuition and related expenses.
ADJ_AMT NUMBER
Yes Box 3 amount. Adjustments made for Payment received or Amounts Billed for a prior year.
FIN_AID_AMT NUMBER
Yes Box 4 amount. Scholarships or grants. This also includes Tuition waivers.
FIN_AID_ADJ_AMT NUMBER
Yes Box 5 amount. Adjustments to scholarships or grants for a prior year.
NEXT_ACAD_FLAG VARCHAR2 (1) Yes Box 6 checkbox. Flag which indicates if the Payment received amount or the Amount billed includes amounts for an academic period beginning in the first three months of the next academic year.
HALF_TIME_FLAG VARCHAR2 (1) Yes Box 8 checkbox. Flag which indicates that the student was at least a half-time student during any academic period that began in the tax year
GRAD_FLAG VARCHAR2 (1) Yes Box 9 checkbox. Flag that indicates that the student was a graduate student.
STATUS_CODE VARCHAR2 (30) Yes Code to indicate the validation status of the student's 1098-T data record.
IRS_FILED_FLAG VARCHAR2 (1) Yes Flag to indicate that the 1098-T tuition statement is filed with the Internal Revenue Service
CORRECTION_FLAG VARCHAR2 (1) Yes Flag to indicate that the 1098-T data has been corrected, following filing with the Internal Revenue Service
STMNT_PRINT_FLAG VARCHAR2 (1) Yes Flag to indicate that the student copy of the 1098-T tuition statement has been printed
OVERRIDE_FLAG VARCHAR2 (1) Yes Flag to indicate that the 1098-T data has been overridden manually
PAYMENT_AMT NUMBER
Yes Not currently used. Box 1 amount. The Payments received for qualified tuition and related expenses.
REFUND_AMT NUMBER
Yes Not currently used. Box 7 amount.
BATCH_ID NUMBER

To store the Batch ID which generated the electronic file for the IRS.
CORRECTION_TYPE_CODE VARCHAR2 (1)
Code that indicates which category of error, a correction 1098-T record falls in. Valid values are 1 and 2.
ERROR_CODE VARCHAR2 (30)
Code to indicate the type of Validation failure encountered while extracting the 1098-T data for the student.
ADDRESS1 VARCHAR2 (240)
First line for address
ADDRESS2 VARCHAR2 (240)
Second line for address
ADDRESS3 VARCHAR2 (240)
Third line for address
ADDRESS4 VARCHAR2 (240)
Fourth line for address
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (60)
Country code from the TERRITORY_CODE column in the FND_TERRITORY table
CITY VARCHAR2 (60)
City
POSTAL_CODE VARCHAR2 (60)
Postal code
STATE VARCHAR2 (60)
State
DELIVERY_POINT_CODE VARCHAR2 (50)
Delivery Point Code
SPECIAL_DATA_ENTRY VARCHAR2 (60)
Used to record information for state or local government reporting or for the filer's own purposes. Payers should contact the state or local revenue departments for the filing requirements.
FILE_NAME VARCHAR2 (30)
Name of the 1098-T Tuition Statement file created for the student.
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
REQUEST_ID NUMBER (15)
Standard Concurrent Program Column
PROGRAM_ID NUMBER (15)
Standard Concurrent Program Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Concurrent Program Column
PROGRAM_UPDATE_DATE DATE

Standard Concurrent Program Column
Query Text

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


SELECT STU_1098T_ID
,      OBJECT_VERSION_NUMBER
,      TAX_YEAR_NAME
,      PARTY_ID
,      EXTRACT_DATE
,      PARTY_NAME
,      TAXID
,      STU_NAME_CONTROL
,      BILLED_AMT
,      ADJ_AMT
,      FIN_AID_AMT
,      FIN_AID_ADJ_AMT
,      NEXT_ACAD_FLAG
,      HALF_TIME_FLAG
,      GRAD_FLAG
,      STATUS_CODE
,      IRS_FILED_FLAG
,      CORRECTION_FLAG
,      STMNT_PRINT_FLAG
,      OVERRIDE_FLAG
,      PAYMENT_AMT
,      REFUND_AMT
,      BATCH_ID
,      CORRECTION_TYPE_CODE
,      ERROR_CODE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      PROVINCE
,      COUNTY
,      COUNTRY
,      CITY
,      POSTAL_CODE
,      STATE
,      DELIVERY_POINT_CODE
,      SPECIAL_DATA_ENTRY
,      FILE_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_FI_1098T_DATA;

Dependencies

[top of page]

IGS.IGS_FI_1098T_DATA does not reference any database object

IGS.IGS_FI_1098T_DATA is referenced by following:

SchemaAPPS
SynonymIGS_FI_1098T_DATA