[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_PS_UNIT_OFR_OPT_SV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_PS_UNIT_OFR_OPT_SV
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row id | |
| UNIT_CD | 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. 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. |
| LOCATION_CD | 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 |
| UOO_ID | NUMBER | (7) | Yes | Unique identifier for a unit offering option. |
| 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. |
| CALL_NUMBER | NUMBER | Unique identifier needed to support Interactive Voice Response registration. | ||
| UNIT_SECTION_STATUS | VARCHAR2 | (30) | Status of unit section occurrence. For example, planned, inactive. | |
| 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_IND | 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. | |
| GRADING_SCHEMA_PRCDNCE_IND | 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. |
| 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. | |
| GRADING_SCHEMA_CD | VARCHAR2 | (10) | Yes | Code that identifies the grading schema. A grading schema describes the set of available marks and grades that can be used in the assessment of student unit attempts. There can be multiple grading schemas for any one institution. |
| GS_VERSION_NUMBER | NUMBER | (3) | Yes | System generated number used to identify the version of the grading schema. |
| UNIT_CONTACT | NUMBER | (15) | Person identification number of a staff member who is the contact for a particular unit offering. | |
| SS_ENROL_IND | VARCHAR2 | (1) | Self Service Enrollment Indicator | |
| 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) | Request identifier of last concurrent program to update this record. | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record. | |
| PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record. | |
| PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program. | ||
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | The responsible organization unit for the unit section | |
| ATTENDANCE_REQUIRED_IND | 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_IND | VARCHAR2 | (1) | Indicates if special permission is required for the unit | |
| SS_DISPLAY_IND | VARCHAR2 | (1) | Excludes unit from displaying in unit search windows in self service enrollments | |
| DIR_ENROLLMENT | NUMBER | (15) | Number of students enrolled, class open. | |
| ENR_FROM_WLST | NUMBER | (15) | Number of students enrolled from waitlist. | |
| INQ_NOT_WLST | NUMBER | (15) | Number of students who attempted to enroll (add unit to cart) but the section was full and waitlist either not offered or offered & student not interested | |
| REV_ACCOUNT_CD | 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 | |
| ANON_UNIT_GRADING_IND | VARCHAR2 | (1) | Anonymous Unit Grading Y / N | |
| ANON_ASSESS_GRADING_IND | VARCHAR2 | (1) | Anonymous Assessment Item Grading Y / N | |
| NON_STD_USEC_IND | VARCHAR2 | (1) | Indicates whether the Unit Section is Standard or Non Standard | |
| AUDITABLE_IND | VARCHAR2 | (1) | Indicates if the 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. | |
| DEFAULT_ENROLL_FLAG | VARCHAR2 | (1) | Indicate whether to enroll the subordinate unit section when the superior unit section is enrolled. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, LOCATION_CD
, UNIT_CLASS
, UOO_ID
, IVRS_AVAILABLE_IND
, CALL_NUMBER
, UNIT_SECTION_STATUS
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, ENROLLMENT_ACTUAL
, WAITLIST_ACTUAL
, OFFERED_IND
, STATE_FINANCIAL_AID
, GRADING_SCHEMA_PRCDNCE_IND
, FEDERAL_FINANCIAL_AID
, UNIT_QUOTA
, UNIT_QUOTA_RESERVED_PLACES
, INSTITUTIONAL_FINANCIAL_AID
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, UNIT_CONTACT
, SS_ENROL_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, OWNER_ORG_UNIT_CD
, ATTENDANCE_REQUIRED_IND
, RESERVED_SEATING_ALLOWED
, SPECIAL_PERMISSION_IND
, SS_DISPLAY_IND
, DIR_ENROLLMENT
, ENR_FROM_WLST
, INQ_NOT_WLST
, REV_ACCOUNT_CD
, ANON_UNIT_GRADING_IND
, ANON_ASSESS_GRADING_IND
, NON_STD_USEC_IND
, AUDITABLE_IND
, AUDIT_PERMISSION_IND
, NOT_MULTIPLE_SECTION_FLAG
, SUP_UOO_ID
, RELATION_TYPE
, DEFAULT_ENROLL_FLAG
FROM APPS.IGS_PS_UNIT_OFR_OPT_SV;
APPS
IGS_PS_UNIT_OFR_OPT_ALL
APPS
IGS_EN_USEC_STAT_V
|
|
|
|