GP_PI_BCD_VW (SQL View)	Index Back
PI Batch Code view This is a view to retreive Batch Code (DESC) from GP_PI_MNL_DATA

GP_PI_BCD_VW

(SQL View)

PI Batch Code view

This is a view to retreive Batch Code (DESC) from GP_PI_MNL_DATA

SELECT DISTINCT A.GP_PAYGROUP , A.CAL_ID , A.GP_BATCH_CD FROM PS_GP_PI_MNL_DATA A , PS_GP_PI_CAL_VW B WHERE GP_BATCH_CD <> ' ' AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

2 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

3 GP_BATCH_CD Character(10) VARCHAR2(10) NOT NULL The Batch Code will be used to identify a group of positive input.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
2	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
3	GP_BATCH_CD	Character(10)	VARCHAR2(10) NOT NULL	The Batch Code will be used to identify a group of positive input.