[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AD_INSTHIST_INT |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_AD_INSTHIST_INT
|
| Subobject Name: | |
| Status: | VALID |
Contains the Admission Application Instance History details for each person to be imported into the IGS_AD_PS_APLINSTHST table by the Admission Import process, Admissions Legacy Data Import and the Transcripts Import processes.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Admission Application Instance History
Category: BUSINESS_ENTITY IGS_INSTITUTION
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_AD_INSTHIST_INT_PK | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INTERFACE_INSTHIST_ID
|
| IGS_AD_INSTHIST_INT_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INTERFACE_PS_APPL_INST_ID
|
| IGS_AD_INSTHIST_INT_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
STATUS
|
| IGS_AD_INSTHIST_INT_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INTERFACE_RUN_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_INSTHIST_ID | NUMBER | (15) | Yes | A unique identifier to identify each row in this table |
| INTERFACE_PS_APPL_INST_ID | NUMBER | (15) | Yes | Interface Application Instance ID |
| HIST_START_DT | DATE | Yes | The effective start date and time of the history record. It should not be greater than system date | |
| HIST_END_DT | DATE | Yes | The effective end date and time of the history record. It should not be greater than system date and It should not be less than HIST_START_DT | |
| ADM_DOC_STATUS | VARCHAR2 | (10) | Describes the documentation status of the admission program application instance | |
| ADM_ENTRY_QUAL_STATUS | VARCHAR2 | (10) | Describes the entry qualification status of the admission program application instance | |
| LATE_ADM_FEE_STATUS | VARCHAR2 | (10) | Describes the institution-defined fee status for a late program admission application instance | |
| ADM_OUTCOME_STATUS | VARCHAR2 | (10) | Describes the outcome status of the admission program application instance | |
| ADM_OTCM_STAT_AUTH_PER_NUMBER | NUMBER | (15) | Describes the person who authorized the outcome status Valid Staff member | |
| ADM_OUTCOME_STATUS_AUTH_DT | DATE | Describes the date that the outcome status was authorized. It should not be greater than system date | ||
| ADM_OUTCOME_STATUS_REASON | VARCHAR2 | (60) | Used to further describe a status, for example, an outcome status of Revoked may have associated reason for the revocation | |
| OFFER_DT | DATE | Describes the date that an offer of admission was made to the applicant. It should not be greater than system date | ||
| ADM_CNDTNL_OFFER_STATUS | VARCHAR2 | (10) | Describes the status assigned to an admission program application in relation to a conditional offer | |
| CNDTNL_OFFER_SATISFIED_DT | DATE | Describes the date that a conditional offer was satisfied or waived. It should not be greater than system date | ||
| CNDTNL_OFFER_MUST_BE_STSFD_IND | VARCHAR2 | (1) | Describes whether or not a conditional offer must be satisfied before the offer can be accepted. It should be having value Y or N | |
| ADM_OFFER_RESP_STATUS | VARCHAR2 | (10) | Describes the offer response status of the admission program application instance | |
| ACTUAL_RESPONSE_DT | DATE | Describes the actual date a response was made by an applicant to an offerIt should not be greater than system date | ||
| ADM_OFFER_DFRMNT_STATUS | VARCHAR2 | (10) | Describes the offer deferment status of the admission program application instance | |
| DEFERRED_TRACKING_ID | NUMBER | (9) | Describes the tracking ID of the deferral request that has been forwarded for assessment | |
| APPLICANT_ACPTNCE_CNDTN | VARCHAR2 | (2000) | Describes the conditions the applicant is requesting as part of their acceptance of an offer, for example, request for scholarship granted, advanced standing approved. | |
| CNDTNL_OFFER_CNDTN | VARCHAR2 | (2000) | Describes the conditions of a conditional offer. An assessor may use this field to list conditions the applicant must satisfy in order to satisfy the conditional offer. | |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | Describes the attendance type for the application | |
| ATTENDANCE_MODE | VARCHAR2 | (2) | Describes the attendance mode for the application | |
| LOCATION_CD | VARCHAR2 | (10) | Describes the Location code for the application | |
| UNIT_SET_CD | VARCHAR2 | (10) | Describes the Unit Set code for the application | |
| US_VERSION_NUMBER | NUMBER | (3) | Describes the Unit Set Code version number for the application | |
| PREFERENCE_NUMBER | NUMBER | (2) | Describes the Preference Number of the application | |
| OFFER_RESP_DATE | DATE | Describes the Offer Response Date of the ApplicantIt should not be greater than system date | ||
| PRPSD_COMMENCEMENT_DT | DATE | Describes the Proposed Commencement date for the courseIt should not be greater than system date | ||
| ASS_RANK | NUMBER | (3) | Assessment Rank.Value should be greater than 0. | |
| SECONDARY_ASS_RANK | NUMBER | (3) | Secondary Assessment Rank.Value should be greater than 0. | |
| INTRNTNL_ACCEPTANCE_ADVICE_NUM | NUMBER | (15) | International Acceptance Advice Number | |
| ASS_TRACKING_ID | NUMBER | (9) | Assessment Tracking Identifier | |
| FEE_CAT | VARCHAR2 | (10) | Describes the Fee category for the Application | |
| HECS_PAYMENT_OPTION | VARCHAR2 | (10) | Describes the HECS Payment Option for the Application | |
| EXPECTED_COMPLETION_YR | NUMBER | (4) | Describes the Expected Completion Year for the Course | |
| EXPECTED_COMPLETION_PERD | VARCHAR2 | (1) | Describes the Expected Completion Period for the course | |
| ENROLMENT_CAT | VARCHAR2 | (10) | Describes the Enrolment Category for the application | |
| FUNDING_SOURCE | VARCHAR2 | (10) | Describes the Funding Source for the application | |
| ERROR_CODE | VARCHAR2 | (30) | Error Code | |
| STATUS | VARCHAR2 | (1) | Yes | Status of the interface record |
| 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. | |
| NOMINATED_COURSE_CD | VARCHAR2 | (6) | Couse Code. This column will be populated by the import process. | |
| SEQUENCE_NUMBER | NUMBER | Sequence number. This column will be populated by the import process. | ||
| ERROR_TEXT | VARCHAR2 | (2000) | Error Text | |
| APPL_INST_STATUS | VARCHAR2 | (10) | Application Instance Status |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_INSTHIST_ID
, INTERFACE_PS_APPL_INST_ID
, HIST_START_DT
, HIST_END_DT
, ADM_DOC_STATUS
, ADM_ENTRY_QUAL_STATUS
, LATE_ADM_FEE_STATUS
, ADM_OUTCOME_STATUS
, ADM_OTCM_STAT_AUTH_PER_NUMBER
, ADM_OUTCOME_STATUS_AUTH_DT
, ADM_OUTCOME_STATUS_REASON
, OFFER_DT
, ADM_CNDTNL_OFFER_STATUS
, CNDTNL_OFFER_SATISFIED_DT
, CNDTNL_OFFER_MUST_BE_STSFD_IND
, ADM_OFFER_RESP_STATUS
, ACTUAL_RESPONSE_DT
, ADM_OFFER_DFRMNT_STATUS
, DEFERRED_TRACKING_ID
, APPLICANT_ACPTNCE_CNDTN
, CNDTNL_OFFER_CNDTN
, ATTENDANCE_TYPE
, ATTENDANCE_MODE
, LOCATION_CD
, UNIT_SET_CD
, US_VERSION_NUMBER
, PREFERENCE_NUMBER
, OFFER_RESP_DATE
, PRPSD_COMMENCEMENT_DT
, ASS_RANK
, SECONDARY_ASS_RANK
, INTRNTNL_ACCEPTANCE_ADVICE_NUM
, ASS_TRACKING_ID
, FEE_CAT
, HECS_PAYMENT_OPTION
, EXPECTED_COMPLETION_YR
, EXPECTED_COMPLETION_PERD
, ENROLMENT_CAT
, FUNDING_SOURCE
, ERROR_CODE
, STATUS
, 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
, NOMINATED_COURSE_CD
, SEQUENCE_NUMBER
, ERROR_TEXT
, APPL_INST_STATUS
FROM IGS.IGS_AD_INSTHIST_INT;
IGS.IGS_AD_INSTHIST_INT does not reference any database object
IGS.IGS_AD_INSTHIST_INT is referenced by following:
APPS
IGS_AD_INSTHIST_INT
|
|
|
|