HRS_APP_LNG_LN

(SQL View)
 Index Back

Applicant Degree Lang Vw

Applicant Degree Lang Vw

SELECT B.HRS_PERSON_ID ,B.HRS_PROFILE_SEQ ,B.HRS_APP_ACMP_ID ,B.LANGUAGE_CD ,B.ISSUED_BY ,B.MANDATE ,B.MANDATE_FUNCTION ,B.EDUCATOR ,B.SCHOOL ,B.MAJOR ,B.GRANTOR ,B.DESCR ,B.SUBFACULTY_NAME ,B.ACCOMPLISHMENT_TXT FROM PS_HRS_APP_ACM_LNG B WHERE (EXISTS ( SELECT 'X' FROM PS_HRS_ACCOM_TBL_I C , PS_HRS_APP_ACMP A WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = B.HRS_PROFILE_SEQ AND A.HRS_APP_ACMP_ID = B.HRS_APP_ACMP_ID AND ((A.ACCOMPLISHMENT = C.ACCOMPLISHMENT AND C.ACCOMP_CATEGORY = 'LNG') OR A.HRS_EXT_ACMP_CTG='LNG')))

  • Related Language Record for HRS_APP_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 HRS_APP_ACMP_ID Number(15,0) DECIMAL(15) NOT NULL Accomplishment ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 ISSUED_BY Character(30) VARCHAR2(30) NOT NULL Issued By
    6 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
    7 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
    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 GRANTOR Character(20) VARCHAR2(20) NOT NULL The name of the person granting the award
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 SUBFACULTY_NAME Character(50) VARCHAR2(50) NOT NULL Sub Faculty Name(Description)(Japan HR)
    14 ACCOMPLISHMENT_TXT Character(30) VARCHAR2(30) NOT NULL Accomplishment Text