How we determine who is on an effort statement in ECC

This is to help describe what positions and departments require effort certification in ECC.

All active and terminated workers are fed into ECC every weekday via INT015D.
ECC puts a worker onto the effort statement if:
- They have a payroll transaction for that month.
- Their Active Status is "Yes".
To ensure unpaid workers are put onto an effort statement, we use INT015N to send phony $0.00 payroll transaction for everyone with their Active Status = "Yes", except workers with the Job Profiles below:

Retiree
College Intern (inactive)
Consultant
Contractor
HHMI Lab Assistant
High School Intern - Paid
High School Intern - Unpaid
Intern - Paid (inactive)
Intern - Unpaid (inactive)
Lab Assistant
Masters Student - Paid
Masters Student - Unpaid
Remote Member
Remote Visitor
Research Assistant - MIT
Research Assistant - Other Paid
Research Assistant - S
Temporary Worker
Undergraduate Student - Paid
Undergraduate Student - Unpaid
UROP
Visiting Postdoctoral Associate
Visiting Researcher Core
Visiting Scholar
Visiting Scientist
Visiting Technical Assistant
Whitehead Fellow - Training

The net effect is that ECC has everybody in it, including terminated workers and workers in administrative departments. A worker ends up on their lab's/department's effort statement if they have a payroll transaction for the month. Every worker with an Active Status = "Y" not in one of the Job Profiles listed has a $0 payroll transaction sent to ECC so that they end up on an effort statement. In ECC, effort statements are created for administrative departments and auto approved each month. These statements are not printed or signed by anyone.