[Home] [Help]
View: IGS_HE_FTE_PROPRT_V
Product: | IGS - Student System (Obsolete) |
Description: | Holds FTE Calendar proportions |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.ROWID ROW_ID
, A.CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.ALTERNATE_CODE CAL_NAME
, B.START_DT START_DATE
, B.END_DT END_DATE
, A.YEAR_OF_PROGRAM
, A.FTE_CAL_TYPE
, A.FTE_SEQUENCE_NUM
, A.FTE_PERC
, A.CLOSED_IND
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM IGS_HE_FTE_PROPRT A
, IGS_CA_INST B
WHERE A.CAL_TYPE=B.CAL_TYPE
AND A.CI_SEQUENCE_NUMBER=B.SEQUENCE_NUMBER
Columns
Name |
ROW_ID |
CAL_TYPE |
CI_SEQUENCE_NUMBER |
CAL_NAME |
START_DATE |
END_DATE |
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 |