GP_RUN_TYPE_VW

(SQL View)
 Index Back

Run Type-Prompt View

This is the prompt view used to select Run Type. It is used on the Calendar pages. Only Run Types where Country of Process PIN is same as Country of Calendar (Paygroup) or where country =ALL are shown for a given calendar.

SELECT D.COUNTRY , A.RUN_TYPE , B.EFFDT , B.EFF_STATUS , A.DESCR , C.COUNTRY FROM PS_GP_RUN_TYPE A , PS_GP_RUN_TYPE_DTL B , PS_GP_PIN C , PS_GP_COUNTRY D WHERE A.RUN_TYPE=B.RUN_TYPE AND B.PIN_PRC_NUM=C.PIN_NUM AND (C.COUNTRY=D.COUNTRY OR C.COUNTRY='ALL')

  • Related Language Record: GP_RUN_TYPE_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code