Return to Navigation

Viewing Sample Equations

This section discusses the syntax of sample equations delivered by Oracle.

You can view any equation that Oracle delivers on the Equation Editor page select (Set Up SACR, then select Common Definitions, then select Equation Engine, then select Equation Editor).

This is a loan validation edit that checks whether the borrower has been defined on the loan origination table.

Line Number

Equation Keyword

Operand Type

Operand

Comment

1

SKIP

    

Borrower Missing

2

ASSIGN

Local Variable

EQUATION_NAME

  

3

  

String

FACRBORROW01

  

4

END ASSIGN

      

5

CALL

Equation

FACEDGETDEST

  

6

CALL PARMS

      

7

  

Local Variable

EQUATION_NAME

  

8

END CALL PARMS

      

9

IF

      

10

  

Global Variable

DEST_ACTV

  

11

<>

      

12

  

String

Y

Edit not active

13

THEN

      

14

RETURN

      

15

END IF

      

16

IF

      

17

  

Table

LOAN_ORIGNATN

  

18

  

Field

BORR_EMPLID

  

19

=

      

20

  

String

    

21

THEN

      

22

CALL

Equation

FACEDLOGERR

  

23

CALL PARMS

      

24

  

Local Variable

EQUATION_NAME

  

25

END CALL PARMS

      

26

END IF

      

27

RETURN

      

This is a hold/release demonstration equation to verify satisfactory academic progress for a student.

Line Number

Equation Keyword

Operand Type

Operand

Comment

1

SKIP

    

Satisfactory Academic Progress Check

2

FIND FIRST

Local Variable

FOUND_STDNT_AID_ATRBT

  

3

  

Table

STDNT_AID_ATRBT

  

4

  

Keyed Global Equal

EMPLID

  

5

  

Keyed Global Equal

INSTITUTION

  

6

  

Keyed Global Equal

AID_YEAR

  

7

  

Keyed Global Equal

TABLE_ID

  

8

END FIND

      

9

IF

      

10

NOT

      

11

  

Local Variable

FOUND_STDNT_AID_ATRBT

  

12

Then

      

13

Message

String

No row in STDNT_AID_ATRBT

  

14

  

String

for key values

  

15

  

Global Variables

EMPLID

  

16

  

Global Variable

INSTITUTION

  

17

  

Global Variable

AID_YEAR

  

18

  

Global Variable

TABLE_ID

  

19

END MESSAGE

      

20

ASSIGN

Global Variable

RESULT

  

21

  

String

FAILED

  

22

END ASSIGN

      

23

ASSIGN

Global Variable

HR_MSG_SET_NBR

  

24

  

String

14432

  

25

END ASSIGN

      

26

ASSIGN

Global Variable

HR_MSG_NBR

  

27

  

String

00001

  

28

END ASSIGN

      

29

RETURN

      

30

END IF

      

31

IF

      

32

  

Table

STDNT_AID_ATRBT

  

33

  

Field

SAT_ACADEMIC_PRG

  

34

=

      

35

  

Prompted Value

Y

  

36

OR

      

37

  

Table

STDNT_AID_ATRBT

  

38

  

Field

SAT_ACADEMIC_PRG

  

39

=

      

40

  

Prompted Value

P

  

41

THEN

      

42

ASSIGN

Global Variable

RESULT

  

43

  

String

PASS

  

44

END ASSIGN

      

45

ELSE

      

46

ASSIGN

Global Variable

HR_MSG_SET_NBR

  

47

  

String

14432

  

48

END ASSIGN

      

49

ASSIGN

Global Variable

HR_MSG_NBR

  

50

  

String

00002

  

51

END ASSIGN

      

52

ASSIGN

Global Variable

RESULT

  

53

  

String

FAILED

  

54

END ASSIGN

      

55

END IF

      

This is a packaging selection equation that checks for undergraduate status.

Line Number

Equation Keyword

Operand Type

Operand

Comment

1

IF

      

2

  

Global Variable

ACAD_CAREER

  

3

=

      

4

  

String

UGRD

  

5

THEN

      

6

ASSIGN

Global Variable

A_SELECT

  

7

  

String

T

  

8

END ASSIGN

      

9

ELSE

      

10

ASSIGN

Global Variable

A_SELECT

  

11

  

String

F

  

12

END ASSIGN

      

13

END IF