[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSBV_PROG_CONCENTRATIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSBV_PROG_CONCENTRATIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This entity describes a unit-set, being a logical sub-grouping of program. eg .Major, Minor, Stream, Strand. A unit-set is typically related to the rules which governs its completion via the Rules Sub-system.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| UNIT_SET_CODE | VARCHAR2 | (10) | Yes | Code of a unit set.Unit set comprises of units or rules that constitute a logical set of units. Unit set are used to represent concepts such as majors,minors,strands,streams and lists. |
| VERSION_NUMBER | NUMBER | (3) | Yes | Used to uniquely identify each version of a unit set |
| UNIT_SET_STATUS | VARCHAR2 | (150) | Yes | Describes the institution-defined unit set status. The unit set status is attributed to each version to define its currency in the system. Unit set status maps to a system unit set status with its associated functionality |
| UNIT_SET_CATEGORY | VARCHAR2 | (10) | Yes | Code of a category of unit set.Unit set categories are institution-defined and might include, for example , MAJOR, MINOR, STRAND and STREAM |
| START_DATE | DATE | Yes | Enters the date on that the unit set version is created | |
| REVIEW_DATE | DATE | Enters the date on that the unit set version is to be reviewed.No automated action will result from this date, rather it is expected to trigger notification of the need for review | ||
| EXPIRY_DATE | DATE | Enters the date on that the unit set version expires. This date would be entered as part of the process of expiring one version and creating a new one. Students may still exist in expired unit set versions until the time when the version is finally ended. No new students can select an expired unit set. | ||
| END_DATE | DATE | Enters the date on that the unit set version is finally closed. All student unit sets must be completed or ended before an end date can be entered. | ||
| TITLE | VARCHAR2 | (90) | Yes | Title of a unit set. Unit set comprise list of units or rules that constitute a logical set of units. Unit sets are used to represent concept such as majors,minors,strands,stream and list. |
| SHORT_TITLE | VARCHAR2 | (40) | Yes | Describes the unit set short title |
| ABBREVIATION | VARCHAR2 | (20) | Yes | Describes the unit set abbreviation |
| RESP_ORG_UNIT_CODE | VARCHAR2 | (30) | Code of an academic or administrative organization unit operating within the university structure that is responsible for a unit set | |
| RESP_ORG_UNIT_START_DATE | DATE | Describes the date from that the organization unit is effective | ||
| ADMINISTRATIVE_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit set is administrative or academic in nature. Setting the checkbox ticked classified the unit set as administrative. Administrative unit sets typically do not appear on official documents |
| AUTHORISATION_RQRD_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether authorization is required before a student can select a unit set as part of their program. Setting the checkbox ticked enforces authorization. For example, approval to select an advanced major by be required from the faculty on a student by student basis |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_SET_CODE
, VERSION_NUMBER
, UNIT_SET_STATUS
, UNIT_SET_CATEGORY
, START_DATE
, REVIEW_DATE
, EXPIRY_DATE
, END_DATE
, TITLE
, SHORT_TITLE
, ABBREVIATION
, RESP_ORG_UNIT_CODE
, RESP_ORG_UNIT_START_DATE
, ADMINISTRATIVE_INDICATOR
, AUTHORISATION_RQRD_INDICATOR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_PROG_CONCENTRATIONS;
APPS
IGS_EN_UNIT_SET_ALL
APPS.IGSBV_PROG_CONCENTRATIONS is not referenced by any database object
|
|
|
|