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_AD_PS_APPL_INST_INT

Object Details

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

Contains Application Instance details for each person to be imported into the IGS_AD_PS_APPL and IGS_AD_PS_APPL_INST_ALL tables by the Admission Import process.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Admission Application Detail
Category: BUSINESS_ENTITY IGS_ADM_APPLICATION

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_PS_APPL_INST_INT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTERFACE_PS_APPL_INST_ID
IGS_AD_PS_APPL_INST_INT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_APPL_ID
IGS_AD_PS_APPL_INST_INT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS
IGS_AD_PS_APPL_INST_INT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_RUN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_APPL_ID	NUMBER	(15)	Yes	Interface Application
INTERFACE_PS_APPL_INST_ID	NUMBER	(15)	Yes	Interface Admission Program Application Instance Identifier
NOMINATED_COURSE_CD	VARCHAR2	(6)	Yes	Nominated program Code
TRANSFER_COURSE_CD	VARCHAR2	(6)		Transfer Program Code
BASIS_FOR_ADMISSION_TYPE	VARCHAR2	(10)		This is the institution-defined basis for admission type of the admission program application.
ADMISSION_CD	VARCHAR2	(10)		This is the institution-defined admission code of the admission program application.
COURSE_RANK_SET	VARCHAR2	(30)		This field describes the ranking of an applicant.
COURSE_RANK_SCHEDULE	VARCHAR2	(10)		Tertiary admissions center schedule that the program rank set was based upon.
REQ_FOR_ADV_STANDING_IND	VARCHAR2	(1)	Yes	Indicates a request for advanced standing has been made by the
APP_SOURCE_ID	NUMBER	(15)		Application Source Identifier
CRV_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the program version number for the program admission application
LOCATION_CD	VARCHAR2	(10)		Describes the location code of the program admission application
ATTENDANCE_MODE	VARCHAR2	(2)		Describes the attendance mode of the program admission application
ATTENDANCE_TYPE	VARCHAR2	(240)		This is the attendance type of the program admission
EDU_GOAL_PRIOR_ENROLL_ID	NUMBER	(15)		Education goal prior to enrollment
APPLY_FOR_FINAID	VARCHAR2	(1)		Apply for financial Aid
ASS_RANK	NUMBER	(3)		Rank of applicant if offers are determined by comparing all applicants and choosing the highest ranked to satisfy program quotas.
SECONDARY_ASS_RANK	NUMBER	(3)		Secondary ranking of an applicant if the desire is to force an offer, or restrict an offer when determining program offers by comparing all applicants.
INTRNTNL_ACCEPTANCE_ADVICE_NUM	NUMBER	(15)		The number of the Acceptance Advice form issued to the applicant with their letter of offer. The Acceptance advice form must be presented by the applicant when seeking a student visa.
UPDATE_ADM_APPL_NUMBER	NUMBER	(15)		Update Admission Application Number
ASS_TRACKING_ID	NUMBER	(9)		Describes the tracking ID of an application that has been forwarded for assessment
FEE_CAT	VARCHAR2	(10)		The fee category applicable to the program admission. Fee categories are used to define the set of fees and charges applicable to a student studying a particular program.
HECS_PAYMENT_OPTION	VARCHAR2	(10)		Describes the HECS payment option associated with an offer. This will enable enrollment fee invoices to be produced.
EXPECTED_COMPLETION_PERD	VARCHAR2	(10)		The period, or part of the year, at which time the assessor considers the applicant will have completed all program requirements.
EXPECTED_COMPLETION_YR	NUMBER	(4)		The year in which the assessor considers the applicant will have completed all program requirements.
ENROLMENT_CAT	VARCHAR2	(10)		Unique institution-defined code used to describe an Enrollment Category. Enrollment categories are used to define the processes and procedures involved in the enrollment of particular groups of students.
FUNDING_SOURCE	VARCHAR2	(10)		A unique identifier for the institution-defined funding source. This must be mapped to a Government funding source.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex field qualifier
ATTRIBUTE1	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE2	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE3	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE4	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE5	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE6	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE7	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE8	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE9	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE10	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE11	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE12	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE13	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE14	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE15	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE16	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE17	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE18	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE19	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE20	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE21	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE22	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE23	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE24	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE25	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE26	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE27	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE28	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE29	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE30	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE31	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE32	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE33	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE34	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE35	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE36	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE37	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE38	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE39	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE40	VARCHAR2	(150)		Standard attribute column. Meant for Descriptive Flex field.
ENTRY_LEVEL	NUMBER			The entry level of an applicant into a program.
ENTRY_STATUS	NUMBER			The entry status of an applicant into a program.
FINAID_APPLY_DATE	DATE			Date that financial aid application was submitted
PREFERENCE_NUMBER	NUMBER	(2)		Describes the applicant preference number of the program applied for
SCH_APL_TO_ID	NUMBER			School to which a student is applying to, in an institution.
UNIT_SET_CD	VARCHAR2	(240)		Describes the unit set code of the program admission application
US_VERSION_NUMBER	NUMBER	(3)		Describes the version number of the nominated unit set code of the program admission application
ERROR_CODE	VARCHAR2	(30)		Error Code for the Record
ERROR_TEXT	VARCHAR2	(2000)		Error Text for the Record
MATCH_IND	VARCHAR2	(2)		Match Indicator for the Interface Record
STATUS	VARCHAR2	(2)	Yes	Status of the record whether it is imported, pending, error or warning
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)		Concurrent Program WHO columns
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program WHO columns
PROGRAM_ID	NUMBER	(15)		Concurrent Program WHO columns
PROGRAM_UPDATE_DATE	DATE			Concurrent Program WHO columns
SEQUENCE_NUMBER	NUMBER	(6)		Sequence Number for the application instance
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
UPDATE_ADM_SEQ_NUMBER	NUMBER	(6)		The valid values for this column are the sequence_number queried from IGS_AD_PS_APPL_INST for the given course_cd , person_id , admission_appl_number.Import process will update the application instance with sequence_number as this column value for the given person, application ,course derived from the parent interface tables
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.
ADMISSION_APPLICATION_TYPE	VARCHAR2	(30)		Admission application type.This column will be populated by the import process.

Query Text

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


SELECT INTERFACE_APPL_ID
,      INTERFACE_PS_APPL_INST_ID
,      NOMINATED_COURSE_CD
,      TRANSFER_COURSE_CD
,      BASIS_FOR_ADMISSION_TYPE
,      ADMISSION_CD
,      COURSE_RANK_SET
,      COURSE_RANK_SCHEDULE
,      REQ_FOR_ADV_STANDING_IND
,      APP_SOURCE_ID
,      CRV_VERSION_NUMBER
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      EDU_GOAL_PRIOR_ENROLL_ID
,      APPLY_FOR_FINAID
,      ASS_RANK
,      SECONDARY_ASS_RANK
,      INTRNTNL_ACCEPTANCE_ADVICE_NUM
,      UPDATE_ADM_APPL_NUMBER
,      ASS_TRACKING_ID
,      FEE_CAT
,      HECS_PAYMENT_OPTION
,      EXPECTED_COMPLETION_PERD
,      EXPECTED_COMPLETION_YR
,      ENROLMENT_CAT
,      FUNDING_SOURCE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE31
,      ATTRIBUTE32
,      ATTRIBUTE33
,      ATTRIBUTE34
,      ATTRIBUTE35
,      ATTRIBUTE36
,      ATTRIBUTE37
,      ATTRIBUTE38
,      ATTRIBUTE39
,      ATTRIBUTE40
,      ENTRY_LEVEL
,      ENTRY_STATUS
,      FINAID_APPLY_DATE
,      PREFERENCE_NUMBER
,      SCH_APL_TO_ID
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      ERROR_CODE
,      ERROR_TEXT
,      MATCH_IND
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SEQUENCE_NUMBER
,      INTERFACE_RUN_ID
,      UPDATE_ADM_SEQ_NUMBER
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      ADMISSION_APPLICATION_TYPE
FROM IGS.IGS_AD_PS_APPL_INST_INT;

Dependencies

[top of page]

IGS.IGS_AD_PS_APPL_INST_INT does not reference any database object

IGS.IGS_AD_PS_APPL_INST_INT is referenced by following:

APPS: IGS_AD_PS_APPL_INST_INT