HCR_PHYS_SRCH_I (SQL View)	Index Back
HS Physician Search Interf Vw Health Safety Physician Search Interface View

HCR_PHYS_SRCH_I

(SQL View)

HS Physician Search Interf Vw

Health Safety Physician Search Interface View

SELECT A.PHYSICIAN_ID , A.NAME FROM PS_PHYSICIAN_SRCH A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PHYSICIAN_ID Character(11) VARCHAR2(11) NOT NULL Physician ID
Default Value: 0

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PHYSICIAN_ID	Character(11)	VARCHAR2(11) NOT NULL	Physician ID Default Value: 0
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name