GP_ABS_LVDNNM_V (SQL View)	Index Back
Abs Mgmt Leave Donation Name Abs Mgmt Leave Donation Name View used to retrieve names from Person Names in the PeopleSoft format to define Board Members.

GP_ABS_LVDNNM_V

(SQL View)

Abs Mgmt Leave Donation Name

Abs Mgmt Leave Donation Name View used to retrieve names from Person Names in the PeopleSoft format to define Board Members.

SELECT EMPLID ,NAME ,NAME_PSFORMAT FROM PS_PERSON_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 NAME_PSFORMAT Character(50) VARCHAR2(50) NOT NULL A Person's name in the Peoplesoft Format (basically LN,FN MI

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	NAME_PSFORMAT	Character(50)	VARCHAR2(50) NOT NULL	A Person's name in the Peoplesoft Format (basically LN,FN MI