eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGS_PS_UNIT_OFR_OPT_V

Object Details

Object Name:	IGS_PS_UNIT_OFR_OPT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PS_UNIT_OFR_OPT_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id.
UOO_ID	NUMBER	(7)	Yes	Unique identifier for a unit offering option.
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code of the unit being offered.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the unit being offered. Students are normally enrolled in the current version of a unit. Prior versions of the unit are end-dated.
UNIT_STATUS	VARCHAR2	(10)	Yes
TITLE	VARCHAR2	(90)	Yes
CALL_NUMBER	NUMBER
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type in that the unit is offered. Units can only be offered in instances of calendar types that are categorized as teaching calendars.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the calendar instance.
ALTERNATE_CODE	VARCHAR2	(10)
CAL_START_DT	DATE		Yes
CAL_END_DT	DATE		Yes
UNIT_CLASS	VARCHAR2	(10)	Yes	Institution-defined code that identifies a unit class.
UNIT_MODE	VARCHAR2	(10)	Yes
LOCATION_CD	VARCHAR2	(10)	Yes	Institution-defined location code, typically of a campus, at that a unit offering option is offered.
LOCATION_DESCRIPTION	VARCHAR2	(60)	Yes
UNIT_SECTION_STATUS	VARCHAR2	(30)
STATUS_DESCRIPTION	VARCHAR2	(80)	Yes
UNIT_SECTION_START_DATE	DATE
UNIT_SECTION_END_DATE	DATE
ENROLLMENT_ACTUAL	NUMBER	(6)
WAITLIST_ACTUAL	NUMBER	(6)
STATE_FINANCIAL_AID	VARCHAR2	(1)
FEDERAL_FINANCIAL_AID	VARCHAR2	(1)
INSTITUTIONAL_FINANCIAL_AID	VARCHAR2	(1)
IVRS_AVAILABLE_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether the unit offering option is available for enrollment via the Interactive Voice Response System. Setting the indicator ticked enables students using the IVR System to enroll in the unit offering option.
GRADING_SCHEMA_PRCDNCE_IND	VARCHAR2	(1)	Yes
UNIT_QUOTA	NUMBER	(6)
UNIT_QUOTA_RESERVED_PLACES	NUMBER	(6)
GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes
GS_VERSION_NUMBER	NUMBER	(3)	Yes
UNIT_CONTACT	NUMBER	(15)
OFFERED_IND	VARCHAR2	(1)	Yes
OWNER_ORG_UNIT_CD	VARCHAR2	(30)
OU_START_DATE	DATE
OU_DESCRIPTION	VARCHAR2	(360)
ATTENDANCE_REQUIRED_IND	VARCHAR2	(1)
ANON_UNIT_GRADING_IND	VARCHAR2	(1)		Anonymous unit grading indicator
ANON_ASSESS_GRADING_IND	VARCHAR2	(1)		Anonymous assess grading indicator
NON_STD_USEC_IND	VARCHAR2	(1)		Indicates wether the Unit Section is Standard or Non Standard
RESERVED_SEATING_ALLOWED	VARCHAR2	(1)
SPECIAL_PERMISSION_IND	VARCHAR2	(1)
SS_DISPLAY_IND	VARCHAR2	(1)
SS_ENROL_IND	VARCHAR2	(1)		Self Service Enrollment indicator
ACHIEVABLE_CREDIT_POINTS	NUMBER			Number of credit points awarded upon successful completion of the unit section.
ENROLLED_CREDIT_POINTS	NUMBER			Number of credit points in which the student is considered to be enrolled.
DIR_ENROLLMENT	NUMBER	(15)		Direct enrollment
ENR_FROM_WLST	NUMBER	(15)		Enrolled from waitlist
INQ_NOT_WLST	NUMBER	(15)		Inquired but not waitlist
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
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
REV_ACCOUNT_CD	VARCHAR2	(40)
AUDITABLE_IND	VARCHAR2	(1)		Indicates if a unit can be audited
AUDIT_PERMISSION_IND	VARCHAR2	(1)		Indicates if permission is required to audit
NOT_MULTIPLE_SECTION_FLAG	VARCHAR2	(1)		Indicating whether this unit section should be excluded from multiple unit section.
SUP_UOO_ID	NUMBER			The superior unit section's identifier for this unit section.
RELATION_TYPE	VARCHAR2	(30)		Indicate whether this unit section is superior,subordinate or none of above.
RELATION_TYPE_MEANING	VARCHAR2	(80)	Yes	Meaning for the relation type
DEFAULT_ENROLL_FLAG	VARCHAR2	(1)		Indicate whether to enroll the subordinate unit section when the superior unit section is enrolled.
CAL_INST_DESCRIPTION	VARCHAR2	(30)		Calendar instance description for the unit section.
BILLING_HRS	NUMBER			Billable Credit Points
ABORT_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the unit section is ABORTED.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      UOO_ID
,      UNIT_CD
,      VERSION_NUMBER
,      UNIT_STATUS
,      TITLE
,      CALL_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ALTERNATE_CODE
,      CAL_START_DT
,      CAL_END_DT
,      UNIT_CLASS
,      UNIT_MODE
,      LOCATION_CD
,      LOCATION_DESCRIPTION
,      UNIT_SECTION_STATUS
,      STATUS_DESCRIPTION
,      UNIT_SECTION_START_DATE
,      UNIT_SECTION_END_DATE
,      ENROLLMENT_ACTUAL
,      WAITLIST_ACTUAL
,      STATE_FINANCIAL_AID
,      FEDERAL_FINANCIAL_AID
,      INSTITUTIONAL_FINANCIAL_AID
,      IVRS_AVAILABLE_IND
,      GRADING_SCHEMA_PRCDNCE_IND
,      UNIT_QUOTA
,      UNIT_QUOTA_RESERVED_PLACES
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      UNIT_CONTACT
,      OFFERED_IND
,      OWNER_ORG_UNIT_CD
,      OU_START_DATE
,      OU_DESCRIPTION
,      ATTENDANCE_REQUIRED_IND
,      ANON_UNIT_GRADING_IND
,      ANON_ASSESS_GRADING_IND
,      NON_STD_USEC_IND
,      RESERVED_SEATING_ALLOWED
,      SPECIAL_PERMISSION_IND
,      SS_DISPLAY_IND
,      SS_ENROL_IND
,      ACHIEVABLE_CREDIT_POINTS
,      ENROLLED_CREDIT_POINTS
,      DIR_ENROLLMENT
,      ENR_FROM_WLST
,      INQ_NOT_WLST
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REV_ACCOUNT_CD
,      AUDITABLE_IND
,      AUDIT_PERMISSION_IND
,      NOT_MULTIPLE_SECTION_FLAG
,      SUP_UOO_ID
,      RELATION_TYPE
,      RELATION_TYPE_MEANING
,      DEFAULT_ENROLL_FLAG
,      CAL_INST_DESCRIPTION
,      BILLING_HRS
,      ABORT_FLAG
FROM APPS.IGS_PS_UNIT_OFR_OPT_V;

Dependencies

[top of page]

APPS.IGS_PS_UNIT_OFR_OPT_V references the following:

APPS: IGS_AD_LOCATION; IGS_AS_UNIT_CLASS; IGS_CA_INST; IGS_LOOKUP_VALUES; IGS_OR_INST_ORG_BASE_V; IGS_PS_UNIT_OFR_OPT; IGS_PS_UNIT_VER; IGS_PS_USEC_CPS

APPS.IGS_PS_UNIT_OFR_OPT_V is referenced by following:

APPS: IGS_AS_USEC_ATTEND_ENTRY_V; IGS_AS_USEC_CLASSLIST_V; IGS_AS_X_USEC_CLASSLIST_V; IGS_EN_USEC_EXAM_SCH_V; IGS_PS_CAL_RSR_VAL - show dependent code; IGS_PS_CAL_RSR_VAL - show dependent code; IGS_PS_GEN_004 - show dependent code; IGS_PS_USEC_OCCURS_FULL_V; IGS_PS_USEC_SCHEDULE - show dependent code; IGS_PS_US_EXAM_MEET_V; IGS_PS_WF_EVENT_HOOK_PKG - show dependent code