GPFR_AED_EXT_VW

(SQL View)
 Index Back

AEDEMAT Extraction View

AEDEMAT Extraction View.

SELECT DISTINCT %TrimSubstr(A.GPFR_AF_CHAR_VAL,1,18) , ( SELECT DISTINCT B.GPFR_AF_NUM_VAL FROM PS_GPFR_AF_EXTRACT B WHERE 1 = 1 AND B.COUNTRY = A.COUNTRY AND B.GPFR_AF_APPL = A.GPFR_AF_APPL AND B.GPFR_AF_NODE_NAME = A.GPFR_AF_NODE_NAME AND B.GPFR_AF_EXTRACT_ID = A.GPFR_AF_EXTRACT_ID AND B.COMPANY = A.COMPANY AND B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.GPFR_AF_ATTR_NAME = '013.002' ) AS GPFR_AF_SEQ_NUM , A.COMPANY , A.EMPLID , A.EMPL_RCD FROM PS_GPFR_AF_EXTRACT A WHERE 1 = 1 AND A.COUNTRY = 'FRA' AND A.GPFR_AF_APPL = 'N4DS2011' AND A.GPFR_AF_NODE_SET = 'DN-AC' AND A.GPFR_AF_NODE_NAME = 'S20.G01.00' AND A.GPFR_AF_ATTR_NAME = '013.001'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 GPFR_AF_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence Number
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr