[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:
|
|
|