RETRODED_ERN_VW

(SQL View)
 Index Back

RetroDed by Emplid VW


SELECT M.RETRODED_SEQ_NO , P.EMPL_RCD FROM PS_RETRODED_MSG M , PS_PAY_LINE P WHERE M.COMPANY <> ' ' AND M.COMPANY = P.COMPANY AND M.PAYGROUP = P.PAYGROUP AND M.PAY_END_DT = P.PAY_END_DT AND M.OFF_CYCLE = P.OFF_CYCLE AND M.PAGE_NUM = P.PAGE_NUM AND M.LINE_NUM = P.LINE_NUM UNION SELECT M.RETRODED_SEQ_NO , R.EMPL_RCD FROM PS_RETRODED_MSG M , PS_RETRODED_RQST R WHERE M.COMPANY = ' ' AND M.RETRODED_SEQ_NO = R.RETRODED_SEQ_NO AND R.RETRODED_RQST_TYPE IN ('G', 'J', 'M', 'A') UNION SELECT M.RETRODED_SEQ_NO , O.EMPL_RCD FROM PS_RETRODED_MSG M , PS_RETRODED_RQST R , PS_PER_ORG_ASGN O WHERE M.COMPANY = ' ' AND M.RETRODED_SEQ_NO = R.RETRODED_SEQ_NO AND R.RETRODED_RQST_TYPE IN ('B', 'P') AND R.EMPLID = O.EMPLID AND R.EMPL_RCD = O.BENEFIT_RCD_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RETRODED_SEQ_NO Character(8) VARCHAR2(8) NOT NULL Retro Ded Sequence Number
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record