Producer Online Contributions Reporting Instructions
To submit contributions (MCON) data files, a production company will be provided a unique ID and Password by the DGA-Producer Pension and Health Plans (DGA Plans). Please contact Marisela Carrillo at (323) 866-2200, ext. 280 to receive an ID, password and links.
To connect to the upload page, go to http://www.dgaplans.org/ProducerLogin.htm in Internet Explorer.
Note: It is highly recommended that you have Internet Explorer 7.x with the latest security patches to ensure the highest level of security of your data. You will also need to add the new site to your trusted location as well as having the ability to install ActiveX components and Java enabled.
The following topics are covered on this page. Click a link below to jump to that section. A PDF version of these instructions is available here.
Unique ID and Password
After receiving your unique ID and password from the DGA Plans, record it for future use.
Logging In
-
After opening the URL in Internet Explorer, you will see the following welcome screen.
-
Click on the link Continue with Producer Login. Once this link is clicked you will be presented with a login screen (example below).
-
Enter your assigned User name and Password (as noted earlier) and click OK. Once you are authenticated to the server the secure gateway/tunnel is activated.
Note: Upon initial sign in you may be prompted to install an ActiveX component, please allow this action to occur otherwise you will not be able to upload files. You may also be informed that a Java application is attempting to run, you will need to allow this action as well. If you have questions or problems with these processes please contact your IT department. If needed, have them contact Marisela Carrillo at (323) 866-2200, ext. 280 for clarification or questions.
File Transfer Applet (FTA)
After a brief moment the following EFT upload form is displayed.
This is where you will browse to your local copy of the data file to be uploaded and then start the upload process to DGA Plans.
FTA – Changing Your Password
After your first login, and periodically, you should change your password. The FTA provides this functionality.
-
Click on the Change Password button and the following form will pop up.
-
Enter your Old Password, then enter your New Password twice (once in the New box and then again in the Confirm box).
-
Then click on the Change Password button and your password will be updated. You will use this password the next time you login to this site.
FTA – Form Areas
The FTA form is broken into three critical areas.
- Local Filesystem
- Remote Filesystem
- Queue Pane
Local Filesystem: This section displays files on your local PC/Network. Use the buttons above this area to browse to the location of the files to be uploaded. In this example, the path browsed to is C:\Upload to DGA. This folder contains three files (your directory structure will reflect your local PC).
Remote Filesystem: This section displays files for your Producer Company on the secured sever. This area may or may not show files. Normally there will be NO FILES displayed in this area, during processing it is normal to see files appear then disappear from this area.
Queue Pane: This section displays your transfer progress and status of files uploaded. This is the section that you should watch to verify that your transferred files have completed.
FTA – Uploading Your File
It is important to note that you should only up load ONE FILE at a time. This applet does support uploading multiple files, however, for proper processing you should ONLY upload ONE FILE at a time and then wait for the Queue Pane to update showing the status.
-
To upload a file, browse in the Local filesystem area until you can see the file to upload in this area’s display.
-
Click on the file to highlight it. Click here for file specifications and samples.
-
To upload, click on the >> button (see image below) that is between the Local and Remote Filesystem areas. This will initiate an upload of the highlighted file. Once you click this the Queue Pane will be updated to reflect the progress/completion.
After submission, you or your company’s designated contact will receive an email from the DGA Plans server noting that the file(s) was received and is being processed. -
Once you have completed your upload, you should either click on the Log Out button or close the Internet Explorer browser window. Your connection to the secure tunnel will timeout after a few minutes of no activity, however, it is always a good idea to close the Internet Explorer browser window when you have completed your upload.
In the example above, the first file in the list is highlighted on the Local Filesystem and upload button has been clicked. The Queue Pane shows the status for the upload file as being complete.
Note: This file does not show up on the Remote Filesystem pane. This is normal. Upon upload the DGA Plans systems move the file from the Remote Filesystem location and store it in a processing location within their network. If you ever see a file or files sitting in the Remote Filesystem area, click on the refresh button to refresh Internet Explorer, the file should no longer be visible in the Remote Filesystem area. If it is still visible, please contact DGA Plans support staff with the details.
File Specifications
Comma Delimited and Tab Delimited Files
Use the following layout for Comma Delimited and Tab Delimited files. Sample mcon-comma.csv and
mcon-tab.txt files.
| Field Name | Req'd Field | Description/Comments |
|---|---|---|
| Payroll Company | N | If Report is being submitted by a Payroll Company, this ID will be provided by the Fund Office. |
| Producer Number | Y | Number will be provided by Plan Office |
| Participants SSN | Y | Social Security Number (no dashes) |
| Participants Last Name | Y | |
| Participants First Name | Y | |
| Participants Middle Name/Initial | N | |
| Category Code | Y | See Field Notes Below |
| Project Name (Picture, TV Series or Commercial) | Y | |
| Project ID Number | Y | Use ID Number established by company |
| Name of TV Series Episode or Commercial Sponsor | Y | |
| ID Number of TV Series Episode or Commercial Sponsor | Y | Use ID Number established by company |
| Length Of Picture or TV Series Episode Code | Y | See Field Notes Below |
| Earnings Code | Y | See Field Notes Below |
| Residual Type Code | N | See Field Notes Below |
| Residual Run Code | Y | See Field Notes Below |
| Worked From Date | Y | MM/DD/YYYY or M/D/YYYY -- Use Work From Date when reporting Original Compensation --OR-- Residual Air Date or Pay Date when reporting Residual Compensation. |
| Worked Through Date | Y | MM/DD/YYYY or M/D/YYYY -- Use Work Thru Date when reporting Original Compensation --OR-- Residual Air Date or Pay Date when reporting Residual Compensation. |
| Days Worked | Y | If Commercial, Shoot Days. |
| Gross Wages | Y | Positive or negative decimal (no commas) |
| Employee Pension Contribution (2.5% of Gross Wages) | Y | Positive or negative decimal (no commas) |
| Employer Pension Contribution (5.5% of Gross Wages) | Y | Positive or negative decimal (no commas) |
| Training Plan Contribution | Y | Positive or negative decimal (no commas) |
| Training City/Region Code | Y | See Field Notes Below |
| Qualification List Contribution | Y | Positive or negative decimal (no commas) |
| Qualification City/Region Code | Y | See Field Notes Below |
| Employer Health Contribution | Y | Positive or negative decimal (no commas) |
| Agreement Code | Y | See Field Notes Below |
| Loan Out Company Name | N | |
| Loan Out Company Tax ID | N | |
| Health Rate | Y | Positive or negative decimal (no commas) |
| Original Work Start Date | Y | Required for Residual Runs - MM/DD/YYYY or M/D/YYYY |
Fixed Width Formatted Files
Use the following layout for Fixed Width formatted files. Sample mcon-fixed.txt file.
| Field Name | Starting Position | Ending Position | Field Length | ** | Req'd Field | Description/Comments |
|---|---|---|---|---|---|---|
| Payroll Company | 1 | 10 | 10 | N | N | If Report is being submitted by a Payroll Company, this ID will be provided by the Fund Office. |
| Producer Number | 11 | 20 | 10 | N | Y | Number will be provided by Plan Office |
| Participants SSN | 21 | 29 | 9 | N | Y | Social Security Number (no dashes) |
| Participants Last Name | 30 | 47 | 18 | A/N | Y | |
| Participants First Name | 48 | 57 | 10 | A/N | Y | |
| Participants Middle Name/Initial | 58 | 67 | 10 | A/N | N | |
| Category Code | 68 | 69 | 2 | A/N | Y | See Attachment |
| Project Name (Picture, TV Series or Commercial) | 70 | 119 | 50 | A/N | Y | |
| Project ID Number | 120 | 131 | 12 | A/N | Y | Use ID Number established by company |
| Name of TV Series Episode or Commercial Sponsor | 132 | 157 | 26 | A/N | Y | |
| ID Number of TV Series Episode or Commercial Sponsor | 158 | 169 | 12 | A/N | Y | Use ID Number established by company |
| Length Of Picture or TV Series Episode Code | 170 | 173 | 4 | N | Y | See Attachment |
| Earnings Code | 174 | 174 | 1 | A/N | Y | See Attachment |
| Residual Type Code | 175 | 176 | 2 | A/N | N | See Attachment |
| Residual Run Code | 177 | 178 | 2 | A/N | Y | See Attachment |
| Work From Date | 179 | 186 | 8 | D | Y | CCYYMMDD -- Use Work From Date when reporting Original Compensation --OR-- Residual Air Date or Pay Date when reporting Residual Compensation. |
| Work Through Date | 187 | 194 | 8 | D | Y | CCYYMMDD -- Use Work Thru Date when reporting Original Compensation --OR-- Residual Air Date or Pay Date when reporting Residual Compensation. |
| Days Worked | 195 | 198 | 4 | N | Y | If Commercial, Shoot Days. |
| Gross Wages | 199 | 207 | 9 | N | Y | S9(7)V99 |
| Employee Pension Contribution (2.5% of Gross Wages) | 208 | 216 | 9 | N | Y | S9(7)V99 |
| Employer Pension Contribution (5.5% of Gross Wages) | 217 | 225 | 9 | N | Y | S9(7)V99 |
| Training Plan Contribution | 226 | 234 | 9 | N | Y | S9(7)V99 |
| Training City/Region Code | 235 | 235 | 1 | A/N | Y | See Attachment |
| Qualification List Contribution | 236 | 244 | 9 | N | Y | S9(7)V99 |
| Qualification City/Region Code | 245 | 245 | 1 | A/N | Y | See Attachment |
| Employer Health Contribution | 246 | 254 | 9 | N | Y | S9(7)V99 |
| Agreement Code | 255 | 255 | 1 | A/N | Y | See Attachment |
| Loan Out Company Name | 256 | 269 | 14 | A/N | N | |
| Loan Out Company Tax ID | 270 | 278 | 9 | N | N | |
| Health Rate | 279 | 283 | 5 | N | Y | 99V999 |
| Original Work Start Date | 284 | 291 | 8 | D | Y | Required for Residual Runs - CCYYMMDD |
A/N = Field Contains Alpha/Numeric Values Left Justified
No. 7 Category Code
| BASIC AND FREELANCE LIVE AND TAPE TV AGREEMENTS | |||
|---|---|---|---|
| Code | Job Category | Code | Job Category |
| 12 | 1ST AD / 2ND AD | K2 | KEY 2ND ASSISTANT DIRECTOR |
| 1A | 1ST ASST. DIRECTOR | LM | LOCATION MANAGER |
| 1M | ASST. DIRECTOR - MULTICAM | PA | PROD. ASSOCIATE |
| 2A | 2ND ASST. DIRECTOR | PP | PROGRAM PRODUCTION ASSISTANT |
| 2L | 2ND 2ND AD / LOCATION MANAGER | PR | UPM / PRODUCER |
| 3A | 2ND 2ND ASST. DIRECTOR | SM | STAGE MGR |
| 4A | ADDITIONAL 2ND ASST. DIRECTOR | SU | UPM STAFF EXECUTIVE |
| A2 | 2UAD - 2ND UNIT ASSISTANT DIRECTOR | SW | AUDIENCE SWITCHER |
| AD | ASSOC. DIRECTOR | TC | TECH. COORDINATOR |
| AS | ASSOC. DR / STAGE MANAGER | U1 | UPM / 1ST ASST. DIRECTOR |
| AT | ASSOC. DR / TECH COORDINATOR | UM | MULTICAM UPM |
| D2 | 2UDR - 2ND UNIT DIRECTOR | UP | UNIT PROD. MGR |
| DR | DIRECTOR | ||
| COMMERCIAL AGREEMENT | |||
|---|---|---|---|
| Code | Job Category | Code | Job Category |
| 12 | 1ST AD / 2ND AD | 4A | ADDITIONAL 2ND ASST. DIRECTOR |
| 1A | 1ST ASST. DIRECTOR | DC | CONTRACT DIRECTOR |
| 1P | 1ST AD / PRINCIPAL | DP | DIRECTOR PRINCIPAL |
| 1S | 1ST AD / STAFF | DR | DIRECTOR |
| 2A | 2ND ASST. DIRECTOR | FD | FREELANCE DIRECTOR |
| 2L | 2ND 2ND AD / LOCATION MANAGER | PU | UPM PRINCIPAL |
| 2P | 2ND AD / PRINCIPAL | U1 | UPM / 1ST ASST. DIRECTOR |
| 2S | 2ND AD / STAFF | UP | UNIT PROD. MGR |
| 3A | 2ND 2ND ASST. DIRECTOR | ||
| NETWORK AGREEMENT | |||
|---|---|---|---|
| Code | Job Category | Code | Job Category |
| 12 | 1ST AD / 2ND AD | ND | NW FREELANCE DIRECTOR |
| 1A | 1ST ASST. DIRECTOR | NL | NW LOCAL DIRECTOR |
| 2A | 2ND ASST. DIRECTOR | NN | NW NATIONAL DIRECTOR |
| 2L | 2ND 2ND AD / LOCATION MANAGER | NS | NW STAFF DIRECTOR |
| AD | ASSOC. DIRECTOR | PA | PROD. ASSOCIATE |
| AS | ASSOC. DR / STAGE MANAGER | PP | PROGRAM PRODUCTION ASSISTANT |
| AT | ASSOC. DR / TECH COORDINATOR | SM | STAGE MGR |
| DR | DIRECTOR | UP | UNIT PROD. MGR |
No. 12 Length of Picture or Episode
| Code | Length of Picture or Episode | Code | Length of Picture or Episode |
|---|---|---|---|
| 30 | 1/2 Hour | 120 | 2 Hours |
| 60 | 1 Hour | 180 | Over 2 Hours |
| 90 | 1 1/2 Hours | 000 | Other |
No. 13 Earnings Code
| Code | Earnings | Code | Earnings |
|---|---|---|---|
| B | Profit, Bonus, Royalties | O | Original Compensation |
| C | Completion of Assignment | R | Residuals |
| H | Clips | V | Vacation |
| L | Deferred Salary |
No. 15 Residual Run Code
| Code | Residual Run Code |
|---|---|
| 01 | First Repeat |
| 02 | Second Repeat |
| 99 | Ninety-Ninth Repeat |
No. 23 Training City/Region Code
| Code | Training City/Region |
|---|---|
| L | Los Angeles/West |
| N | New York/East |
No. 25 Qualification City/Region Code
| Code | Qualification City/Region |
|---|---|
| L | Los Angeles/West |
| N | New York/East |
| O | Third Area (Commercial Only) |
No. 27 Agreement Code
| Code | Agreement | Code | Agreement |
|---|---|---|---|
| B | Basic Agreement | N | Network Agreement |
| C | Commercial Agreement | S | Special or Other Agreement |
| K | Network Cable Agreement | T | Freelance Live & Tape Agreement |
File Samples
MCON-COMMA.CSV Example
Following is an example of a Comma Delimited file.
MCON-TAB.TXT Example
Following is an example of a Tab Delimited file.
MCON-FIXED.TXT Example
Following is an example of a Fixed Width file.
