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

TABLE: IGF.IGF_AP_STUD_SAP_DT_OLD

Object Details
Object Name: IGF_AP_STUD_SAP_DT_OLD
Object Type: TABLE
Owner: IGF
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AP_STUD_SAP_DTLS_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSSD_ID
Columns
Name Datatype Length Mandatory Comments
SSD_ID NUMBER (15) Yes
PERSON_ID NUMBER (15) Yes
SAP_TYPE VARCHAR2 (30) Yes
OUTCOME_NAME VARCHAR2 (30) Yes
SAP_STATUS_DATE DATE

SEQUENCE_NUMBER NUMBER (15) Yes
CAL_TYPE VARCHAR2 (10) Yes
GPA_TR NUMBER (15)
CR_POINTS_ENROLLED NUMBER (15)
CR_POINTS_COMPLETED NUMBER (15)
PERCENT_CR_COMPLETED NUMBER (6)
GPA_CUMULATIVE NUMBER (15)
CR_POINTS_ENROLLED_TR NUMBER (15)
CR_POINTS_COMPLETED_TR NUMBER (15)
PERCENT_CR_COMPLETED_TR NUMBER (6)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT SSD_ID
,      PERSON_ID
,      SAP_TYPE
,      OUTCOME_NAME
,      SAP_STATUS_DATE
,      SEQUENCE_NUMBER
,      CAL_TYPE
,      GPA_TR
,      CR_POINTS_ENROLLED
,      CR_POINTS_COMPLETED
,      PERCENT_CR_COMPLETED
,      GPA_CUMULATIVE
,      CR_POINTS_ENROLLED_TR
,      CR_POINTS_COMPLETED_TR
,      PERCENT_CR_COMPLETED_TR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_AP_STUD_SAP_DT_OLD;

Dependencies

[top of page]

IGF.IGF_AP_STUD_SAP_DT_OLD does not reference any database object

IGF.IGF_AP_STUD_SAP_DT_OLD is referenced by following:

SchemaAPPS
SynonymIGF_AP_STUD_SAP_DT_OLD