[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_UNIT_SET |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_UNIT_SET |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
The code of a unit set. Unit sets comprise lists of units or rules.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | An identifier which represents a row which maps into the unit set record. | |
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 which constitute a logical set of units. Unit sets are used to represent concepts such as majors, minors, strands, streams,and lists. |
VERSION_NUMBER | NUMBER | (3) | Yes | This field is used to uniquely identify each version of a unit set. |
UNIT_SET_STATUS | VARCHAR2 | (150) | Yes | 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) | Yes | The code of a category of unit set. Unit set categoriesare institution-defined and may include, for example, MAJOR,MINOR, STRAND, and STREAM. |
START_DT | DATE | Yes | 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 stillexist 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 enddate can be entered. | ||
TITLE | VARCHAR2 | (90) | Yes | 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 torepresents concepts such as majors, minors, strands, streams,and lists. |
SHORT_TITLE | VARCHAR2 | (40) | Yes | This field describes the unit set short title. |
ABBREVIATION | VARCHAR2 | (20) | Yes | This field describes the unit set abbreviation. |
RESPONSIBLE_ORG_UNIT_CD | VARCHAR2 | (30) | The code of an academic or administrative organisational unitoperating within the University structure which is responsible for a unit set. | |
RESPONSIBLE_OU_START_DT | DATE | This field describes the date from which the organisational unit is effective. | ||
ADMINISTRATIVE_IND | VARCHAR2 | (1) | Yes | 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 not appear on official documents such as transcripts or other statements of results. |
AUTHORISATION_RQRD_IND | VARCHAR2 | (1) | Yes | 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. |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Structure Identifier of the Flex Field. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Flex Field Attribute1. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Flex Field Attribute2. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Flex Field Attribute3. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Flex Field Attribute4. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Flex Field Attribute5. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Flex Field Attribute6. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Flex Field Attribute7. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Flex Field Attribute8. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Flex Field Attribute9. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Flex Field Attribute10. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Flex Field Attribute11. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Flex Field Attribute12. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Flex Field Attribute13. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Flex Field Attribute14. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Flex Field Attribute15. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Flex Field Attribute16. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Flex Field Attribute17. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Flex Field Attribute18. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Flex Field Attribute19. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Flex Field Attribute20. | |
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
, 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
, ADMINISTRATIVE_IND
, AUTHORISATION_RQRD_IND
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_UNIT_SET;
|
|
|