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_EN_CAL_CONF

Object Details

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

IGS_EN_CAL_CONF describes institution-defined date aliases that are used as default dates in certain data records and to control the operation of some processes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_CAL_CONF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	S_CONTROL_NUM
IGS_EN_CAL_CONF_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUB_UNIT_DT_ALIAS
IGS_EN_CAL_CONF_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOAD_EFFECT_DT_ALIAS
IGS_EN_CAL_CONF_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENROLLED_RULE_CUTOFF_DT_ALIAS
IGS_EN_CAL_CONF_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVALID_RULE_CUTOFF_DT_ALIAS
IGS_EN_CAL_CONF_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAPSE_DT_ALIAS
IGS_EN_CAL_CONF_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENR_CLEANUP_DT_ALIAS
IGS_EN_CAL_CONF_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMMENCE_CUTOFF_DT_ALIAS
IGS_EN_CAL_CONF_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECORD_OPEN_DT_ALIAS
IGS_EN_CAL_CONF_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECORD_CUTOFF_DT_ALIAS
IGS_EN_CAL_CONF_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EFFECT_ENR_STRT_DT_ALIAS
IGS_EN_CAL_CONF_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMMENCEMENT_DT_ALIAS
IGS_EN_CAL_CONF_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VARIATION_CUTOFF_DT_ALIAS
IGS_EN_CAL_CONF_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENR_PCKG_PROD_DT_ALIAS
IGS_EN_CAL_CONF_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENR_FORM_DUE_DT_ALIAS

Columns

Name	Datatype	Length	Mandatory	Comments
S_CONTROL_NUM	NUMBER	(1)	Yes	Unique number that specifies the number of records the calendar configuration table can have. This number is generated for processing purpose. The value of this number must be 1. Error messages are displayed if the value is not set to 1.
COMMENCE_CUTOFF_DT_ALIAS	VARCHAR2	(10)	Yes	Date alias within a teaching period for that a student would no longer be considered commencing within their program. This alias is looked for in the student's first enrolled teaching period.
COMMENCEMENT_DT_ALIAS	VARCHAR2	(10)	Yes	Date alias representing the default commencement date within an academic period calendar instance. Only one commencement date alias can exist in each academic period calendar instance.
EFFECT_ENR_STRT_DT_ALIAS	VARCHAR2	(10)	Yes	Enrolment effective start date for an academic period. This date represents the time processes should be considering the related academic period as the "current" period.
RECORD_OPEN_DT_ALIAS	VARCHAR2	(10)		Describes the date for recording of unit enrolments opens within a teaching period calendar instance. Combined with the RECORD_CUTOFF_DT_ALIAS, logical enrolment windows can be constructed.
RECORD_CUTOFF_DT_ALIAS	VARCHAR2	(10)		Describes the date for that recording of unit enrolments that closes within a teaching period calendar instance. Combined with the RECORD_OPEN_DT_ALIAS, logical enrolment windows can be constructed.
SUB_UNIT_DT_ALIAS	VARCHAR2	(10)		Sub-unit date alias is required to establish relationships between teaching calendar instances in that the sub-units are enrolled and the teaching calendar instance that enrolls the superior unit.
VARIATION_CUTOFF_DT_ALIAS	VARCHAR2	(10)		Date alias used to prevent further enrolment variations in a teaching period. For the variation cut-off to be effective, date alias instances have to be specified for each teaching period.
ENR_FORM_DUE_DT_ALIAS	VARCHAR2	(10)	Yes	Date alias that describes a default enrolment form due date. The default is only used by a job that produces enrolment forms if a specific due date is not specified at run time.
ENR_PCKG_PROD_DT_ALIAS	VARCHAR2	(10)		Date alias that describes a default enrolment package production date.
LOAD_EFFECT_DT_ALIAS	VARCHAR2	(10)	Yes	Date alias that describes when student load is effective. It is anticipated that the CENSUS date will be used as this date alias.
ENROLLED_RULE_CUTOFF_DT_ALIAS	VARCHAR2	(10)		Date alias that represents the last date for that the unit attempts can be switched from INVALID to ENROLLED as a result of passing a previously failed rule.
INVALID_RULE_CUTOFF_DT_ALIAS	VARCHAR2	(10)		Date alias that represents the last date for that the unit attempts can be switched from ENROLLED to INVALID as a result of failing a unit rule check.
LAPSE_DT_ALIAS	VARCHAR2	(10)	Yes	Describes the date alias representing the date until that students must remain enrolled within an academic period. Failure to do so will result in their enrollment being lapsed.
ENR_CLEANUP_DT_ALIAS	VARCHAR2	(10)	Yes	Describes the date that unconfirmed student program attempts will be cleaned up within an enrolment period.
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
GRADING_SCHEMA_DT_ALIAS	VARCHAR2	(10)		Grading schema change deadline date alias
BEGIN_TRANS_DT_ALIAS	VARCHAR2	(10)		Begin program transfer date alias
CLEAN_TRANS_DT_ALIAS	VARCHAR2	(10)		Cleanup program transfer date alias
PLANNING_OPEN_DT_ALIAS	VARCHAR2	(10)		Indicates when the load calendar is available for planning
SCHEDULE_OPEN_DT_ALIAS	VARCHAR2	(10)		Indicates when the load calendar is available for schedule
AUDIT_STATUS_DT_ALIAS	VARCHAR2	(10)		Indicates when the Teaching Calendar is not available for updating audit flag

Query Text

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


SELECT S_CONTROL_NUM
,      COMMENCE_CUTOFF_DT_ALIAS
,      COMMENCEMENT_DT_ALIAS
,      EFFECT_ENR_STRT_DT_ALIAS
,      RECORD_OPEN_DT_ALIAS
,      RECORD_CUTOFF_DT_ALIAS
,      SUB_UNIT_DT_ALIAS
,      VARIATION_CUTOFF_DT_ALIAS
,      ENR_FORM_DUE_DT_ALIAS
,      ENR_PCKG_PROD_DT_ALIAS
,      LOAD_EFFECT_DT_ALIAS
,      ENROLLED_RULE_CUTOFF_DT_ALIAS
,      INVALID_RULE_CUTOFF_DT_ALIAS
,      LAPSE_DT_ALIAS
,      ENR_CLEANUP_DT_ALIAS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GRADING_SCHEMA_DT_ALIAS
,      BEGIN_TRANS_DT_ALIAS
,      CLEAN_TRANS_DT_ALIAS
,      PLANNING_OPEN_DT_ALIAS
,      SCHEDULE_OPEN_DT_ALIAS
,      AUDIT_STATUS_DT_ALIAS
FROM IGS.IGS_EN_CAL_CONF;

Dependencies

[top of page]

IGS.IGS_EN_CAL_CONF does not reference any database object

IGS.IGS_EN_CAL_CONF is referenced by following:

APPS: IGS_EN_CAL_CONF