GVT_SCHDCNTRLVW (SQL View)	Index Back
Schedule Control View Schedule Control View

GVT_SCHDCNTRLVW

(SQL View)

Schedule Control View

SELECT B.GVT_SCHED_PREFIX , B.GVT_SCHED_CODE , B.GVT_SCHED_SEQ , B.GVT_SPS_CNTRL_NUM , A.GVT_SUMM_SCHED , A.RUN_ID , A.COMPANY , A.GVT_SCHED_STATUS , '' , '' , '' FROM PS_GVT_SCHED_DEFN A , ps_gvt_sched_cntrl B WHERE B.GVT_SCHED_PREFIX = A.GVT_SCHED_PREFIX AND B.GVT_TOTAL_AMT > 0

# 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_SCHED_SEQ Number(3,0) SMALLINT NOT NULL Schedule Sequence represents last part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence. Schedule may have multiple schedule sequences in case there is a schedule split due to processing requirements such as max TAS BETC amount or max number of TAS BETC per schedule.

4 GVT_SPS_CNTRL_NUM Character(7) VARCHAR2(7) NOT NULL Used to store Control Number for bulk payment file.

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

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

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

8 GVT_SCHED_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Process Status
0=Initial
1=Pay Check Data Extracted
2=Schedule Sequence Generated
3=Bulk File Generated
4=SPS File Generated
5=Completed
Default Value: 0

9 GVT_ECS_DOS_NAME Character(8) VARCHAR2(8) NOT NULL DOS File Name

10 GVT_ECS_DOS_EXT Character(3) VARCHAR2(3) NOT NULL DOS File Extension

11 GVT_EXT_NOTE Character(90) VARCHAR2(90) NOT NULL SPS File Extract Note

#	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_SCHED_SEQ	Number(3,0)	SMALLINT NOT NULL	Schedule Sequence represents last part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence. Schedule may have multiple schedule sequences in case there is a schedule split due to processing requirements such as max TAS BETC amount or max number of TAS BETC per schedule.
4	GVT_SPS_CNTRL_NUM	Character(7)	VARCHAR2(7) NOT NULL	Used to store Control Number for bulk payment file.
5	GVT_SUMM_SCHED	Character(1)	VARCHAR2(1) NOT NULL	Summary Schedule Y/N Table Edit
6	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
7	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
8	GVT_SCHED_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Process Status 0=Initial 1=Pay Check Data Extracted 2=Schedule Sequence Generated 3=Bulk File Generated 4=SPS File Generated 5=Completed Default Value: 0
9	GVT_ECS_DOS_NAME	Character(8)	VARCHAR2(8) NOT NULL	DOS File Name
10	GVT_ECS_DOS_EXT	Character(3)	VARCHAR2(3) NOT NULL	DOS File Extension
11	GVT_EXT_NOTE	Character(90)	VARCHAR2(90) NOT NULL	SPS File Extract Note