[Home] [Help] [Dependency Information]
Object Name: | IGSFV_AD_ADM_PS_APPL_INST |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_AD_ADM_PS_APPL_INST |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Describes the request for program Entry for an Admission period
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 Number |
PERSON_NAME | VARCHAR2 | (450) | Person Name | |
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 | Program Code description of the Program Offering Pattern which the person is applying for Admission to |
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_ALTERNATE_CODE | VARCHAR2 | (10) | Admission Alternate Code | |
ADMISSION_CALENDAR_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 | |
APPICATION_FILE_LOCATION | VARCHAR2 | (40) | Application file location | |
APPLICATION_SOURCE_ID | NUMBER | (15) | Source of application | |
APPLICATION_SOURCE_NAME | VARCHAR2 | (10) | Application Source Name | |
APPLICATION_SOURCE_DESC | VARCHAR2 | (30) | Description of the Application Source | |
PROGRAM_CODE | VARCHAR2 | (6) | Yes | Describes the program code for the program admission application |
PROGRAM_CODE_TITLE | VARCHAR2 | (90) | Yes | Program Code Title |
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 | |
LOCATION_DESCRIPTION | VARCHAR2 | (60) | The description of a physical location owned or used by an institution. Each location has a location type, such as Campus, that defines its use in the system. | |
ATTEND_OTHER_INSTITUTION_CD | VARCHAR2 | (10) | Intend to attend other institution code | |
OTHER_INSTITUTION_NAME | VARCHAR2 | (360) | Indicates the Institution Name | |
ATTENDANCE_MODE | VARCHAR2 | (2) | Describes the attendance mode of the program admission application | |
ATTENDANCE_MODE_DESC | VARCHAR2 | (60) | Description of an institution-defined attendance mode. An attendance mode identifies the mode of attendance for a program that student undertakes. Each attendance mode must be mapped to a government attendance type. | |
EDU_GOAL_PRIOR_ENROLL_ID | NUMBER | (15) | Education goal prior to enrollment | |
EDU_GOAL_PRIOR_ENROLL_NAME | VARCHAR2 | (10) | Education Goal Prior to Enroll ID | |
EDU_GOAL_PRIOR_ENROLL_DESC | VARCHAR2 | (30) | Education Goal Prior to Enroll Name | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Describes the attendance type of the program admission application | |
ATTENDANCE_TYPE_DESC | VARCHAR2 | (60) | Description of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year. | |
DECISION_MAKER_PERSON_ID | NUMBER | (15) | Decision maker person identifier | |
DECISION_MAKER_PERSON_NUM | VARCHAR2 | (30) | Decision Maker Person Number | |
DECISION_MAKER_NAME | VARCHAR2 | (450) | Decision Maker Person Name | |
FINAL_UNIT_SET_CODE | VARCHAR2 | (10) | Describes the unit set code of the program admission application | |
FINAL_UNIT_SET_TITLE | VARCHAR2 | (90) | Title of a unit set. Unit sets comprise lists of units or rules that constitute a logical set of units. Unit sets are used to represent concepts such as majors, minors, strands, streams and lists. | |
FINAL_UNIT_SET_VERSION_NUM | NUMBER | (3) | Describes the version number of the nominated 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) | Decision Reason Id | |
DECISION_REASON | VARCHAR2 | (10) | Decision Reason | |
DECISION_REASON_DESCRIPTION | VARCHAR2 | (30) | Decision Reason Description | |
DECISION_NOTES | VARCHAR2 | (2000) | Decision Notes | |
PENDING_REASON_ID | NUMBER | (15) | Pending Reason Id | |
PENDING_REASON | VARCHAR2 | (10) | Pending Reason | |
PENDING_REASON_DESCRIPTION | VARCHAR2 | (30) | Pending Reason Description | |
APPLICATION_PREFERENCE_NUMBER | NUMBER | (2) | Preference number of Applicant for the Program applied for | |
APPLICATION_COMPLETION_STATUS | VARCHAR2 | (10) | Yes | Application Completion Status |
APPLICATION_COMPLTN_STAT_DESC | VARCHAR2 | (60) | Yes | Application Completion Status Description |
ENTRY_QUALIFICATION_STATUS | VARCHAR2 | (10) | Yes | Admission Entry Qualification Status |
ENTRY_QUAL_STATUS_DESC | VARCHAR2 | (60) | Yes | Admission Entry Qualification Status Description |
DEFICIENCY_IN_PREPARATION | VARCHAR2 | (240) | Deficiency in Preparation | |
LATE_ADMISSION_FEE_STATUS | VARCHAR2 | (10) | Yes | Admission fee Status for a late Admission application instance |
ADMISSION_FEE_STATUS_DESC | VARCHAR2 | (60) | Yes | Admission fee Status Description for a late Admission application instance |
SPECIAL_CONSIDER_COMMENTS | VARCHAR2 | (240) | Special Consideration comments | |
_LA:APPLY_FINANCIAL_AID_FLAG | CHAR | (57) | Applied for Financial Aid lookup tag | |
FINANCIAL_AID_APPLY_DATE | DATE | Financial Aid Applying date | ||
OUTCOME_STATUS | VARCHAR2 | (10) | Yes | Admission Outcome status |
OUTCOME_STATUS_DESC | VARCHAR2 | (60) | Yes | Admission Outcome status Description |
OUTCOME_STAT_AUTH_PERSON_ID | NUMBER | (15) | Person Id who authorized the Admission outcome status | |
OUTCOME_STAT_AUTH_PERSON_NAME | VARCHAR2 | (4000) | Person Name who authorized the Admission outcome status | |
OUTCOME_STATUS_AUTH_DATE | DATE | Date when Admission outcome status was authorized | ||
OUTCOME_STATUS_REASON | VARCHAR2 | (60) | Admission outcome status reason | |
OFFER_DATE | DATE | Offer Date | ||
OFFER_RESPONSE_DATE | DATE | Offer Response Date | ||
PROPOSED_COMMENCEMENT_DATE | DATE | Proposed commencement date | ||
CONDITIONAL_OFFER_STATUS | VARCHAR2 | (10) | Yes | Admission Conditional Offer Status |
CONDITIONAL_OFFER_STATUS_DESC | VARCHAR2 | (60) | Yes | Admission Conditional Offer Status Description |
CONDITIONAL_OFFER_CONDITIONS | VARCHAR2 | (2000) | Condition of a conditional offer | |
CONDITIONAL_OFFER_SATISFIED_DT | DATE | Date when a Conditional offer was satisfied | ||
_LA:OFFER_SATISFIED_IND_FLAG | CHAR | (71) | Lookup tag for whether a conditional offer should be satisfied | |
OFFER_RESPONSE_STATUS | VARCHAR2 | (10) | Yes | Admission offer response status |
OFFER_RESPONSE_STAT_DESC | VARCHAR2 | (60) | Yes | Admission offer response status Description |
ACTUAL_RESPONSE_DATE | DATE | Actual Response date | ||
OFFER_DEFERMENT_STATUS | VARCHAR2 | (10) | Yes | Admission Offer deferment status |
OFFER_DEFERMENT_STATUS_DESC | VARCHAR2 | (60) | Yes | Admission Offer deferment status Description |
DEFERRED_ADMISSION_ALT_CODE | VARCHAR2 | (10) | Alternate Code for Deferred Admission Calendar | |
DEFERRED_ADMISSION_CAL_TYPE | VARCHAR2 | (10) | Deferred Admission Calendar Type | |
DEFERRED_ADM_CAL_INST_SEQ_NUM | NUMBER | (6) | Deferred Admission Calendar sequence number | |
DEFERRED_TRACKING_ID | NUMBER | (9) | Deferred tracking ID | |
ASSESSMENT_RANK | NUMBER | (3) | Rank of applicant for assessing | |
SECONDARY_ASSESSMENT_RANK | NUMBER | (3) | Secondary rank of applicant for assessing | |
INTRNTNL_ACCEPTANCE_ADVICE_NUM | NUMBER | (15) | The number of Acceptance Advice for issued to Applicants | |
ASSESSMENT_TRACKING_ID | NUMBER | (9) | Tracking Id of an Application that has been forwarded for assessment | |
FEE_CATEGORY | VARCHAR2 | (10) | Fee Category applicable for the Program | |
FEE_CATEGORY_DESC | VARCHAR2 | (60) | Fee Category Description applicable for the Program | |
HECS_PAYMENT_OPTION | VARCHAR2 | (10) | Payment option | |
HECS_PAY_OPTION_DESC | VARCHAR2 | (60) | Payment option Description | |
EXPECTED_COMPLETION_YEAR | NUMBER | (4) | Expected completion year | |
EXPECTED_COMPLETION_PERIOD | VARCHAR2 | (1) | Expected completion period | |
CORRESPONDENCE_CATATEGORY | VARCHAR2 | (10) | Expected Completion period | |
CORRESPONDENCE_CATEGORY_DESC | VARCHAR2 | (60) | Correspondence category applicable for the Program | |
ENROLMENT_CATEGORY | VARCHAR2 | (10) | Enrollment category applicable for the Program | |
ENROLMENT_CATEGORY_DESC | VARCHAR2 | (60) | Enrollment category applicable for the Program Description | |
FUNDING_SOURCE | VARCHAR2 | (10) | Funding source | |
FUNDING_SOURCE_DESC | VARCHAR2 | (60) | Funding source Description | |
APPLICANT_ACPTNCE_CONDITION | VARCHAR2 | (2000) | Comments regarding Applicant's response to offer | |
SS_APPLICATION_ID | NUMBER | (15) | Self Service Application ID | |
SS_PWD | VARCHAR2 | (30) | Self service Application Password | |
ENTRY_STATUS | NUMBER | Entry Status of an Applicant to a program | ||
ENTRY_STATUS_NAME | VARCHAR2 | (10) | Entry Status Name of an Applicant to a program | |
ENTRY_STATUS_DESCRIPTION | VARCHAR2 | (30) | Entry Status Description of an Applicant to a program | |
ENTRY_LEVEL | NUMBER | Entry Level of an Applicant to a program | ||
ENTRY_LEVEL_NAME | VARCHAR2 | (10) | Entry Level name of an Applicant to a program | |
ENTRY_LEVEL_DESCRIPTION | VARCHAR2 | (30) | Entry Level description of an Applicant to a program | |
SCHOOL_APLYING_TO_ID | NUMBER | Applying School Id | ||
SCHOOL_APPLYING_TO | VARCHAR2 | (30) | Applying School Name | |
SCHOOL_APPLYING_TO_DESC | VARCHAR2 | (60) | Applying School Description | |
AUTHORIZED_DATE | DATE | Authorized Date | ||
AUTHORIZING_PERSON_ID | NUMBER | (15) | Authorizing Person Id | |
AUTHORIZING_PERSON_NUM | VARCHAR2 | (30) | Authorizing Person Number | |
AUTHORIZING_PERSON_NAME | VARCHAR2 | (450) | Authorizing Person Name | |
ACADEMIC_INDEX_CALC_DATE | DATE | Index Calculation date | ||
_LA:WAITLIST_STATUS_MEANING | CHAR | (69) | Lookup tag for Waitlist Status meaning | |
FUTURE_ACADEMIC_ALT_CODE | VARCHAR2 | (10) | Future Academic Alternate Code | |
FUTURE_ACADEMIC_CAL_TYPE | VARCHAR2 | (10) | Future Academic calendar Type | |
FUTURE_ACAD_CAL_INST_SEQ_NUM | NUMBER | (6) | Future Academic calendar Sequence Number | |
FUTURE_ADMISSION_ALT_CODE | VARCHAR2 | (10) | Future Admission Alternate Code | |
FUTURE_ADMISSION_CAL_TYPE | VARCHAR2 | (10) | Future Admission Calendar Type | |
FUTURE_ADM_CAL_INST_SEQ_NUM | NUMBER | (6) | Future Admission calendar Sequence Number | |
PREVIOUS_TERM_ADM_APPL_NUMBER | NUMBER | (2) | Previous Term Admission Application Number | |
PREVIOUS_TERM_SEQUENCE_NUMBER | NUMBER | (6) | Previous Term Sequence Number | |
FUTURE_TERM_ADM_APPL_NUMBER | NUMBER | (2) | Future Term Admission Application Number | |
FUTURE_TERM_SEQUENCE_NUMBER | NUMBER | (6) | Future Term Sequence Number | |
DEFER_ACADEMIC_ALTERNATE_CODE | VARCHAR2 | (10) | Deferred Academic Alternate Code | |
DEFER_ACADEMIC_CAL_TYPE | VARCHAR2 | (10) | Deferred Academic Calendar Type | |
DEFER_ACAD_CAL_INST_SEQ_NUM | NUMBER | (6) | Deferred Academic Sequence Number | |
DEFER_PREV_TERM_ADM_APPL_NUM | NUMBER | (2) | Deferred Previous term Admission Application Number | |
DEFER_PREV_APPL_SEQUENCE_NUM | NUMBER | (6) | Deferred Pervious Term Application Sequence Number | |
DEFER_TERM_ADM_APPL_NUM | NUMBER | (2) | Deferred term Admission Application Number | |
DEFER_APPL_SEQUENCE_NUM | NUMBER | (6) | Deferred Admission Application Sequence Number | |
CREATED_BY | NUMBER | (15) | Yes | WHO column |
CREATION_DATE | DATE | Yes | WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | WHO column |
LAST_UPDATE_DATE | DATE | Yes | WHO column | |
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_ALTERNATE_CODE
, ADMISSION_CALENDAR_TYPE
, ADMISSION_CAL_SEQ_NUM
, APPICATION_FILE_LOCATION
, APPLICATION_SOURCE_ID
, APPLICATION_SOURCE_NAME
, APPLICATION_SOURCE_DESC
, PROGRAM_CODE
, PROGRAM_CODE_TITLE
, PROGRAM_CODE_VERSION_NUMBER
, WAITLIST_RANK
, LOCATION_CODE
, LOCATION_DESCRIPTION
, ATTEND_OTHER_INSTITUTION_CD
, OTHER_INSTITUTION_NAME
, ATTENDANCE_MODE
, ATTENDANCE_MODE_DESC
, EDU_GOAL_PRIOR_ENROLL_ID
, EDU_GOAL_PRIOR_ENROLL_NAME
, EDU_GOAL_PRIOR_ENROLL_DESC
, ATTENDANCE_TYPE
, ATTENDANCE_TYPE_DESC
, DECISION_MAKER_PERSON_ID
, DECISION_MAKER_PERSON_NUM
, DECISION_MAKER_NAME
, FINAL_UNIT_SET_CODE
, FINAL_UNIT_SET_TITLE
, FINAL_UNIT_SET_VERSION_NUM
, DECISION_DATE
, _DF
, DECISION_REASON_ID
, DECISION_REASON
, DECISION_REASON_DESCRIPTION
, DECISION_NOTES
, PENDING_REASON_ID
, PENDING_REASON
, PENDING_REASON_DESCRIPTION
, APPLICATION_PREFERENCE_NUMBER
, APPLICATION_COMPLETION_STATUS
, APPLICATION_COMPLTN_STAT_DESC
, ENTRY_QUALIFICATION_STATUS
, ENTRY_QUAL_STATUS_DESC
, DEFICIENCY_IN_PREPARATION
, LATE_ADMISSION_FEE_STATUS
, ADMISSION_FEE_STATUS_DESC
, SPECIAL_CONSIDER_COMMENTS
, _LA:APPLY_FINANCIAL_AID_FLAG
, FINANCIAL_AID_APPLY_DATE
, OUTCOME_STATUS
, OUTCOME_STATUS_DESC
, OUTCOME_STAT_AUTH_PERSON_ID
, OUTCOME_STAT_AUTH_PERSON_NAME
, OUTCOME_STATUS_AUTH_DATE
, OUTCOME_STATUS_REASON
, OFFER_DATE
, OFFER_RESPONSE_DATE
, PROPOSED_COMMENCEMENT_DATE
, CONDITIONAL_OFFER_STATUS
, CONDITIONAL_OFFER_STATUS_DESC
, CONDITIONAL_OFFER_CONDITIONS
, CONDITIONAL_OFFER_SATISFIED_DT
, _LA:OFFER_SATISFIED_IND_FLAG
, OFFER_RESPONSE_STATUS
, OFFER_RESPONSE_STAT_DESC
, ACTUAL_RESPONSE_DATE
, OFFER_DEFERMENT_STATUS
, OFFER_DEFERMENT_STATUS_DESC
, DEFERRED_ADMISSION_ALT_CODE
, DEFERRED_ADMISSION_CAL_TYPE
, DEFERRED_ADM_CAL_INST_SEQ_NUM
, DEFERRED_TRACKING_ID
, ASSESSMENT_RANK
, SECONDARY_ASSESSMENT_RANK
, INTRNTNL_ACCEPTANCE_ADVICE_NUM
, ASSESSMENT_TRACKING_ID
, FEE_CATEGORY
, FEE_CATEGORY_DESC
, HECS_PAYMENT_OPTION
, HECS_PAY_OPTION_DESC
, EXPECTED_COMPLETION_YEAR
, EXPECTED_COMPLETION_PERIOD
, CORRESPONDENCE_CATATEGORY
, CORRESPONDENCE_CATEGORY_DESC
, ENROLMENT_CATEGORY
, ENROLMENT_CATEGORY_DESC
, FUNDING_SOURCE
, FUNDING_SOURCE_DESC
, APPLICANT_ACPTNCE_CONDITION
, SS_APPLICATION_ID
, SS_PWD
, ENTRY_STATUS
, ENTRY_STATUS_NAME
, ENTRY_STATUS_DESCRIPTION
, ENTRY_LEVEL
, ENTRY_LEVEL_NAME
, ENTRY_LEVEL_DESCRIPTION
, SCHOOL_APLYING_TO_ID
, SCHOOL_APPLYING_TO
, SCHOOL_APPLYING_TO_DESC
, AUTHORIZED_DATE
, AUTHORIZING_PERSON_ID
, AUTHORIZING_PERSON_NUM
, AUTHORIZING_PERSON_NAME
, ACADEMIC_INDEX_CALC_DATE
, _LA:WAITLIST_STATUS_MEANING
, FUTURE_ACADEMIC_ALT_CODE
, FUTURE_ACADEMIC_CAL_TYPE
, FUTURE_ACAD_CAL_INST_SEQ_NUM
, FUTURE_ADMISSION_ALT_CODE
, 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_ALTERNATE_CODE
, 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.IGSFV_AD_ADM_PS_APPL_INST;
APPS.IGSFV_AD_ADM_PS_APPL_INST is not referenced by any database object
|
|
|