GVT_PAM_USER_DT (SQL Table)	Index Back
PAM SPS user defined data PAM / SPS user defined data

GVT_PAM_USER_DT

(SQL Table)

PAM SPS user defined data

PAM / SPS user defined data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 GVT_INPUT_SYSTEM Character(40) VARCHAR2(40) NOT NULL Input System (Agency ID + Payment Type 1 + Payment Type 2)

3 GVT_LAST_FILE_SEQ Number(4,0) SMALLINT NOT NULL Last File Sequence No to be used as part of the bulk file name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	GVT_INPUT_SYSTEM	Character(40)	VARCHAR2(40) NOT NULL	Input System (Agency ID + Payment Type 1 + Payment Type 2)
3	GVT_LAST_FILE_SEQ	Number(4,0)	SMALLINT NOT NULL	Last File Sequence No to be used as part of the bulk file name