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


VIEW: APPS.IGS_AS_SU_STMPTOUT_MID

Object Details
Object Name: IGS_AS_SU_STMPTOUT_MID
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AS_SU_STMPTOUT_MID
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_NUMBER VARCHAR2 (30) Yes
PERSON_ID NUMBER (15) Yes
COURSE_CD VARCHAR2 (6) Yes
UNIT_CD VARCHAR2 (10) Yes
CAL_TYPE VARCHAR2 (10) Yes
CI_SEQUENCE_NUMBER NUMBER (6) Yes
CI_START_DT DATE
Yes
CI_END_DT DATE
Yes
OUTCOME_DT DATE
Yes
GRADING_SCHEMA_CD VARCHAR2 (10) Yes
VERSION_NUMBER NUMBER (3) Yes
GRADE VARCHAR2 (5) Yes
S_GRADE_CREATION_METHOD_TYPE VARCHAR2 (30) Yes
FINALISED_OUTCOME_IND VARCHAR2 (1) Yes
MARK NUMBER (6)
NUMBER_TIMES_KEYED NUMBER (2)
TRANSLATED_GRADING_SCHEMA_CD VARCHAR2 (10)
TRANSLATED_VERSION_NUMBER NUMBER (3)
TRANSLATED_GRADE VARCHAR2 (5)
TRANSLATED_DT DATE

DSP_VERSION_NUMBER NUMBER (3) Yes
DSP_TITLE VARCHAR2 (90) Yes
DSP_CONTEXT_BLOCK_NAME VARCHAR2 (450)
DSP_SEX VARCHAR2 (80) Yes
DSP_BIRTH_DT DATE

API_PERSON_ID VARCHAR2 (20)
DSP_ALTERNATE_CODE VARCHAR2 (10)
DSP_VERSION_NUMBER2 NUMBER (3) Yes
DSP_TITLE2 VARCHAR2 (90) Yes
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

UOO_ID NUMBER (7) Yes Unit Section identifier
MARK_CAPPED_FLAG VARCHAR2 (1)
Allows user to indicate whether marks have been capped for a student unit attempt outcome
SHOW_ON_ACADEMIC_HISTRY_FLAG VARCHAR2 (1)
Allows user to define whether the changed grade be displayed on the Academic History self-service page.
RELEASE_DATE DATE

Date on which the student unit attempt outcome will be released to the student for viewing
MANUAL_OVERRIDE_FLAG VARCHAR2 (1)
The user should select this checkbox to keep the system from replacing the manually assigned marks with the system calculated ones.
Query Text

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


SELECT ROW_ID
,      PERSON_NUMBER
,      PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      OUTCOME_DT
,      GRADING_SCHEMA_CD
,      VERSION_NUMBER
,      GRADE
,      S_GRADE_CREATION_METHOD_TYPE
,      FINALISED_OUTCOME_IND
,      MARK
,      NUMBER_TIMES_KEYED
,      TRANSLATED_GRADING_SCHEMA_CD
,      TRANSLATED_VERSION_NUMBER
,      TRANSLATED_GRADE
,      TRANSLATED_DT
,      DSP_VERSION_NUMBER
,      DSP_TITLE
,      DSP_CONTEXT_BLOCK_NAME
,      DSP_SEX
,      DSP_BIRTH_DT
,      API_PERSON_ID
,      DSP_ALTERNATE_CODE
,      DSP_VERSION_NUMBER2
,      DSP_TITLE2
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      UOO_ID
,      MARK_CAPPED_FLAG
,      SHOW_ON_ACADEMIC_HISTRY_FLAG
,      RELEASE_DATE
,      MANUAL_OVERRIDE_FLAG
FROM APPS.IGS_AS_SU_STMPTOUT_MID;

Dependencies

[top of page]

APPS.IGS_AS_SU_STMPTOUT_MID references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
ViewIGS_AS_SU_STMPTOUT
ViewIGS_CA_INST
PL/SQL PackageIGS_EN_GEN_003 - show dependent code
PL/SQL PackageIGS_EN_GEN_007 - show dependent code
ViewIGS_EN_STDNT_PS_ATT
ViewIGS_EN_SU_ATTEMPT
ViewIGS_PE_PERSON_V
ViewIGS_PS_UNIT_VER
ViewIGS_PS_VER
APPS.IGS_AS_SU_STMPTOUT_MID is referenced by following:

SchemaAPPS
ViewIGS_AS_SUAO_MID_V