DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_AD_PS_APPL_INST_APLSUMR_V

Object Details
Object Name: IGS_AD_PS_APPL_INST_APLSUMR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AD_PS_APPL_INST_APLSUMR_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes This field describes the ID of the person that the admission application is for.
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.
COMMENCEMENT_PERIOD VARCHAR2 (21)
This field describes the commencement period the admission application is applicable for.
ORIGINAL_COMMENCEMENT_PERIOD VARCHAR2 (21)
This field describes the original commencement period the admission application is applicable for.
OVERRIDE_COMMENCEMENT_PERIOD VARCHAR2 (21)
This field describes the override commencement period the admission application is applicable for.
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.
ACAD_CI_START_DT DATE
Yes The date from which a calendar instance becomes effective. For example, the calendar instance Semester 1 1999 may commence on 1/3/1999.
ACAD_CI_END_DT DATE
Yes The date from which a calendar instance is no longer effective. For example, the calendar instance Semester 1 1999 may end on 11/6/1999.
ADM_CAL_TYPE VARCHAR2 (10)
This field describes the admission calendar type to which the admission application applies.
ADM_CI_SEQUENCE_NUMBER NUMBER

This field describes the admission calendar sequence number that the admission application is for.
ADM_CI_START_DT DATE
Yes The date from which a calendar instance becomes effective. For example, the calendar instance Semester 1 1999 may commence on 1/3/1999.
ADM_CI_END_DT DATE
Yes The date from which a calendar instance is no longer effective. For example, the calendar instance Semester 1 1999 may end on 11/6/1999.
ADMISSION_PROCESS_CAT VARCHAR2 (91)
This field describes the admission process category of the admission application.
ADMISSION_CAT VARCHAR2 (10) Yes This field describes the institution-defined admission category of the admission application.
S_ADMISSION_PROCESS_TYPE VARCHAR2 (30) Yes This field describes the system-defined admission process type of the admission application.
APPL_DT DATE
Yes
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.
CRV_TITLE VARCHAR2 (90)
The title or full name of the course. (DETYA element 308).
PREFERENCE_NUMBER NUMBER (2)
ADM_COURSE_APPL_INSTANCE.PREFERENCE_NUMBER
ADM_APPL_STATUS VARCHAR2 (10) Yes This field describes the institution-defined application status of the admission application.
ADM_OUTCOME_STATUS VARCHAR2 (10) Yes This field describes the outcome status of the admission course application instance.
ADM_OFFER_RESP_STATUS VARCHAR2 (10) Yes This field describes the offer response status of the admission course application instance.
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)
CHOICE_NUMBER NUMBER (3)
Choice number
FUTURE_ACAD_CAL_TYPE VARCHAR2 (10)
Future academic calendar type
FUTURE_ACAD_CI_SEQUENCE_NUMBER NUMBER (6)
Future academic calendar type instance
FUTURE_ACAD_ALTERNATE_CODE VARCHAR2 (10)
Future academic alternate code
FUTURE_ADM_CAL_TYPE VARCHAR2 (10)
Future admission calendar type
FUTURE_ADM_CI_SEQUENCE_NUMBER NUMBER (6)
Future admission calendar type instance
FUTURE_ADM_ALTERNATE_CODE VARCHAR2 (10)
Future admission alternate code
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
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
DEF_ADM_ALTERNATE_CODE VARCHAR2 (10)
Deferred Term Admission Alternate Code
DEF_ACAD_ALTERNATE_CODE VARCHAR2 (10)
Deferred Term Academic Alternate Code
APPLICATION_TYPE VARCHAR2 (30)
Admission Application Type
APPLICATION_ID NUMBER (15)
Application identifier
ALT_APPL_ID VARCHAR2 (30)
Alternate Application ID
APPL_INST_STATUS VARCHAR2 (10)
Application Instance Status
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      COMMENCEMENT_PERIOD
,      ORIGINAL_COMMENCEMENT_PERIOD
,      OVERRIDE_COMMENCEMENT_PERIOD
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ACAD_CI_START_DT
,      ACAD_CI_END_DT
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ADM_CI_START_DT
,      ADM_CI_END_DT
,      ADMISSION_PROCESS_CAT
,      ADMISSION_CAT
,      S_ADMISSION_PROCESS_TYPE
,      APPL_DT
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      CRV_TITLE
,      PREFERENCE_NUMBER
,      ADM_APPL_STATUS
,      ADM_OUTCOME_STATUS
,      ADM_OFFER_RESP_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CHOICE_NUMBER
,      FUTURE_ACAD_CAL_TYPE
,      FUTURE_ACAD_CI_SEQUENCE_NUMBER
,      FUTURE_ACAD_ALTERNATE_CODE
,      FUTURE_ADM_CAL_TYPE
,      FUTURE_ADM_CI_SEQUENCE_NUMBER
,      FUTURE_ADM_ALTERNATE_CODE
,      PREVIOUS_TERM_ADM_APPL_NUMBER
,      PREVIOUS_TERM_SEQUENCE_NUMBER
,      FUTURE_TERM_ADM_APPL_NUMBER
,      FUTURE_TERM_SEQUENCE_NUMBER
,      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
,      DEF_ADM_ALTERNATE_CODE
,      DEF_ACAD_ALTERNATE_CODE
,      APPLICATION_TYPE
,      APPLICATION_ID
,      ALT_APPL_ID
,      APPL_INST_STATUS
FROM APPS.IGS_AD_PS_APPL_INST_APLSUMR_V;

Dependencies

[top of page]

APPS.IGS_AD_PS_APPL_INST_APLSUMR_V references the following:

SchemaAPPS
ViewIGS_AD_APPL
ViewIGS_AD_PS_APPL_INST
ViewIGS_CA_INST
ViewIGS_LOOKUP_VALUES
ViewIGS_PS_VER
APPS.IGS_AD_PS_APPL_INST_APLSUMR_V is referenced by following:

SchemaAPPS
Package BodyIGS_AD_GEN_004 - show dependent code