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

TABLE: IGS.IGS_AD_TRANSCRIPT

Object Details
Object Name: IGS_AD_TRANSCRIPT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_AD_TRANSCRIPT
Subobject Name:
Status: VALID


IGS_AD_TRANSCRIPT holds institution's transcript details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AD_TRANSCRIPT_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSCRIPT_ID
IGS_AD_TRANSCRIPT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEDUCATION_ID
IGS_AD_TRANSCRIPT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONV_GS_ID
IGS_AD_TRANSCRIPT_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTERED_GS_ID
IGS_AD_TRANSCRIPT_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSCRIPT_SOURCE
Columns
Name Datatype Length Mandatory Comments
TRANSCRIPT_ID NUMBER (15) Yes Unique identifier for the transcript details
EDUCATION_ID NUMBER (15) Yes Academic history identifier
TRANSCRIPT_STATUS VARCHAR2 (30) Yes Transcript status
TRANSCRIPT_SOURCE NUMBER (15) Yes Transcript source
DATE_OF_RECEIPT DATE

Date of receipt of transcript
ENTERED_GPA VARCHAR2 (30)
Grade point average for the institution
ENTERED_GS_ID NUMBER (15) Yes Grade point average scale type for the entered GPA
CONV_GPA VARCHAR2 (30)
Grade point average for the institution as per the institutions gpa scale type
CONV_GS_ID NUMBER (15) Yes Institution grading scale
TERM_TYPE VARCHAR2 (1) Yes Tells the type of attendance mode Q - Quarter, S - Semester, T - Trimester
RANK_IN_CLASS NUMBER (5)
Rank in class
CLASS_SIZE NUMBER (5)
Class size
APPROXIMATE_RANK VARCHAR2 (1)
Y or Null
WEIGHTED_RANK VARCHAR2 (1)
Y or Null
DECILE_RANK NUMBER

Decile rank
QUARTILE_RANK NUMBER

Quartile rank
QUINTILE_RANK NUMBER

Quintile rank
PERCENTILE_RANK NUMBER

Percentile rank
TRANSCRIPT_TYPE VARCHAR2 (30)
This indicates if the Transcript is Official or Unofficial
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
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program
OVERRIDE VARCHAR2 (1)
Override Indicator column to indicate manual override of formula values for Percentile, Decile, Quartile and Quintile.
OVERRIDE_ID NUMBER (15)
User ID of the person who has done the override.
OVERRIDE_DATE DATE

Date on which override has been done.
DATE_OF_ISSUE DATE

Date on which the transcript is issued
CORE_CURRICULUM_VALUE VARCHAR2 (10)
This value indicates the level a student has attained in high school toward the 'core curriculum'
Query Text

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


SELECT TRANSCRIPT_ID
,      EDUCATION_ID
,      TRANSCRIPT_STATUS
,      TRANSCRIPT_SOURCE
,      DATE_OF_RECEIPT
,      ENTERED_GPA
,      ENTERED_GS_ID
,      CONV_GPA
,      CONV_GS_ID
,      TERM_TYPE
,      RANK_IN_CLASS
,      CLASS_SIZE
,      APPROXIMATE_RANK
,      WEIGHTED_RANK
,      DECILE_RANK
,      QUARTILE_RANK
,      QUINTILE_RANK
,      PERCENTILE_RANK
,      TRANSCRIPT_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OVERRIDE
,      OVERRIDE_ID
,      OVERRIDE_DATE
,      DATE_OF_ISSUE
,      CORE_CURRICULUM_VALUE
FROM IGS.IGS_AD_TRANSCRIPT;

Dependencies

[top of page]

IGS.IGS_AD_TRANSCRIPT does not reference any database object

IGS.IGS_AD_TRANSCRIPT is referenced by following:

SchemaAPPS
SynonymIGS_AD_TRANSCRIPT