[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSBV_HIGH_ED_PROG_VERSIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSBV_HIGH_ED_PROG_VERSIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This entity describes Program Versions including information about the intermission, financial aid, supplemental exams , minimum and maximum credit points.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROGRAM_CODE | VARCHAR2 | (6) | Yes | Program Code |
| VERSION_NUMBER | NUMBER | (3) | Yes | Version Number of the program |
| START_DATE | DATE | Yes | Start Date of the Program | |
| REVIEW_DATE | DATE | Review Date of the Program | ||
| EXPIRY_DATE | DATE | Expiry Date of the Program | ||
| END_DATE | DATE | End Date of the Program | ||
| PROGRAM_STATUS | VARCHAR2 | (10) | Yes | Program Status of the Program |
| TITLE | VARCHAR2 | (90) | Yes | Title of the Program |
| SHORT_TITLE | VARCHAR2 | (40) | Yes | Short Title of the Program |
| ABBREVIATION | VARCHAR2 | (20) | Yes | Program Abbreviation |
| SUPP_EXAM_PERM_INDICATOR | VARCHAR2 | (1) | Yes | Supplemental Examination Permission Indicator |
| GENERIC_PROGRAM_INDICATOR | VARCHAR2 | (1) | Yes | Generic Program Indicator |
| GRADUATE_STUDENTS_INDICATOR | VARCHAR2 | (1) | Yes | Graduate Student Indicator |
| COUNT_INTERMISSION_INDICATOR | VARCHAR2 | (1) | Yes | Intermission Count Indicator |
| INTERMISSION_ALLOWED_INDICATOR | VARCHAR2 | (1) | Yes | Intermission Allowed Indicator |
| PROGRAM_TYPE | VARCHAR2 | (10) | Yes | Program Type |
| RESP_ORG_UNIT_CODE | VARCHAR2 | (30) | Yes | Responsible Organization Unit Code |
| RESP_ORG_UNIT_START_DATE | DATE | Yes | Responsible Organization Unit Start Date | |
| GOVT_SPECIAL_PROGRAM_TYPE | VARCHAR2 | (2) | Yes | Government Special Program Type |
| QUALIFICATION_RECENCY | NUMBER | (2) | Time period in years for that other studies can be recognized for the purpose of granting advanced standing in this program | |
| EXTERNAL_ADV_STND_LIMIT | NUMBER | (7) | External Advance Standing Limit | |
| INTERNAL_ADV_STND_LIMIT | NUMBER | (7) | Internal Advance Standing Limit | |
| CONTACT_HOURS | NUMBER | (7) | Contact Hours | |
| CREDIT_POINTS_REQUIRED | NUMBER | (6) | Credit Points Required | |
| GOVT_PROGRAM_LOAD | NUMBER | (2) | Government Program Load | |
| STD_ANNUAL_LOAD | NUMBER | (7) | Student Annual Load | |
| ANNUAL_INSTRUCTION_TIME | NUMBER | Annula Instruction Time of the program mesaured in weeks. | ||
| PROGRAM_TOTAL_EFTSU | NUMBER | (5) | EFTSU Program Total | |
| MAX_INTERMISSION_DURATION | NUMBER | (3) | Maximum duration of Intermission | |
| NUM_OF_UNITS_BEFORE_INTRMSN | NUMBER | (3) | Number of Units before Intermission | |
| MIN_SUBMISSION_PERCENTAGE | NUMBER | (5) | Minimum Submission Percentage | |
| MAX_CP_PER_TEACH_PERIOD | NUMBER | (6) | Maximum Credit Point Per Teaching Period | |
| APPROVAL_DATE | DATE | Approval Date | ||
| EXTERNAL_APPROVAL_DATE | DATE | External Approval Date | ||
| RESIDENCY_CP_REQUIRED | NUMBER | (6) | Required Credit Point for Residency | |
| STATE_FINANCIAL_AID | VARCHAR2 | (1) | State Financial Aid | |
| FEDERAL_FINANCIAL_AID | VARCHAR2 | (1) | Federal Financial Aid | |
| INSTITUTIONAL_FINANCIAL_AID | VARCHAR2 | (1) | Institutional Financial Aid | |
| MINIMUM_CP_PER_CALENDAR | NUMBER | (5) | Minimum Credit Point Per Calendar | |
| REVENUE_ACCOUNT_CODE | VARCHAR2 | (40) | Revenue Account Code | |
| PRIMARY_PROGRAM_RANK | NUMBER | (5) | Primary Program Rank | |
| 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 | |
| MAX_WLST_PER_STUD | NUMBER | Maximum waitlists allowed per student |
Cut, paste (and edit) the following text to query this object:
SELECT PROGRAM_CODE
, VERSION_NUMBER
, START_DATE
, REVIEW_DATE
, EXPIRY_DATE
, END_DATE
, PROGRAM_STATUS
, TITLE
, SHORT_TITLE
, ABBREVIATION
, SUPP_EXAM_PERM_INDICATOR
, GENERIC_PROGRAM_INDICATOR
, GRADUATE_STUDENTS_INDICATOR
, COUNT_INTERMISSION_INDICATOR
, INTERMISSION_ALLOWED_INDICATOR
, PROGRAM_TYPE
, RESP_ORG_UNIT_CODE
, RESP_ORG_UNIT_START_DATE
, GOVT_SPECIAL_PROGRAM_TYPE
, QUALIFICATION_RECENCY
, EXTERNAL_ADV_STND_LIMIT
, INTERNAL_ADV_STND_LIMIT
, CONTACT_HOURS
, CREDIT_POINTS_REQUIRED
, GOVT_PROGRAM_LOAD
, STD_ANNUAL_LOAD
, ANNUAL_INSTRUCTION_TIME
, PROGRAM_TOTAL_EFTSU
, MAX_INTERMISSION_DURATION
, NUM_OF_UNITS_BEFORE_INTRMSN
, MIN_SUBMISSION_PERCENTAGE
, MAX_CP_PER_TEACH_PERIOD
, APPROVAL_DATE
, EXTERNAL_APPROVAL_DATE
, RESIDENCY_CP_REQUIRED
, STATE_FINANCIAL_AID
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, MINIMUM_CP_PER_CALENDAR
, REVENUE_ACCOUNT_CODE
, PRIMARY_PROGRAM_RANK
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, MAX_WLST_PER_STUD
FROM APPS.IGSBV_HIGH_ED_PROG_VERSIONS;
APPS
IGS_PS_VER_ALL
APPS.IGSBV_HIGH_ED_PROG_VERSIONS is not referenced by any database object
|
|
|
|