RC_FGPY042_SCHD (SQL Table)	Index Back
Run Control - FGPY042 schedule This run control is for FGPY042 - select processing schedule sequence

RC_FGPY042_SCHD

(SQL Table)

Run Control - FGPY042 schedule

This run control is for FGPY042 - select processing schedule sequence

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

4 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

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

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	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.
4	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
5	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.
6	GVT_SPS_CNTRL_NUM	Character(7)	VARCHAR2(7) NOT NULL	Used to store Control Number for bulk payment file.
7	GVT_ECS_DOS_NAME	Character(8)	VARCHAR2(8) NOT NULL	DOS File Name
8	GVT_ECS_DOS_EXT	Character(3)	VARCHAR2(3) NOT NULL	DOS File Extension
9	GVT_EXT_NOTE	Character(90)	VARCHAR2(90) NOT NULL	SPS File Extract Note