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

TABLE: IGS.IGS_SS_ADM_APPL_STG_ALL_OLD

Object Details
Object Name: IGS_SS_ADM_APPL_STG_ALL_OLD
Object Type: TABLE
Owner: IGS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SS_ADM_APPL_ID NUMBER (15) Yes
PERSON_ID NUMBER (15) Yes
APPL_DATE DATE

ACAD_CAL_TYPE VARCHAR2 (10)
ACAD_CAL_SEQ_NUMBER NUMBER (15)
ADM_CAL_TYPE VARCHAR2 (10)
ADM_CAL_SEQ_NUMBER NUMBER (15)
ADMISSION_CAT VARCHAR2 (10)
S_ADM_PROCESS_TYPE VARCHAR2 (10)
ENTRY_STATUS NUMBER

ENTRY_LEVEL NUMBER

SPCL_GRP_1 NUMBER

SPCL_GRP_2 NUMBER

APPLY_FOR_FINAID VARCHAR2 (1)
FINAID_APPLY_DATE DATE

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
COMMENCEMENT_PERIOD VARCHAR2 (21)
ADMISSION_APPLICATION_TYPE VARCHAR2 (30)
ORG_ID NUMBER (15)
DESCRIPTION VARCHAR2 (60)
APP_SOURCE_ID NUMBER (15)
Query Text

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


SELECT SS_ADM_APPL_ID
,      PERSON_ID
,      APPL_DATE
,      ACAD_CAL_TYPE
,      ACAD_CAL_SEQ_NUMBER
,      ADM_CAL_TYPE
,      ADM_CAL_SEQ_NUMBER
,      ADMISSION_CAT
,      S_ADM_PROCESS_TYPE
,      ENTRY_STATUS
,      ENTRY_LEVEL
,      SPCL_GRP_1
,      SPCL_GRP_2
,      APPLY_FOR_FINAID
,      FINAID_APPLY_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMENCEMENT_PERIOD
,      ADMISSION_APPLICATION_TYPE
,      ORG_ID
,      DESCRIPTION
,      APP_SOURCE_ID
FROM IGS.IGS_SS_ADM_APPL_STG_ALL_OLD;

Dependencies

[top of page]

IGS.IGS_SS_ADM_APPL_STG_ALL_OLD does not reference any database object

IGS.IGS_SS_ADM_APPL_STG_ALL_OLD is referenced by following:

SchemaAPPS
SynonymIGS_SS_ADM_APPL_STG_ALL_OLD