GVT_TSP_ADJ_SCH

(SQL View)
Index Back

Search EE on TSP Adjustments


SELECT A.COMPANY ,B.EMPLID ,B.EMPL_RCD ,B.NAME ,A.PAYGROUP FROM PS_GVT_JOB A ,PS_GVT_TSP_01_HIST B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GVT_JOB A1 WHERE A1.EMPLID=A.EMPLID AND A1.EMPL_RCD=A.EMPL_RCD AND A1.EFFDT<=%CurrentDateIn) AND A.GVT_STATUS_TYPE IN ('COM','COR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Default Value: INSTALLATION.COMPANY

Prompt Table: GVT_INTRFC_INFO

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group