[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_PS_UNIT_VER_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_PS_UNIT_VER_ALL
|
| Subobject Name: | |
| Status: | VALID |
This entity describes a version of a unit, which is offered by the university.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_PS_UNIT_VER_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 UNIT_CD
VERSION_NUMBER
|
| IGS_PS_UNIT_VER_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UNIT_STATUS
|
| IGS_PS_UNIT_VER_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UNIT_LEVEL
|
| IGS_PS_UNIT_VER_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREDIT_POINT_DESCRIPTOR
|
| IGS_PS_UNIT_VER_ALL_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COORD_PERSON_ID
|
| IGS_PS_UNIT_VER_ALL_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OWNER_ORG_UNIT_CD
OWNER_OU_START_DT
|
| IGS_PS_UNIT_VER_ALL_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UNIT_INT_COURSE_LEVEL_CD
|
| IGS_PS_UNIT_VER_ALL_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TITLE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| UNIT_CD | VARCHAR2 | (10) | Yes | Unique identifier of the unit. |
| VERSION_NUMBER | NUMBER | (3) | Yes | Version number of the unit. Students are normally enrolled in the current version. Prior versions are end-dated. |
| START_DT | DATE | Yes | Date on that this version of the unit became current. | |
| REVIEW_DT | DATE | Date on that this version of the unit is due for review. | ||
| EXPIRY_DT | DATE | Date on that the unit version expires. Students already studying this unit version may remain enrolled. No further enrollments are normally allowable. | ||
| END_DT | DATE | Date on that this version of the unit ends. No students can remain enrolled in unit after its end date has been reached. | ||
| UNIT_STATUS | VARCHAR2 | (10) | Yes | Institution-defined status of a unit that maps to a system unit status. |
| TITLE | VARCHAR2 | (90) | Yes | Title of the unit. |
| SHORT_TITLE | VARCHAR2 | (40) | Yes | Short name of the unit. |
| TITLE_OVERRIDE_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the title of the unit can be overridden at the student unit attempt level. Setting the checkbox ticked allows the title to be overridden. |
| ABBREVIATION | VARCHAR2 | (20) | Yes | Abbreviated name of the unit. |
| UNIT_LEVEL | VARCHAR2 | (4) | Yes | Normal year level of the unit. |
| CREDIT_POINT_DESCRIPTOR | VARCHAR2 | (30) | Yes | Institution's name for credit points. |
| ENROLLED_CREDIT_POINTS | NUMBER | (6) | Yes | Number of credit points in that the student is considered to be enrolled. |
| POINTS_OVERRIDE_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether it is possible to override the number of credit points awarded upon successful completion on the unit. Setting the checkbox ticked allows the enrolled credit points and the enrolled EFTSU to be overridden. |
| SUPP_EXAM_PERMITTED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether a supplementary examination or other supplementary assessment can be granted in this unit. Setting the checkbox ticked allows supplementary assessment to be granted. |
| COORD_PERSON_ID | NUMBER | (15) | Yes | Person identification number of the unit coordinator. |
| OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | Yes | Code of the organizational unit that owns the unit. |
| OWNER_OU_START_DT | DATE | Yes | Date on that the owning organizational unit became current. | |
| AWARD_COURSE_ONLY_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit is available only to award program students. Setting the checkbox ticked restricts enrollment to award program students. |
| RESEARCH_UNIT_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit is classified as a research unit. Setting the checkbox ticked classifies the unit as research. Research units are normally only available to students enrolled in research programs. |
| SUB_UNIT_ALLOWED_IND | VARCHAR2 | (1) | Indicator that specifies whether this unit can be classified as a sub-unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a sub-unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete | |
| SUP_UNIT_ALLOWED_IND | VARCHAR2 | (1) | Indicator that specifies whether this unit can be classified as a superior unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a superior unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete | |
| INDUSTRIAL_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit is classified as an industrial experience unit. |
| PRACTICAL_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit is classified as a practical experience unit. |
| REPEATABLE_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit can count more than once towards the satisfaction of program requirements. Setting the checkbox ticked enables a student to repeat an already passed unit. |
| ASSESSABLE_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit is assessed. Setting the checkbox ticked indicates that the unit is assessed. |
| ACHIEVABLE_CREDIT_POINTS | NUMBER | (6) | Number of credit points awarded upon successful completion of the unit. | |
| POINTS_INCREMENT | NUMBER | (6) | If the override credit points indicator is set, this field records the allowable credit point increment. | |
| POINTS_MIN | NUMBER | (6) | If the override credit point indicator is set, this field records the minimum number of credit points that can be awarded upon successful completion of the unit. | |
| POINTS_MAX | NUMBER | (6) | If the override credit point indicator is set, this field records the maximum number of credit points that can be awarded upon successful completion of the unit. | |
| UNIT_INT_COURSE_LEVEL_CD | VARCHAR2 | (10) | Internal program level grouping of the unit. | |
| SUBTITLE | VARCHAR2 | (90) | Obsolete - Subordinate name | |
| SUBTITLE_MODIFIABLE_FLAG | VARCHAR2 | (1) | Sub Title modifiable or not indicator | |
| 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 | |
| CLOCK_HOURS | NUMBER | (6) | Clock hours | |
| BILLING_CREDIT_POINTS | NUMBER | Audit Credit Points | ||
| WORK_LOAD_CP_LECTURE | NUMBER | (6) | Lecture work load credit point | |
| WORK_LOAD_CP_LAB | NUMBER | (6) | Lab workload credit points | |
| CONTINUING_EDUCATION_UNITS | NUMBER | (6) | Continuing education units | |
| ENROLLMENT_EXPECTED | NUMBER | Expected enrollment | ||
| ENROLLMENT_MINIMUM | NUMBER | Minimum enrollment | ||
| ENROLLMENT_MAXIMUM | NUMBER | Maximum enrollment | ||
| ADVANCE_MAXIMUM | NUMBER | Maximum waitlist in advance | ||
| 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 indicator | |
| MAX_REPEATS_FOR_CREDIT | NUMBER | Number of maximum repeats for credits | ||
| MAX_REPEATS_FOR_FUNDING | NUMBER | Number of maximum repeats for funding | ||
| MAX_REPEAT_CREDIT_POINTS | NUMBER | (6) | Maximum repeat credit points | |
| SAME_TEACH_PERIOD_REPEATS | NUMBER | Same teaching period repeats | ||
| SAME_TEACH_PERIOD_REPEATS_CP | NUMBER | (6) | Same teaching period repeats credit points | |
| IVR_ENROL_IND | VARCHAR2 | (1) | IVR Enrollment Indicator | |
| CLAIMABLE_HOURS | NUMBER | (7) | The maximum hours that a student in a class can claim | |
| ANON_UNIT_GRADING_IND | VARCHAR2 | (1) | Anonymous Unit Grading Y / N | |
| ANON_ASSESS_GRADING_IND | VARCHAR2 | (1) | Anonymous Assessment Item Grading Y / N | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| SS_ENROL_IND | VARCHAR2 | (1) | Self Service Enrollment Indicator | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| 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 | |
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| SUBTITLE_ID | NUMBER | This field is Foreign key to IGS_PS_UNIT_SUBTITLE. It indicates the subtitle identifier for subtitle associated with the unit | ||
| WORK_LOAD_OTHER | NUMBER | (5) | Work load for any component other than lecture and laboratory. | |
| CONTACT_HRS_LECTURE | NUMBER | (5) | Contact Hours for Lecture. | |
| CONTACT_HRS_LAB | NUMBER | (5) | Contact hours for Laboratory | |
| CONTACT_HRS_OTHER | NUMBER | (5) | Contact hours for any component other than lecture and laboratory. | |
| BILLING_HRS | NUMBER | Billable Credit Points | ||
| NON_SCHD_REQUIRED_HRS | NUMBER | (5) | Non Scheduled Required Hours | |
| FIN_AID_CP | NUMBER | (5) | Financial Aid Credit Points - Obsolete | |
| FIN_AID_HRS | NUMBER | (5) | Financial Aid Hours - Obsolete | |
| EXCLUDE_FROM_MAX_CP_LIMIT | VARCHAR2 | (1) | Excludes a unit's achievable credit points from counting in a student's maximum credit points limit. | |
| RECORD_EXCLUSION_FLAG | VARCHAR2 | (1) | Excludes unit from displaying in self service records windows and on transcripts, and excludes unit from GPA calculations | |
| SS_DISPLAY_IND | VARCHAR2 | (1) | Excludes unit from displaying in unit search windows in self service enrollments. | |
| CAL_TYPE_ENROL_LOAD_CAL | VARCHAR2 | (10) | Load Calendar type associated with Teaching Period in which unit was last offered and has actual enrollment > 0 | |
| SEQUENCE_NUM_ENROL_LOAD_CAL | NUMBER | (6) | Load Calendar Instance associated with Teaching Period in which unit was last offered and has actual enrollment > 0 | |
| CAL_TYPE_OFFER_LOAD_CAL | VARCHAR2 | (10) | Load Calendar associated with Teaching Period in which unit was last offered. Sections which were offered and subsequently cancelled will be included in this field. | |
| SEQUENCE_NUM_OFFER_LOAD_CAL | NUMBER | (6) | Load Calendar Instance associated with Teaching Period in which unit was last offered. Sections which were offered and subsequently cancelled will be included in this field. | |
| CURRICULUM_ID | VARCHAR2 | (10) | Master unit Identifier. Links different versions of unit when then unit code changes. | |
| OVERRIDE_ENROLLMENT_MAX | NUMBER | (6) | This field stores the value till which the actual enrollment can increase without requiring that the maximum enrollment be increased. | |
| RPT_FMLY_ID | NUMBER | Indicates the repeat family to which the unit belongs. | ||
| UNIT_TYPE_ID | NUMBER | Indicates the unit program type level to which the unit belongs. | ||
| SPECIAL_PERMISSION_IND | VARCHAR2 | (1) | Indicates if special permission is required for the unit | |
| 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 | |
| AUDITABLE_IND | VARCHAR2 | (1) | Indicates if the unit can be audited | |
| AUDIT_PERMISSION_IND | VARCHAR2 | (1) | Indicates if permission is required to audit | |
| MAX_AUDITORS_ALLOWED | NUMBER | (6) | Indicates maximum number of auditors allowed | |
| OVRD_WKLD_VAL_FLAG | VARCHAR2 | (1) | Override workload validation flag | |
| WORKLOAD_VAL_CODE | VARCHAR2 | (30) | Workload validation type |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_CD
, VERSION_NUMBER
, START_DT
, REVIEW_DT
, EXPIRY_DT
, END_DT
, UNIT_STATUS
, TITLE
, SHORT_TITLE
, TITLE_OVERRIDE_IND
, ABBREVIATION
, UNIT_LEVEL
, CREDIT_POINT_DESCRIPTOR
, ENROLLED_CREDIT_POINTS
, POINTS_OVERRIDE_IND
, SUPP_EXAM_PERMITTED_IND
, COORD_PERSON_ID
, OWNER_ORG_UNIT_CD
, OWNER_OU_START_DT
, AWARD_COURSE_ONLY_IND
, RESEARCH_UNIT_IND
, SUB_UNIT_ALLOWED_IND
, SUP_UNIT_ALLOWED_IND
, INDUSTRIAL_IND
, PRACTICAL_IND
, REPEATABLE_IND
, ASSESSABLE_IND
, ACHIEVABLE_CREDIT_POINTS
, POINTS_INCREMENT
, POINTS_MIN
, POINTS_MAX
, UNIT_INT_COURSE_LEVEL_CD
, SUBTITLE
, SUBTITLE_MODIFIABLE_FLAG
, APPROVAL_DATE
, LECTURE_CREDIT_POINTS
, LAB_CREDIT_POINTS
, OTHER_CREDIT_POINTS
, CLOCK_HOURS
, BILLING_CREDIT_POINTS
, WORK_LOAD_CP_LECTURE
, WORK_LOAD_CP_LAB
, CONTINUING_EDUCATION_UNITS
, ENROLLMENT_EXPECTED
, ENROLLMENT_MINIMUM
, ENROLLMENT_MAXIMUM
, ADVANCE_MAXIMUM
, STATE_FINANCIAL_AID
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, SAME_TEACHING_PERIOD
, MAX_REPEATS_FOR_CREDIT
, MAX_REPEATS_FOR_FUNDING
, MAX_REPEAT_CREDIT_POINTS
, SAME_TEACH_PERIOD_REPEATS
, SAME_TEACH_PERIOD_REPEATS_CP
, IVR_ENROL_IND
, CLAIMABLE_HOURS
, ANON_UNIT_GRADING_IND
, ANON_ASSESS_GRADING_IND
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, SS_ENROL_IND
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, SUBTITLE_ID
, WORK_LOAD_OTHER
, CONTACT_HRS_LECTURE
, CONTACT_HRS_LAB
, CONTACT_HRS_OTHER
, BILLING_HRS
, NON_SCHD_REQUIRED_HRS
, FIN_AID_CP
, FIN_AID_HRS
, EXCLUDE_FROM_MAX_CP_LIMIT
, RECORD_EXCLUSION_FLAG
, SS_DISPLAY_IND
, CAL_TYPE_ENROL_LOAD_CAL
, SEQUENCE_NUM_ENROL_LOAD_CAL
, CAL_TYPE_OFFER_LOAD_CAL
, SEQUENCE_NUM_OFFER_LOAD_CAL
, CURRICULUM_ID
, OVERRIDE_ENROLLMENT_MAX
, RPT_FMLY_ID
, UNIT_TYPE_ID
, SPECIAL_PERMISSION_IND
, REV_ACCOUNT_CD
, AUDITABLE_IND
, AUDIT_PERMISSION_IND
, MAX_AUDITORS_ALLOWED
, OVRD_WKLD_VAL_FLAG
, WORKLOAD_VAL_CODE
FROM IGS.IGS_PS_UNIT_VER_ALL;
IGS.IGS_PS_UNIT_VER_ALL does not reference any database object
IGS.IGS_PS_UNIT_VER_ALL is referenced by following:
APPS
IGS_PS_UNIT_VER_ALL
|
|
|
|