PAYROLL QTRLY FYTD FTE Table
This iew is for VPF teams: controller, budget, HQ, Payroll, 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 |
|---|---|---|---|
CEMITO_LEVEL4_CATEGORY |
The category of salary GLs. |
VARCHAR2 |
40 |
CEMITO_LEVEL5_CATEGORY |
Ths subcategory of salary GLs (VPF use only). |
VARCHAR2 |
40 |
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_AMOUNT |
The cumulated FYTD payroll distributed amount (VPF use only). |
NUMBER |
|
FYTD_FTE |
The cumulated FYTD FTEs. |
NUMBER |
|
HR_ORG_UNIT_KEY |
The HR organization for the appointment. |
VARCHAR2 |
10 |
PCMIT0_LEVEL1_CATEGORY |
XXX |
VARCHAR2 |
40 |
PCMIT0_LEVEL2_CATEGORY |
XXX |
VARCHAR2 |
40 |
PCMIT0_LEVEL3_CATEGORY |
XXX |
VARCHAR2 |
40 |
PRIME_SPONSOR_KEY |
The key for the prime sponsor (i.e. source fo funds). |
VARCHAR2 |
10 |
PRIME_SPONSOR_LEVEL1 |
XXX |
VARCHAR2 |
50 |
PRIME_SPONSOR_LEVEL2 |
XXX |
VARCHAR2 |
50 |
PRIME_SPONSOR_NAME |
The name used to identify a primary sponsor associated with a particular sponsor code. |
VARCHAR2 |
200 |
PRIME_SPONSOR_TYPE |
Type of primary sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
100 |
PROFIT_CENTER_KEY |
The profit center associated with the cost object. |
VARCHAR2 |
11 |
SPONSOR_KEY |
The key for the direct sponsor. |
VARCHAR2 |
10 |
SPONSOR_LEVEL1 |
XXX |
VARCHAR2 |
50 |
SPONSOR_LEVEL2 |
XXX |
VARCHAR2 |
50 |
SPONSOR_NAME |
In the PROJECT and SPONSOR tables, identifies the sponsor, associated with a particular sponsor code, providing funding for a sponsored research project. In the personnel APPOINTMENT tables, identifies the sponsor providing financial support for a Fellow; this field is not currently populated by Human Resources. |
VARCHAR2 |
200 |
SPONSOR_TYPE |
The type of sponsor (Example: Federal, Private - Pofit, Private - Non-Profit, State, etc..) |
VARCHAR2 |
100 |