LAMGRDNOTEVWLNG

(SQL View)
 Index Back

Rel Lang Student Grade Note

LAMGRDNOTEVWLNG is the language record view related to LAM_GRD_NOTE_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT B.STRM ,B.CLASS_NBR ,B.EMPLID ,B.LAM_GRADE_NOTE_SEQ ,A.LANGUAGE_CD ,A.DESCRLONG FROM PS_LAM_GRD_NOTE_LN A , PS_LAM_GRADE_NOTE B WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.EMPLID = B.EMPLID AND B.SHOW_STUDENT = 'Y'

  • Related Language Record for LAM_GRD_NOTE_VW

  • Parent record: STDNT_GRADE_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    2 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 LAM_GRADE_NOTE_SEQ Number(3,0) SMALLINT NOT NULL Grade Note
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCRLONG Long Character CLOB Long Description