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_AD_SS_APPL_TYP

Object Details

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

IGS_AD_SS_APPL_TYP holds Self Service Admission Application Type details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_SS_APPL_TYP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADMISSION_APPLICATION_TYPE
IGS_AD_SS_APPL_TYP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADMISSION_CAT S_ADMISSION_PROCESS_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ADMISSION_APPLICATION_TYPE	VARCHAR2	(30)	Yes	This column stores the admission application types for admission applications created from the self service
DESCRIPTION	VARCHAR2	(60)		Description of the Admission Application Type
ADMISSION_CAT	VARCHAR2	(10)	Yes	Admission Category of the Admission Application Type
S_ADMISSION_PROCESS_TYPE	VARCHAR2	(30)	Yes	System Admission Process Type of the Admission Category of Admission Application type
CONFIGURABILITY_FUNC_NAME	VARCHAR2	(30)		Configurability Function Name attached to the Admission Application Type
APPLICATION_FEE_AMOUNT	NUMBER	(13)		Application Fee Amount attached to the application type
GL_REV_ACCT_CCID	NUMBER	(15)		General Ledger Revenue Account Code Identifier
GL_CASH_ACCT_CCID	NUMBER	(15)		General Ledger Cash Account Code Identifier
REV_ACCOUNT_CODE	VARCHAR2	(40)		User Defined Revenue Account Code
CASH_ACCOUNT_CODE	VARCHAR2	(40)		User Defined Cash Account Code
CLOSED_IND	VARCHAR2	(1)	Yes	Admission Application Type Closed Indicator
CREATED_BY	NUMBER	(15)	Yes	WHO column
CREATION_DATE	DATE		Yes	WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO column
LAST_UPDATE_DATE	DATE		Yes	WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO column
SYSTEM_DEFAULT	VARCHAR2	(1)		Indicates whether this application type is the system default.
ENROLL_DEPOSIT_AMOUNT	NUMBER	(13)		Enrollment Deposit Amount
ENROLL_DEPOSIT_LEVEL	VARCHAR2	(30)		Enrollment Deposit Level
USE_IN_APPL_SELF_SRVC	VARCHAR2	(1)		Specifies whether the application type should be displayed to the user in applicant self service or not
CRT_REV_INSTR	VARCHAR2	(600)		Create and Review Instruction
SUBMIT_INSTR	VARCHAR2	(600)		Submit Application Instruction
SUBMIT_ERR_INSTR	VARCHAR2	(600)		Submit Error Instruction

Query Text

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


SELECT ADMISSION_APPLICATION_TYPE
,      DESCRIPTION
,      ADMISSION_CAT
,      S_ADMISSION_PROCESS_TYPE
,      CONFIGURABILITY_FUNC_NAME
,      APPLICATION_FEE_AMOUNT
,      GL_REV_ACCT_CCID
,      GL_CASH_ACCT_CCID
,      REV_ACCOUNT_CODE
,      CASH_ACCOUNT_CODE
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SYSTEM_DEFAULT
,      ENROLL_DEPOSIT_AMOUNT
,      ENROLL_DEPOSIT_LEVEL
,      USE_IN_APPL_SELF_SRVC
,      CRT_REV_INSTR
,      SUBMIT_INSTR
,      SUBMIT_ERR_INSTR
FROM IGS.IGS_AD_SS_APPL_TYP;

Dependencies

[top of page]

IGS.IGS_AD_SS_APPL_TYP does not reference any database object

IGS.IGS_AD_SS_APPL_TYP is referenced by following:

APPS: IGS_AD_SS_APPL_TYP