MOTORCAR_MYS_VW (SQL View)	Index Back
Company Property Benefits This view contains company property which is considered a Benefit in Kind for the employee

MOTORCAR_MYS_VW

(SQL View)

Company Property Benefits

This view contains company property which is considered a Benefit in Kind for the employee

SELECT a.EMPLID ,c.EFFDT ,a.DT_ISSUED ,a.DT_RETURNED ,c.PURCHASE_DATE_MYS ,c.PURCHASE_PRICE_MYS ,c.CURRENCY_CD FROM PS_COMP_PROP a , PS_COMP_PROP_TBL b , PS_COMP_PROP_MYS c WHERE a.PROPERTY_ID = b.PROPERTY_ID AND a.PROPERTY_ID = c.PROPERTY_ID AND b.EFFDT = c.EFFDT AND c.BENEFIT_MYS = 'Y' AND b.PROPERTY_CTGY = 'VE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 DT_ISSUED Date(10) DATE Issue Date

4 DT_RETURNED Date(10) DATE Date Returned

5 PURCHASE_DATE_MYS Date(10) DATE Purchase Date

6 PURCHASE_PRICE_MYS Number(19,6) DECIMAL(18,6) NOT NULL Purchase Price

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DT_ISSUED	Date(10)	DATE	Issue Date
4	DT_RETURNED	Date(10)	DATE	Date Returned
5	PURCHASE_DATE_MYS	Date(10)	DATE	Purchase Date
6	PURCHASE_PRICE_MYS	Number(19,6)	DECIMAL(18,6) NOT NULL	Purchase Price
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code