PAYROLL QTRLY FYTD FTE PII Table
This is view with personal identifiable information restricted to super 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 |
|---|---|---|---|
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 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
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 |