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_BILL_PLN_CRD

Object Details

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

Stores the planned credit records for the particular bill extract.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_BILL_PLN_CRD_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BILL_ID AWARD_ID DISB_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
BILL_ID	NUMBER		Yes	The bill Id for which the planned credit record was created.
AWARD_ID	NUMBER	(15)	Yes	The award Id of the award record whose planned disbursement that was considered for the bill.
DISB_NUM	NUMBER	(15)	Yes	The disbursement number of the planned disbursement record that was considered for the bill.
PLN_CREDIT_DATE	DATE		Yes	The date of the planned credit record.
FUND_ID	NUMBER	(15)	Yes	The fund Id for which the planned disbursement was created in financial aid.
FEE_CAL_TYPE	VARCHAR2	(10)		The Fee Calendar for which the planned credit was created.
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)		The Fee Calendar Instance
PLN_CREDIT_AMOUNT	NUMBER		Yes	The planned credit amount.
CREATED_BY	NUMBER	(15)	Yes	Standard who column.
BILL_DESC	VARCHAR2	(240)		Bill Description.
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 process column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard concurrent process column.
PROGRAM_ID	NUMBER	(15)		Standard concurrent process column.
PROGRAM_UPDATE_DATE	DATE			Standard concurrent process column.

Query Text

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


SELECT BILL_ID
,      AWARD_ID
,      DISB_NUM
,      PLN_CREDIT_DATE
,      FUND_ID
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      PLN_CREDIT_AMOUNT
,      CREATED_BY
,      BILL_DESC
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_FI_BILL_PLN_CRD;

Dependencies

[top of page]

IGS.IGS_FI_BILL_PLN_CRD does not reference any database object

IGS.IGS_FI_BILL_PLN_CRD is referenced by following:

APPS: IGS_FI_BILL_PLN_CRD