HR_COMMAINPH_VW (SQL View)	Index Back
Company Phone Table Company Phone Table

HR_COMMAINPH_VW

(SQL View)

Company Phone Table

SELECT A.COMPANY , A.COUNTRY_CODE , A.PHONE FROM PS_COMP_PHONE_TBL A WHERE A.PHONE_TYPE = 'MAIN' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_COMP_PHONE_TBL B WHERE B.COMPANY = A.COMPANY AND B.PHONE_TYPE = A.PHONE_TYPE AND B.EFFDT <= %CurrentDateIn )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
3	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone