DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_EN_UNIT_SET

Object Details
Object Name: IGS_EN_UNIT_SET
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_EN_UNIT_SET
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.IGS_EN_UNIT_SET references the following:

SchemaAPPS
SynonymIGS_EN_UNIT_SET_ALL
APPS.IGS_EN_UNIT_SET is referenced by following:

SchemaAPPS
Package BodyIGF_AP_OSS_INTR_DTLS - show dependent code
Package BodyIGR_PER_INFO_001 - show dependent code
Package BodyIGS_AD_GEN_010 - show dependent code
Package BodyIGS_AD_GEN_014 - show dependent code
ViewIGS_AD_PS_APL_INST_CNTX_V
ViewIGS_AD_PS_APPL_INST_APLINST_V
Package BodyIGS_AD_SS_GEN_001 - show dependent code
Package BodyIGS_AD_UNIT_SETS_PKG - show dependent code
ViewIGS_AD_UNIT_SETS_V
Package BodyIGS_AD_VAL_ACAI - show dependent code
Package BodyIGS_AD_VAL_SCFT - show dependent code
Package BodyIGS_AS_ADI_UPLD_AIO_PKG - show dependent code
ViewIGS_AS_GPC_UNIT_SETS_V
Package BodyIGS_AS_PRC_TRANSCRPT - show dependent code
ViewIGS_AS_PROGUGAI_ADI_V
ViewIGS_AS_SUSA_INQ_V
Package BodyIGS_AS_SU_SETATMPT_PKG - show dependent code
Package BodyIGS_DA_XML_PKG - show dependent code
ViewIGS_DA_XML_SUBPROGRAM_V
Package BodyIGS_EN_ELGBL_OVERRIDE - show dependent code
Package BodyIGS_EN_GEN_008 - show dependent code
Package BodyIGS_EN_GEN_009 - show dependent code
Package BodyIGS_EN_GEN_010 - show dependent code
Package BodyIGS_EN_GEN_LEGACY - show dependent code
Package BodyIGS_EN_HESA_PKG - show dependent code
ViewIGS_EN_OR_UNIT_WLST_PRF_V
ViewIGS_EN_SUA_YEAR_V
ViewIGS_EN_SUSA_PARENT_V
ViewIGS_EN_SUSA_YEAR_V
ViewIGS_EN_UNIT_SET_ACTIVE_V
ViewIGS_EN_UNIT_SET_COURSE_TYPE_V
ViewIGS_EN_UNIT_SET_HIST_V
ViewIGS_EN_UNIT_SET_MAP_V
ViewIGS_EN_UNIT_SET_RULE_V
ViewIGS_EN_UNIT_SET_VALID_V
Package BodyIGS_EN_VAL_PUSE - show dependent code
Package BodyIGS_EN_VAL_SUSA - show dependent code
Package BodyIGS_EN_VAL_USFT - show dependent code
ViewIGS_FI_FEE_AS_RATE_V
ViewIGS_FI_FEE_TRG_GRP_V
Package BodyIGS_FI_GEN_001 - show dependent code
Package BodyIGS_FI_GEN_005 - show dependent code
Package BodyIGS_GE_GEN_004 - show dependent code
Package BodyIGS_GR_GEN_001 - show dependent code
Package BodyIGS_GR_VAL_ACUS - show dependent code
Package BodyIGS_HE_EXTRACT2_PKG - show dependent code
Package BodyIGS_HE_EXTRACT_PKG - show dependent code
Package BodyIGS_HE_FTE_CALC_PKG - show dependent code
Package BodyIGS_HE_IDENTIFY_TARGET_POP - show dependent code
ViewIGS_HE_POOUS_DTLS_V
Package BodyIGS_HE_VERIFY_RETURN_PKG - show dependent code
Package BodyIGS_PR_ACAD_DETAILS - show dependent code
ViewIGS_PR_ACAD_YEAR_V
Package BodyIGS_PR_PROUT_LGCY_PUB - show dependent code
ViewIGS_PR_SCA_US_V
Package BodyIGS_PR_VAL_SPUS - show dependent code
Package BodyIGS_PS_GEN_003 - show dependent code
Package BodyIGS_PS_GEN_006 - show dependent code
ViewIGS_PS_OFR_OPT_UNIT_SET_V
ViewIGS_PS_OFR_UNIT_SET_V
ViewIGS_PS_RSV_ORGUN_PRF_V
ViewIGS_PS_RSV_UOP_PRF_V
ViewIGS_PS_RSV_USEC_PRF_V
ViewIGS_PS_UOFR_WLST_PRF_V
ViewIGS_PS_USEC_WLST_PRF_V
Package BodyIGS_PS_VALIDATE_GENERIC_PKG - show dependent code
Package BodyIGS_PS_VAL_COUSR - show dependent code
Package BodyIGS_PS_VAL_POS - show dependent code
Package BodyIGS_PS_VAL_US - show dependent code
Package BodyIGS_PS_VAL_USC - show dependent code
Package BodyIGS_RU_GEN_001 - show dependent code
Package BodyIGS_RU_GEN_002 - show dependent code
Package BodyIGS_SS_ENR_DETAILS - show dependent code
Package BodyIGS_UC_EXPORT_DECISION_REPLY - show dependent code
Package BodyIGS_UC_EXPORT_TO_OSS - show dependent code