GPES_AUTH_CMPVW

(SQL View)
 Index Back

Social Security Header Setup

Social Security Header Setup.

SELECT DISTINCT B.SOCS_AUTH_KEY_ESP , C.GPES_YEAR , C.GPES_MONTH , B.COMPANY , A.DESCR FROM PS_SOCS_SETHD_ESP B , PS_GPES_CRT_CMP_VW C , PS_GPES_SYS_CALEND D , PS_COMPANY_TBL A WHERE B.COMPANY = C.COMPANY AND C.GPES_YEAR = D.CALYEAR AND C.GPES_MONTH = D.GPES_MONTH AND B.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_SOCS_SETHD_ESP ED WHERE ED.COMPANY = B.COMPANY AND ED.EFFDT <= D.GPES_MONTH_BGN_DT) AND B.COMPANY = A.COMPANY AND A.EFFDT = ( SELECT MAX(ED1.EFFDT) FROM PS_COMPANY_TBL ED1 WHERE ED1.COMPANY = A.COMPANY AND ED1.EFFDT <= D.GPES_MONTH_BGN_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOCS_AUTH_KEY_ESP Character(8) VARCHAR2(8) NOT NULL Authorization Key
2 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
3 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description