XML_PHYS_ESP_VW (SQL View)	Index Back
Physician Physician

XML_PHYS_ESP_VW

(SQL View)

Physician

SELECT A.EMPLID ,B.INCIDENT_DT , A.EMPL_RCD ,A.INCIDENT_NBR ,A.PHYSICIAN_NAME ,A.HOSPITAL ,A.ADDRESS1 ,A.PHONE ,A.MEDICAL_FAC_CD FROM PS_INJ_ILL_ADDR_VW A ,PS_XML_DLT_INJ_VW B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD AND A.INCIDENT_NBR=B.INCIDENT_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INCIDENT_DT Date(10) DATE Incident Date

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

5 PHYSICIAN_NAME Character(50) VARCHAR2(50) NOT NULL Physician Name

6 HOSPITAL Character(30) VARCHAR2(30) NOT NULL Hospital Name

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

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

9 MEDICAL_FAC_CD Character(4) VARCHAR2(4) NOT NULL Medical Facility

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	INCIDENT_DT	Date(10)	DATE	Incident Date
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
5	PHYSICIAN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Physician Name
6	HOSPITAL	Character(30)	VARCHAR2(30) NOT NULL	Hospital Name
7	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
9	MEDICAL_FAC_CD	Character(4)	VARCHAR2(4) NOT NULL	Medical Facility