[Home] [Help]
[Dependency Information]
[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
HZ_PARTIES
HZ_PERSON_PROFILES
IGS_AD_CNDNL_OFRSTAT
IGS_AD_CODE_CLASSES
IGS_AD_DOC_STAT
IGS_AD_ENT_QF_STAT
IGS_AD_FEE_STAT
IGS_AD_LOCATION_ALL
IGS_AD_OFRDFRMT_STAT
IGS_AD_OFR_RESP_STAT
IGS_AD_OU_STAT
IGS_AD_PS_APPL_INST_ALL
IGS_AD_SCHL_APLY_TO
IGS_CA_INST_ALL
IGS_CO_CAT
IGS_EN_ATD_MODE_ALL
IGS_EN_ATD_TYPE_ALL
IGS_EN_ENROLMENT_CAT
IGS_EN_UNIT_SET_ALL
IGS_FI_FEE_CAT_ALL
IGS_FI_FUND_SRC_ALL
IGS_FI_HECS_PAY_OPTN
IGS_GE_GEN_001
- show dependent code
IGS_PE_HZ_PARTIES
IGS_PS_VER_ALL
APPS.IGSFV_AD_ADM_PS_APPL_INST is not referenced by any database object
|
|
|
|