GVT_ECS_RUN_VW (SQL View)	Index Back
GVT ECS Run Control View Used to track the assigning and usage of the ECS Schedule Numbers.

GVT_ECS_RUN_VW

(SQL View)

GVT ECS Run Control View

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

SELECT DISTINCT B.COMPANY ,B.GVT_SCHEDULE_NO ,B.DESCR FROM PS_GVT_ECS_CONTROL B WHERE B.GVT_ECS_DOS_NAME = ' '

Related Language Record: GVT_ECSR_LNG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	GVT_SCHEDULE_NO	Character(14)	VARCHAR2(14) NOT NULL	Schedule Number
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description