TRNSFRCOMFRVWLN

(SQL View)
 Index Back

Rltd Lang-Ext Trnsfer Eq Cmpnt

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

SELECT A.INSTITUTION ,A.TRNSFR_SRC_ID ,A.COMP_SUBJECT_AREA ,A.EFFDT ,B.SCHOOL_SUBJECT ,A.TRNSFR_EQVLNCY_CMP ,A.LANGUAGE_CD ,A.DESCR FROM PS_TRNSFR_COMP_LNG A , PS_TRNSFR_FROM B WHERE A.INSTITUTION = B.INSTITUTION AND A.TRNSFR_SRC_ID = B.TRNSFR_SRC_ID AND A.COMP_SUBJECT_AREA = B.COMP_SUBJECT_AREA AND A.EFFDT = B.EFFDT AND A.TRNSFR_EQVLNCY_CMP = B.TRNSFR_EQVLNCY_CMP AND B.TRNSFR_CMP_SEQ = ( SELECT MIN(C.TRNSFR_CMP_SEQ) FROM PS_TRNSFR_FROM C WHERE C.INSTITUTION = B.INSTITUTION AND C.TRNSFR_SRC_ID = B.TRNSFR_SRC_ID AND C.COMP_SUBJECT_AREA = B.COMP_SUBJECT_AREA AND C.EFFDT = B.EFFDT AND C.TRNSFR_EQVLNCY_CMP = B.TRNSFR_EQVLNCY_CMP)

  • Related Language Record for TRNSFR_COMFR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 TRNSFR_SRC_ID Character(11) VARCHAR2(11) NOT NULL Source ID
    3 COMP_SUBJECT_AREA Character(16) VARCHAR2(16) NOT NULL Component Subject Area
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject
    6 TRNSFR_EQVLNCY_CMP Character(4) VARCHAR2(4) NOT NULL Equiv Component
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description