GVT_SCHED_REF (SQL Table)	Index Back
Schedule Paycheck Reference Define Schedule Paycheck Reference

GVT_SCHED_REF

(SQL Table)

Schedule Paycheck Reference

Define Schedule Paycheck Reference

# 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_CHECK_REF_NO Number(4,0) SMALLINT NOT NULL Paycheck Reference Number

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

4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

5 PAY_END_DT Date(10) DATE Pay Period End Date

6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

#	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_CHECK_REF_NO	Number(4,0)	SMALLINT NOT NULL	Paycheck Reference Number
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
4	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
5	PAY_END_DT	Date(10)	DATE	Pay Period End Date
6	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?