GVT_EXTPRCOPTVW (SQL View)	Index Back
PAM SPS system control PAM / SPS system control

GVT_EXTPRCOPTVW

(SQL View)

PAM SPS system control

PAM / SPS system control

SELECT fieldvalue , xlatlongname FROM XLATTABLE_VW WHERE eff_status = 'A' AND fieldname = 'GVT_EXT_PROC_OPTN' AND fieldvalue <> 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GVT_EXT_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Extract Pay Check Data Processing Option
E=Extract
R=Restart Extract
S=Assign Schedule Sequence

2 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_EXT_PROC_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Extract Pay Check Data Processing Option E=Extract R=Restart Extract S=Assign Schedule Sequence
2	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr