GPFR_DISBLTY_VW (SQL View)	Index Back
Disability FRA Disability data with calculated BOETH_STATUS upon BOETH_STATUS calculation rules.

GPFR_DISBLTY_VW

(SQL View)

Disability FRA

Disability data with calculated BOETH_STATUS upon BOETH_STATUS calculation rules.

SELECT DS.EMPLID , DS.DIS_BEGIN_DT_FRA , BO.BOETH_STATUS , DS.SUPP_PUBLIC_DEVICE FROM PS_DISABILITY_FRA DS , PS_DISABL_TRGR_FRA BO WHERE DS.EMPLID = BO.EMPLID AND BO.EFFDT = ( SELECT MAX(BO2.EFFDT) FROM PS_DISABL_TRGR_FRA BO2 WHERE BO2.EMPLID = BO.EMPLID AND BO2.EFFDT <= DS.DIS_BEGIN_DT_FRA)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DIS_BEGIN_DT_FRA Date(10) DATE NOT NULL Disability Begin Date
Default Value: %Date

3 BOETH_STATUS Character(3) VARCHAR2(3) NOT NULL BOETH Status

4 SUPP_PUBLIC_DEVICE Character(3) VARCHAR2(3) NOT NULL Supplement of Public Device

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DIS_BEGIN_DT_FRA	Date(10)	DATE NOT NULL	Disability Begin Date Default Value: %Date
3	BOETH_STATUS	Character(3)	VARCHAR2(3) NOT NULL	BOETH Status
4	SUPP_PUBLIC_DEVICE	Character(3)	VARCHAR2(3) NOT NULL	Supplement of Public Device