[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_APPHIST_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_APPHIST_INT |
Subobject Name: | |
Status: | VALID |
Contains the Admission Application History details to be imported into the IGS_AD_APPL_HIST table by the Admissions Legacy Data Import process
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Admission Application History
Category: BUSINESS_ENTITY IGS_ADM_APPLICATION
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_APPHIST_INT_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_APPHIST_ID |
IGS_AD_APPHIST_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_APPL_ID |
IGS_AD_APPHIST_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_AD_APPHIST_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_APPHIST_ID | NUMBER | (15) | Yes | Unique identifier to identify each row of this table |
INTERFACE_APPL_ID | NUMBER | (15) | Yes | Interface Application ID |
HIST_START_DT | DATE | Yes | The effective start date and time of the interface record. Should not be greater than system date | |
HIST_END_DT | DATE | Yes | The effective end date and time of the interface record. Should not be greater than system date | |
ADM_APPL_STATUS | VARCHAR2 | (10) | Yes | Describes the institution-defined application status of the admission application. |
ADM_FEE_STATUS | VARCHAR2 | (10) | Yes | Describes the institution-defined fee status of the admission application. |
APPL_DT | DATE | Yes | Application Date | |
TAC_APPL_IND | VARCHAR2 | (1) | Yes | TAC Application indicator. Should have the value 'Y' or 'N' |
STATUS | VARCHAR2 | (1) | Yes | Status of the record |
ERROR_CODE | VARCHAR2 | (30) | Error Code | |
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 who column for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent programs | ||
INTERFACE_RUN_ID | NUMBER | Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user | ||
PERSON_ID | NUMBER | (15) | Person Identifier. This column will be populated by the import process. | |
ADMISSION_APPL_NUMBER | NUMBER | (15) | Application Number. This column will be populated by the import process. | |
ERROR_TEXT | VARCHAR2 | (2000) | Error Text |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_APPHIST_ID
, INTERFACE_APPL_ID
, HIST_START_DT
, HIST_END_DT
, ADM_APPL_STATUS
, ADM_FEE_STATUS
, APPL_DT
, TAC_APPL_IND
, STATUS
, ERROR_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, INTERFACE_RUN_ID
, PERSON_ID
, ADMISSION_APPL_NUMBER
, ERROR_TEXT
FROM IGS.IGS_AD_APPHIST_INT;
IGS.IGS_AD_APPHIST_INT does not reference any database object
IGS.IGS_AD_APPHIST_INT is referenced by following:
|
|
|