GP_CANCEL_WRK (SQL Table)	Index Back
Work table for apprvd segs Temporary table used to hold subset of records in GP_PYE_SEG_STAT that are approved. Needed in place of subselect against GP_PYE_SEG_STAT for statements in GPPCANCL that updates same table. Works in all other environments

GP_CANCEL_WRK

(SQL Table)

Work table for apprvd segs

Temporary table used to hold subset of records in GP_PYE_SEG_STAT that are approved. Needed in place of subselect against GP_PYE_SEG_STAT for statements in GPPCANCL that updates same table. Works in all other environments

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id