GVT_ANN_IND_VW

(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.EFFDT ,A.EFF_STATUS ,A.XLATLONGNAME ,A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'GVT_ANN_IND' AND A.FIELDVALUE NOT IN('M','N','P','W','X','Y')

  • Related Language Record: GVT_ANNUITY_LNG

    • # 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
    M=Former FERS Phased Retiree
    N=FERS Phased Retiree Officer
    P=Phased Ret/Former Enlisted FE
    W=Phased Retiree/Former CS
    X=CSRS Phased Retiree Officer
    Y=Phased Ret/Former Enlisted CS
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name