GVT_ECS_REM_LNG (SQL Table)	Index Back
GVT ECS Schedule Remarks Info Used to track the assigning and usage of the ECS Schedule Number Remarks by count for each Summary Schedule. Note that there are edits concerning the number entries on this table based on Schedule type Related Language record for GVT_ECS_REMARKS.

GVT_ECS_REM_LNG

(SQL Table)

GVT ECS Schedule Remarks Info

Used to track the assigning and usage of the ECS Schedule Number Remarks by count for each Summary Schedule. Note that there are edits concerning the number entries on this table based on Schedule type Related Language record for GVT_ECS_REMARKS.

Related Language Record for GVT_ECS_REMARKS

Parent record: GVT_ECS_CONTROL

# 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 GVT_ECS_REMARKS_NO Number(2,0) SMALLINT NOT NULL GVT ECS Remarks Line Number

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 GVT_ECS_REMARKS Character(72) VARCHAR2(72) NOT NULL Govt ECS Remarks

#	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	GVT_ECS_REMARKS_NO	Number(2,0)	SMALLINT NOT NULL	GVT ECS Remarks Line Number
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	GVT_ECS_REMARKS	Character(72)	VARCHAR2(72) NOT NULL	Govt ECS Remarks