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

PROPERTY_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 ,b.EFFDT ,a.DT_ISSUED ,a.DT_RETURNED ,c.MARKET_VALUE_MYS ,c.CURRENCY_CD ,c.LIFE_SPAN_MYS 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 MARKET_VALUE_MYS Number(19,6) DECIMAL(18,6) NOT NULL Market Value

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

7 LIFE_SPAN_MYS Number(3,0) SMALLINT NOT NULL Life Span (years)

#	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	MARKET_VALUE_MYS	Number(19,6)	DECIMAL(18,6) NOT NULL	Market Value
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	LIFE_SPAN_MYS	Number(3,0)	SMALLINT NOT NULL	Life Span (years)