GVT_DIS_PUSH_VW (SQL View)	Index Back
GVT DISABLED Push View Used to push GVT Disablilty information to the PS_DISABILITY table. As of Rel 8.0 had to use quote enclosed variables to make the push work. The field types in the new subrecords and we are using 'txt', '0', 'txt' to make the push happen in the last three fields.

GVT_DIS_PUSH_VW

(SQL View)

GVT DISABLED Push View

Used to push GVT Disablilty information to the PS_DISABILITY table. As of Rel 8.0 had to use quote enclosed variables to make the push work. The field types in the new subrecords and we are using 'txt', '0', 'txt' to make the push happen in the last three fields.

SELECT A.EMPLID , A.DISABLED , %subrec(DISABL_USA_SBR,A) FROM PS_GVT_DISABILITY A , PS_GVT_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EMPL_RCD = 0 AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND B.GVT_STATUS_TYPE IN ('COR', 'COM') AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_GVT_JOB BB WHERE BB.EMPLID = B.EMPLID AND BB.EMPL_RCD = B.EMPL_RCD AND BB.EFFDT <= %CurrentDateIn AND BB.GVT_STATUS_TYPE IN ('COR', 'COM')) AND B.EFFSEQ = ( SELECT MAX(BBB.EFFSEQ) FROM PS_GVT_JOB BBB WHERE BBB.EMPLID = B.EMPLID AND BBB.EMPL_RCD = B.EMPL_RCD AND BBB.EFFDT = B.EFFDT AND BBB.GVT_STATUS_TYPE IN ('COM', 'COR'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

3 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran
Y/N Table Edit
Default Value: N

4 DISABILITY_STS_USA Character(1) VARCHAR2(1) NOT NULL Disability (Section 503) Status USA
N=Not Disabled
X=Not Indicated
Y=Disabled

5 HR_EE_SIGNATURE Character(75) VARCHAR2(75) NOT NULL Employee Signature

6 HR_DISCLOSURE_DT Date(10) DATE Disclosure Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled.
3	DISABLED_VET	Character(1)	VARCHAR2(1) NOT NULL	Disabled Veteran Y/N Table Edit Default Value: N
4	DISABILITY_STS_USA	Character(1)	VARCHAR2(1) NOT NULL	Disability (Section 503) Status USA N=Not Disabled X=Not Indicated Y=Disabled
5	HR_EE_SIGNATURE	Character(75)	VARCHAR2(75) NOT NULL	Employee Signature
6	HR_DISCLOSURE_DT	Date(10)	DATE	Disclosure Date