[Home] [Help] [Dependency Information]
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 |
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. | |
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. |
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;
|
|
|