Data Fields

Preferred First Name
Select the preferred first name if it exists; otherwise, select first name.

Overview Tab
Field Name: FA_Preferred_First_Name
Description: Preferred First Name, else First Name
Folder Name: CM_Financial_Aid
Preview Value: Preferred First Name

Data Selection Tab
SQL Statement:
SELECT CASE WHEN SPBPERS_PREF_FIRST_NAME IS NOT NULL THEN SPBPERS_PREF_FIRST_NAME
ELSE SPRIDEN_FIRST_NAME
END
as pname
FROM SPBPERS, SPRIDEN
WHERE SPRIDEN_CHANGE_IND IS NULL
AND SPBPERS_PIDM = SPRIDEN_PIDM
AND SPBPERS_PIDM = :pidm

Formatting Tab
Format: $pname$

--

ROAMESG Title and Description

Overview Tab
Field Name: FA_ROAMESG
Description: RTVMESG Description and ROAMESG Description
Folder Name: CM_Financial_Aid
Preview Value: [ROAMESG]

Data Selection Tab
SQL Statement:
SELECT RORMESG_FULL_DESC RORMESG_DESC, RTVMESG_MESG_DESC RTVMESG_DESC
FROM RORMESG, RTVMESG
WHERE RORMESG_AIDY_CODE = :CM_aidyearcode
AND RORMESG_VPDI_CODE = 'XXX'
AND (RORMESG_FULL_DESC IS NOT NULL
OR RTVMESG_MESG_DESC IS NOT NULL)
AND RTVMESG_CODE = RORMESG_MESG_CODE
AND RTVMESG_VPDI_CODE = RORMESG_VPDI_CODE
AND TRUNC(RORMESG_ACTIVITY_DATE) >= TRUNC(SYSDATE-7)
AND TRUNC(RORMESG_ACTIVITY_DATE) <= TRUNC(SYSDATE)
AND RORMESG_PIDM = :pidm

Formatting Tab
Format:
<ul>
$rtvmesg_desc, rormesg_desc:{ d, r |
<li>$d$ $r$</li>
}$
</ul>