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


VIEW: APPS.IGS_AD_STDNT_PS_ATT_V

Object Details
Object Name: IGS_AD_STDNT_PS_ATT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AD_STDNT_PS_ATT_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
ROW_ID ROWID (10)
PERSON_ID NUMBER (15) Yes
PERSON_NUMBER VARCHAR2 (30) Yes
COURSE_CD VARCHAR2 (6) Yes
VERSION_NUMBER NUMBER (3) Yes
CAL_TYPE VARCHAR2 (10) Yes
LOCATION_CD VARCHAR2 (10) Yes
ATTENDANCE_MODE VARCHAR2 (2) Yes
ATTENDANCE_TYPE VARCHAR2 (2) Yes
COO_ID NUMBER (7) Yes
STUDENT_CONFIRMED_IND VARCHAR2 (1) Yes
COMMENCEMENT_DT DATE

COURSE_ATTEMPT_STATUS VARCHAR2 (30)
PROGRESSION_STATUS VARCHAR2 (30)
DERIVED_ATT_TYPE VARCHAR2 (2)
DERIVED_ATT_MODE VARCHAR2 (2)
PROVISIONAL_IND VARCHAR2 (1) Yes
DISCONTINUED_DT DATE

DISCONTINUATION_REASON_CD VARCHAR2 (10)
LAPSED_DT DATE

FUNDING_SOURCE VARCHAR2 (10)
EXAM_LOCATION_CD VARCHAR2 (10)
DERIVED_COMPLETION_YR NUMBER (4)
DERIVED_COMPLETION_PERD VARCHAR2 (1)
NOMINATED_COMPLETION_YR NUMBER (4)
NOMINATED_COMPLETION_PERD VARCHAR2 (30)
RULE_CHECK_IND VARCHAR2 (1) Yes
WAIVE_OPTION_CHECK_IND VARCHAR2 (1) Yes
LAST_RULE_CHECK_DT DATE

PUBLISH_OUTCOMES_IND VARCHAR2 (1) Yes
COURSE_RQRMNT_COMPLETE_IND VARCHAR2 (1) Yes
COURSE_RQRMNTS_COMPLETE_DT DATE

S_COMPLETED_SOURCE_TYPE VARCHAR2 (10)
OVERRIDE_TIME_LIMITATION NUMBER (4)
ADVANCED_STANDING_IND VARCHAR2 (1) Yes
FEE_CAT VARCHAR2 (10)
CORRESPONDENCE_CAT VARCHAR2 (10)
SELF_HELP_GROUP_IND VARCHAR2 (1) Yes
LOGICAL_DELETE_DT DATE

ADM_ADMISSION_APPL_NUMBER NUMBER (2)
ADM_NOMINATED_COURSE_CD VARCHAR2 (6)
ADM_SEQUENCE_NUMBER NUMBER (6)
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)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      COURSE_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      COO_ID
,      STUDENT_CONFIRMED_IND
,      COMMENCEMENT_DT
,      COURSE_ATTEMPT_STATUS
,      PROGRESSION_STATUS
,      DERIVED_ATT_TYPE
,      DERIVED_ATT_MODE
,      PROVISIONAL_IND
,      DISCONTINUED_DT
,      DISCONTINUATION_REASON_CD
,      LAPSED_DT
,      FUNDING_SOURCE
,      EXAM_LOCATION_CD
,      DERIVED_COMPLETION_YR
,      DERIVED_COMPLETION_PERD
,      NOMINATED_COMPLETION_YR
,      NOMINATED_COMPLETION_PERD
,      RULE_CHECK_IND
,      WAIVE_OPTION_CHECK_IND
,      LAST_RULE_CHECK_DT
,      PUBLISH_OUTCOMES_IND
,      COURSE_RQRMNT_COMPLETE_IND
,      COURSE_RQRMNTS_COMPLETE_DT
,      S_COMPLETED_SOURCE_TYPE
,      OVERRIDE_TIME_LIMITATION
,      ADVANCED_STANDING_IND
,      FEE_CAT
,      CORRESPONDENCE_CAT
,      SELF_HELP_GROUP_IND
,      LOGICAL_DELETE_DT
,      ADM_ADMISSION_APPL_NUMBER
,      ADM_NOMINATED_COURSE_CD
,      ADM_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.IGS_AD_STDNT_PS_ATT_V;

Dependencies

[top of page]

APPS.IGS_AD_STDNT_PS_ATT_V references the following:

SchemaAPPS
ViewIGS_EN_STDNT_PS_ATT
ViewIGS_PE_PERSON_BASE_V

APPS.IGS_AD_STDNT_PS_ATT_V is not referenced by any database object