GVT_ANNUITY_LNG

(SQL View)
 Index Back

GVT Annuity Indic Value View

To override the default way XLAT values are displayed for selection from prompt values.

SELECT %Substring(A.FIELDVALUE,1,1) ,A.LANGUAGE_CD ,A.EFFDT ,A.XLATLONGNAME ,A.XLATSHORTNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'GVT_ANN_IND'

  • Related Language Record for GVT_ANNUITY_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_ANN_IND Character(1) VARCHAR2(1) NOT NULL Annuitant Indicator
    1=Reempl Ann-CS
    2=Ret Officer
    3=Ret Enlisted
    4=Ret Off/Reempl Ann-CS
    5=Ret Enl/Reempl Ann-CS
    6=CS-No Reduction
    7=Ret Off/CS-No Reduc
    8=Ret Enl/CS-No Reduc
    9=Not Applicable
    A=Reempl Ann-FE
    B=Former Ann-FE
    C=Ret Off/Reempl Ann-FE
    D=Ret Off/Former Ann-FE
    E=Ret Enl/Reempl Ann-FE
    F=Ret Enl/Former Ann-FE
    G=FE - No Reduction
    H=Ret Off/FE-No Reduc
    J=Ret Enl/FE-No Reduc
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name