[Home] [Help] [Dependency Information]
Object Name: | IGSFV_HIGH_ED_UNIT_VERSIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_HIGH_ED_UNIT_VERSIONS |
Subobject Name: | |
Status: | VALID |
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.
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 | |
_DF | CHAR | (32) | Descriptive Flexfields | |
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 | |
REPORTING_FAMILY_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 | |
UNIT_STATUS_DESCRIPTION | VARCHAR2 | (60) | Yes | Description of the unit status |
UNIT_LEVEL_DESCRIPTION | VARCHAR2 | (60) | Unit Level Description | |
COORD_PERSON_NAME | VARCHAR2 | (360) | Yes | Coordinator Person Name |
OWNER_ORG_UNIT_DESC | VARCHAR2 | (360) | Yes | Description of Organization Unit Code |
UNIT_INT_COURSE_LEVEL_DESC | VARCHAR2 | (60) | Unit course level description | |
ENROL_LOAD_CAL_DESC | VARCHAR2 | (30) | Enrolment Load Calendar description | |
OFFERED_LOAD_CAL_DESC | VARCHAR2 | (30) | Offered Load Calendar Description | |
CURRICULUM_DESCRIPTION | VARCHAR2 | (80) | Curriculum description | |
REPORTING_FAMILY_DESCRIPTION | VARCHAR2 | (80) | Reporting Family description | |
UNIT_TYPE_DESCRIPTION | VARCHAR2 | (80) | Unit Type Id description | |
REVENUE_ACCOUNT_DESC | VARCHAR2 | (60) | Revenue Account description | |
_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 |
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
, _DF
, 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
, REPORTING_FAMILY_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
, UNIT_STATUS_DESCRIPTION
, UNIT_LEVEL_DESCRIPTION
, COORD_PERSON_NAME
, OWNER_ORG_UNIT_DESC
, UNIT_INT_COURSE_LEVEL_DESC
, ENROL_LOAD_CAL_DESC
, OFFERED_LOAD_CAL_DESC
, CURRICULUM_DESCRIPTION
, REPORTING_FAMILY_DESCRIPTION
, UNIT_TYPE_DESCRIPTION
, REVENUE_ACCOUNT_DESC
, _LA:CP_DESCRIPTOR_MEANING
, _LA:WORKLOAD_VALIDATION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_HIGH_ED_UNIT_VERSIONS;
APPS.IGSFV_HIGH_ED_UNIT_VERSIONS is not referenced by any database object
|
|
|