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

VIEW: APPS.IGSBV_HIGH_ED_UNIT_VERSIONS

Object Details
Object Name: IGSBV_HIGH_ED_UNIT_VERSIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_HIGH_ED_UNIT_VERSIONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This entity describes the Unit version details with title information, important dates, maximum/minimum/increment points, details regarding enrolment with enrolment/offered load calendar types and sequence numbers.


[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIT_CODE VARCHAR2 (10) Yes Unit Code
VERSION_NUMBER NUMBER (3) Yes Version Number
START_DATE DATE
Yes Start Date
REVIEW_DATE DATE

Review Date
EXPIRY_DATE DATE

Expiry Date
END_DATE DATE

End Date
UNIT_STATUS VARCHAR2 (10) Yes Unit Status
TITLE VARCHAR2 (90) Yes Title
SHORT_TITLE VARCHAR2 (40) Yes Short Title
TITLE_OVERRIDE_INDICATOR VARCHAR2 (1) Yes Title Override Indicator
ABBREVIATION VARCHAR2 (20) Yes Abbreviation of the Title
UNIT_LEVEL VARCHAR2 (4) Yes Unit Level
CREDIT_POINT_DESCRIPTOR VARCHAR2 (30) Yes Credit Point descriptor -Obsolete
ENROLLED_CREDIT_POINTS NUMBER (6) Yes Enroled Credit Points
POINTS_OVERRIDE_INDICATOR VARCHAR2 (1) Yes Point Override indicator
SUPP_EXAM_PERM_INDICATOR VARCHAR2 (1) Yes Supplemental Exam Permission Indicator
COORD_PERSON_ID NUMBER (15) Yes Coordinator Person Id
OWNER_ORG_UNIT_CD VARCHAR2 (30) Yes Organization Unit Code of Owner
OWNER_ORG_UNIT_START_DATE DATE
Yes Organization Unit Start Date of the owner
AWARD_COURSE_ONLY_INDICATOR VARCHAR2 (1) Yes Award Course Only Indicator
RESEARCH_UNIT_INDICATOR VARCHAR2 (1) Yes Research Unit Indicator
SUB_UNIT_ALLOWED_INDICATOR VARCHAR2 (1)
Sub Unit Allowed Indicator Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete
SUP_UNIT_ALLOWED_INDICATOR VARCHAR2 (1)
Superior Unit Allowed Indicator . Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete
INDUSTRIAL_INDICATOR VARCHAR2 (1) Yes Industrial Indicator
PRACTICAL_INDICATOR VARCHAR2 (1) Yes Practical Indicator
REPEATABLE_INDICATOR VARCHAR2 (1) Yes Repeatable Indicator
ASSESSABLE_INDICATOR VARCHAR2 (1) Yes Assessable Indicator
ACHIEVABLE_CREDIT_POINTS NUMBER (6)
Achievable Credit Points
POINTS_INCREMENT NUMBER (6)
Increment Points
POINTS_MINIMUM NUMBER (6)
Minimum Points
POINTS_MAXIMUM NUMBER (6)
Maximum Points
UNIT_INT_COURSE_LEVEL_CODE VARCHAR2 (10)
Course Level Code
SUBTITLE VARCHAR2 (90)
Subtitle
SUBTITLE_MODIFIABLE_FLAG VARCHAR2 (1)
Subtitle modifiable flag
APPROVAL_DATE DATE

Approval date
LECTURE_CREDIT_POINTS NUMBER (6)
Lecture Credit Points
LAB_CREDIT_POINTS NUMBER (6)
Laboratory Credit points
OTHER_CREDIT_POINTS NUMBER (6)
Other Credit Points
BILLING_CREDIT_POINTS NUMBER

Audit credit points
CLOCK_HOURS NUMBER (6)
Clock Hours
WORK_LOAD_CP_LECTURE NUMBER (6)
Work Load Credit Point Lecture
WORK_LOAD_CP_LAB NUMBER (6)
Work Load Credit Point Laboratory
CONTINUING_EDUCATION_UNITS NUMBER (6)
Continuing Education Units
ENROLLMENT_EXPECTED NUMBER

Expected Enrolment
ENROLLMENT_MINIMUM NUMBER

Minimum Enrolment
ENROLLMENT_MAXIMUM NUMBER

Maximum Enrolment
ADVANCE_MAXIMUM NUMBER

Maximum Advance
BILLABLE_CREDIT_POINTS NUMBER

Billable Credit Points
STATE_FINANCIAL_AID VARCHAR2 (1)
State Financial Aid
FEDERAL_FINANCIAL_AID VARCHAR2 (1)
Federal Financial Aid
INSTITUTIONAL_FINANCIAL_AID VARCHAR2 (1)
Institutional Financial Aid
SAME_TEACHING_PERIOD VARCHAR2 (1)
Same Teaching Period
MAXIMUM_CREDITS_FOR_REPEAT NUMBER

Maximum Credit Points for Repeat
MAXIMUM_CREDITS_FOR_FUNDING NUMBER

Maximum Credit Points for funding
MAXIMUM_REPEAT_CREDIT_POINTS NUMBER (6)
Maximum Repeatable credit points
SAME_TEACH_PERIOD_REPEATS NUMBER

Same Teaching Period Repeats
SAME_TEACH_PERIOD_REPEATS_CP NUMBER (6)
Credit Points for same Teaching Period Repeats
IVR_ENROL_INDICATOR VARCHAR2 (1)
Interactive Voice Response Enrolment Indicator
SS_ENROL_INDICATOR VARCHAR2 (1)
Self Service Enrolment Indicator
SUBTITLE_ID NUMBER

Subtitle Id
WORK_LOAD_OTHER NUMBER (5)
Other Work Load
CONTACT_HOURS_LECTURE NUMBER (5)
Lecture Contact Hours
CONTACT_HOURS_LABORATORY NUMBER (5)
Laboratory Contact Hours
CONTACT_HOURS_OTHER NUMBER (5)
Other Contact Hours
NON_SCHED_REQUIRED_HOURS NUMBER (5)
Required Non Scheduled hours
EXCLUDE_FROM_MAX_CP_LIMIT VARCHAR2 (1)
Exclude from Maximum Credit Point Limit
RECORD_EXCLUSION_FLAG VARCHAR2 (1)
Record Exclusion Flag
SS_DISP_INDICATOR VARCHAR2 (1)
Self Service Display Indicator
ENROL_LOAD_CALENDAR_TYPE VARCHAR2 (10)
Enrolment Load Calendar Type
ENROL_LOAD_CAL_SEQ_NUMBER NUMBER (6)
Enrolment Load Calendar Sequence Number
OFFERED_LOAD_CALENDAR_TYPE VARCHAR2 (10)
Offered Load Calendar Type
OFFERED_LOAD_CAL_SEQ_NUMBER NUMBER (6)
Offered Load Calendar Sequence Number
CURRICULUM_ID VARCHAR2 (10)
Curriculum Id
OVERRIDE_ENROL_MAXIMUM NUMBER (6)
Enrolment Maximum Override
RPT_FMLY_ID NUMBER

Repeat Family Id
UNIT_TYPE_ID NUMBER

Unit Type Id
SPL_PERMISSION_INDICATOR VARCHAR2 (1)
Special Permission Indicator
REVENUE_ACCOUNTS_CODE VARCHAR2 (40)
Revenue Account Code
CLAIMABLE_HOURS NUMBER (7)
Claimable Hours
ANON_UNITS_GRADING_INDICATOR VARCHAR2 (1)
Anonymous Unit grading indicator
ANON_ASSESS_GRADING_INDICATOR VARCHAR2 (1)
Anonymous assessment grading indicator
AUDITABLE_INDICATOR VARCHAR2 (1)
Auditable Indicator
AUDIT_PERMISSION_INDICATOR VARCHAR2 (1)
Audit Permission Indicator
MAXIMUM_AUDITORS_ALLOWED NUMBER (6)
Maximum Auditors Allowed
WORKLOAD_VALIDATION_FLAG VARCHAR2 (1)
Override workload validation flag
_LA:CP_DESCRIPTOR_MEANING CHAR (71)
Credit Point descriptor
_LA:WORKLOAD_VALIDATION CHAR (61)
Workload validation type
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
Query Text

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


SELECT UNIT_CODE
,      VERSION_NUMBER
,      START_DATE
,      REVIEW_DATE
,      EXPIRY_DATE
,      END_DATE
,      UNIT_STATUS
,      TITLE
,      SHORT_TITLE
,      TITLE_OVERRIDE_INDICATOR
,      ABBREVIATION
,      UNIT_LEVEL
,      CREDIT_POINT_DESCRIPTOR
,      ENROLLED_CREDIT_POINTS
,      POINTS_OVERRIDE_INDICATOR
,      SUPP_EXAM_PERM_INDICATOR
,      COORD_PERSON_ID
,      OWNER_ORG_UNIT_CD
,      OWNER_ORG_UNIT_START_DATE
,      AWARD_COURSE_ONLY_INDICATOR
,      RESEARCH_UNIT_INDICATOR
,      SUB_UNIT_ALLOWED_INDICATOR
,      SUP_UNIT_ALLOWED_INDICATOR
,      INDUSTRIAL_INDICATOR
,      PRACTICAL_INDICATOR
,      REPEATABLE_INDICATOR
,      ASSESSABLE_INDICATOR
,      ACHIEVABLE_CREDIT_POINTS
,      POINTS_INCREMENT
,      POINTS_MINIMUM
,      POINTS_MAXIMUM
,      UNIT_INT_COURSE_LEVEL_CODE
,      SUBTITLE
,      SUBTITLE_MODIFIABLE_FLAG
,      APPROVAL_DATE
,      LECTURE_CREDIT_POINTS
,      LAB_CREDIT_POINTS
,      OTHER_CREDIT_POINTS
,      BILLING_CREDIT_POINTS
,      CLOCK_HOURS
,      WORK_LOAD_CP_LECTURE
,      WORK_LOAD_CP_LAB
,      CONTINUING_EDUCATION_UNITS
,      ENROLLMENT_EXPECTED
,      ENROLLMENT_MINIMUM
,      ENROLLMENT_MAXIMUM
,      ADVANCE_MAXIMUM
,      BILLABLE_CREDIT_POINTS
,      STATE_FINANCIAL_AID
,      FEDERAL_FINANCIAL_AID
,      INSTITUTIONAL_FINANCIAL_AID
,      SAME_TEACHING_PERIOD
,      MAXIMUM_CREDITS_FOR_REPEAT
,      MAXIMUM_CREDITS_FOR_FUNDING
,      MAXIMUM_REPEAT_CREDIT_POINTS
,      SAME_TEACH_PERIOD_REPEATS
,      SAME_TEACH_PERIOD_REPEATS_CP
,      IVR_ENROL_INDICATOR
,      SS_ENROL_INDICATOR
,      SUBTITLE_ID
,      WORK_LOAD_OTHER
,      CONTACT_HOURS_LECTURE
,      CONTACT_HOURS_LABORATORY
,      CONTACT_HOURS_OTHER
,      NON_SCHED_REQUIRED_HOURS
,      EXCLUDE_FROM_MAX_CP_LIMIT
,      RECORD_EXCLUSION_FLAG
,      SS_DISP_INDICATOR
,      ENROL_LOAD_CALENDAR_TYPE
,      ENROL_LOAD_CAL_SEQ_NUMBER
,      OFFERED_LOAD_CALENDAR_TYPE
,      OFFERED_LOAD_CAL_SEQ_NUMBER
,      CURRICULUM_ID
,      OVERRIDE_ENROL_MAXIMUM
,      RPT_FMLY_ID
,      UNIT_TYPE_ID
,      SPL_PERMISSION_INDICATOR
,      REVENUE_ACCOUNTS_CODE
,      CLAIMABLE_HOURS
,      ANON_UNITS_GRADING_INDICATOR
,      ANON_ASSESS_GRADING_INDICATOR
,      AUDITABLE_INDICATOR
,      AUDIT_PERMISSION_INDICATOR
,      MAXIMUM_AUDITORS_ALLOWED
,      WORKLOAD_VALIDATION_FLAG
,      _LA:CP_DESCRIPTOR_MEANING
,      _LA:WORKLOAD_VALIDATION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_HIGH_ED_UNIT_VERSIONS;

Dependencies

[top of page]

APPS.IGSBV_HIGH_ED_UNIT_VERSIONS references the following:

SchemaAPPS
SynonymIGS_PS_UNIT_VER_ALL

APPS.IGSBV_HIGH_ED_UNIT_VERSIONS is not referenced by any database object