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_FTCI_ACCTS

Object Details

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

For a Fee Type Calendar Instance, Revenue Account Code or the Natural Account Segment for the combination of attributes will be stored in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_FTCI_ACCTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCT_ID
IGS_FI_FTCI_ACCTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FEE_TYPE FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER ORDER_SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
ACCT_ID	NUMBER	(15)	Yes	Sequence Generated Identifier.
FEE_TYPE	VARCHAR2	(10)	Yes	The Fee Type for which the accounting information is setup.
FEE_CAL_TYPE	VARCHAR2	(10)	Yes	The Fee Calendar Type for which the accounting information is setup.
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The Fee Type Calendar Instance for which the accounting information is setup.
ORDER_SEQUENCE	NUMBER	(15)	Yes	Sequence Order for determining the Revenue Accounting information.
NATURAL_ACCOUNT_SEGMENT	VARCHAR2	(25)		Natural Accounting Segment for the combination of attributes specified when Oracle General Ledger is installed.
REV_ACCOUNT_CD	VARCHAR2	(40)		Revenue Account Code for the combination of attributes when an external accounting system is installed.
LOCATION_CD	VARCHAR2	(10)		The institution-defined code of a physical location owned or used by the institution.
ATTENDANCE_TYPE	VARCHAR2	(2)		Code of an institution-defined attendance type.
ATTENDANCE_MODE	VARCHAR2	(2)		Code of an institution-defined attendance mode.
COURSE_CD	VARCHAR2	(6)		Code of the program offered by an institution.
CRS_VERSION_NUMBER	NUMBER	(3)		Version number associated to a program.
UNIT_CD	VARCHAR2	(10)		Code of the unit offered by an institution.
UNIT_VERSION_NUMBER	NUMBER	(3)		Version number associated to an unit.
ORG_UNIT_CD	VARCHAR2	(30)		Organization Unit.
RESIDENCY_STATUS_CD	VARCHAR2	(30)		Student Residency Status Code.
UOO_ID	NUMBER	(7)		Unit Section Offering option identifier.
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.
REQUEST_ID	NUMBER	(15)		Standard Concurrent Program Who Column.
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Program Who Column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Program Who Column.
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Program Who Column.
UNIT_LEVEL	VARCHAR2	(10)		Unit Level
UNIT_TYPE_ID	NUMBER			Unit Program Type Level Identifier
UNIT_CLASS	VARCHAR2	(10)		Institution-defined code that identifies a unit class.
UNIT_MODE	VARCHAR2	(10)		Institution-defined mode of offering a unit.

Query Text

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


SELECT ACCT_ID
,      FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      ORDER_SEQUENCE
,      NATURAL_ACCOUNT_SEGMENT
,      REV_ACCOUNT_CD
,      LOCATION_CD
,      ATTENDANCE_TYPE
,      ATTENDANCE_MODE
,      COURSE_CD
,      CRS_VERSION_NUMBER
,      UNIT_CD
,      UNIT_VERSION_NUMBER
,      ORG_UNIT_CD
,      RESIDENCY_STATUS_CD
,      UOO_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      UNIT_LEVEL
,      UNIT_TYPE_ID
,      UNIT_CLASS
,      UNIT_MODE
FROM IGS.IGS_FI_FTCI_ACCTS;

Dependencies

[top of page]

IGS.IGS_FI_FTCI_ACCTS does not reference any database object

IGS.IGS_FI_FTCI_ACCTS is referenced by following:

APPS: IGS_FI_FTCI_ACCTS