OPRIDRUN_CNTL_IDCOMPANYPrompt Table: COMPANY_TBL
Y/N Table Edit
Default Value: N
GPUS_MW508_VW(SQL View) |
Index Back |
|---|---|
Run Control Record State MMREFRun Control Record for State MMREF |
| SELECT OPRID , RUN_CNTL_ID , COMPANY , GPUS_YE_MW508_LN2 , GPUS_YE_MW508_LN3 , GPUS_YE_MW508_LN3A , GPUS_YE_MW508_LN3B , GPUS_YE_MW508_LN4 , GPUS_YE_MW508_LN5 , GPUS_YE_MW508_LN6 , GPUS_YE_MW508_LN7 , TELEPHONE_NBR , GPUS_MW508_DATE , GPUS_MW508_REP_NM , GPUS_MW508_TITLE , GPUS_MW508_IND FROM PS_GPUS_MMREFST_MD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 4 | GPUS_YE_MW508_LN2 | Number(13,2) | DECIMAL(12,2) NOT NULL | Maryland MMREF - MW508 form - Total Employer Taxes Withheld |
| 5 | GPUS_YE_MW508_LN3 | Number(13,2) | DECIMAL(12,2) NOT NULL | Maryland MMREF - MW508 form - Employer State/Local Taxes Withheld |
| 6 | GPUS_YE_MW508_LN3A | Number(13,2) | DECIMAL(12,2) NOT NULL | Maryland MMREF - MW508 form - Withholding Tax |
| 7 | GPUS_YE_MW508_LN3B | Number(13,2) | DECIMAL(12,2) NOT NULL | Maryland MMREF - MW508 form - Employer credits |
| 8 | GPUS_YE_MW508_LN4 | Number(13,2) | DECIMAL(12,2) NOT NULL | Maryland MMREF - MW508 form - Withholding Taxes due - MW058 Line 3 minus Line 3A |
| 9 | GPUS_YE_MW508_LN5 | Number(13,2) | DECIMAL(12,2) NOT NULL | Maryland MMREF - MW508 form - Employer Amount Balance Due |
| 10 | GPUS_YE_MW508_LN6 | Number(13,2) | DECIMAL(12,2) NOT NULL | Maryland MMREF - MW508 form - Employer Overpayment |
| 11 | GPUS_YE_MW508_LN7 | Number(13,2) | DECIMAL(12,2) NOT NULL | Maryland MMREF - MW508 form - Overpayment applied as a Credit |
| 12 | TELEPHONE_NBR | Character(15) | VARCHAR2(15) NOT NULL | Telephone Number |
| 13 | GPUS_MW508_DATE | Date(10) | DATE | Maryland MMREF - MW508 form - Date submitted |
| 14 | GPUS_MW508_REP_NM | Character(28) | VARCHAR2(28) NOT NULL | Maryland MMREF - MW508 form - Company Representative name |
| 15 | GPUS_MW508_TITLE | Character(20) | VARCHAR2(20) NOT NULL | Maryland MMREF - MW508 form - Company Representative title |
| 16 | GPUS_MW508_IND | Character(1) | VARCHAR2(1) NOT NULL |
Maryland MMREF - MW508 form - CompletIion Filing flag
Y/N Table Edit Default Value: N |