GVT_SCHED_REMKS (SQL Table)	Index Back
Schedule Remarks Define Schedule Remarks

GVT_SCHED_REMKS

(SQL Table)

Schedule Remarks

Define Schedule Remarks

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GVT_SCHED_PREFIX Character(10) VARCHAR2(10) NOT NULL Schedule Prefix represents user defined part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.

2 GVT_SCHED_CODE Character(1) VARCHAR2(1) NOT NULL Schedule Code identifies PeopleSoft supported schedules and it is middle part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.
A=PAMSALCHK
B=PAMSALEFT
C=PAMMISCHK
D=PAMMISEFT

3 GVT_ECS_REMARKS_NO Number(2,0) SMALLINT NOT NULL GVT ECS Remarks Line Number
Default Value: 1

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_SCHED_PREFIX	Character(10)	VARCHAR2(10) NOT NULL	Schedule Prefix represents user defined part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.
2	GVT_SCHED_CODE	Character(1)	VARCHAR2(1) NOT NULL	Schedule Code identifies PeopleSoft supported schedules and it is middle part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence. A=PAMSALCHK B=PAMSALEFT C=PAMMISCHK D=PAMMISEFT
3	GVT_ECS_REMARKS_NO	Number(2,0)	SMALLINT NOT NULL	GVT ECS Remarks Line Number Default Value: 1
4	GVT_ECS_REMARKS	Character(72)	VARCHAR2(72) NOT NULL	Govt ECS Remarks