SPORIGINCLSVWLN

(SQL View)
Index Back

Rel Origins View Class scty

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

SELECT DISTINCT B.BUSINESS_UNIT , A.ORIGIN_ID , B.OPRCLASS , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_ORIGIN_LNG A , PS_SEC_ORIGIN_CLS B , PS_SET_CNTRL_REC C WHERE B.ORIGIN_ID = A.ORIGIN_ID AND B.ACCESS_CD = 'Y' AND C.SETID = A.SETID AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.RECNAME = 'ORIGIN_TBL'

  • Related Language Record for SP_ORIGIN_CLSVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Origin ID

    Prompt Table: ORIGIN_TBL

    3 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    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