PAID Table
View exposing paid payroll distribution assignments by person, cost collector, general ledger account, fiscal month, and distribution start and end dates.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DISTRIBUTION_END_DATE |
Date associated with distribution end. |
DATE |
|
DISTRIBUTION_START_DATE |
Date associated with distribution start. |
DATE |
|
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |