[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_HE_POOUS_DTLS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_HE_POOUS_DTLS_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row ID | |
| HESA_POOUS_ID | NUMBER | (6) | Yes | |
| COURSE_CD | VARCHAR2 | (6) | Yes | |
| CRV_VERSION_NUMBER | NUMBER | (3) | Yes | |
| COURSE_STATUS | VARCHAR2 | (10) | Yes | |
| SHORT_TITLE | VARCHAR2 | (40) | Yes | |
| CAL_TYPE | VARCHAR2 | (10) | Yes | |
| CAL_DESCRIPTION | VARCHAR2 | (60) | Yes | |
| LOCATION_CD | VARCHAR2 | (10) | Yes | |
| ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | |
| UNIT_SET_CD | VARCHAR2 | (10) | Yes | |
| UNIT_SET_DESC | VARCHAR2 | (90) | Yes | |
| US_VERSION_NUMBER | NUMBER | (3) | Yes | |
| LOCATION_OF_STUDY | VARCHAR2 | (30) | Location of Study | |
| LOCATION_OF_STUDY_DESC | VARCHAR2 | (240) | ||
| MODE_OF_STUDY | VARCHAR2 | (30) | Mode of Study | |
| MODE_OF_STUDY_DESC | VARCHAR2 | (240) | ||
| UFI_PLACE | VARCHAR2 | (30) | ||
| UFI_PLACE_DESC | VARCHAR2 | (240) | ||
| FRANCHISING_ACTIVITY | VARCHAR2 | (30) | ||
| FRANCHISING_ACTIVITY_DESC | VARCHAR2 | (240) | ||
| TYPE_OF_YEAR | VARCHAR2 | (30) | ||
| TYPE_OF_YEAR_DESC | VARCHAR2 | (240) | ||
| LENG_CURRENT_YEAR | NUMBER | (2) | ||
| CREDIT_VALUE_YOP1 | NUMBER | (3) | ||
| LEVEL_CREDIT1 | VARCHAR2 | (30) | Level Credit 1 | |
| LEVEL_CREDIT1_DESC | VARCHAR2 | (60) | ||
| CREDIT_VALUE_YOP2 | NUMBER | (3) | ||
| LEVEL_CREDIT2 | VARCHAR2 | (30) | Level Credit 2 | |
| LEVEL_CREDIT2_DESC | VARCHAR2 | (60) | ||
| FTE_INTENSITY | NUMBER | (5) | FTE Intensity | |
| FTE_CALC_TYPE | VARCHAR2 | (1) | FTE calculation type flag.Can take values I and U | |
| FTE_CALC_TYPE_DESC | VARCHAR2 | (80) | FTE calculation type description | |
| TEACH_PERIOD_START_DT | DATE | Teaching period start date | ||
| TEACH_PERIOD_END_DT | DATE | Teaching period end date | ||
| OTHER_INSTIT_TEACH1 | VARCHAR2 | (30) | ||
| OTHER_INSTIT_TEACH1_DESC | VARCHAR2 | (360) | ||
| OTHER_INSTIT_TEACH2 | VARCHAR2 | (30) | ||
| OTHER_INSTIT_TEACH2_DESC | VARCHAR2 | (360) | ||
| PROP_NOT_TAUGHT | NUMBER | (5) | Proportion not Taught | |
| FUNDABILITY_CD | VARCHAR2 | (30) | ||
| FUNDABILITY_DESC | VARCHAR2 | (240) | ||
| FEE_BAND | VARCHAR2 | (30) | ||
| FEE_BAND_DESC | VARCHAR2 | (240) | ||
| FUNDING_SOURCE | VARCHAR2 | (10) | Institution defined Funding Source | |
| FUNDING_SOURCE_DESC | VARCHAR2 | (60) | Institution defined Funding Source Description | |
| LEVEL_APPLICABLE_TO_FUNDING | VARCHAR2 | (30) | ||
| LEVEL_APPLICABLE_DESC | VARCHAR2 | (240) | ||
| GRADING_SCHEMA_CD | VARCHAR2 | (10) | Grading Schema Code | |
| GS_VERSION_NUMBER | NUMBER | (3) | ||
| GRADING_SCHEMA_DESC | VARCHAR2 | (60) | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREDIT_VALUE_YOP3 | NUMBER | Credit value of year of programme 3 | ||
| LEVEL_CREDIT3 | VARCHAR2 | (30) | Level Credit 3 | |
| LEVEL_CREDIT3_DESC | VARCHAR2 | (60) | Level of credit 3 description | |
| CREDIT_VALUE_YOP4 | NUMBER | Credit value of year of programme 4 | ||
| LEVEL_CREDIT4 | VARCHAR2 | (30) | Level Credit 4 | |
| LEVEL_CREDIT4_DESC | VARCHAR2 | (60) | Level of credit 4 description |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, HESA_POOUS_ID
, COURSE_CD
, CRV_VERSION_NUMBER
, COURSE_STATUS
, SHORT_TITLE
, CAL_TYPE
, CAL_DESCRIPTION
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, UNIT_SET_CD
, UNIT_SET_DESC
, US_VERSION_NUMBER
, LOCATION_OF_STUDY
, LOCATION_OF_STUDY_DESC
, MODE_OF_STUDY
, MODE_OF_STUDY_DESC
, UFI_PLACE
, UFI_PLACE_DESC
, FRANCHISING_ACTIVITY
, FRANCHISING_ACTIVITY_DESC
, TYPE_OF_YEAR
, TYPE_OF_YEAR_DESC
, LENG_CURRENT_YEAR
, CREDIT_VALUE_YOP1
, LEVEL_CREDIT1
, LEVEL_CREDIT1_DESC
, CREDIT_VALUE_YOP2
, LEVEL_CREDIT2
, LEVEL_CREDIT2_DESC
, FTE_INTENSITY
, FTE_CALC_TYPE
, FTE_CALC_TYPE_DESC
, TEACH_PERIOD_START_DT
, TEACH_PERIOD_END_DT
, OTHER_INSTIT_TEACH1
, OTHER_INSTIT_TEACH1_DESC
, OTHER_INSTIT_TEACH2
, OTHER_INSTIT_TEACH2_DESC
, PROP_NOT_TAUGHT
, FUNDABILITY_CD
, FUNDABILITY_DESC
, FEE_BAND
, FEE_BAND_DESC
, FUNDING_SOURCE
, FUNDING_SOURCE_DESC
, LEVEL_APPLICABLE_TO_FUNDING
, LEVEL_APPLICABLE_DESC
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, GRADING_SCHEMA_DESC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREDIT_VALUE_YOP3
, LEVEL_CREDIT3
, LEVEL_CREDIT3_DESC
, CREDIT_VALUE_YOP4
, LEVEL_CREDIT4
, LEVEL_CREDIT4_DESC
FROM APPS.IGS_HE_POOUS_DTLS_V;
APPS
IGS_AS_GRD_SCHEMA
IGS_CA_TYPE
IGS_EN_UNIT_SET
IGS_FI_FUND_SRC_ALL
IGS_HE_CODE_VALUES
IGS_HE_POOUS
IGS_LOOKUPS_VIEW
IGS_OR_INSTITUTION
IGS_PS_UNIT_LEVEL
IGS_PS_VER
APPS.IGS_HE_POOUS_DTLS_V is not referenced by any database object
|
|
|
|