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

TABLE: IGS.IGS_PR_RU_CAT

Object Details
Object Name: IGS_PR_RU_CAT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_PR_RU_CAT
Subobject Name:
Status: VALID


IGS_PR_RU_CAT describes the categories of progression rules that are available for use within the Progression subsystem. These progression rule categories must map back onto a system defined rule type, that allows a little flexibility in the naming and description of each rule category.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PR_RU_CAT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROGRESSION_RULE_CAT
IGS_PR_RU_CAT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnS_RULE_CALL_CD
Columns
Name Datatype Length Mandatory Comments
PROGRESSION_RULE_CAT VARCHAR2 (10) Yes The code of an institution-defined progression rule category. Each category of progression rules is mapped to one of the system rule call codes. To maintain flexibility in the application of rules, institutions are advised to create one 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 program courses 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. Note a progression rule has no application until to one of the set of system elements.
DESCRIPTION VARCHAR2 (60) Yes The description of an institution defined progression rule category. Each category of progression rules is mapped to one of the system rule call codes. To maintain flexibility in the application of rules, institutions are advised to create one 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. Note that a progression rule has no application until to one of the set of system elements.
S_RULE_CALL_CD VARCHAR2 (10) Yes The code of a sytem defined rule call to that the institution-defined category of progression rules is mapped. System rule call codes are used to limit the selection set of rule options maitained.
CLOSED_IND VARCHAR2 (1) Yes Indicates and specifies if the categroy of rules is open or closed. Selecting the indicator to closed as selected prevents further application of all rules within the category.
MESSAGE VARCHAR2 (2000)
A text-based facility for entering additional information about the context institution-defined rule category, the default set of progression periods under that the rules of the context category are tested and the range of potential outcomes arising from failure of the rules.
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
POSITIVE_RULE_IND VARCHAR2 (1)
Indicates whether the rule is positive.
Query Text

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


SELECT PROGRESSION_RULE_CAT
,      DESCRIPTION
,      S_RULE_CALL_CD
,      CLOSED_IND
,      MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      POSITIVE_RULE_IND
FROM IGS.IGS_PR_RU_CAT;

Dependencies

[top of page]

IGS.IGS_PR_RU_CAT does not reference any database object

IGS.IGS_PR_RU_CAT is referenced by following:

SchemaAPPS
SynonymIGS_PR_RU_CAT