[Home] [Help] [Dependency Information]
Object Name: | IGS_SS_EN_ENROLL_CART_RSLT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SS_EN_ENROLL_CART_RSLT_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
Enrollment Worksheet Result
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_CD | VARCHAR2 | (10) | Yes | Unit Code |
CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar Type |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Sequence Number |
VERSION_NUMBER | NUMBER | (3) | Yes | Unit Version Number |
UNIT_STATUS | VARCHAR2 | (10) | Yes | Unit Status |
TITLE_OVERRIDE_IND | VARCHAR2 | (1) | Yes | Title Override Indicator |
ABBREVIATION | VARCHAR2 | (20) | Yes | Abbreviation |
TITLE | VARCHAR2 | (90) | Yes | Title |
SHORT_TITLE | VARCHAR2 | (40) | Yes | Short Title |
UOO_ID | NUMBER | (7) | Yes | Unit Offering Option Identifier |
CALL_NUMBER | NUMBER | Call Number | ||
UNIT_SECTION_STATUS | VARCHAR2 | (30) | Unit Section Status | |
UNIT_CLASS | VARCHAR2 | (10) | Yes | Unit Class |
LOCATION_CD | VARCHAR2 | (10) | Yes | Location Code |
START_DATE | VARCHAR2 | (11) | Start Date | |
END_DATE | VARCHAR2 | (11) | End Date | |
SEMESTER | VARCHAR2 | (40) | Semester | |
SUBTITLE | VARCHAR2 | (80) | Subtitle | |
SUBTITLE_MODIFIABLE_FLAG | VARCHAR2 | (1) | Subtitle Modifiable Flag | |
ENROLLMENT_ACTUAL | NUMBER | (6) | Actual Enrollment | |
ENROLLMENT_MINIMUM | NUMBER | Minimum Enrollment | ||
ENROLLMENT_MAXIMUM | NUMBER | Maximum Enrollment | ||
TEACH_CAL_DESCRIPTION | VARCHAR2 | (30) | Teaching Calendar Instance Description | |
UNIT_SECTION_START_DT | DATE | Unit Section Start Date | ||
UNIT_SECTION_END_DT | DATE | Unit Section End Date | ||
LOC_DESCRIPTION | VARCHAR2 | (60) | Yes | Location Description |
ORG_UNIT_CD | VARCHAR2 | (30) | Yes | Organisation Unit Code |
ENROLL_MAX_ACT | VARCHAR2 | (4000) | Enrollment Maximum | |
WAITLIST_MAX_ACT | VARCHAR2 | (82) | Waitlist Maximum | |
TITLE_SUBTITLE | VARCHAR2 | (4000) | Title Subtitle Combination | |
CREDIT_POINTS | NUMBER | Credit Points | ||
GRADING_SCHEMA | VARCHAR2 | (4000) | Grading Schema | |
OCCUR_LOCATION_DESC | VARCHAR2 | (4000) | Occurrence Location Description | |
OCCUR_LOCATION_CODE | VARCHAR2 | (4000) | Occurrence Location Code | |
OCCUR_NO_LOCATION | VARCHAR2 | (4000) | Occurrence No Location Indicator | |
SS_DISPLAY_IND | VARCHAR2 | (1) | Excludes unit from displaying in unit search windows in self service enrollments | |
SS_ENROL_IND | VARCHAR2 | (1) | Self Service enrollment indicator | |
AUDITABLE_IND | VARCHAR2 | (1) | Indicates whether the unit can be attempted for Audit. | |
USEC_PART_OF_GROUP | VARCHAR2 | (4000) | Indicates whether the unit section is a part of any group | |
SUP_UOO_ID | NUMBER | Superior unit section identifier | ||
RELATION_TYPE | VARCHAR2 | (30) | Relation type. Superior, subordinate or none | |
SUP_SUB_DETAILS | VARCHAR2 | (4000) | Superior or subordinate details | |
PRACTICAL_IND | VARCHAR2 | (1) | Yes | Placement Indicator |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, VERSION_NUMBER
, UNIT_STATUS
, TITLE_OVERRIDE_IND
, ABBREVIATION
, TITLE
, SHORT_TITLE
, UOO_ID
, CALL_NUMBER
, UNIT_SECTION_STATUS
, UNIT_CLASS
, LOCATION_CD
, START_DATE
, END_DATE
, SEMESTER
, SUBTITLE
, SUBTITLE_MODIFIABLE_FLAG
, ENROLLMENT_ACTUAL
, ENROLLMENT_MINIMUM
, ENROLLMENT_MAXIMUM
, TEACH_CAL_DESCRIPTION
, UNIT_SECTION_START_DT
, UNIT_SECTION_END_DT
, LOC_DESCRIPTION
, ORG_UNIT_CD
, ENROLL_MAX_ACT
, WAITLIST_MAX_ACT
, TITLE_SUBTITLE
, CREDIT_POINTS
, GRADING_SCHEMA
, OCCUR_LOCATION_DESC
, OCCUR_LOCATION_CODE
, OCCUR_NO_LOCATION
, SS_DISPLAY_IND
, SS_ENROL_IND
, AUDITABLE_IND
, USEC_PART_OF_GROUP
, SUP_UOO_ID
, RELATION_TYPE
, SUP_SUB_DETAILS
, PRACTICAL_IND
FROM APPS.IGS_SS_EN_ENROLL_CART_RSLT_V;
APPS.IGS_SS_EN_ENROLL_CART_RSLT_V is not referenced by any database object
|
|
|