GPBR_PCMP_FG_VW

(SQL View)
 Index Back

View Table - Company Flag eSoc

eSocial - View Table - Companies with Flag eSocial

SELECT A.COMPANY ,B.DESCR FROM PS_GPBR_C_PARM_SRC A , PS_COMPANY_TBL B , PS_GPBR_COMP_P_EFF C WHERE A.COMPANY = B.COMPANY AND C.COMPANY = B.COMPANY AND A.GPBR_ES_ADHERE = ( SELECT MAX(A2.GPBR_ES_ADHERE) FROM PS_GPBR_C_PARM_SRC A2 WHERE A.COMPANY = A2.COMPANY) AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_COMPANY_TBL B2 WHERE B2.COMPANY = B.COMPANY AND B2.EFFDT <= A.GPBR_ES_ADHERE)

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