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_PR_RULE_ALL

Object Details

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

IGS_PR_RULE_ALL describes a standard progression rule that then can be applied to one of the allowable system elements - a program version, program type, organization unit or individual student program attempt using progression rule application.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PR_RULE_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROGRESSION_RULE_CAT PROGRESSION_RULE_CD
IGS_PR_RULE_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RUL_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRESSION_RULE_CAT	VARCHAR2	(10)	Yes	The code of an institution-defined category for progression rule. Each category of progression rules is mapped to one of the system rule call codes. The system rule call codes are PRG-GPA, PRG-UFAIL, PRG-WAM. To maintain flexibility in the application of rules, institutions are advised to create more than one rule category for each system rule call code. For example, three categories of GPA calculation can be appropriate - one category is used to represent standard program grade point average calculations applied to the majority of programs within the institution. A second category could be created for progression period GPA calculations. A third category can be applicable if a particular organizational unit applies different GPA thresholds from the rest of the institution. A progression rule has no application until to one of the set of system elements. Organizational unit applies different GPA thresholds from the rest.
PROGRESSION_RULE_CD	VARCHAR2	(10)	Yes	The code of an institution-defined program progression rule as it is applied to one of the allowable system elements.The allowable values are program version, program type, organizational unit or individual student program attempt. A progression rule is classified according to one of the set of institution-defined progression rule categories. Progression rules do not have version control or date stamping. Consequently the definition of a rule should not change over time. If the set of progression rules to be applied needs to change, old rules should be closed and new rules created that support the changed situation.
DESCRIPTION	VARCHAR2	(60)	Yes	The explaination of an institution-defined program progression rule as it is applied to one of the allowable system elements. The allowable system elements are program version, program type, organizational unit or individual student program attempt. A progression rule is classified according to one of the set of institution-defined progression rule categories. Progression rules do not have version control or date stamping. Consequently the definition of a rule should not change over time. If the set of progression rules to be applied needs to change, old rules should be closed and new rules created that support the changed situation.
RUL_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the unique identifier for the rule
CLOSED_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the progression rule is open or closed. Selecting the checkbox to closed prevents further application of the progression rule.
MESSAGE	VARCHAR2	(2000)		A text based facility for enteing additional information about the context rule code. For example, it can be appropriate to fully describe the rule definition, the cohort of students to whom the rule applies, the default set of progression periods under that the rule is tested and the range of outcomes arising from failure of the rule.
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
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

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


SELECT PROGRESSION_RULE_CAT
,      PROGRESSION_RULE_CD
,      DESCRIPTION
,      RUL_SEQUENCE_NUMBER
,      CLOSED_IND
,      MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_PR_RULE_ALL;

Dependencies

[top of page]

IGS.IGS_PR_RULE_ALL does not reference any database object

IGS.IGS_PR_RULE_ALL is referenced by following:

APPS: IGS_PR_RULE_ALL