USRPRF3CVWLNG

(SQL View)
Index Back

Communication Category Vw

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

SELECT DISTINCT C.OPRID , A.INSTITUTION , A.EVENT_3CS_ID , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_EVNT_3CS_LANG A , PS_EVNT_GRP_3C_TBL B , PS_OPR_GRP_3C_TBL C WHERE A.INSTITUTION = B.INSTITUTION AND A.EVENT_3CS_ID = B.EVENT_3CS_ID AND A.INSTITUTION = C.INSTITUTION AND B.GROUP_3C = C.GROUP_3C AND C.ENTRY_USE_IND = 'Y'

  • Related Language Record for USRPRF_3C_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPR_DEF_TBL_CS

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID

    Prompt Table: EVNT_3CS_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description