[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.IGSBV_HIGH_ED_PROG_VERSIONS is not referenced by any database object
|
|
|