One entity exists for each employee receiving financial aid during the
fiscal
year. The attributes include fiscal Year-to-Date totals by financial
aid
type (teaching assistant, research assistant, other) and source of funds
(federal, nonfederal). The data originates from the Employee Data Base (EDB).
| Field Name |
Business Name |
Data Type |
Description |
| FNA_ADC_CODE |
ADD/DELETE/CHANGE FLAG |
VARCHAR2(1) |
The code indicating the most recent update activity applied to
the
associated financial aid earnings entry (A=Add, D=Delete,
or C=Change) |
| FNA_EMPLOYEE_ID |
EMPLOYEE ID NUMBER |
VARCHAR2(9) |
The unique employee identification number |
| FNA_FISCAL_YEAR |
FISCAL YEAR |
NUMBER(5) |
The fiscal year of the associated financial aid earnings entry |
| FNA_OTH_FED_FYTD |
OTHER FEDERAL FISCAL YEAR-TO-DATE AMOUNT |
NUMBER(7,2) |
The fiscal year-to-date total of earnings other than work study,
research
assistance, or teaching assistant paid under federal funds
to an individual
classified as a student for purposes of financial aid |
| FNA_OTH_NONFD_FYTD |
OTHER NON-FEDERAL YEAR-TO-DATE AMOUNT |
NUMBER(7,2) |
The fiscal year-to-date total of earnings other than work study,
research
assistance, or teaching assistant paid under non-federal
funds to an individual
classified as a student for purposes of
financial aid |
| FNA_RA_FED_FYTD |
RESEARCH ASSISTANT FISCAL YEAR-TO-DATE AMOUNT |
NUMBER(7,2) |
The fiscal year-to-date total of research assistant earnings
paid under
federal funds to an individual classified as a student
for purposes of financial
aid |
| FNA_RA_NONFD_FYTD |
NON-FEDERAL RESEARCH ASSISTANT YEAR-TO-DATE AMOUNT |
NUMBER(7,2) |
The fiscal year-to-date total of research assistant earnings paid
under
non-federal funds to an individual classified as a student
for purposes of
financial aid |
| FNA_TA_FED_FYTD |
TEACHING ASSISTANT FISCAL YEAR-TO-DATE AMOUNT |
NUMBER(7,2) |
The fiscal year-to-date total of teaching assistant earnings paid
under
federal funds to an individual classified as a student for
purposes of financial
aid |
| FNA_TA_NONFD_FYTD |
NON-FEDERAL TEACHING ASSISTANT YEAR-TO-DATE AMOUNT |
NUMBER(7,2) |
The fiscal year-to-date total of teaching assistant earnings paid
under
non-federal funds to an individual classified as a student for
purposes of
financial aid |
