[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSBV_ST_HESA_DLHE_SURVEY_RECS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSBV_ST_HESA_DLHE_SURVEY_RECS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Base business view to allow queries on student DLHE survey records.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Unique person identifier |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Unique person number |
| SUBMISSION_NAME | VARCHAR2 | (50) | Yes | HESA submission name of HESA DLHE return student |
| USER_RETURN_SUBCLASS | VARCHAR2 | (50) | Yes | HESA DLHE submission user return subclass |
| RETURN_NAME | VARCHAR2 | (50) | Yes | HESA DLHE submission user return name |
| QUALIFYING_PERIOD_CODE | VARCHAR2 | (10) | Yes | HESA DLHE submission user return qualifying period |
| DLHE_RECORD_STATUS | VARCHAR2 | (3) | Yes | HESA DLHE record status |
| PARTICIPANT_SOURCE | VARCHAR2 | (1) | Yes | Identifies whether the student was a leaver or a research student |
| DATE_STATUS_CHANGED | DATE | Date DLHE record status last changed | ||
| VALIDATION_STATUS | VARCHAR2 | (1) | Flag to identify the validation status of the record | |
| ADMIN_CODING | VARCHAR2 | (1) | Flag to identify whether the employer details still require coding. | |
| SURVEY_METHOD | VARCHAR2 | (30) | Method of data collection.Returned as HESA METHOD | |
| EMPLOYMENT | VARCHAR2 | (30) | Identifies whether the student is in employment.Returned as HESA EMPCIR | |
| FURTHER_STUDY | VARCHAR2 | (30) | Identifies whether the student is engaged in further study.Returned as HESA MODSTUDY | |
| QUALIFIED_TEACHER | VARCHAR2 | (1) | Identifies whether the student was enrolled on a teacher training program of study. | |
| PT_STUDY | VARCHAR2 | (1) | Identifies whether the student was enrolled on a part-time program of study. | |
| EMPLOYER_BUSINESS | VARCHAR2 | (60) | The employers business.Returned as HESA MAKEDO | |
| EMPLOYER_NAME | VARCHAR2 | (60) | Employer name. | |
| EMPLOYER_CLASSIFICATION | VARCHAR2 | (30) | Employer standard industrial classification. Returned as HESA SIC | |
| EMPLOYER_LOCATION | VARCHAR2 | (60) | Employer location. Returned as HESA LOCEMP | |
| EMPLOYER_POSTCODE | VARCHAR2 | (10) | Employer postcode. | |
| EMPLOYER_COUNTRY | VARCHAR2 | (10) | Employer country. | |
| JOB_TITLE | VARCHAR2 | (60) | Job title.Returned as HESA JOBTITLE | |
| JOB_DUTIES | VARCHAR2 | (60) | Duties of role. | |
| JOB_CLASSIFICATION | VARCHAR2 | (30) | Standard Occupational Classification of job.Returned as HESA SOCDLHE | |
| EMPLOYER_SIZE | VARCHAR2 | (30) | Size of employer.Returned as HESA EMPSIZE | |
| JOB_DURATION | VARCHAR2 | (30) | Duration of employment.Returned as HESA DURATION | |
| JOB_SALARY | NUMBER | (6) | Salary.Returned as HESA SALARY | |
| SALARY_REFUSED | VARCHAR2 | (1) | Yes | Salary refused indicator. |
| QUAL_REQUIREMENT | VARCHAR2 | (30) | Qualification required for job.Returned as HESA QUALREQ | |
| QUAL_IMPORTANCE | VARCHAR2 | (30) | Importance to employer.Returned as HESA EMPIMP | |
| JOB_REASON1 | VARCHAR2 | (1) | Yes | First Reason for taking the job indicator.Returned as HESA CAREER1 |
| JOB_REASON2 | VARCHAR2 | (1) | Yes | Second Reason for taking the job indicator.Returned as HESA CAREER2 |
| JOB_REASON3 | VARCHAR2 | (1) | Yes | Third Reason for taking the job indicator.Returned as HESA CAREER3 |
| JOB_REASON4 | VARCHAR2 | (1) | Yes | Fourth Reason for taking the job indicator.Returned as HESA CAREER4 |
| JOB_REASON5 | VARCHAR2 | (1) | Yes | Fifth Reason for taking the job indicator.Returned as HESA CAREER5 |
| JOB_REASON6 | VARCHAR2 | (1) | Yes | Sixth Reason for taking the job indicator.Returned as HESA CAREER6 |
| JOB_REASON7 | VARCHAR2 | (1) | Yes | Seventh Reason for taking the job indicator.Returned as HESA CAREER7 |
| JOB_REASON8 | VARCHAR2 | (1) | Yes | Eighth Reason for taking the job indicator.Returned as HESA CAREER8 |
| OTHER_JOB_REASON | VARCHAR2 | (60) | Other reason for taking job. | |
| NO_OTHER_JOB_REASON | VARCHAR2 | (1) | Yes | No reason for taking job indicator. |
| JOB_SOURCE | VARCHAR2 | (30) | How found job.Returned as HESA JOBFND | |
| OTHER_JOB_SOURCE | VARCHAR2 | (60) | Other way of finding out about the job | |
| NO_OTHER_JOB_SOURCE | VARCHAR2 | (1) | Yes | No other way indicator |
| PREVIOUS_JOB | VARCHAR2 | (30) | Previously employed indicator.Returned as HESA PREVEMP | |
| PREVIOUS_JOBTYPE1 | VARCHAR2 | (1) | Yes | Category of previous employment 1.Returned as HESA PREVCAT1 |
| PREVIOUS_JOBTYPE2 | VARCHAR2 | (1) | Yes | Category of previous employment 2.Returned as HESA PREVCAT2 |
| PREVIOUS_JOBTYPE3 | VARCHAR2 | (1) | Yes | Category of previous employment 3.Returned as HESA PREVCAT3 |
| PREVIOUS_JOBTYPE4 | VARCHAR2 | (1) | Yes | Category of previous employment 4.Returned as HESA PREVCAT4 |
| PREVIOUS_JOBTYPE5 | VARCHAR2 | (1) | Yes | Category of previous employment 5.Returned as HESA PREVCAT5 |
| PREVIOUS_JOBTYPE6 | VARCHAR2 | (1) | Yes | Category of previous employment6.Returned as HESA PREVCAT6 |
| FURTHER_STUDY_TYPE | VARCHAR2 | (30) | Nature of study/training.Returned as HESA NATSTUDY | |
| COURSE_NAME | VARCHAR2 | (60) | Name of course being undertaken | |
| COURSE_TRAINING_SUBJECT | VARCHAR2 | (30) | Professional subject of training code.Returned as HESA PROFSOCT | |
| RESEARCH_SUBJECT | VARCHAR2 | (60) | Subject of Research text | |
| RESEARCH_TRAINING_SUBJECT | VARCHAR2 | (30) | Subject of Research code.Returned as HESA PROFSOCT | |
| FURTHER_STUDY_PROVIDER | VARCHAR2 | (30) | Institution providing study.Returned as HESA INSTPROV | |
| FURTHER_STUDY_QUAL_AIM | VARCHAR2 | (30) | Type of qualification.Returned as HESA TYPEQUAL | |
| PROFESSIONAL_QUAL | VARCHAR2 | (60) | Professional Qualification being undertaken | |
| STUDY_REASON1 | VARCHAR2 | (30) | Reason for taking another course 1.Returned as HESA SECINT1 | |
| STUDY_REASON2 | VARCHAR2 | (1) | Yes | Reason for taking another course 2.Returned as HESA SECINT2 |
| STUDY_REASON3 | VARCHAR2 | (1) | Yes | Reason for taking another course 3.Returned as HESA SECINT3 |
| STUDY_REASON4 | VARCHAR2 | (1) | Yes | Reason for taking another course 4.Returned as HESA SECINT4 |
| STUDY_REASON5 | VARCHAR2 | (1) | Yes | Reason for taking another course 5.Returned as HESA SECINT5 |
| STUDY_REASON6 | VARCHAR2 | (1) | Yes | Reason for taking another course 6.Returned as HESA SECINT6 |
| STUDY_REASON7 | VARCHAR2 | (1) | Yes | Reason for taking another course 7.Returned as HESA SECINT7 |
| OTHER_STUDY_REASON | VARCHAR2 | (60) | Other reason for taking another course indicator.Returned as HESA SCEINT8 | |
| NO_OTHER_STUDY_REASON | VARCHAR2 | (1) | Yes | No Other reason for taking another course indicator. |
| EMPLOYER_SPONSORED | VARCHAR2 | (1) | Yes | Financial support.Returned as HESA EMPPAID |
| FUNDING_SOURCE | VARCHAR2 | (30) | How funding further study.Returned as HESA FUNDSTDY | |
| TEACHER_TEACHING | VARCHAR2 | (1) | Teaching employment marker.Used to derive HESA TCHEMP. | |
| TEACHER_SEEKING | VARCHAR2 | (1) | Teacher seeking employment indicator.Used to derive HESA TCHEMP. | |
| TEACHING_SECTOR | VARCHAR2 | (30) | Teaching sector.Returned as HESA TEACHSCT | |
| TEACHING_LEVEL | VARCHAR2 | (30) | Teaching phase.Returned as HESA TEACHPHS | |
| REASON_FOR_PTCOURSE | VARCHAR2 | (30) | Reason for taking original course.Returned as HESA INTENT | |
| JOB_WHILE_STUDYING | VARCHAR2 | (1) | Yes | Employed during course.Returned as HESA EMPCRSE |
| EMPLOYER_SUPPORT1 | VARCHAR2 | (1) | Yes | Employer sponsorship 1.Returned as EMSPNS1 |
| EMPLOYER_SUPPORT2 | VARCHAR2 | (1) | Yes | Employer sponsorship 2.Returned as EMSPNS2 |
| EMPLOYER_SUPPORT3 | VARCHAR2 | (1) | Yes | Employer sponsorship 3.Returned as EMSPNS3 |
| EMPLOYER_SUPPORT4 | VARCHAR2 | (1) | Yes | Employer sponsorship 4.Returned as EMSPNS4 |
| EMPLOYER_SUPPORT5 | VARCHAR2 | (1) | Yes | Employer sponsorship 5.Returned as EMSPNS5 |
| POPDLHE_FLAG | VARCHAR2 | (1) | Yes | Flag to identify records included in POPDLHE |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO column indicates who create this record |
| CREATION_DATE | DATE | Yes | Standard WHO column indicates when this record was created | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column indicates who updated this record last |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO column indicates when this record was last updated |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PERSON_NUMBER
, SUBMISSION_NAME
, USER_RETURN_SUBCLASS
, RETURN_NAME
, QUALIFYING_PERIOD_CODE
, DLHE_RECORD_STATUS
, PARTICIPANT_SOURCE
, DATE_STATUS_CHANGED
, VALIDATION_STATUS
, ADMIN_CODING
, SURVEY_METHOD
, EMPLOYMENT
, FURTHER_STUDY
, QUALIFIED_TEACHER
, PT_STUDY
, EMPLOYER_BUSINESS
, EMPLOYER_NAME
, EMPLOYER_CLASSIFICATION
, EMPLOYER_LOCATION
, EMPLOYER_POSTCODE
, EMPLOYER_COUNTRY
, JOB_TITLE
, JOB_DUTIES
, JOB_CLASSIFICATION
, EMPLOYER_SIZE
, JOB_DURATION
, JOB_SALARY
, SALARY_REFUSED
, QUAL_REQUIREMENT
, QUAL_IMPORTANCE
, JOB_REASON1
, JOB_REASON2
, JOB_REASON3
, JOB_REASON4
, JOB_REASON5
, JOB_REASON6
, JOB_REASON7
, JOB_REASON8
, OTHER_JOB_REASON
, NO_OTHER_JOB_REASON
, JOB_SOURCE
, OTHER_JOB_SOURCE
, NO_OTHER_JOB_SOURCE
, PREVIOUS_JOB
, PREVIOUS_JOBTYPE1
, PREVIOUS_JOBTYPE2
, PREVIOUS_JOBTYPE3
, PREVIOUS_JOBTYPE4
, PREVIOUS_JOBTYPE5
, PREVIOUS_JOBTYPE6
, FURTHER_STUDY_TYPE
, COURSE_NAME
, COURSE_TRAINING_SUBJECT
, RESEARCH_SUBJECT
, RESEARCH_TRAINING_SUBJECT
, FURTHER_STUDY_PROVIDER
, FURTHER_STUDY_QUAL_AIM
, PROFESSIONAL_QUAL
, STUDY_REASON1
, STUDY_REASON2
, STUDY_REASON3
, STUDY_REASON4
, STUDY_REASON5
, STUDY_REASON6
, STUDY_REASON7
, OTHER_STUDY_REASON
, NO_OTHER_STUDY_REASON
, EMPLOYER_SPONSORED
, FUNDING_SOURCE
, TEACHER_TEACHING
, TEACHER_SEEKING
, TEACHING_SECTOR
, TEACHING_LEVEL
, REASON_FOR_PTCOURSE
, JOB_WHILE_STUDYING
, EMPLOYER_SUPPORT1
, EMPLOYER_SUPPORT2
, EMPLOYER_SUPPORT3
, EMPLOYER_SUPPORT4
, EMPLOYER_SUPPORT5
, POPDLHE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_ST_HESA_DLHE_SURVEY_RECS;
APPS
HZ_PARTIES
IGS_HE_STDNT_DLHE
APPS.IGSBV_ST_HESA_DLHE_SURVEY_RECS is not referenced by any database object
|
|
|
|