GVT_RTND_PP_VW

(SQL View)
 Index Back

Retained Ern Program View

Table is used to retrieve the Hourly Conversion Factor and Locality, Leo, IGA, Premium Pay. Auto Wig, Sal Step Type based on Retained Earnings Program.

SELECT DISTINCT A.GVT_PAY_PLAN , A.EFFDT , A.DESCR , A.DESCRSHORT FROM PS_GVT_PAY_PLAN A

  • Parent record: ERN_PROGRAM_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_RTND_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description