GVT_SCHDDEFNVW3 (SQL View)	Index Back
Schedule Definition Schedule Definition with Process Statuses "Initial" and "Pay Check Data Extracted"

GVT_SCHDDEFNVW3

(SQL View)

Schedule Definition

Schedule Definition with Process Statuses "Initial" and "Pay Check Data Extracted"

SELECT RUN_ID , GVT_SCHED_PREFIX , DESCR , GVT_SUMM_SCHED , COMPANY FROM PS_GVT_SCHED_DEFN WHERE GVT_SCHED_STATUS IN ('0', '1')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

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

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