[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_DSCP_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_DSCP_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_PS_DSCP_HIST_ALL describes the history of changes for a discipline.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_DSCP_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DISCIPLINE_GROUP_CD
HIST_START_DT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISCIPLINE_GROUP_CD | VARCHAR2 | (4) | Yes | Describes the discipline group to that a unit of study is classified by the institution. |
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 history. |
DESCRIPTION | VARCHAR2 | (60) | 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. 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. 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. 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_CD | VARCHAR2 | (4) | Describes the government discipline group to that this discipline code belongs. | |
CLOSED_IND | VARCHAR2 | (1) | Indicator that specifies if the discipline is open or closed. Setting the indicator to closed prevents 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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT DISCIPLINE_GROUP_CD
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, DESCRIPTION
, FUNDING_INDEX_1
, FUNDING_INDEX_2
, FUNDING_INDEX_3
, GOVT_DISCIPLINE_GROUP_CD
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_PS_DSCP_HIST_ALL;
IGS.IGS_PS_DSCP_HIST_ALL does not reference any database object
IGS.IGS_PS_DSCP_HIST_ALL is referenced by following:
|
|
|