GVT_ECS_CHK_VW

(SQL View)
 Index Back

GVT ECS Check Schedule View

Used to track the assigning and usage of the ECS Schedule Numbers.

SELECT DISTINCT A.RUN_ID ,B.GVT_SCHEDULE_NO ,B.DESCR FROM PS_PAY_CALENDAR A, PS_GVT_ECS_CONTROL B WHERE A.RUN_ID <> ' ' AND A.COMPANY = B.COMPANY AND B.GVT_ECS_TRANS_TYPE ='05' AND B.GVT_ECS_PYMNT_1 ='S' AND B.GVT_ECS_PYMNT_2 ='C' AND B.GVT_ECS_DOS_NAME = ' '

  • Related Language Record: GVT_ECSW_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
    2 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description