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_RU_APPL_ALL

Object Details

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

IGS_PR_RU_APPL_ALL describes a progression rule as it is applied to one of the allowable system elements a program version, program type, organization unit, or individual student student attempt.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PR_RU_APPL_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROGRESSION_RULE_CAT SEQUENCE_NUMBER
IGS_PR_RU_APPL_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROGRESSION_RULE_CAT PROGRESSION_RULE_CD
IGS_PR_RU_APPL_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COURSE_TYPE
IGS_PR_RU_APPL_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CRV_COURSE_CD CRV_VERSION_NUMBER
IGS_PR_RU_APPL_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OU_ORG_UNIT_CD OU_START_DT
IGS_PR_RU_APPL_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCA_PERSON_ID SCA_COURSE_CD
IGS_PR_RU_APPL_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_TYPE
IGS_PR_RU_APPL_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRO_PROGRESSION_RULE_CAT PRO_PRA_SEQUENCE_NUMBER PRO_SEQUENCE_NUMBER
IGS_PR_RU_APPL_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SPO_PERSON_ID SPO_COURSE_CD SPO_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 like PRG-GPA, PRG-UFAIL, PRG-WAM. 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 particularof the institution. Note, a progression rule has no application until to one of the set of system elements.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the progression rule application
S_RELATION_TYPE	VARCHAR2	(10)	Yes	Identifies the entity that the progression rule applies. It can be either organizational unit, program type, program version or, if the outcome of failing one rule is the application of a subsequent rule, a student program attempt.
PROGRESSION_RULE_CD	VARCHAR2	(10)		The code of an institution-defined program progression rule as it is applied to one of the allowable system elements 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.
REFERENCE_CD	VARCHAR2	(30)		Describes the reference code assigned to 'one-off' progression rules created at the point of finalizing a progression outcome. The reference replaces a rule code.
RUL_SEQUENCE_NUMBER	NUMBER	(6)		Describes the unique identifier for the rule
ATTENDANCE_TYPE	VARCHAR2	(2)		The code of an institution-defined attendance type that the program progression rule is restricted to
OU_ORG_UNIT_CD	VARCHAR2	(30)		The code of an organization unit that the progression rule is restricted to
OU_START_DT	DATE			The date from that the organizational unit is effective. An organizational unit is uniquely identified by the combination of its code and start date.
COURSE_TYPE	VARCHAR2	(10)		The code of an institution-defined program type that the progression rule is restricted to
CRV_COURSE_CD	VARCHAR2	(6)		Code of a program that the progression rule is restricted to
CRV_VERSION_NUMBER	NUMBER	(3)		The version number of the program that the progression rule is restricted to
SCA_PERSON_ID	NUMBER	(15)		The person identifier of the individual student program attempt that the progression rule is restricted to
SCA_COURSE_CD	VARCHAR2	(6)		The code of the individual student program attempt that the progression rule is restricted to
PRO_PROGRESSION_RULE_CAT	VARCHAR2	(10)		The category of institution-defined progression rules that the progression rule outcome is linked
PRO_PRA_SEQUENCE_NUMBER	NUMBER	(6)		A unique sequence number linking the application of the progression rule to its outcome
PRO_SEQUENCE_NUMBER	NUMBER	(6)		A unique sequence number linking the progression outcome to a particular application of a progression rule
SPO_PERSON_ID	NUMBER	(15)		The person identifier of the student program attempt that the progression outcome applies
SPO_COURSE_CD	VARCHAR2	(6)		The code of the student program attempt that the progression outcome applies
SPO_SEQUENCE_NUMBER	NUMBER	(6)		A unique sequence number linking the student progression outcome to a particular application of the progression rule.
LOGICAL_DELETE_DT	DATE			Identifies the date the record was logically deleted
MESSAGE	VARCHAR2	(2000)		A text based facility for entering 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 and can be limited to either a program type, or all programs within a given organizational unit or a particular individual student program attempt, the default set of progression periods under that 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
MIN_CP	NUMBER	(6)		Minimum of Credit Point Range
MAX_CP	NUMBER	(6)		Maximum of Credit Point Range
IGS_PR_CLASS_STD_ID	NUMBER	(15)		Class Standing ID

Query Text

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


SELECT PROGRESSION_RULE_CAT
,      SEQUENCE_NUMBER
,      S_RELATION_TYPE
,      PROGRESSION_RULE_CD
,      REFERENCE_CD
,      RUL_SEQUENCE_NUMBER
,      ATTENDANCE_TYPE
,      OU_ORG_UNIT_CD
,      OU_START_DT
,      COURSE_TYPE
,      CRV_COURSE_CD
,      CRV_VERSION_NUMBER
,      SCA_PERSON_ID
,      SCA_COURSE_CD
,      PRO_PROGRESSION_RULE_CAT
,      PRO_PRA_SEQUENCE_NUMBER
,      PRO_SEQUENCE_NUMBER
,      SPO_PERSON_ID
,      SPO_COURSE_CD
,      SPO_SEQUENCE_NUMBER
,      LOGICAL_DELETE_DT
,      MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      MIN_CP
,      MAX_CP
,      IGS_PR_CLASS_STD_ID
FROM IGS.IGS_PR_RU_APPL_ALL;

Dependencies

[top of page]

IGS.IGS_PR_RU_APPL_ALL does not reference any database object

IGS.IGS_PR_RU_APPL_ALL is referenced by following:

APPS: IGS_PR_RU_APPL_ALL