UDSFS_EE0070

Context

Reusable equation to maintain parent email addresses for automated PeopleSoft communications. 

Highlights

  • Intended to be used with the AY_ACTIVE_DISB_EVEN / _ODD tree nodes.
  • Uses callable SQL UDSFS_SI0005 to insert new "Plus" email address into the email address table.
  • Uses callable SQL UDSFS_SU0064 to update "Plus" email address.

Equation Logic

Line Number Keyword Operand Type Operand
1 Skip       
2 Skip       
3 Skip       
4 Skip       
5 Skip       
6 Message String Running UDSFS_EE0070
7 End Message  
8 Skip    
9 If    
10 Exists Global Variable PRM_TREE_NODE
11 Then    
12 Message String Using Node
13   Global Variable PRM_TREE_NODE
14 End Message  
15 Else    
16 Message String Terminating: No node provided
17 End Message  
18 Return    
19 End If    
20 Assign Global Variable PRM_TREE_NAME
21   String UD_FA_AID_YEAR
22 End Assign  
23 Assign Global Variable PRM_TREE_LEAF
24   String 2001
25 End Assign  
26 Call Equation UDSFS_LEAF
27 If    
28   Global Variable PRM_TREE_LEAF
29 =    
30   String 2001
31 Then    
32 Message String Terminating: No active aid year
33 End Message  
34 Return    
35 Else    
36 Assign Local Variable USE_AID_YEAR
37   Global Variable PRM_TREE_LEAF
38 End Assign  
39 Message String Using Aid Year
40   Local Variable USE_AID_YEAR
41 End Message  
42 End If    
43 Assign Local Variable USE_E_ADDR_TYPE_PARENT
44   String PLUS
45 End Assign  
46 Message String Using Parent Email Addr
47   Local Variable USE_E_ADDR_TYPE_PARENT
48 End Message  
49 Skip    
50 Message String +++Inserting PLUS rows...
51 End Message  
52 Assign Local Variable SI_RET_CODE
53   Number 0
54 End Assign  
55 Assign Local Variable SI_ROW_COUNT
56   Number 0
57 End Assign  
58 Call SQL UDSFS_SI0005
59 Call Parms  
60   Local Variable SI_RET_CODE
61   Local Variable SI_ROW_COUNT
62   Local Variable USE_AID_YEAR
63   Local Variable USE_E_ADDR_TYPE_PARENT
64 End Call Parms  
65 Message String Ins Status:
66   Local Variable SI_RET_CODE
67   String Ins Count:
68   Local Variable SI_ROW_COUNT
69 End Message  
70 Assign Global Variable PRM_RESULT
71   Local Variable SI_ROW_COUNT
72 End Assign  
73 Skip    
74 Message String +++Updating existing rows...
75 End Message  
76 Assign Local Variable SU_RET_CODE
77   Number 0
78 End Assign  
79 Assign Local Variable SU_ROW_COUNT
80   Number 0
81 End Assign  
82 Call SQL UDSFS_SU0064
83 Call Parms  
84   Local Variable SU_RET_CODE
85   Local Variable SU_ROW_COUNT
86   Local Variable USE_AID_YEAR
87   Local Variable USE_E_ADDR_TYPE_PARENT
88 End Call Parms  
89 Message String Upd Status:
90   Local Variable SU_RET_CODE
91   String Upd Count:
92   Local Variable SU_ROW_COUNT
93 End Message  
94 Assign Global Variable PRM_RESULT
95   Global Variable PRM_RESULT
96 +    
97   Local Variable SU_ROW_COUNT
98 End Assign  
99 Message Global Variable PRM_RESULT
100   String Rows Maintained
101 End Message  
102 Return    

 

 

 

Print Article