[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_PS_UNIT_VER_HIST_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_PS_UNIT_VER_HIST_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGS_PS_UNIT_VER_HIST_ALL describes the history of changes to a unit version.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_PS_UNIT_VER_HIST_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 UNIT_CD
VERSION_NUMBER
HIST_START_DT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| UNIT_CD | VARCHAR2 | (10) | Yes | Code used to identify the unit. |
| VERSION_NUMBER | NUMBER | (3) | Yes | Version number is used to uniquely identify each version of a unit. |
| HIST_START_DT | DATE | Yes | Effective start date and time of the history record. | |
| HIST_END_DT | DATE | Yes | Effective end date and time of the history record. | |
| HIST_WHO | NUMBER | (15) | Yes | Oracle username of the person who created the history record. |
| START_DT | DATE | 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 the unit version expires. Students already studying this unit version can remain enrolled. No further enrollments are normally allowable. | ||
| END_DT | DATE | Date on that this version of the unit closed. No students can be enrolled in a closed unit version. | ||
| UNIT_STATUS | VARCHAR2 | (10) | Institution-defined status of a unit that maps to a system unit status. | |
| TITLE | VARCHAR2 | (90) | The title of the unit. | |
| SHORT_TITLE | VARCHAR2 | (40) | The short name of the unit. | |
| TITLE_OVERRIDE_IND | VARCHAR2 | (1) | An 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) | Abbreviated name of the unit. | |
| UNIT_LEVEL | VARCHAR2 | (4) | Normal year level of the unit. | |
| UL_DESCRIPTION | VARCHAR2 | (60) | Explanation of the unit level. | |
| CREDIT_POINT_DESCRIPTOR | VARCHAR2 | (30) | Institution's name for credit points. | |
| ENROLLED_CREDIT_POINTS | NUMBER | (6) | Number of credit points in that the student is considered to be enrolled. | |
| POINTS_OVERRIDE_IND | VARCHAR2 | (1) | 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 number of credit points to be overridden. | |
| SUPP_EXAM_PERMITTED_IND | VARCHAR2 | (1) | Indicator that specifies whether a supplementary examination or other supplementary assessment can be granted in this unit. Setting the checkbox allows supplementary assessment to be granted. | |
| COORD_PERSON_ID | NUMBER | (15) | Person identification number of the unit coordinator. | |
| OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | Code of the organizational unit that owns the unit. | |
| OWNER_OU_START_DT | DATE | Date on that the owning organizational unit became current. | ||
| OU_DESCRIPTION | VARCHAR2 | (60) | Description of an organizational unit. An organizational unit is a business unit of an institution or organization. Common organizational units in tertiary institutions are faculties, schools, departments, and divisions. | |
| AWARD_COURSE_ONLY_IND | VARCHAR2 | (1) | 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) | Indicator that specifies whether the unit is classified as a research unit. Setting the checkbox ticked classifies the unit as research. | |
| 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 allows the unit to be a superior unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete | |
| INDUSTRIAL_IND | VARCHAR2 | (1) | Indicator that specifies whether the unit is classified as an industrial experience unit. | |
| PRACTICAL_IND | VARCHAR2 | (1) | Indicator that specifies whether the unit is classified as a practical experience unit. | |
| REPEATABLE_IND | VARCHAR2 | (1) | 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) | 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) | Where the override credit point indicator is set, this field records the allowable credit point increment. | |
| POINTS_MIN | NUMBER | (6) | Where 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) | Where 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 for WEFTSU purposes. WEFTSU is equal to EFTSU multiplied by discipline funding index then multiplied by unit program level factor. | |
| UICL_DESCRIPTION | VARCHAR2 | (60) | Description, or name, of the unit internal program level. Internal program levels are used in the determination of WEFTSU. | |
| SS_ENROL_IND | VARCHAR2 | (1) | Self Service Enrollment Indicator | |
| IVR_ENROL_IND | VARCHAR2 | (1) | IVR Enrollment Indicator | |
| 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 | 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. | ||
| REPEAT_CODE | VARCHAR2 | (10) | Repeat code | |
| UNIT_TYPE_ID | NUMBER | Indicates the unit program type level to which the unit belongs. | ||
| LEVEL_CODE | VARCHAR2 | (10) | The unit program type level code for unit | |
| ADVANCE_MAXIMUM | NUMBER | Maximum waitlist in advance | ||
| APPROVAL_DATE | DATE | Approval date | ||
| BILLING_CREDIT_POINTS | NUMBER | Audit Credit Points | ||
| CONTINUING_EDUCATION_UNITS | NUMBER | (6) | Continuing education units | |
| ENROLLMENT_EXPECTED | NUMBER | Expected enrollment | ||
| ENROLLMENT_MAXIMUM | NUMBER | Maximum enrollment | ||
| ENROLLMENT_MINIMUM | NUMBER | Minimum enrollment | ||
| FEDERAL_FINANCIAL_AID | VARCHAR2 | (1) | Federal financial aid | |
| INSTITUTIONAL_FINANCIAL_AID | VARCHAR2 | (1) | Institutional financial aid | |
| LAB_CREDIT_POINTS | NUMBER | (6) | Laboratory credit points | |
| LECTURE_CREDIT_POINTS | NUMBER | (6) | Lecture credit points | |
| 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 | |
| CLOCK_HOURS | NUMBER | (6) | Clock hours | |
| OTHER_CREDIT_POINTS | NUMBER | (6) | Other credit points | |
| SAME_TEACHING_PERIOD | VARCHAR2 | (1) | Same teaching period indicator | |
| SAME_TEACH_PERIOD_REPEATS | NUMBER | Same teaching period repeats | ||
| SAME_TEACH_PERIOD_REPEATS_CP | NUMBER | (6) | Same teaching period repeats credit points | |
| STATE_FINANCIAL_AID | VARCHAR2 | (1) | State financial aid | |
| WORK_LOAD_CP_LAB | NUMBER | (6) | Lab workload credit points | |
| WORK_LOAD_CP_LECTURE | NUMBER | (6) | Lecture work load credit point | |
| SUBTITLE_MODIFIABLE_FLAG | VARCHAR2 | (1) | Sub Title modifiable or not indicator | |
| SUBTITLE | VARCHAR2 | (90) | Obsolete - Subordinate name | |
| SPECIAL_PERMISSION_IND | VARCHAR2 | (1) | Indicates if special permission is required for the unit | |
| CLAIMABLE_HOURS | NUMBER | (7) | The maximum hours that a student in a class can claim | |
| AUDITABLE_IND | VARCHAR2 | (1) | Indicates if 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
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, START_DT
, REVIEW_DT
, EXPIRY_DT
, END_DT
, UNIT_STATUS
, TITLE
, SHORT_TITLE
, TITLE_OVERRIDE_IND
, ABBREVIATION
, UNIT_LEVEL
, UL_DESCRIPTION
, CREDIT_POINT_DESCRIPTOR
, ENROLLED_CREDIT_POINTS
, POINTS_OVERRIDE_IND
, SUPP_EXAM_PERMITTED_IND
, COORD_PERSON_ID
, OWNER_ORG_UNIT_CD
, OWNER_OU_START_DT
, OU_DESCRIPTION
, 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
, UICL_DESCRIPTION
, SS_ENROL_IND
, IVR_ENROL_IND
, 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
, REPEAT_CODE
, UNIT_TYPE_ID
, LEVEL_CODE
, ADVANCE_MAXIMUM
, APPROVAL_DATE
, BILLING_CREDIT_POINTS
, CONTINUING_EDUCATION_UNITS
, ENROLLMENT_EXPECTED
, ENROLLMENT_MAXIMUM
, ENROLLMENT_MINIMUM
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, LAB_CREDIT_POINTS
, LECTURE_CREDIT_POINTS
, MAX_REPEATS_FOR_CREDIT
, MAX_REPEATS_FOR_FUNDING
, MAX_REPEAT_CREDIT_POINTS
, CLOCK_HOURS
, OTHER_CREDIT_POINTS
, SAME_TEACHING_PERIOD
, SAME_TEACH_PERIOD_REPEATS
, SAME_TEACH_PERIOD_REPEATS_CP
, STATE_FINANCIAL_AID
, WORK_LOAD_CP_LAB
, WORK_LOAD_CP_LECTURE
, SUBTITLE_MODIFIABLE_FLAG
, SUBTITLE
, SPECIAL_PERMISSION_IND
, CLAIMABLE_HOURS
, AUDITABLE_IND
, AUDIT_PERMISSION_IND
, MAX_AUDITORS_ALLOWED
, OVRD_WKLD_VAL_FLAG
, WORKLOAD_VAL_CODE
FROM IGS.IGS_PS_UNIT_VER_HIST_ALL;
IGS.IGS_PS_UNIT_VER_HIST_ALL does not reference any database object
IGS.IGS_PS_UNIT_VER_HIST_ALL is referenced by following:
APPS
IGS_PS_UNIT_VER_HIST_ALL
|
|
|
|