Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_HE_FTE_PROPRT

Object Details
Object Name: IGS_HE_FTE_PROPRT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_HE_FTE_PROPRT
Subobject Name:
Status: VALID


To hold FTE calendar proportions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_HE_FTE_PROPRT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFTE_CAL_TYPE
ColumnFTE_SEQUENCE_NUM
ColumnCAL_TYPE
ColumnCI_SEQUENCE_NUMBER
ColumnYEAR_OF_PROGRAM
Columns
Name Datatype Length Mandatory Comments
CAL_TYPE VARCHAR2 (10) Yes Academic calendar type contained within FTE calculation period.
CI_SEQUENCE_NUMBER NUMBER (6) Yes Academic calendar type sequence number
YEAR_OF_PROGRAM NUMBER (2) Yes Year of program for which FTE is to be calculated.
FTE_CAL_TYPE VARCHAR2 (10) Yes Academic calendar for which FTE is to be calculated.
FTE_SEQUENCE_NUM NUMBER (6) Yes Academic calendar sequence number for which FTE is to be calculated.
FTE_PERC NUMBER (5) Yes Percentage contribution of academic calendar to FTE calculation.
CLOSED_IND VARCHAR2 (1) Yes Closed indicator
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      YEAR_OF_PROGRAM
,      FTE_CAL_TYPE
,      FTE_SEQUENCE_NUM
,      FTE_PERC
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_HE_FTE_PROPRT;

Dependencies

[top of page]

IGS.IGS_HE_FTE_PROPRT does not reference any database object

IGS.IGS_HE_FTE_PROPRT is referenced by following:

SchemaAPPS
SynonymIGS_HE_FTE_PROPRT