PAYROLL QTRLY FYTD FTE IR Table
This view is for Institutional Research (IR) users, it is based on aggregate computed from the salary distribution transactions table (eDACCA) and normalized to 40hrs per week for all paid person.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_CATEGORY_CODE |
The group of cost object (research, general...). |
VARCHAR2 |
5 |
COST_COLLECTOR_KEY |
The cost object where the salary charge is made. |
VARCHAR2 |
12 |
COST_COLLECTOR_TYPE_CODE |
The type of cost object (cost center, internal order, project wbs). |
VARCHAR2 |
2 |
FISCAL_PERIOD |
The fiscal period ending the fiscal quarter. |
VARCHAR2 |
6 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
FYTD_FTE |
The cumulated FYTD FTEs. |
NUMBER |
|
HR_ORG_UNIT_KEY |
The HR organization for the appointment. |
VARCHAR2 |
10 |
PRIME_SPONSOR_KEY |
The key for the prime sponsor (i.e. source fo funds). |
VARCHAR2 |
10 |
PROFIT_CENTER_KEY |
The profit center associated with the cost object. |
VARCHAR2 |
11 |
SALARY_GL_LEVEL4_CATEGORY |
The category of salary GLs. |
VARCHAR2 |
40 |
SALARY_GL_LEVEL5_CATEGORY |
The subcategory of salary GLs (VPF use only). |
VARCHAR2 |
40 |
SPONSOR_KEY |
The key for the direct sponsor. |
VARCHAR2 |
10 |