[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AD_PS_APPL_INST_APLINST_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AD_PS_APPL_INST_APLINST_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| PERSON_ID | NUMBER | (15) | Yes | This field describes the ID of the person that the admission application is for. |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | |
| ADMISSION_APPL_NUMBER | NUMBER | (2) | Yes | This field uniquely identifies an admission application for a person. |
| NOMINATED_COURSE_CD | VARCHAR2 | (6) | Yes | This field describes the course code of the course offering instance that the person is applying for admission to. |
| SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field describes the unique identifier of an admission course application instance. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code. |
| ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | This field describes the academic calendar type to which the admission application applies. |
| ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field describes the academic calendar sequence number that the admission application is for. |
| ADM_CAL_TYPE | VARCHAR2 | (10) | This field describes the calendar type of the admission period. | |
| ADM_CI_SEQUENCE_NUMBER | NUMBER | This field describes the calendar sequence number of the admission period. | ||
| COURSE_CD | VARCHAR2 | (6) | Yes | This field describes the course code for the course admission application. |
| CRV_VERSION_NUMBER | NUMBER | (3) | Yes | This field describes the course version number for the course admission application. |
| LOCATION_CD | VARCHAR2 | (10) | This field describes the location code of the course admission application. | |
| ATTENDANCE_MODE | VARCHAR2 | (2) | This field describes the attendance mode of the course admission application. | |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | This field describes the nominated attendance type of the course admission application. | |
| UNIT_SET_CD | VARCHAR2 | (10) | This field describes the unit set code of the course admission application. | |
| UNIT_SET_TITLE | VARCHAR2 | (90) | ||
| US_VERSION_NUMBER | NUMBER | (3) | This field describes the version number of the nominated unit set code of the course admission application. | |
| PREFERENCE_NUMBER | NUMBER | (2) | This field describes the applicant preference number of the course applied for. | |
| ADM_DOC_STATUS | VARCHAR2 | (10) | Yes | This field describes the documentation status of the admission course application instance. |
| ADM_ENTRY_QUAL_STATUS | VARCHAR2 | (10) | Yes | This field describes the entry qualification status of the admission course application instance. |
| LATE_ADM_FEE_STATUS | VARCHAR2 | (10) | Yes | This field describes the institution-defined fee status for a late course admission application instance. |
| ADM_OUTCOME_STATUS | VARCHAR2 | (10) | Yes | This field describes the outcome status of the admission course application instance. |
| ADM_OTCM_STATUS_AUTH_PERSON_ID | NUMBER | (15) | This field describes the ID of the person who authorised the outcome status. | |
| ADM_OTCM_STATUS_AUTH_PER_NUM | VARCHAR2 | (30) | ||
| ADM_OUTCOME_STATUS_AUTH_DT | DATE | This field describes the date on which the outcome status was authorised. | ||
| ADM_OUTCOME_STATUS_REASON | VARCHAR2 | (60) | This reason is used to further describe a status e.g. an outcome status of 'Revoked' may have associated reason for the revocation. | |
| OFFER_DT | DATE | Date of offer being made | ||
| OFFER_RESPONSE_DT | DATE | This date indicates when an applicant must respond by before an offer will lapse. | ||
| PRPSD_COMMENCEMENT_DT | DATE | This field describes the proposed commencement date for an admission course application instance. | ||
| ADM_CNDTNL_OFFER_STATUS | VARCHAR2 | (10) | Yes | This field describes the status assigned to an admission course application in relation to a conditional offer. |
| CNDTNL_OFFER_CNDTN | VARCHAR2 | (2000) | Describes the conditions that have been asociated with a conditional offer. | |
| CNDTNL_OFFER_SATISFIED_DT | DATE | This field describes the date on which a conditional offer was satisfied or waived. | ||
| CNDTNL_OFFER_MUST_BE_STSFD_IND | VARCHAR2 | (1) | Yes | This field describes whether or not conditions attached to an offer must be satisfied before an offer can be accepted. Setting the indicator (ticked) means that the condition must be satisfied before the conditional offer can be accepted. |
| ADM_OFFER_RESP_STATUS | VARCHAR2 | (10) | Yes | This field describes the offer response status of the admission course application instance. |
| ACTUAL_RESPONSE_DT | DATE | This field describes the actual date a response was made by an applicant to an offer. | ||
| APPLICANT_ACPTNCE_CNDTN | VARCHAR2 | (2000) | This describes the conditions the applicant is requesting as part of their acceptance of an offer e.g. request for scholarship granted, advanced standing approved. | |
| ADM_OFFER_DFRMNT_STATUS | VARCHAR2 | (10) | Yes | This field describes the offer deferment status of the admission course application instance. |
| DEFERRED_ADM_CAL_TYPE | VARCHAR2 | (10) | This field describes the admission calendar type of the course offering option that an deferral was made in. | |
| DEFERRED_ADM_CI_SEQUENCE_NUM | NUMBER | (6) | This field describes the admission calendar sequence number of the course offering option that an deferral was made in. | |
| DEFERRED_ADM_ALTERNATE_CODE | VARCHAR2 | (10) | The alternate short reference code for identifying a teaching or academic calendar instance. This code is used for mass keying of enrolments and unit/course offerings. | |
| DEFERRED_ACAD_ALTERNATE_CODE | VARCHAR2 | (10) | The alternate short reference code for identifying a teaching or academic calendar instance. This code is used for mass keying of enrolments and unit/course offerings. | |
| DEFERRED_TRACKING_ID | NUMBER | (9) | This field describes the tracking ID of the deferral request. | |
| ASS_RANK | NUMBER | (3) | Rank of applicant where offers are determined by comparing all applicants and choosing the highest ranked to satisfy course 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 course offers by comparing all applicants. | |
| INTRNTNL_ACCEPTANCE_ADVICE_NUM | NUMBER | (15) | This is the number on the government form that goes with the offer letter for international applicants to take to the embassy overseas to get their visa. | |
| ASS_TRACKING_ID | NUMBER | (9) | This field 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) | This field describes the HECS payment option associated with an offer. This will enable enrolment 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. The assessor also nominates the expected period (Summer, Mid-year or End of Year) of course completion. This information can be derived from course version F/T, P/T standard completion time but may need to be overriden when advanced standing is a consideration. This information will enable determination of fee-paying applicant contract durations. | |
| 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. The assessor also nominates the year of expected course completion. | |
| 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) | ADM_COURSE_APPL_INSTANCE.ENROLMENT_CAT | |
| FUNDING_SOURCE | VARCHAR2 | (10) | A unique identifier for the institution-defined funding source. This must be mapped to a Government funding source. | |
| BASIS_FOR_ADMISSION_TYPE | VARCHAR2 | (10) | This field describes the institution-defined basis for admission type of the admission course application. | |
| REQ_FOR_RECONSIDERATION_IND | VARCHAR2 | (1) | Yes | This field describes whether a request for reconsideration in the next course offering is made, if unsuccessful in obtaining an offer due to quota restrictions. |
| REQ_FOR_ADV_STANDING_IND | VARCHAR2 | (1) | Yes | Indicates a request for advanced standing has been made by the applicant |
| ADMISSION_CD | VARCHAR2 | (10) | This field describes the institution-defined admission code of the admission course application. | |
| COURSE_RANK_SET | VARCHAR2 | (30) | This field describes the ranking of an applicant. The course rank set was identified via QTAC offer course preference data eg. YR 12 = 1:2:3 (OP1) or 25:2:3 (OP25); Non YR12 = 98:78:45. For YR12, 1 in the first position represents the highest ranked applicant (25 lowest). Fields 2 and 3 represent descriptors. For Non YR12, 99 represents the highest ranked applicant (equates to 1 for YR12, then 78 would represent a rank achieved in tertiary education etc.). | |
| COURSE_RANK_SCHEDULE | VARCHAR2 | (10) | This field describes the TAC schedule that the course rank set was based upon. | |
| TRANSFER_COURSE_CD | VARCHAR2 | (6) | This field describes the course code of the student course attempt that the person is applying to transfer from. | |
| COURSE_TITLE_DISPLAY | VARCHAR2 | (90) | The full name of the course, (DETYA element 308). | |
| COURSE_STATUS_DISPLAY | VARCHAR2 | (10) | Yes | An institution-defined course status which indicates the level of activity of the course version. A course is established with a status of PLANNED. For students to be enrolled in the course it must be ACTIVE. |
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| PREDICTED_GPA | NUMBER | (5) | ||
| ACADEMIC_INDEX | VARCHAR2 | (10) | ||
| APP_FILE_LOCATION | VARCHAR2 | (40) | ||
| APP_SOURCE_ID | NUMBER | (15) | ||
| APP_SOURCE | VARCHAR2 | (10) | ||
| APP_SOURCE_DESC | VARCHAR2 | (30) | ||
| ATHLETIC_GPA | VARCHAR2 | (0) | ||
| ATHLETIC_ELIGIBILITY_STATUS | VARCHAR2 | (0) | ||
| ATHLETICS_ELIG_STATUS_DESC | VARCHAR2 | (0) | ||
| ATHLETIC_ELIGIBILITY_STATUS_ID | VARCHAR2 | (0) | ||
| WAITLIST_RANK | VARCHAR2 | (30) | ||
| ATTENT_OTHER_INST_CD | VARCHAR2 | (10) | ||
| ATTENT_OTHER_INST_NAME | VARCHAR2 | (360) | ||
| EDU_GOAL_PRIOR_ENROLL_ID | NUMBER | (15) | ||
| EDU_GOAL_PRIOR_ENROLL | VARCHAR2 | (10) | ||
| EDU_GOAL_PRIOR_ENROLL_DESC | VARCHAR2 | (30) | ||
| DECISION_DATE | DATE | |||
| DECISION_MAKE_ID | NUMBER | (15) | ||
| DECISION_MAKER_NAME | VARCHAR2 | (4000) | ||
| DECISON_REASON_ID | NUMBER | (15) | ||
| DECISION_REASON | VARCHAR2 | (10) | ||
| DECISION_REASON_DESC | VARCHAR2 | (30) | ||
| PENDING_REASON_ID | NUMBER | (15) | ||
| PENDING_REASON | VARCHAR2 | (10) | ||
| PENDING_REASON_DESC | VARCHAR2 | (30) | ||
| DECISION_NOTES | VARCHAR2 | (2000) | ||
| DEFICIENCY_IN_PREP | VARCHAR2 | (240) | ||
| SPL_CONSIDER_COMMENTS | VARCHAR2 | (240) | ||
| APPLY_FOR_FINAID | VARCHAR2 | (1) | ||
| FINAID_APPLY_DATE | DATE | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ATTRIBUTE20 | VARCHAR2 | (150) | ||
| SS_APPLICATION_ID | NUMBER | (15) | ||
| AUTHORIZED_DT | DATE | |||
| AUTHORIZING_PERS_ID | NUMBER | (15) | Authorizing Person Id | |
| AUTHORIZING_PERS_NUM | VARCHAR2 | (30) | Authorizing Person Number | |
| ENTRY_STATUS | NUMBER | Entry Status | ||
| ENTRY_STATUS_NAME | VARCHAR2 | (10) | Entry Status Name | |
| ENTRY_STATUS_DESC | VARCHAR2 | (30) | Entry Status Description | |
| ENTRY_LEVEL | NUMBER | Entry Level | ||
| ENTRY_LEVEL_NAME | VARCHAR2 | (10) | Entry Level Name | |
| ENTRY_LEVEL_DESC | VARCHAR2 | (30) | Entry Status Description | |
| SCH_APL_TO_ID | NUMBER | School Apply To ID | ||
| SCHOOL_APPLYING_TO | VARCHAR2 | (30) | School Applying To | |
| SCH_APL_TO_DESC | VARCHAR2 | (60) | School Applyinh To Description | |
| IDX_CALC_DATE | DATE | Calculation Date | ||
| WAITLIST_STATUS | VARCHAR2 | (30) | Waitlist Status | |
| WAITLIST_STATUS_DESC | VARCHAR2 | (80) | Waitlist Status Description | |
| ADM_FEE_STATUS | VARCHAR2 | (10) | Yes | Admission Fee Status |
| ADM_OTCM_STATUS_AUTH_PER_NAME | VARCHAR2 | (391) | Admission Outcome Status Authorizing Person Name | |
| DECISION_MAKER_NUMBER | VARCHAR2 | (30) | Decision Maker Number | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE31 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE32 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE33 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE34 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE35 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE36 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE37 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE38 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE39 | VARCHAR2 | (150) | Descriptive Flexfield Column | |
| ATTRIBUTE40 | VARCHAR2 | (240) | Descriptive Flexfield Column | |
| ADMISSION_CD_DESC | VARCHAR2 | (60) | ||
| BASIS_FOR_ADM_TYP_DESC | VARCHAR2 | (60) | ||
| FUTURE_ACAD_ALTERNATE_CODE | VARCHAR2 | (10) | Future academic alternate code | |
| FUTURE_ACAD_CAL_TYPE | VARCHAR2 | (10) | Future academic calendar type | |
| FUTURE_ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Future academic calendar type instance | |
| FUTURE_ADM_ALTERNATE_CODE | VARCHAR2 | (10) | Future admission alternate code | |
| 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 reference | |
| 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 | |
| ADM_ALTERNATE_CODE | VARCHAR2 | (10) | ||
| 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 | |
| APPLICATION_ID | NUMBER | (15) | Application Identifier | |
| ALT_APPL_ID | VARCHAR2 | (30) | Alternate Application Identifier | |
| 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 ROW_ID
, PERSON_ID
, PERSON_NUMBER
, ADMISSION_APPL_NUMBER
, NOMINATED_COURSE_CD
, SEQUENCE_NUMBER
, ACAD_CAL_TYPE
, ACAD_CI_SEQUENCE_NUMBER
, ADM_CAL_TYPE
, ADM_CI_SEQUENCE_NUMBER
, COURSE_CD
, CRV_VERSION_NUMBER
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, UNIT_SET_CD
, UNIT_SET_TITLE
, US_VERSION_NUMBER
, PREFERENCE_NUMBER
, ADM_DOC_STATUS
, ADM_ENTRY_QUAL_STATUS
, LATE_ADM_FEE_STATUS
, ADM_OUTCOME_STATUS
, ADM_OTCM_STATUS_AUTH_PERSON_ID
, ADM_OTCM_STATUS_AUTH_PER_NUM
, ADM_OUTCOME_STATUS_AUTH_DT
, ADM_OUTCOME_STATUS_REASON
, OFFER_DT
, OFFER_RESPONSE_DT
, PRPSD_COMMENCEMENT_DT
, ADM_CNDTNL_OFFER_STATUS
, CNDTNL_OFFER_CNDTN
, CNDTNL_OFFER_SATISFIED_DT
, CNDTNL_OFFER_MUST_BE_STSFD_IND
, ADM_OFFER_RESP_STATUS
, ACTUAL_RESPONSE_DT
, APPLICANT_ACPTNCE_CNDTN
, ADM_OFFER_DFRMNT_STATUS
, DEFERRED_ADM_CAL_TYPE
, DEFERRED_ADM_CI_SEQUENCE_NUM
, DEFERRED_ADM_ALTERNATE_CODE
, DEFERRED_ACAD_ALTERNATE_CODE
, 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
, BASIS_FOR_ADMISSION_TYPE
, REQ_FOR_RECONSIDERATION_IND
, REQ_FOR_ADV_STANDING_IND
, ADMISSION_CD
, COURSE_RANK_SET
, COURSE_RANK_SCHEDULE
, TRANSFER_COURSE_CD
, COURSE_TITLE_DISPLAY
, COURSE_STATUS_DISPLAY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PREDICTED_GPA
, ACADEMIC_INDEX
, APP_FILE_LOCATION
, APP_SOURCE_ID
, APP_SOURCE
, APP_SOURCE_DESC
, ATHLETIC_GPA
, ATHLETIC_ELIGIBILITY_STATUS
, ATHLETICS_ELIG_STATUS_DESC
, ATHLETIC_ELIGIBILITY_STATUS_ID
, WAITLIST_RANK
, ATTENT_OTHER_INST_CD
, ATTENT_OTHER_INST_NAME
, EDU_GOAL_PRIOR_ENROLL_ID
, EDU_GOAL_PRIOR_ENROLL
, EDU_GOAL_PRIOR_ENROLL_DESC
, DECISION_DATE
, DECISION_MAKE_ID
, DECISION_MAKER_NAME
, DECISON_REASON_ID
, DECISION_REASON
, DECISION_REASON_DESC
, PENDING_REASON_ID
, PENDING_REASON
, PENDING_REASON_DESC
, DECISION_NOTES
, DEFICIENCY_IN_PREP
, SPL_CONSIDER_COMMENTS
, APPLY_FOR_FINAID
, FINAID_APPLY_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, SS_APPLICATION_ID
, AUTHORIZED_DT
, AUTHORIZING_PERS_ID
, AUTHORIZING_PERS_NUM
, ENTRY_STATUS
, ENTRY_STATUS_NAME
, ENTRY_STATUS_DESC
, ENTRY_LEVEL
, ENTRY_LEVEL_NAME
, ENTRY_LEVEL_DESC
, SCH_APL_TO_ID
, SCHOOL_APPLYING_TO
, SCH_APL_TO_DESC
, IDX_CALC_DATE
, WAITLIST_STATUS
, WAITLIST_STATUS_DESC
, ADM_FEE_STATUS
, ADM_OTCM_STATUS_AUTH_PER_NAME
, DECISION_MAKER_NUMBER
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE31
, ATTRIBUTE32
, ATTRIBUTE33
, ATTRIBUTE34
, ATTRIBUTE35
, ATTRIBUTE36
, ATTRIBUTE37
, ATTRIBUTE38
, ATTRIBUTE39
, ATTRIBUTE40
, ADMISSION_CD_DESC
, BASIS_FOR_ADM_TYP_DESC
, FUTURE_ACAD_ALTERNATE_CODE
, FUTURE_ACAD_CAL_TYPE
, FUTURE_ACAD_CI_SEQUENCE_NUMBER
, FUTURE_ADM_ALTERNATE_CODE
, 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
, ADM_ALTERNATE_CODE
, 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
, APPLICATION_ID
, ALT_APPL_ID
, APPL_INST_STATUS
, AIS_REASON
, DECLINE_OFR_REASON
FROM APPS.IGS_AD_PS_APPL_INST_APLINST_V;
APPS
HZ_PARTIES
IGS_AD_APPL
IGS_AD_BASIS_FOR_AD
IGS_AD_CD
IGS_AD_CODE_CLASSES
IGS_AD_PS_APPL
IGS_AD_PS_APPL_INST_SV
IGS_AD_SCHL_APLY_TO
IGS_CA_INST
IGS_EN_UNIT_SET
IGS_GE_GEN_001
- show dependent code
IGS_LOOKUP_VALUES
IGS_OR_INSTITUTION
IGS_PS_VER
APPS
IGS_AD_APPL_INST_MKDES_V
IGS_AD_OUTCOME_LETTERS_V
IGS_AD_PS_APLINSTHST_HISTORY_V
IGS_AD_VAL_ACAI
- show dependent code
IGS_CO_GEN_003
- show dependent code
IGS_CO_GEN_003
- show dependent code
IGS_EN_GEN_006
- show dependent code
IGS_EN_GEN_010
- show dependent code
IGS_EN_VAL_SCA
- show dependent code
|
|
|
|