[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_OFR_UNIT_SET |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_OFR_UNIT_SET |
Subobject Name: | |
Status: | VALID |
This entity describes the link between unit sets and programs. E.g. it would link the possible majors to a program
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_OFR_UNIT_SET_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
COURSE_CD
CRV_VERSION_NUMBER CAL_TYPE UNIT_SET_CD US_VERSION_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COURSE_CD | VARCHAR2 | (6) | Yes | Describes the program code. |
CRV_VERSION_NUMBER | NUMBER | (3) | Yes | Version number of the program. There can only be one version of a program with a system status of Active and an unset Expiry Date. |
CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the calendar type of the program offering to that the unit set is linked. |
UNIT_SET_CD | VARCHAR2 | (10) | Yes | Code of a unit set. Unit sets consists lists of units or rules that constitute a logical set of units. Unit sets are used to represents concepts such as majors, minors, strands, streams and lists. |
US_VERSION_NUMBER | NUMBER | (3) | Yes | Used to uniquely identify each version of a unit set. There can only be one version of a unit set with a system status of Active and an unset Expiry date. |
OVERRIDE_TITLE | VARCHAR2 | (90) | Override title of a unit set when selected within the context program version. | |
ONLY_AS_SUB_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit set can only be selected as a subordinate unit set within the related program offering. If checked, the unit set must always be selected within an already selected or completed parent unit set. |
SHOW_ON_OFFICIAL_NTFCTN_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit set should appear on official notifications to the student, such as academic transcripts and degree. The indicator defaults to checked ticked for academic unit sets and defaults to unchecked for administrative unit sets. |
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 COURSE_CD
, CRV_VERSION_NUMBER
, CAL_TYPE
, UNIT_SET_CD
, US_VERSION_NUMBER
, OVERRIDE_TITLE
, ONLY_AS_SUB_IND
, SHOW_ON_OFFICIAL_NTFCTN_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_OFR_UNIT_SET;
IGS.IGS_PS_OFR_UNIT_SET does not reference any database object
IGS.IGS_PS_OFR_UNIT_SET is referenced by following:
|
|
|