[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.IGSBV_ST_HESA_DLHE_SURVEY_RECS is not referenced by any database object
|
|
|