[Home] [Help] [Dependency Information]
Object Name: | IGF_DB_DISB_HOLDS_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_DB_DISB_HOLDS_ALL |
Subobject Name: | |
Status: | VALID |
Stores the various holds put on a disbursement for a student.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_DB_DISB_HOLD_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | HOLD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HOLD_ID | NUMBER | (15) | Yes | Indicates a unique identifier for a Hold |
AWARD_ID | NUMBER | (15) | Yes | Indicates the unique identifier for a Student Award |
DISB_NUM | NUMBER | (15) | Yes | Indicates the Disbursement Number for an Award Disbursement |
HOLD | VARCHAR2 | (30) | Yes | Indicates the Hold Description |
HOLD_DATE | DATE | Yes | Indicates the Date on which the Hold was added. | |
HOLD_TYPE | VARCHAR2 | (30) | Yes | Indicates the Type of Hold whether Process or Manual. |
RELEASE_DATE | DATE | Indicates the Date on which the Hold was released. | ||
RELEASE_FLAG | VARCHAR2 | (30) | Indicates if the Hold is still valid or released | |
RELEASE_REASON | VARCHAR2 | (300) | Indicates the reason for releasing a Hold | |
ORG_ID | NUMBER | (15) | Indicates the Operating Unit 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 |
Cut, paste (and edit) the following text to query this object:
SELECT HOLD_ID
, AWARD_ID
, DISB_NUM
, HOLD
, HOLD_DATE
, HOLD_TYPE
, RELEASE_DATE
, RELEASE_FLAG
, RELEASE_REASON
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGF.IGF_DB_DISB_HOLDS_ALL;
IGF.IGF_DB_DISB_HOLDS_ALL does not reference any database object
IGF.IGF_DB_DISB_HOLDS_ALL is referenced by following:
|
|
|