[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AD_PS_APPL_INST_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_AD_PS_APPL_INST_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGS_AD_PS_APPL_INST_ALL holds the request for program entry for an admission period.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_AD_PS_APPL_INST_ALL_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PERSON_ID
ADMISSION_APPL_NUMBER
NOMINATED_COURSE_CD
SEQUENCE_NUMBER
|
| IGS_AD_PS_APPL_INST_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ATTENDANCE_MODE
|
| IGS_AD_PS_APPL_INST_ALL_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOCATION_CD
|
| IGS_AD_PS_APPL_INST_ALL_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEFERRED_TRACKING_ID
|
| IGS_AD_PS_APPL_INST_ALL_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FEE_CAT
|
| IGS_AD_PS_APPL_INST_ALL_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CORRESPONDENCE_CAT
|
| IGS_AD_PS_APPL_INST_ALL_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LATE_ADM_FEE_STATUS
|
| IGS_AD_PS_APPL_INST_ALL_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADM_CAL_TYPE
ADM_CI_SEQUENCE_NUMBER
|
| IGS_AD_PS_APPL_INST_ALL_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
HECS_PAYMENT_OPTION
|
| IGS_AD_PS_APPL_INST_ALL_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEFERRED_ADM_CAL_TYPE
DEFERRED_ADM_CI_SEQUENCE_NUM
|
| IGS_AD_PS_APPL_INST_ALL_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COURSE_CD
CRV_VERSION_NUMBER
|
| IGS_AD_PS_APPL_INST_ALL_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ENROLMENT_CAT
|
| IGS_AD_PS_APPL_INST_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADM_ENTRY_QUAL_STATUS
|
| IGS_AD_PS_APPL_INST_ALL_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UNIT_SET_CD
US_VERSION_NUMBER
|
| IGS_AD_PS_APPL_INST_ALL_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADM_OUTCOME_STATUS
ADM_OFFER_RESP_STATUS
|
| IGS_AD_PS_APPL_INST_ALL_N22 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FUNDING_SOURCE
|
| IGS_AD_PS_APPL_INST_ALL_N23 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FUTURE_ACAD_CAL_TYPE
FUTURE_ACAD_CI_SEQUENCE_NUMBER
|
| IGS_AD_PS_APPL_INST_ALL_N24 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FUTURE_ADM_CAL_TYPE
FUTURE_ADM_CI_SEQUENCE_NUMBER
|
| IGS_AD_PS_APPL_INST_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADM_CNDTNL_OFFER_STATUS
|
| IGS_AD_PS_APPL_INST_ALL_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ATTENDANCE_TYPE
|
| IGS_AD_PS_APPL_INST_ALL_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADM_DOC_STATUS
|
| IGS_AD_PS_APPL_INST_ALL_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADM_OFFER_RESP_STATUS
|
| IGS_AD_PS_APPL_INST_ALL_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADM_OFFER_DFRMNT_STATUS
|
| IGS_AD_PS_APPL_INST_ALL_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASS_TRACKING_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| PERSON_ID | NUMBER | (15) | Yes | Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| ADMISSION_APPL_NUMBER | NUMBER | (2) | Yes | Identifies uniquely an admission application for a person |
| NOMINATED_COURSE_CD | VARCHAR2 | (6) | Yes | Describes the program code of the program offering instance to that the person is applying for admission |
| SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the unique identifier of an admission program application instance. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code. |
| PREDICTED_GPA | NUMBER | (5) | Predicted grade point average for the applicant | |
| ACADEMIC_INDEX | VARCHAR2 | (10) | Academic index | |
| ADM_CAL_TYPE | VARCHAR2 | (10) | Describes the calendar type of the admission period | |
| APP_FILE_LOCATION | VARCHAR2 | (40) | Application file location | |
| ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Describes the calendar sequence number of the admission period | |
| APP_SOURCE_ID | NUMBER | (15) | Source of application | |
| COURSE_CD | VARCHAR2 | (6) | Yes | Describes the program code for the program admission application |
| CRV_VERSION_NUMBER | NUMBER | (3) | Yes | Describes the program version number for the program admission application |
| ATHLETIC_GPA | NUMBER | (5) | Made obsolete in Enhancement bug 2101696 | |
| ATHLETIC_ELIGIBILITY_STATUS_ID | NUMBER | (15) | Made obsolete in Enhancement bug 2101696 | |
| WAITLIST_RANK | VARCHAR2 | (30) | Wait list rank | |
| LOCATION_CD | VARCHAR2 | (10) | Describes the location code of the program admission application | |
| ATTENT_OTHER_INST_CD | VARCHAR2 | (10) | Intend to attend other institution code | |
| ATTENDANCE_MODE | VARCHAR2 | (2) | Describes the attendance mode of the program admission application | |
| EDU_GOAL_PRIOR_ENROLL_ID | NUMBER | (15) | Education goal prior to enrollment | |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | Describes the attendance type of the program admission application | |
| DECISION_MAKE_ID | NUMBER | (15) | Decision maker person identifier | |
| UNIT_SET_CD | VARCHAR2 | (10) | Describes the unit set code of the program admission application | |
| DECISION_DATE | DATE | Date when the decision is made | ||
| 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. | |
| DECISION_REASON_ID | NUMBER | (15) | Decision reason | |
| US_VERSION_NUMBER | NUMBER | (3) | Describes the version number of the nominated unit set code of the program admission application | |
| DECISION_NOTES | VARCHAR2 | (2000) | Decision notes | |
| PENDING_REASON_ID | NUMBER | (15) | Pending reason | |
| PREFERENCE_NUMBER | NUMBER | (2) | This field describes the applicant preference number of the course | |
| ADM_DOC_STATUS | VARCHAR2 | (10) | Yes | Describes the documentation status of the admission program application instance |
| ADM_ENTRY_QUAL_STATUS | VARCHAR2 | (10) | Yes | Describes the entry qualification status of the admission program application instance |
| DEFICIENCY_IN_PREP | VARCHAR2 | (240) | Deficiencies in preparation | |
| LATE_ADM_FEE_STATUS | VARCHAR2 | (10) | Yes | Describes the institution-defined fee status for a late program admission application instance |
| SPL_CONSIDER_COMMENTS | VARCHAR2 | (240) | Special consideration comments | |
| APPLY_FOR_FINAID | VARCHAR2 | (1) | Indicates if the person has applied for financial aid | |
| FINAID_APPLY_DATE | DATE | Date that financial aid application was submitted | ||
| ADM_OUTCOME_STATUS | VARCHAR2 | (10) | Yes | Describes the outcome status of the admission program application instance |
| ADM_OTCM_STATUS_AUTH_PERSON_ID | NUMBER | (15) | Describes the ID of the person who authorized the change to the admission outcome status | |
| ADM_OUTCOME_STATUS_AUTH_DT | DATE | Describes the date that the change to the outcome status was authorized | ||
| ADM_OUTCOME_STATUS_REASON | VARCHAR2 | (60) | A reason used to further describe a status, for example, an outcome status of 'Revoked' may have an associated reason for the revocation. | |
| OFFER_DT | DATE | Describes the date that an offer of admission was made to the applicant | ||
| OFFER_RESPONSE_DT | DATE | Indicates the date by that an applicant must respond to the offer of admission. After this date, the offer would be expired by the process that changes the offer response status to Lapsed. | ||
| PRPSD_COMMENCEMENT_DT | DATE | Describes the proposed commencement date for an admission program application instance | ||
| ADM_CNDTNL_OFFER_STATUS | VARCHAR2 | (10) | Yes | 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 | ||
| CNDTNL_OFFER_MUST_BE_STSFD_IND | VARCHAR2 | (1) | Yes | Describes whether or not a conditional offer must be satisfied before the offer can be accepted. |
| ADM_OFFER_RESP_STATUS | VARCHAR2 | (10) | Yes | 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 offer | ||
| ADM_OFFER_DFRMNT_STATUS | VARCHAR2 | (10) | Yes | Describes the offer deferment status of the admission program application instance |
| DEFERRED_ADM_CAL_TYPE | VARCHAR2 | (10) | Describes the admission calendar type of the admission period to which the offer has been deferred | |
| DEFERRED_ADM_CI_SEQUENCE_NUM | NUMBER | (6) | Describes the admission calendar sequence number of the admission period to which the offer has been deferred | |
| DEFERRED_TRACKING_ID | NUMBER | (9) | Describes the tracking ID of a deferral request that has been forwarded for assessment | |
| 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. | |
| 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 course admission. Fee categories are used to define the set of fees and charges applicable to a student studying a particular course. | |
| 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_YR | NUMBER | (4) | The year in which the assessor considers the applicant will have completed all course requirements. | |
| EXPECTED_COMPLETION_PERD | VARCHAR2 | (1) | The period, or part of the year, at which time the assessor considers the applicant will have completed all course requirements. The allowable values are Summer, Mid-year or End of Year. | |
| CORRESPONDENCE_CAT | VARCHAR2 | (10) | The Correspondence Category applicable to the student's course admission. Correspondence categories are used to define the set of system generated and non-system originated correspondence items which will be sent to the student. | |
| ENROLMENT_CAT | VARCHAR2 | (10) | A unique institution-defined code used to describe an Enrolment Category. Enrolment categories are used to define the processes and procedures involved in the enrolment of particular groups of students. | |
| FUNDING_SOURCE | VARCHAR2 | (10) | A unique identifier for the institution-defined funding source. | |
| APPLICANT_ACPTNCE_CNDTN | VARCHAR2 | (2000) | Describes comments regarding the applicant's response to the offer. | |
| 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. | |
| SS_APPLICATION_ID | NUMBER | (15) | Self Service Application ID | |
| SS_PWD | VARCHAR2 | (30) | Self service Application Password | |
| ENTRY_STATUS | NUMBER | The entry status of an applicant into a program. | ||
| ENTRY_LEVEL | NUMBER | The entry level of an applicant into a program. | ||
| SCH_APL_TO_ID | NUMBER | School to which a student is applying to, in an institution. | ||
| 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) | Request identifier of last concurrent program to update this record | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
| PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record | |
| PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program | ||
| AUTHORIZED_DT | DATE | Authorized Date | ||
| AUTHORIZING_PERS_ID | NUMBER | (15) | Authorizing Person ID | |
| IDX_CALC_DATE | DATE | Index Calculation Date | ||
| WAITLIST_STATUS | VARCHAR2 | (30) | This field will be populated only for Outcome Status of "Applicant has been added to a waitlist". Valid values for Waitlist Status are PENDING, ACTIVE and INACTIVE. | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE31 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE32 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE33 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE34 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE35 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE36 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE37 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE38 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE39 | VARCHAR2 | (150) | Descriptive Flex field Column | |
| ATTRIBUTE40 | VARCHAR2 | (240) | Descriptive Flex field Column | |
| FUTURE_ACAD_CAL_TYPE | VARCHAR2 | (10) | Future academic calendar type | |
| FUTURE_ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Future academic calendar type instance | |
| FUTURE_ADM_CAL_TYPE | VARCHAR2 | (10) | Future admission calendar type | |
| FUTURE_ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Future admission calendar type instance | |
| PREVIOUS_TERM_ADM_APPL_NUMBER | NUMBER | (2) | Previous admission term application number reference | |
| PREVIOUS_TERM_SEQUENCE_NUMBER | NUMBER | (6) | Previous admission term sequence number | |
| FUTURE_TERM_ADM_APPL_NUMBER | NUMBER | (2) | Future admission term application number reference | |
| FUTURE_TERM_SEQUENCE_NUMBER | NUMBER | (6) | Future admission term sequence number reference | |
| DEF_ACAD_CAL_TYPE | VARCHAR2 | (10) | Deferred Academic Calendar Type | |
| DEF_ACAD_CI_SEQUENCE_NUM | NUMBER | (6) | Deferred Academic Calendar Sequence Number | |
| DEF_PREV_TERM_ADM_APPL_NUM | NUMBER | (2) | Deferred Previous Term Admission Application Number | |
| DEF_PREV_APPL_SEQUENCE_NUM | NUMBER | (6) | Deferred Previous Term Application Sequence Number | |
| DEF_TERM_ADM_APPL_NUM | NUMBER | (2) | Deferred Term Admission Application Number | |
| DEF_APPL_SEQUENCE_NUM | NUMBER | (6) | Deferred Term Application Sequence Number | |
| APPL_INST_STATUS | VARCHAR2 | (10) | Application Instance Status | |
| AIS_REASON | VARCHAR2 | (60) | Application Instance Status Reason | |
| DECLINE_OFR_REASON | VARCHAR2 | (60) | Reason for declining offer |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, PERSON_ID
, ADMISSION_APPL_NUMBER
, NOMINATED_COURSE_CD
, SEQUENCE_NUMBER
, PREDICTED_GPA
, ACADEMIC_INDEX
, ADM_CAL_TYPE
, APP_FILE_LOCATION
, ADM_CI_SEQUENCE_NUMBER
, APP_SOURCE_ID
, COURSE_CD
, CRV_VERSION_NUMBER
, ATHLETIC_GPA
, ATHLETIC_ELIGIBILITY_STATUS_ID
, WAITLIST_RANK
, LOCATION_CD
, ATTENT_OTHER_INST_CD
, ATTENDANCE_MODE
, EDU_GOAL_PRIOR_ENROLL_ID
, ATTENDANCE_TYPE
, DECISION_MAKE_ID
, UNIT_SET_CD
, DECISION_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, DECISION_REASON_ID
, US_VERSION_NUMBER
, DECISION_NOTES
, PENDING_REASON_ID
, PREFERENCE_NUMBER
, ADM_DOC_STATUS
, ADM_ENTRY_QUAL_STATUS
, DEFICIENCY_IN_PREP
, LATE_ADM_FEE_STATUS
, SPL_CONSIDER_COMMENTS
, APPLY_FOR_FINAID
, FINAID_APPLY_DATE
, ADM_OUTCOME_STATUS
, ADM_OTCM_STATUS_AUTH_PERSON_ID
, ADM_OUTCOME_STATUS_AUTH_DT
, ADM_OUTCOME_STATUS_REASON
, OFFER_DT
, OFFER_RESPONSE_DT
, PRPSD_COMMENCEMENT_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_ADM_CAL_TYPE
, DEFERRED_ADM_CI_SEQUENCE_NUM
, DEFERRED_TRACKING_ID
, ASS_RANK
, SECONDARY_ASS_RANK
, INTRNTNL_ACCEPTANCE_ADVICE_NUM
, ASS_TRACKING_ID
, FEE_CAT
, HECS_PAYMENT_OPTION
, EXPECTED_COMPLETION_YR
, EXPECTED_COMPLETION_PERD
, CORRESPONDENCE_CAT
, ENROLMENT_CAT
, FUNDING_SOURCE
, APPLICANT_ACPTNCE_CNDTN
, CNDTNL_OFFER_CNDTN
, SS_APPLICATION_ID
, SS_PWD
, ENTRY_STATUS
, ENTRY_LEVEL
, SCH_APL_TO_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, AUTHORIZED_DT
, AUTHORIZING_PERS_ID
, IDX_CALC_DATE
, WAITLIST_STATUS
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE31
, ATTRIBUTE32
, ATTRIBUTE33
, ATTRIBUTE34
, ATTRIBUTE35
, ATTRIBUTE36
, ATTRIBUTE37
, ATTRIBUTE38
, ATTRIBUTE39
, ATTRIBUTE40
, FUTURE_ACAD_CAL_TYPE
, FUTURE_ACAD_CI_SEQUENCE_NUMBER
, FUTURE_ADM_CAL_TYPE
, FUTURE_ADM_CI_SEQUENCE_NUMBER
, PREVIOUS_TERM_ADM_APPL_NUMBER
, PREVIOUS_TERM_SEQUENCE_NUMBER
, FUTURE_TERM_ADM_APPL_NUMBER
, FUTURE_TERM_SEQUENCE_NUMBER
, DEF_ACAD_CAL_TYPE
, DEF_ACAD_CI_SEQUENCE_NUM
, DEF_PREV_TERM_ADM_APPL_NUM
, DEF_PREV_APPL_SEQUENCE_NUM
, DEF_TERM_ADM_APPL_NUM
, DEF_APPL_SEQUENCE_NUM
, APPL_INST_STATUS
, AIS_REASON
, DECLINE_OFR_REASON
FROM IGS.IGS_AD_PS_APPL_INST_ALL;
IGS.IGS_AD_PS_APPL_INST_ALL does not reference any database object
IGS.IGS_AD_PS_APPL_INST_ALL is referenced by following:
APPS
IGS_AD_PS_APPL_INST_ALL
|
|
|
|