CNTCT_PHONE_VW (SQL View)	Index Back
Contact Phone Uses the POSITION_PHONE from WORKER.

CNTCT_PHONE_VW

(SQL View)

Contact Phone

Uses the POSITION_PHONE from WORKER.

SELECT EMPLID ,POSITION_PHONE FROM PS_PER_ORG_ASGN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: PERSON_NAME

2 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: PERSON_NAME
2	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone