[Home] [Help] [Dependency Information]
Object Name: | IGSBV_ACADEMIC_DISCIPLINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_ACADEMIC_DISCIPLINES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This is the base view which describes the university set of discipline group codes.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISCIPLINE_GROUP_CODE | VARCHAR2 | (4) | Yes | Describes the discipline group to that a unit of study belongs to, as classified by the institution. |
DISCIPLINE_GRP_DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the discipline group code. |
FUNDING_INDEX_1 | NUMBER | (3) | Funding index is used for determining Weighted Equivalent Full Time Student Unit. Weighted Equivalent Full Time Student Unit(WEFTSU) is equal to EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index and then multiplied by level funding index. | |
FUNDING_INDEX_2 | NUMBER | (3) | Funding index is used for determining Weighted Equivalent Full Time Student Unit. Weighted Equivalent Full Time Student Unit(WEFTSU) is equal to EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index and then multiplied by level funding index. | |
FUNDING_INDEX_3 | NUMBER | (3) | Funding index is used for determining Weighted Equivalent Full Time Student Unit. Weighted Equivalent Full Time Student Unit(WEFTSU) is equal to EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index and then multiplied by level funding index. | |
GOVT_DISCIPLINE_GROUP_CODE | VARCHAR2 | (4) | Yes | Describes the government discipline group, to which this discipline code belongs. |
CLOSED_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies if the discipline is open or closed. Setting the indicator to closed prevents the use of the discipline in new or modified discipline records. |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT DISCIPLINE_GROUP_CODE
, DISCIPLINE_GRP_DESCRIPTION
, FUNDING_INDEX_1
, FUNDING_INDEX_2
, FUNDING_INDEX_3
, GOVT_DISCIPLINE_GROUP_CODE
, CLOSED_INDICATOR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_ACADEMIC_DISCIPLINES;
APPS.IGSBV_ACADEMIC_DISCIPLINES is not referenced by any database object
|
|
|