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_CAL_CONF

Object Details

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

IGS_AD_CAL_CONF stores dates aliases required for Admissions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_CAL_CONF_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	S_CONTROL_NUM
IGS_AD_CAL_CONF_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_SHORT_STRT_DT_ALIAS
IGS_AD_CAL_CONF_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_M_COMP_PERD_DT_ALIAS
IGS_AD_CAL_CONF_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_COURSE_STRT_DT_ALIAS
IGS_AD_CAL_CONF_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INQ_CAL_TYPE
IGS_AD_CAL_CONF_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_DUE_DT_ALIAS
IGS_AD_CAL_CONF_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_FINAL_DT_ALIAS
IGS_AD_CAL_CONF_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_CHNG_OF_PREF_DT_ALIAS
IGS_AD_CAL_CONF_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_OFFER_RESP_DT_ALIAS
IGS_AD_CAL_CONF_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INITIALISE_ADM_PERD_DT_ALIAS
IGS_AD_CAL_CONF_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_ENCMB_CHK_DT_ALIAS
IGS_AD_CAL_CONF_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_E_COMP_PERD_DT_ALIAS
IGS_AD_CAL_CONF_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_APPL_S_COMP_PERD_DT_ALIAS

Columns

Name	Datatype	Length	Mandatory	Comments
S_CONTROL_NUM	NUMBER	(1)	Yes	Describes the control number of the admission calendar configuration table. There will only be one row on this table, hence the control number will always be set to 1.
INITIALISE_ADM_PERD_DT_ALIAS	VARCHAR2	(10)		Describes the date in the admission period on that initialization processes are to be run, for example, switching applications to be reconsidered to pending, re-activating deferred applications.
ADM_APPL_ENCMB_CHK_DT_ALIAS	VARCHAR2	(10)		Describes the date alias used to check for the existence of program and unit encumbrances. This will be linked to an admission period
ADM_APPL_COURSE_STRT_DT_ALIAS	VARCHAR2	(10)		Describes the program start date alias. It will be linked to admission periods. An example of its use is for the enrollment fee assessment contract start date.
ADM_APPL_SHORT_STRT_DT_ALIAS	VARCHAR2	(10)		Describes the date the short admission process becomes effective. This will be linked to an admission period. Use of the short admission process, for example, SHORT-ADM, will not be allowed unless this date exists, and the application is being processed on or after this date.
ADM_APPL_DUE_DT_ALIAS	VARCHAR2	(10)		Describes the date alias within an admission period when admission applications are due. Late fees may be charged after this date.
ADM_APPL_FINAL_DT_ALIAS	VARCHAR2	(10)		Describes the date alias within an admission period by which admission applications must be received.
ADM_APPL_CHNG_OF_PREF_DT_ALIAS	VARCHAR2	(10)		Describes the date alias within an admission period until which preferences may be changed for an admission application.
ADM_APPL_OFFER_RESP_DT_ALIAS	VARCHAR2	(10)		Describes the date alias within an admission period by which all offers of admission must be responded to.
ADM_APPL_E_COMP_PERD_DT_ALIAS	VARCHAR2	(10)		Describes the date alias within an academic period that allows determination of the expected period of completion. This date alias identifies the 'End' of year expected completion period.
ADM_APPL_M_COMP_PERD_DT_ALIAS	VARCHAR2	(10)		Describes the date alias within an academic period that allows determination of the expected period of completion. This date alias identifies the 'Mid' - year expected completion period.
ADM_APPL_S_COMP_PERD_DT_ALIAS	VARCHAR2	(10)		Describes the date alias within an academic period that allows determination of the expected period of completion. This date alias identifies the 'Summer' expected completion period.
ADM_PRC_TRK_DT_ALIAS	VARCHAR2	(10)		Admission Processing Tracking Date Alias
POST_ADM_TRK_DT_ALIAS	VARCHAR2	(10)		Post Admission Tracking Date Alias
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
INQ_CAL_TYPE	VARCHAR2	(10)		Inquiry Calendar Type

Query Text

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


SELECT S_CONTROL_NUM
,      INITIALISE_ADM_PERD_DT_ALIAS
,      ADM_APPL_ENCMB_CHK_DT_ALIAS
,      ADM_APPL_COURSE_STRT_DT_ALIAS
,      ADM_APPL_SHORT_STRT_DT_ALIAS
,      ADM_APPL_DUE_DT_ALIAS
,      ADM_APPL_FINAL_DT_ALIAS
,      ADM_APPL_CHNG_OF_PREF_DT_ALIAS
,      ADM_APPL_OFFER_RESP_DT_ALIAS
,      ADM_APPL_E_COMP_PERD_DT_ALIAS
,      ADM_APPL_M_COMP_PERD_DT_ALIAS
,      ADM_APPL_S_COMP_PERD_DT_ALIAS
,      ADM_PRC_TRK_DT_ALIAS
,      POST_ADM_TRK_DT_ALIAS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INQ_CAL_TYPE
FROM IGS.IGS_AD_CAL_CONF;

Dependencies

[top of page]

IGS.IGS_AD_CAL_CONF does not reference any database object

IGS.IGS_AD_CAL_CONF is referenced by following:

APPS: IGS_AD_CAL_CONF