[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.IGSBV_AD_ADM_PS_APPL_INST is not referenced by any database object
|
|
|