HRS_AACMP_LN_I

(SQL View)
 Index Back

Applicant Accomplishments Lang

Applicant Accomplishment Language Interfaces

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.HRS_APP_ACMP_ID ,B.LANGUAGE_CD ,B.ISSUED_BY ,A.ACCOMPLISHMENT ,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_ACMP A , PS_HRS_APP_ACM_LNG B 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

  • Related Language Record for HRS_APP_ACMP_I

    • # 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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
    7 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
    8 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
    9 EDUCATOR Character(50) VARCHAR2(50) NOT NULL Educator
    10 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    11 MAJOR Character(30) VARCHAR2(30) NOT NULL Major
    12 GRANTOR Character(20) VARCHAR2(20) NOT NULL The name of the person granting the award
    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 SUBFACULTY_NAME Character(50) VARCHAR2(50) NOT NULL Sub Faculty Name(Description)(Japan HR)
    15 ACCOMPLISHMENT_TXT Character(30) VARCHAR2(30) NOT NULL Accomplishment Text