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_PERSON_HOLDS

Object Details

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

This table acts as an intermediate table that will be used by the release hold process to find out the holds placed on a person by student finance. The Apply Hold Process populates data into this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_PERSON_HOLDS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID HOLD_TYPE HOLD_START_DT

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	The person identifier on whom the hold is placed.
HOLD_PLAN_NAME	VARCHAR2	(30)	Yes	The name of the Hold plan under which the particular hold type was created for the person.
HOLD_TYPE	VARCHAR2	(10)	Yes	The Hold type associated with the person.
HOLD_START_DT	DATE		Yes	The date on which the Hold type is effective for the person.
PROCESS_START_DT	DATE		Yes	The date on which the holds apply process was run (Functionally the batch cut off date)
PROCESS_END_DT	DATE		Yes	The end date specified for the holds apply process (Functionally the payment due date)
OFFSET_DAYS	NUMBER	(3)		The Offset Days (grace period) for which the Holds apply process was run.
BALANCE_AMOUNT	NUMBER			No longer used
PAST_DUE_AMOUNT	NUMBER		Yes	The amount due by the person as on the balance due date. (Along with the offset days)
FEE_CAL_TYPE	VARCHAR2	(10)		The fee calendar for which the process of application of hold was run when the process was run for a fee type level hold plan. Will Not have any value if the Hold plan is sub account / student level.
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)		The fee calendar instance for which the process of application of hold was run when the process was run for a fee type level hold plan. Will Not have any value if the Hold plan is sub account / student level.
FEE_TYPE_INVOICE_AMOUNT	NUMBER			This stores the total charges incurred by the person as on the process_start_date when the hold application process was run.
REQUEST_ID	NUMBER	(15)		Standard Concurrent Process Column
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Process Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Process Column
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Process Column
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
RELEASE_CREDIT_ID	NUMBER	(15)		Release Credit Identifier
STUDENT_PLAN_ID	NUMBER			Student Plan Identifier
LAST_INSTLMNT_DUE_DATE	DATE			Last Installment Due Date

Query Text

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


SELECT PERSON_ID
,      HOLD_PLAN_NAME
,      HOLD_TYPE
,      HOLD_START_DT
,      PROCESS_START_DT
,      PROCESS_END_DT
,      OFFSET_DAYS
,      BALANCE_AMOUNT
,      PAST_DUE_AMOUNT
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      FEE_TYPE_INVOICE_AMOUNT
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RELEASE_CREDIT_ID
,      STUDENT_PLAN_ID
,      LAST_INSTLMNT_DUE_DATE
FROM IGS.IGS_FI_PERSON_HOLDS;

Dependencies

[top of page]

IGS.IGS_FI_PERSON_HOLDS does not reference any database object

IGS.IGS_FI_PERSON_HOLDS is referenced by following:

APPS: IGS_FI_PERSON_HOLDS