PAYMENT_PER_VW (SQL View)	Index Back
Payment View This is a view used as a prompt for Payment ID Number in COMM_VAR_DATA. Emplid is the primary key.

PAYMENT_PER_VW

(SQL View)

Payment View

This is a view used as a prompt for Payment ID Number in COMM_VAR_DATA. Emplid is the primary key.

SELECT COMMON_ID , COMMON_ID , BUSINESS_UNIT , PAYMENT_ID_NBR FROM PS_PAYMENT_TBL WHERE SA_ID_TYPE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

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

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	PAYMENT_ID_NBR	Number(12,0)	DECIMAL(12) NOT NULL	Payment ID Nbr