[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_USEC_RPT_COND |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_USEC_RPT_COND |
Subobject Name: | |
Status: | VALID |
IGS_PS_USEC_RPT_COND describes the repeat conditions for a unit section. Case and Seed document: PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc - Obsolete
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_USEC_RPT_COND_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIT_SECTION_REPT_CONDITION_ID |
IGS_PS_USEC_RPT_COND_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UOO_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_SECTION_REPT_CONDITION_ID | NUMBER | Yes | Unique identifier for the repeat conditions for a unit section. | |
UOO_ID | NUMBER | (7) | Yes | Unique unit section identifier. |
REPEATABLE_IND | VARCHAR2 | (1) | Yes | Repeatable indicator |
SAME_TEACHING_PERIOD | VARCHAR2 | (1) | Same teaching period indicator. | |
MAX_REPEATS_FOR_CREDIT | NUMBER | (2) | Maximum number of unit section repeat for credit. | |
MAX_REPEATS_FOR_FUNDING | NUMBER | (2) | Maximum repeat of unit section for funding. | |
MAX_REPEAT_CREDIT_POINTS | NUMBER | (5) | Maximum credit points for repeat of unit section. | |
SAME_TEACH_PERIOD_REPEATS | NUMBER | (2) | Same teaching period repeats for unit section repeat conditions. | |
SAME_TEACH_PERIOD_REPEATS_CP | NUMBER | (5) | Credit points of same teaching period repeats. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_SECTION_REPT_CONDITION_ID
, UOO_ID
, REPEATABLE_IND
, SAME_TEACHING_PERIOD
, MAX_REPEATS_FOR_CREDIT
, MAX_REPEATS_FOR_FUNDING
, MAX_REPEAT_CREDIT_POINTS
, SAME_TEACH_PERIOD_REPEATS
, SAME_TEACH_PERIOD_REPEATS_CP
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_USEC_RPT_COND;
IGS.IGS_PS_USEC_RPT_COND does not reference any database object
IGS.IGS_PS_USEC_RPT_COND is referenced by following:
|
|
|