[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_SPI_RCOND_INTS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_EN_SPI_RCOND_INTS |
Subobject Name: | |
Status: | VALID |
Interface table for Student Intermission Return conditions
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_EN_SPI_RCOND_INTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | LGCY_EN_SPI_RCONS_INT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LGCY_EN_SPI_RCONS_INT_ID | NUMBER | Yes | Student Intermission Return Condition interface record identifier | |
BATCH_ID | NUMBER | Yes | Batch Identifier | |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
PROGRAM_CD | VARCHAR2 | (6) | Yes | Program Code |
START_DT | DATE | Yes | Start date of Intermission | |
RETURN_CONDITION | VARCHAR2 | (25) | Yes | Return condition |
STATUS_CODE | VARCHAR2 | (30) | Return condition Status Code | |
APPROVED_DT | DATE | Approved date | ||
APPROVER_NUMBER | VARCHAR2 | (30) | Approver number | |
IMPORT_STATUS | VARCHAR2 | (1) | Import status | |
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
REQUEST_ID | NUMBER | (15) | Standard Request parameters | |
PROGRAM_ID | NUMBER | (15) | Standard Request parameters | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Request parameters | |
PROGRAM_UPDATE_DATE | DATE | Standard Request parameters |
Cut, paste (and edit) the following text to query this object:
SELECT LGCY_EN_SPI_RCONS_INT_ID
, BATCH_ID
, PERSON_NUMBER
, PROGRAM_CD
, START_DT
, RETURN_CONDITION
, STATUS_CODE
, APPROVED_DT
, APPROVER_NUMBER
, IMPORT_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM IGS.IGS_EN_SPI_RCOND_INTS;
IGS.IGS_EN_SPI_RCOND_INTS does not reference any database object
IGS.IGS_EN_SPI_RCOND_INTS is referenced by following:
|
|
|