[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_PS_VER_HIST_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_PS_VER_HIST_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGS_PS_VER_HIST_ALL describes the history of changes to a program version.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_PS_VER_HIST_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 COURSE_CD
VERSION_NUMBER
HIST_START_DT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COURSE_CD | VARCHAR2 | (6) | Yes | Describes the program code. |
| VERSION_NUMBER | NUMBER | (3) | Yes | Version number of the program. There can only be one version of a program with a system status of active and an unset expiry date. |
| 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 | Updated by person at the time of the history. |
| START_DT | DATE | Date on that the program version became current. | ||
| REVIEW_DT | DATE | Date on that the program version is due for review. No automatic closure or rollover is implied by this date. | ||
| EXPIRY_DT | DATE | Date on that the program version expires. Students already enrolled may remain in an expired program version. New students are not normally enrolled in an expired program version. | ||
| END_DT | DATE | Date on that the program version is completely ended. All students will have completed or been transferred to other versions. No more students can be enrolled in the version. | ||
| COURSE_STATUS | VARCHAR2 | (10) | Institution-defined program status that indicates the level of program. | |
| TITLE | VARCHAR2 | (90) | Full name of the program. | |
| SHORT_TITLE | VARCHAR2 | (40) | Short title of the program version. | |
| ABBREVIATION | VARCHAR2 | (20) | Abbreviated program version name. | |
| SUPP_EXAM_PERMITTED_IND | VARCHAR2 | (1) | Indicator that specifies whether or not supplementary examinations or other assessment can be undertaken by students enrolled in this program. Setting the checkbox ticked allows supplementary assessment to be granted. | |
| GENERIC_COURSE_IND | VARCHAR2 | (1) | Indicates whether the program is a generic program. Students in a generic program can transfer to any of the programs in the related group at any point during their enrollment. | |
| GRADUATE_STUDENTS_IND | VARCHAR2 | (1) | Describes whether or not students may graduate after completing this program. Setting the checkbox ticked enables students to graduate upon completion of program requirements. The indicator is not set for non-award programs. | |
| COUNT_INTRMSN_IN_TIME_IND | VARCHAR2 | (1) | Indicator that specifies whether or not to count the duration of a student's intermission when checking the maximum time allowed to complete a program. | |
| INTRMSN_ALLOWED_IND | VARCHAR2 | (1) | Indicates whether intermission is allowed for this program version. | |
| COURSE_TYPE | VARCHAR2 | (10) | Institution-defined program type. Program type indicates the type of higher education program. Each program type must map to a government program type. | |
| CT_DESCRIPTION | VARCHAR2 | (60) | Description of the institution-defined program type. | |
| RESPONSIBLE_ORG_UNIT_CD | VARCHAR2 | (30) | Unique code of the organizational unit responsible for this program version. | |
| RESPONSIBLE_OU_START_DT | DATE | Start date of the organizational unit responsible for this program version. | ||
| 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. | |
| GOVT_SPECIAL_COURSE_TYPE | VARCHAR2 | (2) | Code that identifies programs of special interest. | |
| GSCT_DESCRIPTION | VARCHAR2 | (60) | Description of the government special program type. | |
| QUALIFICATION_RECENCY | NUMBER | (2) | The time period in years for that other studies will be recognized for the purpose of granting advanced standing in this program. | |
| EXTERNAL_ADV_STND_LIMIT | NUMBER | (7) | Maximum amount of advanced standing that can be granted in the program for studies undertaken outside the institution. | |
| INTERNAL_ADV_STND_LIMIT | NUMBER | (7) | Maximum amount of advanced standing that can be granted in the program for studies undertaken at the institution. | |
| CONTACT_HOURS | NUMBER | (7) | Minimum number of contact hours required for completion of the program. | |
| CREDIT_POINTS_REQUIRED | NUMBER | (6) | The minimum number of credit points required to complete program requirements. | |
| GOVT_COURSE_LOAD | NUMBER | (2) | Aggregate effective full time student units value for a program, expressed in tenths. | |
| STD_ANNUAL_LOAD | NUMBER | (7) | Describes the load in credit points that a full-time student would normally study in a year if enrolled in the program. This is used to calculate the relative weighting of the units. | |
| COURSE_TOTAL_EFTSU | NUMBER | (5) | The total equivalent full time student units for the program. | |
| STD_FT_COMPLETION_TIME | NUMBER | (3) | OBSOLETE. Code that indicates the standard time to complete the requirements of the program on a full time basis. For example 30 is equal to 3 years. Not in current use. | |
| STD_PT_COMPLETION_TIME | NUMBER | (3) | OBSOLETE. Code that indicates the standard time to complete the requirements of the program on a part time basis. For example, 60 is equal to 6 years. Not in current use. | |
| MAX_INTRMSN_DURATION | NUMBER | (3) | Describes the maximum intermission duration in months. | |
| NUM_OF_UNITS_BEFORE_INTRMSN | NUMBER | (3) | The number of units a student must complete before being allowed intermission. | |
| MIN_SBMSN_PERCENTAGE | NUMBER | (5) | Contains the percentage of the total effective full time days that must be attained prior to submission of a research thesis. This detail applies only to research programs. | |
| 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 | |
| MIN_CP_PER_CALENDAR | NUMBER | (5) | The minimum credit points to be taken by student and is critical to control minimum load required for certain students cohorts for federal financial assistance recipients and intercollegiate athletes . | |
| APPROVAL_DATE | DATE | Approval Date | ||
| EXTERNAL_APPROVAL_DATE | DATE | External Approval Date | ||
| FEDERAL_FINANCIAL_AID | VARCHAR2 | (1) | Is the financial aid funded by the federation. | |
| INSTITUTIONAL_FINANCIAL_AID | VARCHAR2 | (1) | Is the financial aid funded by the institution. | |
| MAX_CP_PER_TEACHING_PERIOD | NUMBER | (6) | Maximum credit points per teaching period | |
| RESIDENCY_CP_REQUIRED | NUMBER | (6) | Residency credit points required | |
| STATE_FINANCIAL_AID | VARCHAR2 | (1) | Is the financial aid funded by the state. | |
| PRIMARY_PROGRAM_RANK | NUMBER | (5) | Primary Program Rank Higher the Value , Lower the Rank | |
| MAX_WLST_PER_STUD | NUMBER | Maximum waitlists allowed per student | ||
| ANNUAL_INSTRUCTION_TIME | NUMBER | Annul Instruction Time of the program measured in weeks. |
Cut, paste (and edit) the following text to query this object:
SELECT COURSE_CD
, VERSION_NUMBER
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, START_DT
, REVIEW_DT
, EXPIRY_DT
, END_DT
, COURSE_STATUS
, TITLE
, SHORT_TITLE
, ABBREVIATION
, SUPP_EXAM_PERMITTED_IND
, GENERIC_COURSE_IND
, GRADUATE_STUDENTS_IND
, COUNT_INTRMSN_IN_TIME_IND
, INTRMSN_ALLOWED_IND
, COURSE_TYPE
, CT_DESCRIPTION
, RESPONSIBLE_ORG_UNIT_CD
, RESPONSIBLE_OU_START_DT
, OU_DESCRIPTION
, GOVT_SPECIAL_COURSE_TYPE
, GSCT_DESCRIPTION
, QUALIFICATION_RECENCY
, EXTERNAL_ADV_STND_LIMIT
, INTERNAL_ADV_STND_LIMIT
, CONTACT_HOURS
, CREDIT_POINTS_REQUIRED
, GOVT_COURSE_LOAD
, STD_ANNUAL_LOAD
, COURSE_TOTAL_EFTSU
, STD_FT_COMPLETION_TIME
, STD_PT_COMPLETION_TIME
, MAX_INTRMSN_DURATION
, NUM_OF_UNITS_BEFORE_INTRMSN
, MIN_SBMSN_PERCENTAGE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, MIN_CP_PER_CALENDAR
, APPROVAL_DATE
, EXTERNAL_APPROVAL_DATE
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, MAX_CP_PER_TEACHING_PERIOD
, RESIDENCY_CP_REQUIRED
, STATE_FINANCIAL_AID
, PRIMARY_PROGRAM_RANK
, MAX_WLST_PER_STUD
, ANNUAL_INSTRUCTION_TIME
FROM IGS.IGS_PS_VER_HIST_ALL;
IGS.IGS_PS_VER_HIST_ALL does not reference any database object
IGS.IGS_PS_VER_HIST_ALL is referenced by following:
APPS
IGS_PS_VER_HIST_ALL
|
|
|
|