DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_ST_HESA_DLHE_SURVEY_RECS

Object Details
Object Name: IGSFV_ST_HESA_DLHE_SURVEY_RECS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_ST_HESA_DLHE_SURVEY_RECS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Full business view to allow queries on Student DLHE Survey Records.


[View Source]

Columns
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
_LA:DLHE_RECORD_STATUS_DESC CHAR (79)
HESA DLHE record status description
PARTICIPANT_SOURCE VARCHAR2 (1) Yes Identifies whether the student was a leaver or a research student whose funding has ceased
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
SURVEY_METHOD_DESC VARCHAR2 (240)
Method of data collection description
EMPLOYMENT VARCHAR2 (30)
Employment circumstances, identifies whether the student is in employment.Returned as HESA EMPCIR
EMPLOYMENT_DESC VARCHAR2 (240)
Employment circumstances description
FURTHER_STUDY VARCHAR2 (30)
Identifies whether the student is engaged in further study.Returned as HESA MODSTUDY
FURTHER_STUDY_DESC VARCHAR2 (240)
Further Study description
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_CLASSIFICATION_DESC VARCHAR2 (240)
Employer classification description
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
JOB_CLASSIFICATION_DESC VARCHAR2 (240)
Job Classification description
EMPLOYER_SIZE VARCHAR2 (30)
Size of employer.Returned as EMPSIZE
EMPLOYER_SIZE_DESC VARCHAR2 (240)
Size of employer description
JOB_DURATION VARCHAR2 (30)
Duration of employment.Returned as HESA DURATION
JOB_DURATION_DESC VARCHAR2 (240)
Duration of employment description
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_REQUIREMENT_DESC VARCHAR2 (240)
Qualification required for job description
QUAL_IMPORTANCE VARCHAR2 (30)
Importance to employer.Returned as HESA EMPIMP
QUAL_IMPORTANCE_DESC VARCHAR2 (240)
Importance to employer description
JOB_REASON1 VARCHAR2 (1) Yes First Reason for taking the job indicator.Returned as HESA CAREER1
JOB_REASON1_DESC CHAR (72)
Reason 1 for taking job description
JOB_REASON2 VARCHAR2 (1) Yes Second Reason for taking the job indicator.Returned as HESA CAREER2
JOB_REASON2_DESC CHAR (64)
Reason 2 for taking job description
JOB_REASON3 VARCHAR2 (1) Yes Third Reason for taking the job indicator.Returned as HESA CAREER3
JOB_REASON3_DESC CHAR (53)
Reason 3 for taking job description
JOB_REASON4 VARCHAR2 (1) Yes Fourth reason for taking the job indicator.Returned as HESA CAREER4
JOB_REASON4_DESC CHAR (61)
Reason 4 for taking job description
JOB_REASON5 VARCHAR2 (1) Yes Fifth Reason for taking the job indicator.Returned as HESA CAREER5
JOB_REASON5_DESC CHAR (51)
Reason 5 for taking job description
JOB_REASON6 VARCHAR2 (1) Yes Sixth Reason for taking the job indicator.Returned as HESA CAREER6
JOB_REASON6_DESC CHAR (52)
Reason 6 for taking job description
JOB_REASON7 VARCHAR2 (1) Yes Seventh Reason for taking the job indicator.Returned as HESA CAREER7
JOB_REASON7_DESC CHAR (25)
Reason 7 for taking job description
JOB_REASON8 VARCHAR2 (1) Yes Eighth Reason for taking the job indicator.Returned as HESA CAREER8
JOB_REASON8_DESC CHAR (42)
Reason 8 for taking job description
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
JOB_SOURCE_DESC VARCHAR2 (240)
How found job description
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_JOB_DESC VARCHAR2 (240)
Previously employed description
PREVIOUS_JOBTYPE1 VARCHAR2 (1) Yes Category of previous employment 1.Returned as HESA PREVCAT1
PREVIOUS_JOBTYPE1_DESC CHAR (23)
Previous job type 1 description
PREVIOUS_JOBTYPE2 VARCHAR2 (1) Yes Category of previous employment 2.Returned as HESA PREVCAT2
PREVIOUS_JOBTYPE2_DESC CHAR (44)
Previous job type 2 description
PREVIOUS_JOBTYPE3 VARCHAR2 (1) Yes Category of previous employment 3.Returned as HESA PREVCAT3
PREVIOUS_JOBTYPE3_DESC CHAR (16)
Previous job type 3 description
PREVIOUS_JOBTYPE4 VARCHAR2 (1) Yes Category of previous employment 4.Returned as HESA PREVCAT4
PREVIOUS_JOBTYPE4_DESC CHAR (42)
Previous job type 4 description
PREVIOUS_JOBTYPE5 VARCHAR2 (1) Yes Category of previous employment 5.Returned as HESA PREVCAT5
PREVIOUS_JOBTYPE5_DESC CHAR (39)
Previous job type 5 description
PREVIOUS_JOBTYPE6 VARCHAR2 (1) Yes Category of previous employment6.Returned as HESA PREVCAT6
PREVIOUS_JOBTYPE6_DESC CHAR (13)
Previous job type 6 description
FURTHER_STUDY_TYPE VARCHAR2 (30)
Nature of study/training.Returned as HESA NATSTUDY
FURTHER_STUDY_TYPE_DESC VARCHAR2 (240)
Nature of study/training description
COURSE_NAME VARCHAR2 (60)
Name of course being undertaken
COURSE_TRAINING_SUBJECT VARCHAR2 (30)
Subject of professional training code.Returned as HESA PROFSOCT
COURSE_TRAINING_SUBJECT_DESC VARCHAR2 (240)
Subject of professional training subject code
RESEARCH_SUBJECT VARCHAR2 (60)
Subject of Research text
RESEARCH_TRAINING_SUBJECT VARCHAR2 (30)
Subject of Research code.Returned as HESA PROFSOCT
RESEARCH_TRAINING_SUBJECT_DESC VARCHAR2 (240)
Subject of research code description
FURTHER_STUDY_PROVIDER VARCHAR2 (30)
Institution providing study.Returned as HESA INSTPROV
FURTHER_STUDY_PROVIDER_NAME VARCHAR2 (360)
Institution providing study name
FURTHER_STUDY_QUAL_AIM VARCHAR2 (30)
Type of qualification.Returned as HESA TYPEQUAL
FURTHER_STUDY_QUAL_AIM_DESC VARCHAR2 (240)
Type of qualification description
PROFESSIONAL_QUAL VARCHAR2 (60)
Professional Qualification being undertaken
STUDY_REASON1 VARCHAR2 (30)
Reason for taking another course 1.Returned as HESA SECINT1
STUDY_REASON1_DESC CHAR (93)
Reason 1 for taking another course description
STUDY_REASON2 VARCHAR2 (1) Yes Reason for taking another course 2.Returned as HESA SECINT2
STUDY_REASON2_DESC CHAR (68)
Reason 2 for taking another course description
STUDY_REASON3 VARCHAR2 (1) Yes Reason for taking another course 3.Returned as HESA SECINT3
STUDY_REASON3_DESC CHAR (38)
Reason 3 for taking another course description
STUDY_REASON4 VARCHAR2 (1) Yes Reason for taking another course 4.Returned as HESA SECINT4
STUDY_REASON4_DESC CHAR (53)
Reason 4 for taking another course description
STUDY_REASON5 VARCHAR2 (1) Yes Reason for taking another course 5.Returned as HESA SECINT5
STUDY_REASON5_DESC CHAR (69)
Reason 5 for taking another course description
STUDY_REASON6 VARCHAR2 (1) Yes Reason for taking another course 6.Returned as HESA SECINT6
STUDY_REASON6_DESC CHAR (68)
Reason 6 for taking another course description
STUDY_REASON7 VARCHAR2 (1) Yes Reason for taking another course 7.Returned as HESA SECINT7
STUDY_REASON7_DESC CHAR (40)
Reason 7 for taking another course description
OTHER_STUDY_REASON VARCHAR2 (60)
Other reason for taking another course indicator.Returned as HESA SECINT8
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
FUNDING_SOURCE_DESC VARCHAR2 (240)
How funding further study description
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_SECTOR_DESC VARCHAR2 (240)
Teaching sector description
TEACHING_LEVEL VARCHAR2 (30)
Teaching phase.Returned as HESA TEACHPHS
TEACHING_LEVEL_DESC VARCHAR2 (240)
Teaching phase description
REASON_FOR_PTCOURSE VARCHAR2 (30)
Reason for taking original course.Returned as HESA INTENT
REASON_FOR_PTCOURSE_DESC VARCHAR2 (240)
Reason for taking original course description
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_SUPPORT1_DESC CHAR (30)
Employer sponsorship 1 description
EMPLOYER_SUPPORT2 VARCHAR2 (1) Yes Employer sponsorship 2.Returned as EMSPNS2
EMPLOYER_SUPPORT2_DESC CHAR (69)
Employer sponsorship 2 description
EMPLOYER_SUPPORT3 VARCHAR2 (1) Yes Employer sponsorship 3.Returned as EMSPNS3
EMPLOYER_SUPPORT3_DESC CHAR (28)
Employer sponsorship 3 description
EMPLOYER_SUPPORT4 VARCHAR2 (1) Yes Employer sponsorship 4.Returned as EMSPNS4
EMPLOYER_SUPPORT4_DESC CHAR (34)
Employer sponsorship 4 description
EMPLOYER_SUPPORT5 VARCHAR2 (1) Yes Employer sponsorship 5.Returned as EMSPNS5
EMPLOYER_SUPPORT5_DESC CHAR (45)
Employer sponsorship 5 description
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
Query Text

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
,      _LA:DLHE_RECORD_STATUS_DESC
,      PARTICIPANT_SOURCE
,      DATE_STATUS_CHANGED
,      VALIDATION_STATUS
,      ADMIN_CODING
,      SURVEY_METHOD
,      SURVEY_METHOD_DESC
,      EMPLOYMENT
,      EMPLOYMENT_DESC
,      FURTHER_STUDY
,      FURTHER_STUDY_DESC
,      QUALIFIED_TEACHER
,      PT_STUDY
,      EMPLOYER_BUSINESS
,      EMPLOYER_NAME
,      EMPLOYER_CLASSIFICATION
,      EMPLOYER_CLASSIFICATION_DESC
,      EMPLOYER_LOCATION
,      EMPLOYER_POSTCODE
,      EMPLOYER_COUNTRY
,      JOB_TITLE
,      JOB_DUTIES
,      JOB_CLASSIFICATION
,      JOB_CLASSIFICATION_DESC
,      EMPLOYER_SIZE
,      EMPLOYER_SIZE_DESC
,      JOB_DURATION
,      JOB_DURATION_DESC
,      JOB_SALARY
,      SALARY_REFUSED
,      QUAL_REQUIREMENT
,      QUAL_REQUIREMENT_DESC
,      QUAL_IMPORTANCE
,      QUAL_IMPORTANCE_DESC
,      JOB_REASON1
,      JOB_REASON1_DESC
,      JOB_REASON2
,      JOB_REASON2_DESC
,      JOB_REASON3
,      JOB_REASON3_DESC
,      JOB_REASON4
,      JOB_REASON4_DESC
,      JOB_REASON5
,      JOB_REASON5_DESC
,      JOB_REASON6
,      JOB_REASON6_DESC
,      JOB_REASON7
,      JOB_REASON7_DESC
,      JOB_REASON8
,      JOB_REASON8_DESC
,      OTHER_JOB_REASON
,      NO_OTHER_JOB_REASON
,      JOB_SOURCE
,      JOB_SOURCE_DESC
,      OTHER_JOB_SOURCE
,      NO_OTHER_JOB_SOURCE
,      PREVIOUS_JOB
,      PREVIOUS_JOB_DESC
,      PREVIOUS_JOBTYPE1
,      PREVIOUS_JOBTYPE1_DESC
,      PREVIOUS_JOBTYPE2
,      PREVIOUS_JOBTYPE2_DESC
,      PREVIOUS_JOBTYPE3
,      PREVIOUS_JOBTYPE3_DESC
,      PREVIOUS_JOBTYPE4
,      PREVIOUS_JOBTYPE4_DESC
,      PREVIOUS_JOBTYPE5
,      PREVIOUS_JOBTYPE5_DESC
,      PREVIOUS_JOBTYPE6
,      PREVIOUS_JOBTYPE6_DESC
,      FURTHER_STUDY_TYPE
,      FURTHER_STUDY_TYPE_DESC
,      COURSE_NAME
,      COURSE_TRAINING_SUBJECT
,      COURSE_TRAINING_SUBJECT_DESC
,      RESEARCH_SUBJECT
,      RESEARCH_TRAINING_SUBJECT
,      RESEARCH_TRAINING_SUBJECT_DESC
,      FURTHER_STUDY_PROVIDER
,      FURTHER_STUDY_PROVIDER_NAME
,      FURTHER_STUDY_QUAL_AIM
,      FURTHER_STUDY_QUAL_AIM_DESC
,      PROFESSIONAL_QUAL
,      STUDY_REASON1
,      STUDY_REASON1_DESC
,      STUDY_REASON2
,      STUDY_REASON2_DESC
,      STUDY_REASON3
,      STUDY_REASON3_DESC
,      STUDY_REASON4
,      STUDY_REASON4_DESC
,      STUDY_REASON5
,      STUDY_REASON5_DESC
,      STUDY_REASON6
,      STUDY_REASON6_DESC
,      STUDY_REASON7
,      STUDY_REASON7_DESC
,      OTHER_STUDY_REASON
,      NO_OTHER_STUDY_REASON
,      EMPLOYER_SPONSORED
,      FUNDING_SOURCE
,      FUNDING_SOURCE_DESC
,      TEACHER_TEACHING
,      TEACHER_SEEKING
,      TEACHING_SECTOR
,      TEACHING_SECTOR_DESC
,      TEACHING_LEVEL
,      TEACHING_LEVEL_DESC
,      REASON_FOR_PTCOURSE
,      REASON_FOR_PTCOURSE_DESC
,      JOB_WHILE_STUDYING
,      EMPLOYER_SUPPORT1
,      EMPLOYER_SUPPORT1_DESC
,      EMPLOYER_SUPPORT2
,      EMPLOYER_SUPPORT2_DESC
,      EMPLOYER_SUPPORT3
,      EMPLOYER_SUPPORT3_DESC
,      EMPLOYER_SUPPORT4
,      EMPLOYER_SUPPORT4_DESC
,      EMPLOYER_SUPPORT5
,      EMPLOYER_SUPPORT5_DESC
,      POPDLHE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_ST_HESA_DLHE_SURVEY_RECS;

Dependencies

[top of page]

APPS.IGSFV_ST_HESA_DLHE_SURVEY_RECS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_HE_CODE_VALUES
SynonymIGS_HE_STDNT_DLHE
SynonymIGS_PE_HZ_PARTIES

APPS.IGSFV_ST_HESA_DLHE_SURVEY_RECS is not referenced by any database object