[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_HE_STDNT_DLHE |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_HE_STDNT_DLHE
|
| Subobject Name: | |
| Status: | VALID |
Stores the Student DLHE details for each Submission Return Qualifying Period
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_HE_STDNT_DLHE_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PERSON_ID
SUBMISSION_NAME
RETURN_NAME
|
| IGS_HE_STDNT_DLHE_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SUBMISSION_NAME
RETURN_NAME
USER_RETURN_SUBCLASS
QUAL_PERIOD_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
| SUBMISSION_NAME | VARCHAR2 | (50) | Yes | Submission Name |
| USER_RETURN_SUBCLASS | VARCHAR2 | (50) | Yes | User Return Subclass |
| RETURN_NAME | VARCHAR2 | (50) | Yes | Return Name |
| QUAL_PERIOD_CODE | VARCHAR2 | (10) | Yes | Qualifying Period Code |
| DLHE_RECORD_STATUS | VARCHAR2 | (3) | Yes | Status of this student record during Survey. Can take values NST, EXC, SUB, SAV, REV |
| PARTICIPANT_SOURCE | VARCHAR2 | (1) | Yes | Qualification Type . Either L (Leaver) , R (Research) or M (Manual) |
| DATE_STATUS_CHANGED | DATE | Latest date when this record's DLHE record status has changed | ||
| VALIDATION_STATUS | VARCHAR2 | (1) | Indicates if this DLHE record satisfies all the validations in Self Service | |
| ADMIN_CODING | VARCHAR2 | (1) | Indicates if validations related to Employer Details are satisfied | |
| SURVEY_METHOD | VARCHAR2 | (30) | Related to HESA field METHOD (4) | |
| EMPLOYMENT | VARCHAR2 | (30) | Related to question Q1 and HESA field EMPCIR (5) | |
| FURTHER_STUDY | VARCHAR2 | (30) | Related to question Q2 and HESA field MODSTUDY (6) | |
| QUALIFIED_TEACHER | VARCHAR2 | (1) | Related to questionnaire Section D | |
| PT_STUDY | VARCHAR2 | (1) | Related to questionnaire Section E | |
| EMPLOYER_BUSINESS | VARCHAR2 | (60) | Related to question Q3.1 and HESA field MAKEDO (7) | |
| EMPLOYER_NAME | VARCHAR2 | (60) | Related to question Q4 | |
| EMPLOYER_CLASSIFICATION | VARCHAR2 | (30) | Related to question Q3.2 and HESA field SIC (8) | |
| EMPLOYER_LOCATION | VARCHAR2 | (60) | Related to question Q5.1 | |
| EMPLOYER_POSTCODE | VARCHAR2 | (10) | Related to question Q5.3 and HESA field LOCEMP (9) | |
| EMPLOYER_COUNTRY | VARCHAR2 | (10) | Related to question Q5.2 and HESA field LOCEMP (9) | |
| JOB_TITLE | VARCHAR2 | (60) | Related to question Q6 and HESA field JOBTITLE (10) | |
| JOB_DUTIES | VARCHAR2 | (60) | Related to question Q7 | |
| JOB_CLASSIFICATION | VARCHAR2 | (30) | Related to HESA field SOCDLHE (11) | |
| EMPLOYER_SIZE | VARCHAR2 | (30) | Related to question Q8 and HESA field EMPSIZE (12) | |
| JOB_DURATION | VARCHAR2 | (30) | Related to question Q9 and HESA field DURATION (13) | |
| JOB_SALARY | NUMBER | (6) | Related to question Q10 and HESA field SALARY (14) | |
| SALARY_REFUSED | VARCHAR2 | (1) | Yes | Related to question Q10 |
| QUALIFICATION_REQUIREMENT | VARCHAR2 | (30) | Related to question Q11 and HESA field QUALREQ (15) | |
| QUALIFICATION_IMPORTANCE | VARCHAR2 | (30) | Related to question Q12 and HESA field EMPIMP (16) | |
| JOB_REASON1 | VARCHAR2 | (1) | Yes | Related to question Q13.1 and HESA field CAREER1 (17) |
| JOB_REASON2 | VARCHAR2 | (1) | Yes | Related to question Q13.2 and HESA field CAREER2 (18) |
| JOB_REASON3 | VARCHAR2 | (1) | Yes | Related to question Q13.3 and HESA field CAREER3 (19) |
| JOB_REASON4 | VARCHAR2 | (1) | Yes | Related to question Q13.4 and HESA field CAREER4 (20) |
| JOB_REASON5 | VARCHAR2 | (1) | Yes | Related to question Q13.5 and HESA field CAREER5 (21) |
| JOB_REASON6 | VARCHAR2 | (1) | Yes | Related to question Q13.6 and HESA field CAREER6 (22) |
| JOB_REASON7 | VARCHAR2 | (1) | Yes | Related to question Q13.7 and HESA field CAREER7 (23) |
| JOB_REASON8 | VARCHAR2 | (1) | Yes | Related to question Q13.8 and HESA field CAREER8 (24) |
| OTHER_JOB_REASON | VARCHAR2 | (60) | Related to question Q14.1 | |
| NO_OTHER_JOB_REASON | VARCHAR2 | (1) | Yes | Related to question Q14.2 |
| JOB_SOURCE | VARCHAR2 | (30) | Related to question Q15 and HESA field JOBFND (25) | |
| OTHER_JOB_SOURCE | VARCHAR2 | (60) | Related to question Q16.1 | |
| NO_OTHER_JOB_SOURCE | VARCHAR2 | (1) | Yes | Related to question Q16.2 |
| PREVIOUS_JOB | VARCHAR2 | (30) | Related to question Q17 and HESA field PREVEMP (26) | |
| PREVIOUS_JOBTYPE1 | VARCHAR2 | (1) | Yes | Related to question Q18.1 and HESA field PREVCAT1 (27) |
| PREVIOUS_JOBTYPE2 | VARCHAR2 | (1) | Yes | Related to question Q18.2 and HESA field PREVCAT2 (28) |
| PREVIOUS_JOBTYPE3 | VARCHAR2 | (1) | Yes | Related to question Q18.3 and HESA field PREVCAT3 (29) |
| PREVIOUS_JOBTYPE4 | VARCHAR2 | (1) | Yes | Related to question Q18.4 and HESA field PREVCAT4 (30) |
| PREVIOUS_JOBTYPE5 | VARCHAR2 | (1) | Yes | Related to question Q18.5 and HESA field PREVCAT5 (31) |
| PREVIOUS_JOBTYPE6 | VARCHAR2 | (1) | Yes | Related to question Q18.6 and HESA field PREVCAT6 (32) |
| FURTHER_STUDY_TYPE | VARCHAR2 | (30) | Related to question Q19 and HESA field NATSTUDY (33) | |
| COURSE_NAME | VARCHAR2 | (60) | Related to question Q20.1 | |
| COURSE_TRAINING_SUBJECT | VARCHAR2 | (30) | Related to question Q20.2 and HESA field PROFSOCT (34) | |
| RESEARCH_SUBJECT | VARCHAR2 | (60) | Related to question Q21.1 | |
| RESEARCH_TRAINING_SUBJECT | VARCHAR2 | (30) | Related to question Q21.2 and HESA field PROFSOCT (34) | |
| FURTHER_STUDY_PROVIDER | VARCHAR2 | (30) | Related to question Q22 and HESA field INSTPROV (35) | |
| FURTHER_STUDY_QUALAIM | VARCHAR2 | (30) | Related to question Q23 and HESA field TYPEQUAL (36) | |
| PROFESSIONAL_QUALIFICATION | VARCHAR2 | (60) | Related to question Q24 not returned to HESA | |
| STUDY_REASON1 | VARCHAR2 | (30) | Related to question Q25 and HESA field SECINT1 (37) | |
| STUDY_REASON2 | VARCHAR2 | (1) | Yes | Related to question Q27.1 and HESA field SECINT2 (38) |
| STUDY_REASON3 | VARCHAR2 | (1) | Yes | Related to question Q27.2 and HESA field SECINT3 (39) |
| STUDY_REASON4 | VARCHAR2 | (1) | Yes | Related to question Q27.3 and HESA field SECINT4 (40) |
| STUDY_REASON5 | VARCHAR2 | (1) | Yes | Related to question Q27.4 and HESA field SECINT5 (41) |
| STUDY_REASON6 | VARCHAR2 | (1) | Yes | Related to question Q27.5 and HESA field SECINT6 (42) |
| STUDY_REASON7 | VARCHAR2 | (1) | Yes | Related to question Q27.6 and HESA field SECINT7 (43) |
| OTHER_STUDY_REASON | VARCHAR2 | (60) | Related to question Q28.1 and HESA field SECINT8 (44) | |
| NO_OTHER_STUDY_REASON | VARCHAR2 | (1) | Yes | Related to question Q28.2 and HESA field SECINT8 (44) |
| EMPLOYER_SPONSORED | VARCHAR2 | (1) | Yes | Related to question Q26 and HESA field EMPPAID (45) |
| FUNDING_SOURCE | VARCHAR2 | (30) | Related to question Q29 and HESA field FUNDSTDY (46) | |
| TEACHER_TEACHING | VARCHAR2 | (1) | Related to question Q30 and HESA field TCHEMP (47) | |
| TEACHER_SEEKING | VARCHAR2 | (1) | Related to question Q33 and HESA field TCHEMP (47) | |
| TEACHING_SECTOR | VARCHAR2 | (30) | Related to question Q31 and HESA field TEACHSCT (48) | |
| TEACHING_LEVEL | VARCHAR2 | (30) | Related to question Q32 and HESA field TEACHPHS(49) | |
| REASON_FOR_PTCOURSE | VARCHAR2 | (30) | Related to question Q34 and HESA field INTENT (50) | |
| JOB_WHILE_STUDYING | VARCHAR2 | (1) | Yes | Related to question Q35 and HESA field EMPCRSE (51) |
| EMPLOYER_SUPPORT1 | VARCHAR2 | (1) | Yes | Related to question Q36.1 and HESA field EMSPNS1 (52) |
| EMPLOYER_SUPPORT2 | VARCHAR2 | (1) | Yes | Related to question Q36.2 and HESA field EMSPNS2 (53) |
| EMPLOYER_SUPPORT3 | VARCHAR2 | (1) | Yes | Related to question Q36.3 and HESA field EMSPNS3 (54) |
| EMPLOYER_SUPPORT4 | VARCHAR2 | (1) | Yes | Related to question Q36.4 and HESA field EMSPNS4 (55) |
| EMPLOYER_SUPPORT5 | VARCHAR2 | (1) | Yes | Related to question Q36.5 and HESA field EMSPNS5 (56) |
| 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 | |
| POPDLHE_FLAG | VARCHAR2 | (1) | Yes | Flag to identify records included in POPDLHE. |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, SUBMISSION_NAME
, USER_RETURN_SUBCLASS
, RETURN_NAME
, QUAL_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
, QUALIFICATION_REQUIREMENT
, QUALIFICATION_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_QUALAIM
, PROFESSIONAL_QUALIFICATION
, 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, POPDLHE_FLAG
FROM IGS.IGS_HE_STDNT_DLHE;
IGS.IGS_HE_STDNT_DLHE does not reference any database object
IGS.IGS_HE_STDNT_DLHE is referenced by following:
APPS
IGS_HE_STDNT_DLHE
|
|
|
|