[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_VER_HIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_UNIT_VER_HIST_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 |
---|---|---|---|---|
UNIT_CD | VARCHAR2 | (10) | The code used to identify the unit. | |
VERSION_NUMBER | NUMBER | (3) | Version number is used to uniquely identify each version of a unit. | |
HIST_START_DT | DATE | The effective start date/time of the history record. | ||
HIST_END_DT | DATE | The effective end date/time of the history record. | ||
HIST_WHO | NUMBER | (15) | The Oracle username of the person who created the history record. | |
START_DT | DATE | The date on which this version of the unit became current. | ||
REVIEW_DT | DATE | The date on which this version of the unit is due for review. | ||
EXPIRY_DT | DATE | The date on the unit version expires. Students already studying this unit version may remain enrolled. No further enrolments are normally allowable. | ||
END_DT | DATE | The date on which this version of the unit closed. No students can can be enrolled in a closed unit version | ||
UNIT_STATUS | VARCHAR2 | (10) | The institution-defined status of a unit which maps to a system unit status. A unit is established with a system equivalent status of PLANNED. For students to be enrolled in the unit it must have a system equivalent status of ACTIVE. When the unit is no longer to be offered it is given a system equivalent status of INACTIVE. INACTIVE units may be archived. | |
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 which 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) | The abbreviated name of the unit | |
UNIT_LEVEL | VARCHAR2 | (4) | The normal year level of the unit. | |
UL_DESCRIPTION | VARCHAR2 | (60) | An explanation of the unit level. | |
CREDIT_POINT_DESCRIPTOR | VARCHAR2 | (30) | The institution's name for credit points | |
ENROLLED_CREDIT_POINTS | NUMBER | The number of credit points in which the student is considered to be enrolled | ||
POINTS_OVERRIDE_IND | VARCHAR2 | (1) | An indicator which 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) | An indicator which 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 | The person identification number of the unit coordinator | ||
OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | The code of the organisational unit that owns the unit. | |
OWNER_OU_START_DT | DATE | The date on which the owning organisational unit became current. | ||
OU_DESCRIPTION | VARCHAR2 | (360) | The description of an organisational unit. An organisational unit is a business unit of an institution or organisation. Common organisational units in tertiary institutions are faculties, schools, departments and divisions. Each organisational unit must be assigned a start date, description, status, organisational type and member type. An institution code may be assigned to an organisational unit. | |
AWARD_COURSE_ONLY_IND | VARCHAR2 | (1) | An indicator which specifies whether the unit is available only to award course students. Setting the checkbox (ticked) restricts enrolment to award course students | |
RESEARCH_UNIT_IND | VARCHAR2 | (1) | An indicator which 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) | An indicator which specifies whether this unit can be classified as a sub-unit in a superior / 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) | An indicator which specifies whether this unit can be classified as a superior unit in a superior / 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) | An indicator which specifies whether the unit is classified as an industrial experience unit, as described in the Higher Education Student Data Collection DETYA 1997, Element Number 337. | |
PRACTICAL_IND | VARCHAR2 | (1) | An indicator which specifies whether the unit is classified as a practical experience unit, as described in the Higher Education Student Data Collection Glossary DETYA 1997. | |
REPEATABLE_IND | VARCHAR2 | (1) | An indicator which specifies whether the unit may count more than once towards the satisfaction of course requirements. Setting the checkbox (ticked) enables a student to repeat an already passed unit. | |
ASSESSABLE_IND | VARCHAR2 | (1) | An indicator which specifies whether the unit is assessed. Setting the checkbox (ticked) indicates that the unit is assessed | |
ACHIEVABLE_CREDIT_POINTS | NUMBER | The number of credit points awarded upon successful completion of the unit. This number may be overridden for an individual student if the OVERRIDE CREDIT POINTS indicator is set | ||
POINTS_INCREMENT | NUMBER | Where the override credit point indicator is set, this field records the allowable credit point increment. | ||
POINTS_MIN | NUMBER | 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 | 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) | The internal course level grouping of the unit for WEFTSU purposes. WEFTSU = EFTSU * discipline.funding_index * unit_course_ level factor | |
UICL_DESCRIPTION | VARCHAR2 | (60) | The description, or name, of the unit internal course level. Internal course levels are used in the determination of WEFTSU. | |
WORK_LOAD_OTHER | NUMBER | |||
CONTACT_HRS_LECTURE | NUMBER | |||
CONTACT_HRS_LAB | NUMBER | |||
CONTACT_HRS_OTHER | NUMBER | |||
BILLING_HRS | NUMBER | Billable Credit Points | ||
NON_SCHD_REQUIRED_HRS | NUMBER | |||
FIN_AID_CP | NUMBER | Financial Aid Credit Points - Obsolete | ||
FIN_AID_HRS | NUMBER | Financial Aid Hours - Obsolete | ||
EXCLUDE_FROM_MAX_CP_LIMIT | VARCHAR2 | (1) | ||
RECORD_EXCLUSION_FLAG | VARCHAR2 | (1) | ||
SS_DISPLAY_IND | VARCHAR2 | (1) | ||
CAL_TYPE_ENROL_LOAD_CAL | VARCHAR2 | (10) | ||
SEQUENCE_NUM_ENROL_LOAD_CAL | NUMBER | |||
CAL_TYPE_OFFER_LOAD_CAL | VARCHAR2 | (10) | ||
SEQUENCE_NUM_OFFER_LOAD_CAL | NUMBER | |||
CURRICULUM_ID | VARCHAR2 | (10) | ||
OVERRIDE_ENROLLMENT_MAX | NUMBER | |||
RPT_FMLY_ID | NUMBER | |||
UNIT_TYPE_ID | NUMBER | |||
REPEAT_CODE | VARCHAR2 | (10) | ||
LEVEL_CODE | VARCHAR2 | (10) | ||
ADVANCE_MAXIMUM | NUMBER | |||
APPROVAL_DATE | DATE | |||
BILLING_CREDIT_POINTS | NUMBER | Audit Credit Points | ||
CONTINUING_EDUCATION_UNITS | NUMBER | |||
ENROLLMENT_EXPECTED | NUMBER | |||
ENROLLMENT_MAXIMUM | NUMBER | |||
ENROLLMENT_MINIMUM | NUMBER | |||
FEDERAL_FINANCIAL_AID | VARCHAR2 | (1) | ||
INSTITUTIONAL_FINANCIAL_AID | VARCHAR2 | (1) | ||
LAB_CREDIT_POINTS | NUMBER | |||
LECTURE_CREDIT_POINTS | NUMBER | |||
MAX_REPEATS_FOR_CREDIT | NUMBER | |||
MAX_REENROLL_FOR_CREDIT | NUMBER | |||
MAX_REPEATS_FOR_FUNDING | NUMBER | |||
MAX_REPEAT_CREDIT_POINTS | NUMBER | |||
CLOCK_HOURS | NUMBER | |||
OTHER_CREDIT_POINTS | NUMBER | |||
SAME_TEACHING_PERIOD | VARCHAR2 | (1) | ||
SAME_TEACH_PERIOD_REPEATS | NUMBER | |||
SAME_TEACH_PERIOD_REPEATS_CP | NUMBER | |||
STATE_FINANCIAL_AID | VARCHAR2 | (1) | ||
WORK_LOAD_CP_LAB | NUMBER | |||
WORK_LOAD_CP_LECTURE | NUMBER | |||
SUBTITLE_ID | NUMBER | |||
SUBTITLE | VARCHAR2 | (90) | ||
SUBTITLE_MODIFIABLE_FLAG | VARCHAR2 | (1) | ||
SPECIAL_PERMISSION_IND | VARCHAR2 | (1) | ||
IVR_ENROL_IND | VARCHAR2 | (1) | ||
SS_ENROL_IND | VARCHAR2 | (1) | ||
CLAIMABLE_HOURS | NUMBER | The maximum hours that a student in a class can claim | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
AUDITABLE_IND | VARCHAR2 | (1) | Indicates if a unit can be audited | |
AUDIT_PERMISSION_IND | VARCHAR2 | (1) | Indicates if permission is required to audit | |
MAX_AUDITORS_ALLOWED | NUMBER | 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
, 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
, REPEAT_CODE
, 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_REENROLL_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_ID
, SUBTITLE
, SUBTITLE_MODIFIABLE_FLAG
, SPECIAL_PERMISSION_IND
, IVR_ENROL_IND
, SS_ENROL_IND
, CLAIMABLE_HOURS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, AUDITABLE_IND
, AUDIT_PERMISSION_IND
, MAX_AUDITORS_ALLOWED
, OVRD_WKLD_VAL_FLAG
, WORKLOAD_VAL_CODE
FROM APPS.IGS_PS_UNIT_VER_HIST_V;
APPS.IGS_PS_UNIT_VER_HIST_V is not referenced by any database object
|
|
|