[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_HE_EN_SUSA_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_HE_EN_SUSA_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_EN_SUSA_ID | NUMBER | (6) | Yes | Sequence generated record identifier |
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
| COURSE_CD | VARCHAR2 | (6) | Yes | Course code |
| UNIT_SET_CD | VARCHAR2 | (10) | Yes | Unit Set code |
| US_VERSION_NUMBER | NUMBER | (3) | Yes | Unit set version number |
| SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unit set sequence number |
| TERM_TIME_ACCOM | VARCHAR2 | (30) | Term time accomodation code | |
| TERM_TIME_ACCOM_DESC | VARCHAR2 | (240) | Term time accomodation code description | |
| DISABILITY_ALLOW | VARCHAR2 | (30) | Disability allowance code | |
| DISABILITY_ALLOW_DESC | VARCHAR2 | (240) | Disability allowance code description | |
| ADDITIONAL_SUP_BAND | VARCHAR2 | (30) | Additional Support band | |
| ADDITIONAL_SUP_BAND_DESC | VARCHAR2 | (240) | Additional Support band description | |
| SLDD_DISCRETE_PROV | VARCHAR2 | (30) | SLDD Discrete provision | |
| SLDD_DISCRETE_PROV_DESC | VARCHAR2 | (240) | SLDD Discrete provision description | |
| STUDY_MODE | VARCHAR2 | (30) | Study Mode | |
| STUDY_MODE_DESC | VARCHAR2 | (240) | Study mode description | |
| STUDY_LOCATION | VARCHAR2 | (30) | Study Location code | |
| STUDY_LOCATION_DESC | VARCHAR2 | (240) | Study Location description | |
| FTE_PERC_OVERRIDE | NUMBER | (5) | Full time equivalent override percentage | |
| FRANCHISING_ACTIVITY | VARCHAR2 | (30) | Franchising activity code | |
| FRANCHISING_ACTIVITY_DESC | VARCHAR2 | (240) | Franchising activity description | |
| COMPLETION_STATUS | VARCHAR2 | (30) | Completion status code | |
| COMPLETION_STATUS_DESC | VARCHAR2 | (240) | Completion status description | |
| GOOD_STAND_MARKER | VARCHAR2 | (30) | Good standing marker | |
| GOOD_STAND_MARKER_DESC | VARCHAR2 | (240) | Good standing marker description | |
| COMPLETE_PYR_STUDY_CD | VARCHAR2 | (30) | Program year study completion code | |
| COMPLETE_PYR_STUDY_DESC | VARCHAR2 | (240) | Program year study completion description | |
| NEW_ENTRANT_CD | VARCHAR2 | (30) | New entrant code | |
| NEW_ENTRANT_DESC | VARCHAR2 | (240) | New entrant description | |
| TEACHING_INST1 | VARCHAR2 | (30) | Teaching institution 1 | |
| TEACHING_INST1_DESC | VARCHAR2 | (360) | Teaching institution 1 description | |
| TEACHING_INST2 | VARCHAR2 | (30) | Teaching institution 2 | |
| TEACHING_INST2_DESC | VARCHAR2 | (360) | Teaching institution 2 description | |
| PRO_NOT_TAUGHT | NUMBER | (5) | Proportion not taught in this institution | |
| FUNDABILITY_CODE | VARCHAR2 | (30) | Fundability code | |
| FUNDABILITY_CODE_DESC | VARCHAR2 | (240) | Fundability code description | |
| FEE_ELIGIBILITY | VARCHAR2 | (30) | Fee eligibility | |
| FEE_ELIGIBILITY_DESC | VARCHAR2 | (240) | Fee eligibility description | |
| FEE_BAND | VARCHAR2 | (30) | Fee band code | |
| FEE_BAND_DESC | VARCHAR2 | (240) | Fee band code description | |
| NON_PAYMENT_REASON | VARCHAR2 | (30) | Non payment reason code | |
| NON_PAYMENT_REASON_DESC | VARCHAR2 | (240) | Non payment reason description | |
| STUDENT_FEE | VARCHAR2 | (30) | Student fee code | |
| STUDENT_FEE_DESC | VARCHAR2 | (240) | Student fee code description | |
| CREDIT_PT_ACHIEVED1 | NUMBER | (3) | Credit points achieved 1 | |
| CREDIT_PT_ACHIEVED2 | NUMBER | (3) | Credit points achieved 2 | |
| CREDIT_LEVEL1 | VARCHAR2 | (30) | Credit Level 1 | |
| CREDIT_LEVEL1_DESC | VARCHAR2 | (60) | Credit Level 1 description | |
| CREDIT_LEVEL2 | VARCHAR2 | (30) | Credit Level 2 | |
| CREDIT_LEVEL2_DESC | VARCHAR2 | (60) | Credit Level 2 description | |
| CREDIT_VALUE_YOP1 | NUMBER | (3) | Credit value for Year of program 1 | |
| CREDIT_VALUE_YOP2 | NUMBER | (3) | Credit value for Year of program 2 | |
| CREDIT_LEVEL_ACHIEVED1 | VARCHAR2 | (30) | Credit level achieved 1 | |
| CREDIT_LEVEL_ACHIEVED1_DESC | VARCHAR2 | (60) | Credit level achieved 1 description | |
| CREDIT_LEVEL_ACHIEVED2 | VARCHAR2 | (30) | Credit level achieved 2 | |
| CREDIT_LEVEL_ACHIEVED2_DESC | VARCHAR2 | (60) | Credit level achieved 2 description | |
| GRAD_SCH_GRADE | VARCHAR2 | (10) | Grading schema grade | |
| MARK | NUMBER | (6) | Marks | |
| FTE_INTENSITY | NUMBER | (5) | FTE Intensity | |
| CALCULATED_FTE | NUMBER | (5) | Calculated FTE | |
| FTE_CALC_TYPE | VARCHAR2 | (1) | FTE calculation type flag.Can take values I ,B and U | |
| FTE_CALC_TYPE_DESC | VARCHAR2 | (80) | FTE calculation type description | |
| 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 | |
| TYPE_OF_YEAR | VARCHAR2 | (30) | The code that identifies the type of program year as applies to the student | |
| TYPE_OF_YEAR_DESC | VARCHAR2 | (240) | Description of the code that identifies the type of program year as applies to the student | |
| YEAR_STU | NUMBER | Year of student on this programme | ||
| CREDIT_VALUE_YOP3 | NUMBER | Credit value of year of programme 3 | ||
| CREDIT_LEVEL3 | VARCHAR2 | (30) | Level of credit 3 | |
| CREDIT_LEVEL3_DESC | VARCHAR2 | (60) | Level of credit 3 description | |
| CREDIT_VALUE_YOP4 | NUMBER | Credit value of year of programme 4 | ||
| CREDIT_LEVEL4 | VARCHAR2 | (30) | Level of credit 4 | |
| CREDIT_LEVEL4_DESC | VARCHAR2 | (60) | Level of credit 4 description | |
| CREDIT_PT_ACHIEVED3 | NUMBER | Number of credit points obtained 3 | ||
| CREDIT_PT_ACHIEVED4 | NUMBER | Number of credit points obtained 4 | ||
| CREDIT_LEVEL_ACHIEVED3 | VARCHAR2 | (30) | Level of credit points obtained 3 | |
| CREDIT_LEVEL_ACHIEVED3_DESC | VARCHAR2 | (60) | Level of credit points obtained 3 description | |
| CREDIT_LEVEL_ACHIEVED4 | VARCHAR2 | (30) | Level of credit points obtained 4 | |
| CREDIT_LEVEL_ACHIEVED4_DESC | VARCHAR2 | (60) | Level of credit points obtained 4 description | |
| ENH_FUND_ELIG_CD | VARCHAR2 | (30) | Eligibility for enhanced funding code | |
| ENH_FUND_ELIG_DESC | VARCHAR2 | (240) | Eligibility for enhanced funding description | |
| ADDITIONAL_SUP_COST | NUMBER | Additional support cost | ||
| DISADV_UPLIFT_FACTOR | NUMBER | Disadvantage uplift factor |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, HESA_EN_SUSA_ID
, PERSON_ID
, COURSE_CD
, UNIT_SET_CD
, US_VERSION_NUMBER
, SEQUENCE_NUMBER
, TERM_TIME_ACCOM
, TERM_TIME_ACCOM_DESC
, DISABILITY_ALLOW
, DISABILITY_ALLOW_DESC
, ADDITIONAL_SUP_BAND
, ADDITIONAL_SUP_BAND_DESC
, SLDD_DISCRETE_PROV
, SLDD_DISCRETE_PROV_DESC
, STUDY_MODE
, STUDY_MODE_DESC
, STUDY_LOCATION
, STUDY_LOCATION_DESC
, FTE_PERC_OVERRIDE
, FRANCHISING_ACTIVITY
, FRANCHISING_ACTIVITY_DESC
, COMPLETION_STATUS
, COMPLETION_STATUS_DESC
, GOOD_STAND_MARKER
, GOOD_STAND_MARKER_DESC
, COMPLETE_PYR_STUDY_CD
, COMPLETE_PYR_STUDY_DESC
, NEW_ENTRANT_CD
, NEW_ENTRANT_DESC
, TEACHING_INST1
, TEACHING_INST1_DESC
, TEACHING_INST2
, TEACHING_INST2_DESC
, PRO_NOT_TAUGHT
, FUNDABILITY_CODE
, FUNDABILITY_CODE_DESC
, FEE_ELIGIBILITY
, FEE_ELIGIBILITY_DESC
, FEE_BAND
, FEE_BAND_DESC
, NON_PAYMENT_REASON
, NON_PAYMENT_REASON_DESC
, STUDENT_FEE
, STUDENT_FEE_DESC
, CREDIT_PT_ACHIEVED1
, CREDIT_PT_ACHIEVED2
, CREDIT_LEVEL1
, CREDIT_LEVEL1_DESC
, CREDIT_LEVEL2
, CREDIT_LEVEL2_DESC
, CREDIT_VALUE_YOP1
, CREDIT_VALUE_YOP2
, CREDIT_LEVEL_ACHIEVED1
, CREDIT_LEVEL_ACHIEVED1_DESC
, CREDIT_LEVEL_ACHIEVED2
, CREDIT_LEVEL_ACHIEVED2_DESC
, GRAD_SCH_GRADE
, MARK
, FTE_INTENSITY
, CALCULATED_FTE
, FTE_CALC_TYPE
, FTE_CALC_TYPE_DESC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TYPE_OF_YEAR
, TYPE_OF_YEAR_DESC
, YEAR_STU
, CREDIT_VALUE_YOP3
, CREDIT_LEVEL3
, CREDIT_LEVEL3_DESC
, CREDIT_VALUE_YOP4
, CREDIT_LEVEL4
, CREDIT_LEVEL4_DESC
, CREDIT_PT_ACHIEVED3
, CREDIT_PT_ACHIEVED4
, CREDIT_LEVEL_ACHIEVED3
, CREDIT_LEVEL_ACHIEVED3_DESC
, CREDIT_LEVEL_ACHIEVED4
, CREDIT_LEVEL_ACHIEVED4_DESC
, ENH_FUND_ELIG_CD
, ENH_FUND_ELIG_DESC
, ADDITIONAL_SUP_COST
, DISADV_UPLIFT_FACTOR
FROM APPS.IGS_HE_EN_SUSA_V;
APPS
IGS_HE_CODE_VALUES
IGS_HE_EN_SUSA
IGS_LOOKUPS_VIEW
IGS_OR_INSTITUTION
IGS_PS_UNIT_LEVEL
APPS.IGS_HE_EN_SUSA_V is not referenced by any database object
|
|
|
|