GVT_SCHDDEFNVW2 (SQL View)	Index Back
Schedule Definition Schedule Definition with Process Statuses "Bulk File generated" and "Summary File Generated"

GVT_SCHDDEFNVW2

(SQL View)

Schedule Definition

Schedule Definition with Process Statuses "Bulk File generated" and "Summary File Generated"

SELECT GVT_SCHED_PREFIX , DESCR , GVT_SUMM_SCHED , RUN_ID , COMPANY FROM PS_GVT_SCHED_DEFN WHERE GVT_SCHED_STATUS = '3'

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 GVT_SUMM_SCHED Character(1) VARCHAR2(1) NOT NULL Summary Schedule
Y/N Table Edit

4 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

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

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	GVT_SUMM_SCHED	Character(1)	VARCHAR2(1) NOT NULL	Summary Schedule Y/N Table Edit
4	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL