RBI_XLAT_VW

(SQL View)
 Index Back

Translate Values for Insurance

Translate Values for Insurance

SELECT A.FIELDNAME , A.FIELD_VALUE , A.RBI_XLATLONGNAME , A.RBI_XLATSHORTNAME FROM PS_RBI_XLAT_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_RBI_XLAT_TBL B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELD_VALUE = B.FIELD_VALUE AND A.EFFDT = B.EFFDT AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: RBI_XLAT_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    2 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value
    3 RBI_XLATLONGNAME Character(50) VARCHAR2(50) NOT NULL This field is used for translate long values for insurance translate fields.
    4 RBI_XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name