FINAID PAY DIST TYPE Table
A dimensional table for the Financial Aid Campus Work Star Schema. It contains the following data items: Payroll System (for either undergraduate or graduate students), Distribution Type (Undergraduate Timesheet, Graduate Appointment, Undergraduate Voucher, Adjustments, etc.), Personnel Rank (RA, TA, Instructor, etc.). Personnel Rank is not applicable to the undergraduate payroll system.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DISTRIBUTION_TYPE |
The types of student payroll distributions: Undergraduate Timesheet, Undergraduate Voucher, Graduate Appointment, Adjustment, etc. |
VARCHAR2 |
40 |
PAYROLL_SYSTEM |
The Undergraduate or Graduate Payroll System |
VARCHAR2 |
40 |
PAY_DIST_TYPE_KEY |
Key indentifying an entry in the FINAID PAY DIST TYPE table. This field should only be used for linking/joining tables together, NOT for reporting. |
VARCHAR2 |
6 |
PERSONNEL_RANK |
Rank of personnel associated with the Graduate Payroll. Valid values include: Research Assistant, Teaching Assistant, Instructor, Resident Tutor, and Unknown. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |