eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_SS_ADM_APPL_STG

Object Details

Object Name:	IGS_SS_ADM_APPL_STG
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_SS_ADM_APPL_STG
Subobject Name:
Status:	VALID

IGS_SS_ADM_APPL_STG describes admission of applicant to institution

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_SS_ADM_APPL_STG_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SS_ADM_APPL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SS_ADM_APPL_ID	NUMBER	(15)	Yes	Self Service Admission Application Identifier
PERSON_ID	NUMBER	(15)	Yes	Person Id
APPL_DATE	DATE			Application Date
ACAD_CAL_TYPE	VARCHAR2	(10)		Academic Calendar Type
ACAD_CAL_SEQ_NUMBER	NUMBER	(15)		Academic Calendar Sequence Number
ADM_CAL_TYPE	VARCHAR2	(10)		Admission Calendar Type
ADM_CAL_SEQ_NUMBER	NUMBER	(15)		Admission Calendar Sequence Number
ADMISSION_CAT	VARCHAR2	(10)		Admission Category
S_ADM_PROCESS_TYPE	VARCHAR2	(10)		System Admission Process Type
ENTRY_STATUS	NUMBER			Entry Status - Obsolete
ENTRY_LEVEL	NUMBER			Entry Level - Obsolete
SPCL_GRP_1	NUMBER			Special Group1
SPCL_GRP_2	NUMBER			Special Group2
APPLY_FOR_FINAID	VARCHAR2	(1)		Apply for Financial Aid indicator - Obsolete
FINAID_APPLY_DATE	DATE			Financial Aid Apply Date - Obsolete
LAST_UPDATE_DATE	DATE		Yes	standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	standard who column
CREATION_DATE	DATE		Yes	standard who column
CREATED_BY	NUMBER	(15)	Yes	standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		standard who column
COMMENCEMENT_PERIOD	VARCHAR2	(21)		Commencement Period
ADMISSION_APPLICATION_TYPE	VARCHAR2	(30)		Application Type
ORG_ID	NUMBER	(15)		Org id indicator
DESCRIPTION	VARCHAR2	(60)		Description for Calendar (Admission)
APP_SOURCE_ID	NUMBER	(15)		Application Source Identifier
APPL_FEE_AMT	NUMBER			Application Fee Amount

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
,      APPL_FEE_AMT
FROM IGS.IGS_SS_ADM_APPL_STG;

Dependencies

[top of page]

IGS.IGS_SS_ADM_APPL_STG does not reference any database object

IGS.IGS_SS_ADM_APPL_STG is referenced by following:

APPS: IGS_SS_ADM_APPL_STG