[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_UNIT_OFFERING_OPTIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_UNIT_OFFERING_OPTIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This entity describes the Unit offering options with details about the unit section, grading schema details, attendance requirements, special permission and grading indicators.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| UNIT_CODE | VARCHAR2 | (10) | Yes | Unique identifier 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 |
| CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type in that the unit is offered. For example, SEM-1 semester 1 teaching period, TRI-2 trimester 2 teaching period, and SUM summer teaching period. Units can only be offered in instances of calendar types that are categorized as teaching calendars |
| CAL_INST_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique identifier for the calendar instance |
| LOCATION_CODE | VARCHAR2 | (10) | Yes | Institution-defined location code, typically of a campus, at that a unit offering option is offered |
| UNIT_CLASS | VARCHAR2 | (10) | Yes | Institution-defined code that identifies a unit class |
| IVR_AVAILABLE_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit offering option is available for enrolment via the Interactive Voice Response System (IVRS).Setting the indicator ticked enables students using the IVR System to enrol in the unit offering option |
| CALL_NUMBER | NUMBER | Unique identifier needed to support Interactive Voice Response registration | ||
| _LA:UNIT_SECTION_STATUS | CHAR | (69) | Status of unit section occurrence. For example, planned , inactive | |
| _LA:RELATION_TYPE | CHAR | (61) | Indicate whether this unit section is superior,subordinate or none of above. | |
| UNIT_SECTION_START_DATE | DATE | Start date of unit section is specified | ||
| UNIT_SECTION_END_DATE | DATE | End date of unit section is specified | ||
| ENROLLMENT_ACTUAL | NUMBER | (6) | Number of students enrolled in that unit section | |
| WAITLIST_ACTUAL | NUMBER | (6) | Number of students waitlisted in that unit section | |
| OFFERED_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit offering option is available for offering. Setting the checkbox ticked makes the offering available |
| STATE_FINANCIAL_AID | VARCHAR2 | (1) | Indicator for eligibility of the unit section to qualify for state financial aid funding | |
| FEDERAL_FINANCIAL_AID | VARCHAR2 | (1) | Indicator for eligibility of the unit section to qualify for federal financial aid funding | |
| UNIT_QUOTA | NUMBER | (6) | An enrollment quota that restricts the number of students who might be enrolled in a particular unit offering | |
| UNIT_QUOTA_RESERVED_PLACES | NUMBER | (6) | Subset of the enrollment quota that is presently reserved | |
| INSTITUTIONAL_FINANCIAL_AID | VARCHAR2 | (1) | Indicator for eligibility of the unit section to qualify for institutional financial aid funding | |
| GR_SCHEMA_PRECEDENCE_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether any grading schema attached to the unit offering option takes precedence over the grading schema attached to the enrolled student's program offering. Setting the indicator ticked causes the unit grading schema to take precedence. |
| UNIT_CONTACT_PERSON_ID | NUMBER | (15) | Person identification number of a staff member who is the contact for a particular unit offering | |
| SELF_SERVICE_ENROL_INDICATOR | VARCHAR2 | (1) | Self Service enrollment indicator | |
| OWNER_ORG_UNIT_CODE | VARCHAR2 | (30) | The responsible organization unit for the unit section | |
| ATTENDANCE_REQUIRED_INDICATOR | VARCHAR2 | (1) | Indicator to control the unit sections for which Attendance self service rosters are produced for faculty to enter/report Attendance Hours as per the date aliases set in Academic Record | |
| RESERVED_SEATING_ALLOWED | VARCHAR2 | (1) | If value is 'Y' then Reserved seating will be allowed otherwise Reserved seating will not be allowed. (Default value 'Y') | |
| SPECIAL_PERMISSION_INDICATOR | VARCHAR2 | (1) | Indicates if special permission is required for the unit | |
| SELF_SERVICE_DISPLAY_INDICATOR | VARCHAR2 | (1) | Self Service display indicator | |
| AUDITABLE_INDICATOR | VARCHAR2 | (1) | Auditable Indicator | |
| AUDIT_PERMISSION_INDICATOR | VARCHAR2 | (1) | Audit Permission Indicator | |
| NOT_MULTIPLE_SECTION_FLAG | VARCHAR2 | (1) | Indicating whether this unit section should be excluded from multiple unit section. | |
| DEFAULT_ENROLL_FLAG | VARCHAR2 | (1) | Indicate whether to enroll the subordinate unit section when the superior unit section is enrolled. | |
| DIRECT_ENROLLMENT | NUMBER | (15) | Number of students enrolled,class open | |
| ENROLLED_FROM_WAITLIST | NUMBER | (15) | Number of students enrolled from waitlist | |
| INQ_NOT_WAITLIST | NUMBER | (15) | Number of students who attempted to enrol (add unit to cart) but the section was full and waitlist either not offered or offered & student not interested | |
| REVENUE_ACCOUNT_CODE | VARCHAR2 | (40) | Revenue Account Code (An alpha numeric string) . It is populated with the revenue account code when GL is not installed and system uses any other external account systems | |
| ABORT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the occurrence is ABORTED. |
| UNIT_DESCRIPTION | VARCHAR2 | (90) | Yes | Unit Description |
| CAL_DESCRIPTION | VARCHAR2 | (30) | Calendar description | |
| LOCATION_DESCRIPTION | VARCHAR2 | (60) | Yes | Location description |
| UNIT_CLASS_DESCRIPTION | VARCHAR2 | (60) | Yes | Unit class description |
| UNIT_CONTACT_PERSON_NAME | VARCHAR2 | (360) | Person Name | |
| OWNER_ORG_UNIT_DESC | VARCHAR2 | (360) | Yes | Description of the responsible organization |
| REVENUE_ACCOUNT_DESC | VARCHAR2 | (60) | Revenue Account description | |
| ANON_UNIT_GRADING_INDICATOR | VARCHAR2 | (1) | Anonymous Unit Grading Indicator | |
| ANON_ASSESS_GRADING_INDICATOR | VARCHAR2 | (1) | Anonymous assessment grading indicator | |
| NON_STANDARD_USEC_INDICATOR | VARCHAR2 | (1) | Non Standard Unit Section Indicator | |
| UNIT_SECTION_ID | NUMBER | (7) | Yes | Unique identifier for a unit offering option |
| SUPERIOR_UNIT_SECTION_ID | NUMBER | The superior unit section's identifier for this unit section. | ||
| 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_CODE
, VERSION_NUMBER
, CAL_TYPE
, CAL_INST_SEQUENCE_NUMBER
, LOCATION_CODE
, UNIT_CLASS
, IVR_AVAILABLE_INDICATOR
, CALL_NUMBER
, _LA:UNIT_SECTION_STATUS
, _LA:RELATION_TYPE
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, ENROLLMENT_ACTUAL
, WAITLIST_ACTUAL
, OFFERED_INDICATOR
, STATE_FINANCIAL_AID
, FEDERAL_FINANCIAL_AID
, UNIT_QUOTA
, UNIT_QUOTA_RESERVED_PLACES
, INSTITUTIONAL_FINANCIAL_AID
, GR_SCHEMA_PRECEDENCE_INDICATOR
, UNIT_CONTACT_PERSON_ID
, SELF_SERVICE_ENROL_INDICATOR
, OWNER_ORG_UNIT_CODE
, ATTENDANCE_REQUIRED_INDICATOR
, RESERVED_SEATING_ALLOWED
, SPECIAL_PERMISSION_INDICATOR
, SELF_SERVICE_DISPLAY_INDICATOR
, AUDITABLE_INDICATOR
, AUDIT_PERMISSION_INDICATOR
, NOT_MULTIPLE_SECTION_FLAG
, DEFAULT_ENROLL_FLAG
, DIRECT_ENROLLMENT
, ENROLLED_FROM_WAITLIST
, INQ_NOT_WAITLIST
, REVENUE_ACCOUNT_CODE
, ABORT_FLAG
, UNIT_DESCRIPTION
, CAL_DESCRIPTION
, LOCATION_DESCRIPTION
, UNIT_CLASS_DESCRIPTION
, UNIT_CONTACT_PERSON_NAME
, OWNER_ORG_UNIT_DESC
, REVENUE_ACCOUNT_DESC
, ANON_UNIT_GRADING_INDICATOR
, ANON_ASSESS_GRADING_INDICATOR
, NON_STANDARD_USEC_INDICATOR
, UNIT_SECTION_ID
, SUPERIOR_UNIT_SECTION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_UNIT_OFFERING_OPTIONS;
APPS
HZ_PARTIES
IGS_AD_LOCATION_ALL
IGS_AS_UNIT_CLASS_ALL
IGS_CA_INST_ALL
IGS_FI_ACC_ALL
IGS_OR_INST_ORG_BASE_V
IGS_PS_UNIT_OFR_OPT_ALL
IGS_PS_UNIT_VER_ALL
APPS.IGSFV_UNIT_OFFERING_OPTIONS is not referenced by any database object
|
|
|
|