ACCOMPLVW_LNG

(SQL View)
 Index Back

Rellang Per. Accomps/Categ. Vw

Rellang Per. Accomps/Categ. Vw

SELECT A.EMPLID ,A.ACCOMPLISHMENT ,A.DT_ISSUED ,A.MAJOR_CODE ,A.LANGUAGE_CD ,A.ISSUED_BY ,A.MANDATE ,A.MANDATE_FUNCTION ,A.EDUCATOR ,A.SCHOOL ,A.MAJOR ,A.GRANTOR ,A.DESCR ,A.SUBFACULTY_NAME FROM PS_ACCOMPLISH_LANG A

  • Related Language Record for ACCOMPLISHMT_VW SCC_ACCOMP_QVW SCC_ACCOM_LIC_I SCC_ACCOM_LNG_I SCC_ACCOM_MBR_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: %RECNAME_EDIT

    3 DT_ISSUED Date(10) DATE Issue Date
    4 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 ISSUED_BY Character(30) VARCHAR2(30) NOT NULL Issued By
    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)