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

VIEW: APPS.IGS_AS_SU_ATTEMPT_LKUP_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


Describes valid unit attempts for a student's attempt studying at a particular unit offered by the university.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person identifier
COURSE_CD VARCHAR2 (6) Yes Program code
UNIT_CD VARCHAR2 (10) Yes Unit code
VERSION_NUMBER NUMBER (3) Yes Unit version number
CAL_TYPE VARCHAR2 (10) Yes Calendar type
CI_SEQUENCE_NUMBER NUMBER (6) Yes Calendar instance sequence number
ACAD_ALTERNATE_CODE VARCHAR2 (10)
Academic alternate code
TEACH_ALTERNATE_CODE VARCHAR2 (10)
Teaching alternate code
LOCATION_CD VARCHAR2 (10) Yes Location code
UNIT_CLASS VARCHAR2 (10) Yes Unit class
CI_START_DT DATE
Yes Calendar instance effective start date
CI_END_DT DATE
Yes Calendar instance effective end date
UOO_ID NUMBER (7) Yes Unit offering option identifier
ENROLLED_DT DATE

Enrolled date
UNIT_ATTEMPT_STATUS VARCHAR2 (30) Yes Unit attempt status code
ADMINISTRATIVE_UNIT_STATUS VARCHAR2 (10)
Administrative unit status
DISCONTINUED_DT DATE

Discontinuation date
RULE_WAIVED_DT DATE

Rule waived date
RULE_WAIVED_PERSON_ID NUMBER (15)
Person who waived the rule
NO_ASSESSMENT_IND VARCHAR2 (1) Yes Indicates if assessment needs to be done
SUP_UNIT_CD VARCHAR2 (10)
Superior unit code
SUP_VERSION_NUMBER NUMBER (3)
Superior unit version number
EXAM_LOCATION_CD VARCHAR2 (10)
Examination location code
ALTERNATIVE_TITLE VARCHAR2 (90)
Alternative title
OVERRIDE_ENROLLED_CP NUMBER (6)
Override enrolled credit points
OVERRIDE_EFTSU NUMBER (7)
Override EFTSU
OVERRIDE_ACHIEVABLE_CP NUMBER (6)
Override achievable credit points
OVERRIDE_OUTCOME_DUE_DT DATE

Override outcome due date
OVERRIDE_CREDIT_REASON VARCHAR2 (2000)
Override credit reason
OUTCOME_DT DATE
Yes Outcome date
GRADING_SCHEMA_CD VARCHAR2 (10) Yes Grading schema code
GRADE VARCHAR2 (5) Yes Grade
MARK NUMBER (6)
Mark
TITLE VARCHAR2 (90) Yes Title
ENROLLED_CREDIT_POINTS NUMBER

Enrolled credit points
MEANING VARCHAR2 (80) Yes Unit attempt status meaning
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
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DEG_AUD_DETAIL_ID NUMBER

Degree Audit Detail Id
Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ACAD_ALTERNATE_CODE
,      TEACH_ALTERNATE_CODE
,      LOCATION_CD
,      UNIT_CLASS
,      CI_START_DT
,      CI_END_DT
,      UOO_ID
,      ENROLLED_DT
,      UNIT_ATTEMPT_STATUS
,      ADMINISTRATIVE_UNIT_STATUS
,      DISCONTINUED_DT
,      RULE_WAIVED_DT
,      RULE_WAIVED_PERSON_ID
,      NO_ASSESSMENT_IND
,      SUP_UNIT_CD
,      SUP_VERSION_NUMBER
,      EXAM_LOCATION_CD
,      ALTERNATIVE_TITLE
,      OVERRIDE_ENROLLED_CP
,      OVERRIDE_EFTSU
,      OVERRIDE_ACHIEVABLE_CP
,      OVERRIDE_OUTCOME_DUE_DT
,      OVERRIDE_CREDIT_REASON
,      OUTCOME_DT
,      GRADING_SCHEMA_CD
,      GRADE
,      MARK
,      TITLE
,      ENROLLED_CREDIT_POINTS
,      MEANING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEG_AUD_DETAIL_ID
FROM APPS.IGS_AS_SU_ATTEMPT_LKUP_V;

Dependencies

[top of page]

APPS.IGS_AS_SU_ATTEMPT_LKUP_V references the following:

SchemaAPPS
ViewIGS_AS_SU_STMPTOUT
PL/SQL PackageIGS_CA_GEN_001 - show dependent code
PL/SQL PackageIGS_EN_GEN_014 - show dependent code
ViewIGS_EN_SU_ATTEMPT
ViewIGS_LOOKUPS_VIEW
ViewIGS_PS_UNIT_OFR_OPT
ViewIGS_PS_UNIT_VER
SynonymIGS_PS_USEC_CPS

APPS.IGS_AS_SU_ATTEMPT_LKUP_V is not referenced by any database object