PAYING Table
View exposing payroll paying-distribution assignments by person, cost collector, general ledger account, percent distribution, and effective 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 |
PAY_DIST_PERCENT |
Pay dist percent associated with the record. |
NUMBER |
5,2 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |