GVT_ECS_REELS (SQL Table)	Index Back
GVT ECS Schedule Reel No Info Used to track the assigning and usage of the ECS Schedule Number Rel Numbers by count for each Summary Schedule. Note that there are edits concerning the number entries on this table based on Schedule type

GVT_ECS_REELS

(SQL Table)

GVT ECS Schedule Reel No Info

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

Parent record: GVT_ECS_CONTROL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number
Prompt Table: GVT_ECS_CONTROL

3 GVT_ECS_REEL_LINE Number(1,0) SMALLINT NOT NULL GVT ECS Reel Line Number
Default Value: 1

4 GVT_ECS_REEL_NO Character(7) VARCHAR2(7) NOT NULL Govt ECS Reel Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	GVT_SCHEDULE_NO	Character(14)	VARCHAR2(14) NOT NULL	Schedule Number Prompt Table: GVT_ECS_CONTROL
3	GVT_ECS_REEL_LINE	Number(1,0)	SMALLINT NOT NULL	GVT ECS Reel Line Number Default Value: 1
4	GVT_ECS_REEL_NO	Character(7)	VARCHAR2(7) NOT NULL	Govt ECS Reel Number