GVT_ECSM_LNG_VW

(SQL View)
Index Back

GVT ECS VENMIS Schedule View

Used to track the assigning and usage of the ECS Schedule Numbers. Related Language view for GVT_ECS_MISC_VW.

SELECT DISTINCT A.RUN_ID ,B.GVT_SCHEDULE_NO ,BL.LANGUAGE_CD ,BL.DESCR FROM PS_PAY_CALENDAR A, PS_GVT_ECS_CONTROL B, PS_GVT_ECS_CTL_LNG BL WHERE A.RUN_ID <> ' ' AND A.COMPANY = B.COMPANY AND B.GVT_ECS_TRANS_TYPE ='05' AND B.GVT_ECS_PYMNT_1 ='V' AND B.GVT_ECS_PYMNT_2 ='E' AND B.GVT_ECS_DOS_NAME = ' ' AND B.COMPANY = BL.COMPANY AND B.GVT_SCHEDULE_NO = BL.GVT_SCHEDULE_NO

  • Related Language Record for GVT_ECS_MISC_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description