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

VIEW: APPS.IGSFV_AV_ADV_STND_UNIT_LEVEL

Object Details
Object Name: IGSFV_AV_ADV_STND_UNIT_LEVEL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_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
PERSON_NUMBER VARCHAR2 (30) Yes Describes the person number.
PERSON_NAME VARCHAR2 (360) Yes Describes the person name.
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.
PROGRAM_TITLE VARCHAR2 (90) Yes Program Title of a program
EXEMPTION_INSTITUTION_CODE VARCHAR2 (30) 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_NAME VARCHAR2 (360) Yes Describes the level description that advanced standing is being given. For example, first year level within a program, 2 - second year level within a program.
ADV_STAND_UNIT_LEVEL VARCHAR2 (4) Yes Describes the institution code that student undertook the study that resulted in the unit level advanced standing.
ADV_STAND_UNIT_LEVEL_DESCR VARCHAR2 (60) Yes Describes the institution Name that student undertook the study that resulted in the unit level advanced standing.
PREVIOUS_UNIT_CODE VARCHAR2 (10)
Describes the unit abbreviation from the student's academic history
PREVIOUS_UNIT_NAME VARCHAR2 (80)
Description of the unit from the student's academic history
PREVIOUS_TERM VARCHAR2 (30)
Describes the term in which the previous unit was taken
ADMISSION_TEST_TYPE VARCHAR2 (30)
Describes the types of admission test against that results may be recorded for a student
TEST_SEGMENT_NAME VARCHAR2 (30)
Describes the sub category of the admission test type
EXAM_LEVEL_DESCRIPTION VARCHAR2 (90)
Description of the Qualification or award (UK).
ADV_STANDING_TYPE VARCHAR2 (10) Yes Describes the type of advanced standing.
CAL_TYPE VARCHAR2 (10)
Describes the Calendar Type.
CI_SEQUENCE_NUMBER NUMBER (6)
Describes the sequence number.
TERM_CALENDAR VARCHAR2 (30)
Description of the Calendar instance
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.
AUTHORISING_PERSON_NUMBER VARCHAR2 (30) Yes Describes the Person Number of the officer who authorized the advanced standing.
AUTHORISING_PERSON_NAME VARCHAR2 (360) Yes Describes the Person Name of the officer who authorized the advanced standing.
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 PERSON_NUMBER
,      PERSON_NAME
,      PROGRAM_CODE
,      PROGRAM_VERSION_NUMBER
,      PROGRAM_TITLE
,      EXEMPTION_INSTITUTION_CODE
,      EXEMPTION_INSTITUTION_NAME
,      ADV_STAND_UNIT_LEVEL
,      ADV_STAND_UNIT_LEVEL_DESCR
,      PREVIOUS_UNIT_CODE
,      PREVIOUS_UNIT_NAME
,      PREVIOUS_TERM
,      ADMISSION_TEST_TYPE
,      TEST_SEGMENT_NAME
,      EXAM_LEVEL_DESCRIPTION
,      ADV_STANDING_TYPE
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      TERM_CALENDAR
,      CREDIT_POINTS
,      _LA:ASUL_GRANTING_STATUS
,      APPROVED_DT
,      AUTHORISING_PERSON_NUMBER
,      AUTHORISING_PERSON_NAME
,      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.IGSFV_AV_ADV_STND_UNIT_LEVEL;

Dependencies

[top of page]

APPS.IGSFV_AV_ADV_STND_UNIT_LEVEL references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_AD_TERM_DETAILS
SynonymIGS_AD_TERM_UNITDTLS
SynonymIGS_AD_TEST_SEGMENTS
SynonymIGS_AD_TST_RSLT_DTLS
SynonymIGS_AV_STND_UNIT_LVL_ALL
SynonymIGS_CA_INST_ALL
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PS_AWD
SynonymIGS_PS_UNIT_LEVEL_ALL
SynonymIGS_PS_VER_ALL
SynonymIGS_UC_QUAL_DETS

APPS.IGSFV_AV_ADV_STND_UNIT_LEVEL is not referenced by any database object