COMM_FLOANA_FLP_E / _O

The following article documents even/odd year run controls used in automated communication processing to send FLP emails.

Context:

The following article documents the COMM_FLOANA_FLP_E & COMM_FLOANA_FLP_O run controls used in automated communication processing to send FLP emails.

Screenshots:

 

Queries:

• UDSFS1_PS_CG_DISB_ITM_E
• UDSFS1_PS_CG_DISB_ITM_O
   

Query SQL:

SELECT A.COMMON_ID, A.SA_ID_TYPE
  FROM PS_SCC_CG_PER_BIND A, PS_COMMUNICATION B, PS_VAR_DATA_AWRD C, PS_STDNT_AID_ATRBT D
  WHERE ( A.COMMON_ID = B.COMMON_ID
     AND B.SCC_LETTER_CD = :1
     AND B.COMPLETED_COMM <> 'Y'
     AND B.COMMON_ID = C.COMMON_ID
     AND C.VAR_DATA_SEQ = B.VAR_DATA_SEQ
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 C3_5 WHERE  C3_5.SELECTOR_NUM=1136 AND C.AID_YEAR=C3_5.RANGE_FROM_04 AND C3_5.TREE_NODE_NUM BETWEEN 1999267577 AND 1999389646)
     AND D.INSTITUTION = B.INSTITUTION
     AND D.AID_YEAR = C.AID_YEAR
     AND D.EMPLID = C.COMMON_ID
     AND D.AID_APP_STATUS <> 'C')