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

VIEW: APPS.IGSBV_AV_ADV_STND_UNIT_LEVEL

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

View Type

A Business Intelligence System view


Describes the number of advanced standing credit points granted to a student at a given level.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROGRAM_CODE VARCHAR2 (6) Yes Describes the program against advanced standing that is approved or granted.
PROGRAM_VERSION_NUMBER NUMBER (3) Yes Describes the version number of the program against advanced standing that is approved or granted.
ADV_STANDING_TYPE VARCHAR2 (10) Yes Describes the type of advanced standing.
ADV_STND_UNIT_LEVEL VARCHAR2 (4) Yes Describes the level that advanced standing is being given. For example, first year level within a program, 2 - second year level within a program.
EXEMPTION_INSTITUTION_CODE VARCHAR2 (30) Yes Describes the institution that student undertook the study that resulted in the unit level advanced standing.
CAL_TYPE VARCHAR2 (10)
Describes the Calendar Type.
CI_SEQUENCE_NUMBER NUMBER (6)
Describes the sequence number.
CREDIT_POINTS NUMBER (6) Yes Describes the granting status of the advanced standing unit level record. For example, CANCELLED, GRANTED, REVOKED.
_LA:ASUL_GRANTING_STATUS CHAR (86)
Describes the number of credit points that have been awarded as advanced standing at a particular unit level to a student.
APPROVED_DT DATE
Yes Describes the date the unit level was approved for advanced standing purposes.
GRANTED_DT DATE

Describes the date the granting status of the unit level advanced standing was changed to GRANTED.
EXPIRY_DT DATE

Describes the date the approval for the advanced standing unit level expired.
CANCELLED_DT DATE

Describes the date the granting status of the unit level record was changed to CANCELLED.
REVOKED_DT DATE

Describes the date the granting status of the unit level advanced standing was changed to REVOKED.
COMMENTS VARCHAR2 (2000)
Provides comments about the advanced standing unit level record.
PROGRAM_GROUP_IND VARCHAR2 (1) Yes Describes whether the unit level credit is to be regarded as program-grouped.
ADV_STAND_UNIT_LEVEL_ID NUMBER (15) Yes System Generated number to store the primary key
PERSON_ID NUMBER (15) Yes Describes the ID that uniquely identifies a person.
UNIT_DETAILS_ID NUMBER (15)
Previous unit identifier
TST_RSLT_DTLS_ID NUMBER (15)
Test segment identifier
QUAL_DETS_ID NUMBER

Qualification details Identifier
DEG_AUD_DETAIL_ID NUMBER

Degree Audit Details ID
AUTHORISING_PERSON_ID NUMBER (15) Yes Describes the Person ID of the officer who authorized the advanced standing.
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
UNIT_LEVEL_MARK NUMBER (6)
Contains the Unit Level Mark to be included in the Summary Measures of Attainment calculations.
Query Text

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


SELECT PROGRAM_CODE
,      PROGRAM_VERSION_NUMBER
,      ADV_STANDING_TYPE
,      ADV_STND_UNIT_LEVEL
,      EXEMPTION_INSTITUTION_CODE
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CREDIT_POINTS
,      _LA:ASUL_GRANTING_STATUS
,      APPROVED_DT
,      GRANTED_DT
,      EXPIRY_DT
,      CANCELLED_DT
,      REVOKED_DT
,      COMMENTS
,      PROGRAM_GROUP_IND
,      ADV_STAND_UNIT_LEVEL_ID
,      PERSON_ID
,      UNIT_DETAILS_ID
,      TST_RSLT_DTLS_ID
,      QUAL_DETS_ID
,      DEG_AUD_DETAIL_ID
,      AUTHORISING_PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      UNIT_LEVEL_MARK
FROM APPS.IGSBV_AV_ADV_STND_UNIT_LEVEL;

Dependencies

[top of page]

APPS.IGSBV_AV_ADV_STND_UNIT_LEVEL references the following:

SchemaAPPS
SynonymIGS_AV_STND_UNIT_LVL_ALL

APPS.IGSBV_AV_ADV_STND_UNIT_LEVEL is not referenced by any database object