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

TABLE: IGS.IGS_FI_1098T_LPS

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


Stores Load Periods for 1098-T reporting requirements


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_1098T_LPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_YEAR_NAME
ColumnCAL_TYPE
ColumnSEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
TAX_YEAR_NAME VARCHAR2 (30) Yes Name of the Tax Year, as defined by the user.
CAL_TYPE VARCHAR2 (10) Yes Load Calendar Type identified for 1098-T Reporting purposes
SEQUENCE_NUMBER NUMBER (6) Yes Sequence Number of the Load Calendar Type
OBJECT_VERSION_NUMBER NUMBER
Yes This column is used for locking rows in the database.
NEXT_ACAD_FLAG VARCHAR2 (1) Yes Box 6 checkbox
HALF_TIME_FLAG VARCHAR2 (1) Yes Box 8 checkbox
GRAD_FLAG VARCHAR2 (1) Yes Box 9 checkbox
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
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      OBJECT_VERSION_NUMBER
,      NEXT_ACAD_FLAG
,      HALF_TIME_FLAG
,      GRAD_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_1098T_LPS;

Dependencies

[top of page]

IGS.IGS_FI_1098T_LPS does not reference any database object

IGS.IGS_FI_1098T_LPS is referenced by following:

SchemaAPPS
SynonymIGS_FI_1098T_LPS