GVT_ACCR_SRCH (SQL View)	Index Back
Accrual Adjustments Search Rcd SELECT A.EMPLID, A.EMPL_RCD#, A.EFFDT, A.GVT_ERN_ACCR_CLASS, B.NAME, B.LAST_NAME_SRCH FROM PS_GVT_ACCR_SUMM A, PS_PERSONAL_DATA B WHERE A.EMPLID = B.EMPLID AND (A.EFFDT >= %CURRENTDATEIN OR (A.EFFDT = (SELECT MAX(A2.EFFDT) FROM PS_GVT_ACCR_SUMM A2 WHERE A.EMPLID = A2.EMPLID AND A.EMPL_RCD# = A2.EMPL_RCD# AND A2.EFFDT <= %CURRENTDATEIN)))

GVT_ACCR_SRCH

(SQL View)

Accrual Adjustments Search Rcd

SELECT A.EMPLID, A.EMPL_RCD#, A.EFFDT, A.GVT_ERN_ACCR_CLASS, B.NAME, B.LAST_NAME_SRCH FROM PS_GVT_ACCR_SUMM A, PS_PERSONAL_DATA B WHERE A.EMPLID = B.EMPLID AND (A.EFFDT >= %CURRENTDATEIN OR (A.EFFDT = (SELECT MAX(A2.EFFDT) FROM PS_GVT_ACCR_SUMM A2 WHERE A.EMPLID = A2.EMPLID AND A.EMPL_RCD# = A2.EMPL_RCD# AND A2.EFFDT <= %CURRENTDATEIN)))

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.GVT_ERN_ACCR_CLASS , B.NAME , B.LAST_NAME_SRCH FROM PS_GVT_ACCR_SUMM A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 EFFDT Date(10) DATE Effective Date

4 GVT_ERN_ACCR_CLASS Character(6) VARCHAR2(6) NOT NULL Earnings Accrual Class
Prompt Table: GVT_ERN_ACR_CLS

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE	Effective Date
4	GVT_ERN_ACCR_CLASS	Character(6)	VARCHAR2(6) NOT NULL	Earnings Accrual Class Prompt Table: GVT_ERN_ACR_CLS
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name