TCRPTREQSECVWLN

(SQL View)
 Index Back

Related Lng- Transcript Req Vw

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

SELECT B.OPRID , A.EMPLID , A.TRANSCRIPT_SEQ_NO , C.LANGUAGE_CD , C.DESCRLONG FROM PS_TRANSCRIPT_REQ A , PS_TRANSCRIPTREQLN C , PS_SCRTY_TSCRPT B WHERE B.INSTITUTION = A.INSTITUTION AND (B.TSCRPT_TYPE = A.TSCRPT_TYPE OR B.TSCRPT_TYPE= 'ALL') AND B.ACCESS_CD = 'Y' AND A.EMPLID = C.EMPLID AND A.TRANSCRIPT_SEQ_NO =C.TRANSCRIPT_SEQ_NO

  • Related Language Record for TCRPT_REQ_SECVW

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

    Prompt Table: PEOPLE_SRCH

    3 TRANSCRIPT_SEQ_NO Number(3,0) SMALLINT NOT NULL Transcript Seq No
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCRLONG Long Character CLOB Long Description