[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSBV_AD_ADM_PS_APPL_INST |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSBV_AD_ADM_PS_APPL_INST
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Holds Information about Admission Application Program Details
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | |
| PERSON_NAME | VARCHAR2 | (450) | ||
| ADMISSION_APPLICATION_NUMBER | NUMBER | (2) | Yes | Identifies uniquely an admission application for a person |
| NOMINATED_PROGRAM_CODE | VARCHAR2 | (6) | Yes | Describes the program code of the program offering instance to that the person is applying for admission |
| NOMINATED_PROGRAM_TITLE | VARCHAR2 | (90) | Yes | |
| APPLICATION_INSTANCE_SEQ_NUM | 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 | |
| ADMISSION_CAL_TYPE | VARCHAR2 | (10) | Describes the calendar type of the admission period | |
| ADMISSION_CAL_SEQ_NUM | NUMBER | (6) | Describes the calendar sequence number of the admission period | |
| APPLICATION_FILE_LOCATION | VARCHAR2 | (40) | Application file location | |
| APPLICATION_SOURCE_ID | NUMBER | (15) | Source of application | |
| PROGRAM_CODE | VARCHAR2 | (6) | Yes | Describes the program code for the program admission application |
| PROGRAM_CODE_VERSION_NUMBER | NUMBER | (3) | Yes | Describes the program version number for the program admission application |
| WAITLIST_RANK | VARCHAR2 | (30) | Wait list rank | |
| LOCATION_CODE | VARCHAR2 | (10) | Describes the location code of the program admission application | |
| ATTEND_OTHER_INSTITUTION_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_MAKER_PERSON_ID | NUMBER | (15) | Decision maker person identifier | |
| FINAL_UNIT_SET_CODE | VARCHAR2 | (10) | Describes the unit set code of the program admission application | |
| DECISION_DATE | DATE | Date when the decision is made | ||
| _DF | CHAR | (33) | ||
| DECISION_REASON_ID | NUMBER | (15) | ||
| FINAL_UNIT_SET_VERSION_NUMBER | NUMBER | (3) | ||
| DECISION_NOTES | VARCHAR2 | (2000) | ||
| PENDING_REASON_ID | NUMBER | (15) | ||
| APPLICATION_PREFERENCE_NUMBER | NUMBER | (2) | ||
| APPLICATION_COMPLETION_STATUS | VARCHAR2 | (10) | Yes | |
| ENTRY_QUALIFICATION_STATUS | VARCHAR2 | (10) | Yes | |
| DEFICIENCY_IN_PREPARATION | VARCHAR2 | (240) | ||
| LATE_ADMISSION_FEE_STATUS | VARCHAR2 | (10) | Yes | |
| SPECIAL_CONSIDER_COMMENTS | VARCHAR2 | (240) | ||
| _LA:APPLY_FINANCIAL_AID_FLAG | CHAR | (57) | ||
| FINANCIAL_AID_APPLY_DATE | DATE | |||
| OUTCOME_STATUS | VARCHAR2 | (10) | Yes | |
| OUTCOME_STATUS_AUTH_PERSON_ID | NUMBER | (15) | ||
| OUTCOME_STATUS_AUTH_DATE | DATE | |||
| OUTCOME_STATUS_REASON | VARCHAR2 | (60) | ||
| OFFER_DATE | DATE | |||
| OFFER_RESPONSE_DATE | DATE | |||
| PROPOSED_COMMENCEMENT_DT | DATE | |||
| CONDITIONAL_OFFER_STATUS | VARCHAR2 | (10) | Yes | |
| CONDITIONAL_OFFER_CONDITIONS | VARCHAR2 | (2000) | ||
| CONDITIONAL_OFFER_SATISFIED_DT | DATE | |||
| _LA:OFFER_STSFD_IND_FLAG | CHAR | (71) | ||
| OFFER_RESPONSE_STATUS | VARCHAR2 | (10) | Yes | |
| ACTUAL_RESPONSE_DATE | DATE | |||
| OFFER_DEFERMENT_STATUS | VARCHAR2 | (10) | Yes | |
| DEFERRED_ADMISSION_CAL_TYPE | VARCHAR2 | (10) | ||
| DEFERRED_ADM_CAL_INST_SEQ_NUM | NUMBER | (6) | ||
| DEFERRED_TRACKING_ID | NUMBER | (9) | ||
| ASSESMENT_RANK | NUMBER | (3) | ||
| SECONDARY_ASSESMENT_RANK | NUMBER | (3) | ||
| INTRNTNL_ACCEPTANCE_ADVICE_NUM | NUMBER | (15) | ||
| ASSESMENT_TRACKING_ID | NUMBER | (9) | ||
| FEE_CATEGORY | VARCHAR2 | (10) | ||
| HECS_PAYMENT_OPTION | VARCHAR2 | (10) | ||
| EXPECTED_COMPLETION_YEAR | NUMBER | (4) | ||
| EXPECTED_COMPLETION_PERIOD | VARCHAR2 | (1) | ||
| CORRESPONDENCE_CATEGORY | VARCHAR2 | (10) | ||
| ENROLMENT_CATEGORY | VARCHAR2 | (10) | ||
| FUNDING_SOURCE | VARCHAR2 | (10) | ||
| APPLICANT_ACPTNCE_CONDITION | VARCHAR2 | (2000) | ||
| SS_APPLICATION_ID | NUMBER | (15) | ||
| SS_PWD | VARCHAR2 | (30) | ||
| ENTRY_STATUS | NUMBER | |||
| ENTRY_LEVEL | NUMBER | |||
| SCHOOL_APPLYING_TO_ID | NUMBER | |||
| AUTHORIZED_DATE | DATE | |||
| AUTHORIZING_PERSON_ID | NUMBER | (15) | ||
| ACADEMIC_INDEX_CALC_DATE | DATE | |||
| _LA:WAITLIST_STATUS_MEANING | CHAR | (69) | ||
| FUTURE_ACADEMIC_CAL_TYPE | VARCHAR2 | (10) | ||
| FUTURE_ACAD_CAL_INST_SEQ_NUM | NUMBER | (6) | ||
| FUTURE_ADMISSION_CAL_TYPE | VARCHAR2 | (10) | ||
| FUTURE_ADM_CAL_INST_SEQ_NUM | NUMBER | (6) | ||
| PREVIOUS_TERM_ADM_APPL_NUMBER | NUMBER | (2) | ||
| PREVIOUS_TERM_SEQUENCE_NUMBER | NUMBER | (6) | ||
| FUTURE_TERM_ADM_APPL_NUMBER | NUMBER | (2) | ||
| FUTURE_TERM_SEQUENCE_NUMBER | NUMBER | (6) | ||
| DEFER_ACADEMIC_CAL_TYPE | VARCHAR2 | (10) | ||
| DEFER_ACAD_CAL_INST_SEQ_NUM | NUMBER | (6) | ||
| DEFER_PREV_TERM_ADM_APPL_NUM | NUMBER | (2) | ||
| DEFER_PREV_APPL_SEQUENCE_NUM | NUMBER | (6) | ||
| DEFER_TERM_ADM_APPL_NUM | NUMBER | (2) | ||
| DEFER_APPL_SEQUENCE_NUM | NUMBER | (6) | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| APPL_INST_STATUS | VARCHAR2 | (10) | Application Instance Status | |
| AIS_REASON_CODE | VARCHAR2 | (60) | Application Instance Status Reason code | |
| _LA:AIS_REASON | CHAR | (64) | ||
| DECLINE_OFR_REASON_CODE | VARCHAR2 | (60) | Reason for declining offer code | |
| _LA:DECLINE_OFR_REASON | CHAR | (73) |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PERSON_NUMBER
, PERSON_NAME
, ADMISSION_APPLICATION_NUMBER
, NOMINATED_PROGRAM_CODE
, NOMINATED_PROGRAM_TITLE
, APPLICATION_INSTANCE_SEQ_NUM
, PREDICTED_GPA
, ACADEMIC_INDEX
, ADMISSION_CAL_TYPE
, ADMISSION_CAL_SEQ_NUM
, APPLICATION_FILE_LOCATION
, APPLICATION_SOURCE_ID
, PROGRAM_CODE
, PROGRAM_CODE_VERSION_NUMBER
, WAITLIST_RANK
, LOCATION_CODE
, ATTEND_OTHER_INSTITUTION_CD
, ATTENDANCE_MODE
, EDU_GOAL_PRIOR_ENROLL_ID
, ATTENDANCE_TYPE
, DECISION_MAKER_PERSON_ID
, FINAL_UNIT_SET_CODE
, DECISION_DATE
, _DF
, DECISION_REASON_ID
, FINAL_UNIT_SET_VERSION_NUMBER
, DECISION_NOTES
, PENDING_REASON_ID
, APPLICATION_PREFERENCE_NUMBER
, APPLICATION_COMPLETION_STATUS
, ENTRY_QUALIFICATION_STATUS
, DEFICIENCY_IN_PREPARATION
, LATE_ADMISSION_FEE_STATUS
, SPECIAL_CONSIDER_COMMENTS
, _LA:APPLY_FINANCIAL_AID_FLAG
, FINANCIAL_AID_APPLY_DATE
, OUTCOME_STATUS
, OUTCOME_STATUS_AUTH_PERSON_ID
, OUTCOME_STATUS_AUTH_DATE
, OUTCOME_STATUS_REASON
, OFFER_DATE
, OFFER_RESPONSE_DATE
, PROPOSED_COMMENCEMENT_DT
, CONDITIONAL_OFFER_STATUS
, CONDITIONAL_OFFER_CONDITIONS
, CONDITIONAL_OFFER_SATISFIED_DT
, _LA:OFFER_STSFD_IND_FLAG
, OFFER_RESPONSE_STATUS
, ACTUAL_RESPONSE_DATE
, OFFER_DEFERMENT_STATUS
, DEFERRED_ADMISSION_CAL_TYPE
, DEFERRED_ADM_CAL_INST_SEQ_NUM
, DEFERRED_TRACKING_ID
, ASSESMENT_RANK
, SECONDARY_ASSESMENT_RANK
, INTRNTNL_ACCEPTANCE_ADVICE_NUM
, ASSESMENT_TRACKING_ID
, FEE_CATEGORY
, HECS_PAYMENT_OPTION
, EXPECTED_COMPLETION_YEAR
, EXPECTED_COMPLETION_PERIOD
, CORRESPONDENCE_CATEGORY
, ENROLMENT_CATEGORY
, FUNDING_SOURCE
, APPLICANT_ACPTNCE_CONDITION
, SS_APPLICATION_ID
, SS_PWD
, ENTRY_STATUS
, ENTRY_LEVEL
, SCHOOL_APPLYING_TO_ID
, AUTHORIZED_DATE
, AUTHORIZING_PERSON_ID
, ACADEMIC_INDEX_CALC_DATE
, _LA:WAITLIST_STATUS_MEANING
, FUTURE_ACADEMIC_CAL_TYPE
, FUTURE_ACAD_CAL_INST_SEQ_NUM
, FUTURE_ADMISSION_CAL_TYPE
, FUTURE_ADM_CAL_INST_SEQ_NUM
, PREVIOUS_TERM_ADM_APPL_NUMBER
, PREVIOUS_TERM_SEQUENCE_NUMBER
, FUTURE_TERM_ADM_APPL_NUMBER
, FUTURE_TERM_SEQUENCE_NUMBER
, DEFER_ACADEMIC_CAL_TYPE
, DEFER_ACAD_CAL_INST_SEQ_NUM
, DEFER_PREV_TERM_ADM_APPL_NUM
, DEFER_PREV_APPL_SEQUENCE_NUM
, DEFER_TERM_ADM_APPL_NUM
, DEFER_APPL_SEQUENCE_NUM
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, APPL_INST_STATUS
, AIS_REASON_CODE
, _LA:AIS_REASON
, DECLINE_OFR_REASON_CODE
, _LA:DECLINE_OFR_REASON
FROM APPS.IGSBV_AD_ADM_PS_APPL_INST;
APPS
HZ_PARTIES
HZ_PERSON_PROFILES
IGS_AD_PS_APPL_INST_ALL
IGS_PS_VER_ALL
APPS.IGSBV_AD_ADM_PS_APPL_INST is not referenced by any database object
|
|
|
|