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

VIEW: APPS.IGS_PR_ACAD_TRANS_CREDIT_V

Object Details
Object Name: IGS_PR_ACAD_TRANS_CREDIT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PR_ACAD_TRANS_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 Person Transcript Units 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 and foreign key to HZ_PARTIES. This is a sequence generated value.
PERSON_NUMBER VARCHAR2 (30) Yes Unique identification number for this party
PROGRAM_CD VARCHAR2 (6) Yes A code used to identify the course in which the student is enrolled.See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
INSTITUTION_CODE VARCHAR2 (30)
Institution code
INSTITUTION_NAME VARCHAR2 (360)
Institution Name
INSTITUTION_TYPE VARCHAR2 (20)
Institution type
INSTITUTION_CITY VARCHAR2 (60)
Institution City
INSTITUTION_STATE VARCHAR2 (60)
Institution State
INSTITUTION_POSTAL_CODE VARCHAR2 (60)
Institution Postal code
START_DATE DATE

Start date
END_DATE DATE

End Date
PROGRAM_TYPE_ATTEMPTED VARCHAR2 (0)
Attempted Program type
PROGRAM_TYPE_EARNED VARCHAR2 (0)
Earned program type
PROGRAM_CODE VARCHAR2 (60)
Program code
TITLE VARCHAR2 (90)
Title
EDUCATION_ID NUMBER (15) Yes Unique identifier for education
CREDIT_POINTS NUMBER

Credit Points
Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      INSTITUTION_CODE
,      INSTITUTION_NAME
,      INSTITUTION_TYPE
,      INSTITUTION_CITY
,      INSTITUTION_STATE
,      INSTITUTION_POSTAL_CODE
,      START_DATE
,      END_DATE
,      PROGRAM_TYPE_ATTEMPTED
,      PROGRAM_TYPE_EARNED
,      PROGRAM_CODE
,      TITLE
,      EDUCATION_ID
,      CREDIT_POINTS
FROM APPS.IGS_PR_ACAD_TRANS_CREDIT_V;

Dependencies

[top of page]

APPS.IGS_PR_ACAD_TRANS_CREDIT_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_AD_ACAD_HISTORY_V
SynonymIGS_AD_TERM_DETAILS
SynonymIGS_AD_TERM_UNITDTLS
SynonymIGS_AD_TRANSCRIPT
SynonymIGS_AV_STND_UNIT_ALL
SynonymIGS_AV_STND_UNIT_LVL_ALL
SynonymIGS_EN_STDNT_PS_ATT_ALL
SynonymIGS_PE_HZ_PARTIES

APPS.IGS_PR_ACAD_TRANS_CREDIT_V is not referenced by any database object