HRS_HIREPRF_LVW

(SQL View)
 Index Back

Secondary Educ Related Lang Re

HRS_HIREPRF_LVW is the language record related to HRS_HIRE_PRF_VW

SELECT C.EMPLID , A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , D.ACCOMPLISHMENT , D.DT_ISSUED , D.MAJOR_CODE , A.LANGUAGE_CD , A.EDUCATOR ,A.SCHOOL ,A.MAJOR ,A.DESCR ,A.SUBFACULTY_NAME FROM PS_HRS_APP_ACM_LNG A , PS_HRS_APP_ACMP D , PS_HCR_ACCOM_TBL_I B , PS_HRS_HIRE C WHERE D.HRS_PERSON_ID = A.HRS_PERSON_ID AND D.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND A.HRS_APP_ACMP_ID =D.HRS_APP_ACMP_ID AND D.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND B.ACCOMP_CATEGORY = 'DEG' AND D.HRS_PERSON_ID = C.HRS_PERSON_ID AND D.HRS_PROFILE_SEQ = C.HRS_PROFILE_SEQ

  • Related Language Record for HRS_HIRE_PRF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    3 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    4 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
    5 DT_ISSUED Date(10) DATE Issue Date
    6 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 EDUCATOR Character(50) VARCHAR2(50) NOT NULL Educator
    9 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    10 MAJOR Character(30) VARCHAR2(30) NOT NULL Major
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 SUBFACULTY_NAME Character(50) VARCHAR2(50) NOT NULL Sub Faculty Name(Description)(Japan HR)