[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_UNIT_SET_HIST |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_EN_UNIT_SET_HIST
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
This view describes the history of changes to a given unit set.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | This field describes an identifier that represents a row in the in the unit set history table. | |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
| UNIT_SET_CD | VARCHAR2 | (10) | Yes | The code of a unit set. Unit sets comprise lists of units or rules |
| VERSION_NUMBER | NUMBER | (3) | Yes | This field is used to uniquely identify each version of a unit |
| HIST_START_DT | DATE | Yes | The effective start date/time of the history record. | |
| HIST_END_DT | DATE | Yes | The effective end date/time of the history record. | |
| HIST_WHO | NUMBER | (15) | Yes | The Oracle username of the person who created the history record. |
| UNIT_SET_STATUS | VARCHAR2 | (10) | This field describes the institution defined unit set status. The unit set status is attributed to each version to define its currencyin the system. Unit set status maps to a system unitset status with its associated functionality. | |
| UNIT_SET_CAT | VARCHAR2 | (10) | The code of a category of unit set. Unit set categories are institution defined and may include, for example, Major,Minor, Strand, and Stream. | |
| START_DT | DATE | This field records the date on which the unit set version is created. | ||
| REVIEW_DT | DATE | This field records the date on which the unit set version isto be reviewed. No automated action will result from this date,rather it is expected to trigger notification of the need for review. | ||
| EXPIRY_DT | DATE | This field records the date on which the unit set versionexpires. This date would be entered as part of the process ofexpiring one version and creating a new one. Students may still exist in expired unit set versions until the time when the versionis finally ended. No new students can select an expired unit set. | ||
| END_DT | DATE | This field records the date on which 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) | The title of a unit set. Unit sets comprise lists of units or rules which constitute a logical set of units. Unit sets are used to represents concepts such as majors, minors, strands, streams,and lists. | |
| SHORT_TITLE | VARCHAR2 | (40) | This field describes the unit set short title. | |
| ABBREVIATION | VARCHAR2 | (20) | This field describes the unit set abbreviation. | |
| RESPONSIBLE_ORG_UNIT_CD | VARCHAR2 | (30) | The code of an academic or administrative organisational unit operating within the University structure which is responsible for aunit set. | |
| RESPONSIBLE_OU_START_DT | DATE | This field records the date on which the unit set version isto be reviewed. No automated action will result from this date,rather it is expected to trigger notification of the need for review. | ||
| OU_DESCRIPTION | VARCHAR2 | (60) | The description of an organisational unit. An organisational unit is a business unit of an institution or organisation. Common organisational units in tertiary institutions are faculties, schools, departments and divisions. Each organisational unit must be assigned a start date,description, status, organisational type and member type. An institution code may be assigned to an organisational unit. | |
| ADMINISTRATIVE_IND | VARCHAR2 | (1) | An indicator which specifies whether the unit set is administrative or academic in nature. Setting the checkbox ticked classifies the unitset as administrative. Administrative unit sets typically do notappear on official documents such as transcripts or other statementsof results. | |
| AUTHORISATION_RQRD_IND | VARCHAR2 | (1) | An indicator which specifies whether authorisation is required before a student can select a unit set as part of their course. Setting the checkbox ticked enforces authorisation. Example- Approval to selectan 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 | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORG_ID
, UNIT_SET_CD
, VERSION_NUMBER
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, UNIT_SET_STATUS
, UNIT_SET_CAT
, START_DT
, REVIEW_DT
, EXPIRY_DT
, END_DT
, TITLE
, SHORT_TITLE
, ABBREVIATION
, RESPONSIBLE_ORG_UNIT_CD
, RESPONSIBLE_OU_START_DT
, OU_DESCRIPTION
, ADMINISTRATIVE_IND
, AUTHORISATION_RQRD_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_UNIT_SET_HIST;
APPS
IGS_EN_UNIT_SET_HIST_ALL
APPS
IGS_AU_GEN_004
- show dependent code
IGS_EN_UNIT_SET_HIST_V
IGS_PS_GEN_006
- show dependent code
|
|
|
|