GPDE_ELMATTR_VW

(SQL View)
 Index Back

List Set Element Attributes

List Set Element Attributes view for GP Germany, contains Information related to compensation certificate.

SELECT PAT.PIN_NUM , PAT.GP_ELN_ATTR1 ,PAT.GP_ELN_ATTR3 ,PAT.GP_ELN_ATTR6 FROM PS_GP_ELN_SET_ATTR SAT , PS_GP_ELN_PIN_ATTR PAT , PS_GP_ELEM_GRP_MBR EMB WHERE SAT.GP_ELN_SET = PAT.GP_ELN_SET AND SAT.EFFDT = PAT.EFFDT AND SAT.COUNTRY = 'DEU' AND SAT.COUNTRY = PAT.COUNTRY AND PAT.PIN_ELEM_GRP_NUM = EMB.PIN_NUM AND PAT.PIN_NUM = EMB.PIN_ELEM_NUM AND PAT.EFFDT = EMB.EFFDT AND SAT.EFFDT = ( SELECT MAX(SAT1.EFFDT) FROM PS_GP_ELN_SET_ATTR SAT1 WHERE SAT1.COUNTRY = SAT.COUNTRY )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 GP_ELN_ATTR1 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
3 GP_ELN_ATTR3 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
4 GP_ELN_ATTR6 Character(20) VARCHAR2(20) NOT NULL ELN Attribute