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

VIEW: APPS.IGS_PR_ACAD_EXAM_CREDIT_V

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

View Type

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


This view contains the details of credit granted through advanced standing based on the Admissions Exam structure. The credit is shown only as an aggregated summary figure.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person Identifier
PARTY_NUMBER VARCHAR2 (30) Yes Person Identifier
PROGRAM_CD VARCHAR2 (6) Yes Program Code
ADMISSION_TEST_TYPE VARCHAR2 (30) Yes Test type
ADMISSION_TEST_DESCRIPTION VARCHAR2 (60) Yes Test type description
TEST_DATE DATE
Yes Test date
TEST_SEGMENT_NAME VARCHAR2 (30) Yes Segment name
TEST_SEGMENT_DESCRIPTION VARCHAR2 (80) Yes Segment description
TEST_SCORE NUMBER

Test score
TST_RSLT_DTLS_ID NUMBER (15) Yes Test result unique identifier
CREDIT_POINTS NUMBER

Credit Points
Query Text

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


SELECT PERSON_ID
,      PARTY_NUMBER
,      PROGRAM_CD
,      ADMISSION_TEST_TYPE
,      ADMISSION_TEST_DESCRIPTION
,      TEST_DATE
,      TEST_SEGMENT_NAME
,      TEST_SEGMENT_DESCRIPTION
,      TEST_SCORE
,      TST_RSLT_DTLS_ID
,      CREDIT_POINTS
FROM APPS.IGS_PR_ACAD_EXAM_CREDIT_V;

Dependencies

[top of page]

APPS.IGS_PR_ACAD_EXAM_CREDIT_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_AD_TEST_SEG_RESULTS_V
SynonymIGS_AV_STND_UNIT_ALL
SynonymIGS_AV_STND_UNIT_LVL_ALL
SynonymIGS_EN_STDNT_PS_ATT_ALL

APPS.IGS_PR_ACAD_EXAM_CREDIT_V is not referenced by any database object