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

VIEW: APPS.IGS_AD_PS_APPL_INST

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORG_ID NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

PREDICTED_GPA NUMBER (5)
ACADEMIC_INDEX VARCHAR2 (10)
APP_FILE_LOCATION VARCHAR2 (40)
APP_SOURCE_ID NUMBER (15)
WAITLIST_RANK VARCHAR2 (30)
ATHLETIC_GPA VARCHAR2 (0)
ATHLETIC_ELIGIBILITY_STATUS_ID VARCHAR2 (0)
ATTENT_OTHER_INST_CD VARCHAR2 (10)
EDU_GOAL_PRIOR_ENROLL_ID NUMBER (15)
DECISION_MAKE_ID NUMBER (15)
DECISION_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
DECISION_REASON_ID NUMBER (15)
DECISION_NOTES VARCHAR2 (2000)
PENDING_REASON_ID NUMBER (15)
DEFICIENCY_IN_PREP VARCHAR2 (240)
SPL_CONSIDER_COMMENTS VARCHAR2 (240)
APPLY_FOR_FINAID VARCHAR2 (1)
FINAID_APPLY_DATE DATE

PERSON_ID NUMBER (15) Yes
ADMISSION_APPL_NUMBER NUMBER (2) Yes
NOMINATED_COURSE_CD VARCHAR2 (6) Yes
SEQUENCE_NUMBER NUMBER (6) Yes
ADM_CAL_TYPE VARCHAR2 (10)
ADM_CI_SEQUENCE_NUMBER NUMBER (6)
COURSE_CD VARCHAR2 (6) Yes
CRV_VERSION_NUMBER NUMBER (3) Yes
LOCATION_CD VARCHAR2 (10)
ATTENDANCE_MODE VARCHAR2 (2)
ATTENDANCE_TYPE VARCHAR2 (2)
UNIT_SET_CD VARCHAR2 (10)
US_VERSION_NUMBER NUMBER (3)
PREFERENCE_NUMBER NUMBER (2)
ADM_DOC_STATUS VARCHAR2 (10) Yes
ADM_ENTRY_QUAL_STATUS VARCHAR2 (10) Yes
LATE_ADM_FEE_STATUS VARCHAR2 (10) Yes
ADM_OUTCOME_STATUS VARCHAR2 (10) Yes
ADM_OTCM_STATUS_AUTH_PERSON_ID NUMBER (15)
ADM_OUTCOME_STATUS_AUTH_DT DATE

ADM_OUTCOME_STATUS_REASON VARCHAR2 (60)
OFFER_DT DATE

OFFER_RESPONSE_DT DATE

PRPSD_COMMENCEMENT_DT DATE

ADM_CNDTNL_OFFER_STATUS VARCHAR2 (10) Yes
CNDTNL_OFFER_SATISFIED_DT DATE

CNDTNL_OFFER_MUST_BE_STSFD_IND VARCHAR2 (1) Yes
ADM_OFFER_RESP_STATUS VARCHAR2 (10) Yes
ACTUAL_RESPONSE_DT DATE

ADM_OFFER_DFRMNT_STATUS VARCHAR2 (10) Yes
DEFERRED_ADM_CAL_TYPE VARCHAR2 (10)
DEFERRED_ADM_CI_SEQUENCE_NUM NUMBER (6)
DEFERRED_TRACKING_ID NUMBER (9)
ASS_RANK NUMBER (3)
SECONDARY_ASS_RANK NUMBER (3)
INTRNTNL_ACCEPTANCE_ADVICE_NUM NUMBER (15)
ASS_TRACKING_ID NUMBER (9)
FEE_CAT VARCHAR2 (10)
HECS_PAYMENT_OPTION VARCHAR2 (10)
EXPECTED_COMPLETION_YR NUMBER (4)
EXPECTED_COMPLETION_PERD VARCHAR2 (1)
CORRESPONDENCE_CAT VARCHAR2 (10)
ENROLMENT_CAT VARCHAR2 (10)
FUNDING_SOURCE VARCHAR2 (10)
APPLICANT_ACPTNCE_CNDTN VARCHAR2 (2000)
CNDTNL_OFFER_CNDTN VARCHAR2 (2000)
SS_APPLICATION_ID NUMBER (15)
SS_PWD VARCHAR2 (30)
ENTRY_STATUS NUMBER

Entry Status
ENTRY_LEVEL NUMBER

Entry Level
SCH_APL_TO_ID NUMBER

School Application to Id
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
AUTHORIZED_DT DATE

Authorized Date
AUTHORIZING_PERS_ID NUMBER (15)
Authorized Person Id
IDX_CALC_DATE DATE

Index Calculation Date
WAITLIST_STATUS VARCHAR2 (30)
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE31 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE32 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE33 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE34 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE35 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE36 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE37 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE38 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE39 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE40 VARCHAR2 (240)
Descriptive Flexfield Column
FUTURE_ACAD_CAL_TYPE VARCHAR2 (10)
Future academic calendar type
FUTURE_ACAD_CI_SEQUENCE_NUMBER NUMBER (6)
Future academic calendar type instance
FUTURE_ADM_CAL_TYPE VARCHAR2 (10)
Future admission calendar type
FUTURE_ADM_CI_SEQUENCE_NUMBER NUMBER (6)
Future admission calendar type instance
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
APPL_INST_STATUS VARCHAR2 (10)
Application Instance Status
AIS_REASON VARCHAR2 (60)
Application Instance Status Reason
DECLINE_OFR_REASON VARCHAR2 (60)
Query Text

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


SELECT ROW_ID
,      ORG_ID
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PREDICTED_GPA
,      ACADEMIC_INDEX
,      APP_FILE_LOCATION
,      APP_SOURCE_ID
,      WAITLIST_RANK
,      ATHLETIC_GPA
,      ATHLETIC_ELIGIBILITY_STATUS_ID
,      ATTENT_OTHER_INST_CD
,      EDU_GOAL_PRIOR_ENROLL_ID
,      DECISION_MAKE_ID
,      DECISION_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      DECISION_REASON_ID
,      DECISION_NOTES
,      PENDING_REASON_ID
,      DEFICIENCY_IN_PREP
,      SPL_CONSIDER_COMMENTS
,      APPLY_FOR_FINAID
,      FINAID_APPLY_DATE
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      PREFERENCE_NUMBER
,      ADM_DOC_STATUS
,      ADM_ENTRY_QUAL_STATUS
,      LATE_ADM_FEE_STATUS
,      ADM_OUTCOME_STATUS
,      ADM_OTCM_STATUS_AUTH_PERSON_ID
,      ADM_OUTCOME_STATUS_AUTH_DT
,      ADM_OUTCOME_STATUS_REASON
,      OFFER_DT
,      OFFER_RESPONSE_DT
,      PRPSD_COMMENCEMENT_DT
,      ADM_CNDTNL_OFFER_STATUS
,      CNDTNL_OFFER_SATISFIED_DT
,      CNDTNL_OFFER_MUST_BE_STSFD_IND
,      ADM_OFFER_RESP_STATUS
,      ACTUAL_RESPONSE_DT
,      ADM_OFFER_DFRMNT_STATUS
,      DEFERRED_ADM_CAL_TYPE
,      DEFERRED_ADM_CI_SEQUENCE_NUM
,      DEFERRED_TRACKING_ID
,      ASS_RANK
,      SECONDARY_ASS_RANK
,      INTRNTNL_ACCEPTANCE_ADVICE_NUM
,      ASS_TRACKING_ID
,      FEE_CAT
,      HECS_PAYMENT_OPTION
,      EXPECTED_COMPLETION_YR
,      EXPECTED_COMPLETION_PERD
,      CORRESPONDENCE_CAT
,      ENROLMENT_CAT
,      FUNDING_SOURCE
,      APPLICANT_ACPTNCE_CNDTN
,      CNDTNL_OFFER_CNDTN
,      SS_APPLICATION_ID
,      SS_PWD
,      ENTRY_STATUS
,      ENTRY_LEVEL
,      SCH_APL_TO_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      AUTHORIZED_DT
,      AUTHORIZING_PERS_ID
,      IDX_CALC_DATE
,      WAITLIST_STATUS
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE31
,      ATTRIBUTE32
,      ATTRIBUTE33
,      ATTRIBUTE34
,      ATTRIBUTE35
,      ATTRIBUTE36
,      ATTRIBUTE37
,      ATTRIBUTE38
,      ATTRIBUTE39
,      ATTRIBUTE40
,      FUTURE_ACAD_CAL_TYPE
,      FUTURE_ACAD_CI_SEQUENCE_NUMBER
,      FUTURE_ADM_CAL_TYPE
,      FUTURE_ADM_CI_SEQUENCE_NUMBER
,      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
,      APPL_INST_STATUS
,      AIS_REASON
,      DECLINE_OFR_REASON
FROM APPS.IGS_AD_PS_APPL_INST;

Dependencies

[top of page]

APPS.IGS_AD_PS_APPL_INST references the following:

SchemaAPPS
SynonymIGS_AD_PS_APPL_INST_ALL
APPS.IGS_AD_PS_APPL_INST is referenced by following:

SchemaAPPS
Package BodyIGF_AP_GEN_001 - show dependent code
Package BodyIGF_AP_OSS_INTEGR - show dependent code
Package BodyIGF_AP_OSS_INTR_DTLS - show dependent code
PL/SQL PackageIGF_AP_OSS_INTR_DTLS - show dependent code
Package BodyIGF_AW_RULE - show dependent code
Package BodyIGF_SL_GEN - show dependent code
Package BodyIGS_ADMAPPLICATION_PUB - show dependent code
ViewIGS_AD_ACK_LETTER_V
PL/SQL PackageIGS_AD_AC_COMP - show dependent code
Package BodyIGS_AD_AC_COMP - show dependent code
Package BodyIGS_AD_ADM_REQ - show dependent code
Package BodyIGS_AD_APPL_NOTES_PKG - show dependent code
Package BodyIGS_AD_CANCEL_RECONSIDER - show dependent code
PL/SQL PackageIGS_AD_DEF_APPL_PKG - show dependent code
Package BodyIGS_AD_DEF_APPL_PKG - show dependent code
Package BodyIGS_AD_GEN_001 - show dependent code
PL/SQL PackageIGS_AD_GEN_002 - show dependent code
Package BodyIGS_AD_GEN_002 - show dependent code
Package BodyIGS_AD_GEN_003 - show dependent code
Package BodyIGS_AD_GEN_004 - show dependent code
Package BodyIGS_AD_GEN_006 - show dependent code
Package BodyIGS_AD_GEN_007 - show dependent code
Package BodyIGS_AD_GEN_008 - show dependent code
Package BodyIGS_AD_GEN_010 - show dependent code
Package BodyIGS_AD_GEN_011 - show dependent code
Package BodyIGS_AD_GEN_012 - show dependent code
Package BodyIGS_AD_GEN_014 - show dependent code
Package BodyIGS_AD_IMP_004 - show dependent code
Package BodyIGS_AD_IMP_027 - show dependent code
Package BodyIGS_AD_IMP_ADM_DES - show dependent code
PL/SQL PackageIGS_AD_IMP_ADM_DES - show dependent code
Package BodyIGS_AD_IMP_OFF_RESP_DATA - show dependent code
Package BodyIGS_AD_INT_RECONSIDER - show dependent code
PL/SQL PackageIGS_AD_INT_RECONSIDER - show dependent code
ViewIGS_AD_KEY_ACAD_IND_V
ViewIGS_AD_MKADM_DES_INT_V
ViewIGS_AD_PANEL_DTLS_V
Package BodyIGS_AD_PRC_TAC_OFFER - show dependent code
Package BodyIGS_AD_PS_APLINSTUNT_PKG - show dependent code
ViewIGS_AD_PS_APL_INST_CNTX_V
ViewIGS_AD_PS_APPL_INST_APLSUMR_V
ViewIGS_AD_PS_APPL_INST_CONTEXT_V
PL/SQL PackageIGS_AD_PS_APPL_INST_PKG - show dependent code
Package BodyIGS_AD_PS_APPL_INST_PKG - show dependent code
Package BodyIGS_AD_SS_APPL_FEE_PKG - show dependent code
PL/SQL PackageIGS_AD_SS_APPL_UPD_PAGE - show dependent code
Package BodyIGS_AD_SS_APPL_UPD_PAGE - show dependent code
Package BodyIGS_AD_SS_GEN_001 - show dependent code
PL/SQL PackageIGS_AD_SS_GEN_001 - show dependent code
Package BodyIGS_AD_SUSPEND_APPL_PKG - show dependent code
Package BodyIGS_AD_TI_COMP - show dependent code
PL/SQL PackageIGS_AD_TI_COMP - show dependent code
Package BodyIGS_AD_UPD_INITIALISE - show dependent code
PL/SQL PackageIGS_AD_UPD_INITIALISE - show dependent code
Package BodyIGS_AD_VAL_AA - show dependent code
Package BodyIGS_AD_VAL_ACA - show dependent code
Package BodyIGS_AD_VAL_ACAI - show dependent code
Package BodyIGS_AD_VAL_ACAIU - show dependent code
PL/SQL PackageIGS_AD_VAL_ACAI_FTR_OFFER - show dependent code
Package BodyIGS_AD_VAL_ACAI_FTR_OFFER - show dependent code
Package BodyIGS_AD_VAL_ACAI_STATUS - show dependent code
Package BodyIGS_CO_GEN_003 - show dependent code
Package BodyIGS_CO_PROCESS - show dependent code
Package BodyIGS_EN_GEN_002 - show dependent code
Package BodyIGS_EN_GEN_003 - show dependent code
Package BodyIGS_EN_GEN_006 - show dependent code
Package BodyIGS_EN_GEN_008 - show dependent code
Package BodyIGS_EN_GEN_010 - show dependent code
Package BodyIGS_EN_GEN_011 - show dependent code
Package BodyIGS_EN_HESA_PKG - show dependent code
Package BodyIGS_EN_VAL_SCA - show dependent code
Package BodyIGS_EN_VAL_SCT - show dependent code
Package BodyIGS_EN_VAL_SUSA - show dependent code
Package BodyIGS_FI_CRDAPI_UTIL - show dependent code
Package BodyIGS_FI_PRC_STDNT_DPSTS - show dependent code
Package BodyIGS_PR_GEN_004 - show dependent code
Package BodyIGS_PS_GEN_002 - show dependent code
Package BodyIGS_RATINGS_PUB - show dependent code
ViewIGS_RE_CANDIDATURE_V
Package BodyIGS_RE_GEN_001 - show dependent code
Package BodyIGS_RE_GEN_002 - show dependent code
Package BodyIGS_RE_VAL_CA - show dependent code
Package BodyIGS_RE_VAL_RSUP - show dependent code
Package BodyIGS_UC_EXPORT_TO_OSS - show dependent code
Package BodyIGS_UC_TRX_GEN_HOOK - show dependent code
PL/SQL PackageIGS_UC_TRX_GEN_HOOK - show dependent code