RC_TAX106(SQL Table) |
Index Back |
|---|---|
Payroll Report ParametersProcess Scheduler report parameter record utilized by TAX106.SQR- W4- Federal Allowance Withholding Report for IRS. |
| # | 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 4 | W4_UPD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Upd. Web, Single/All Employee
A=All Employees S=Single Employee W=Web created/Updated Employees Default Value: A |
| 5 | RPT_EXMPT_ALLOWANC | Character(1) | VARCHAR2(1) NOT NULL |
Rep Employee Exmpt/Alwnce/Both
A=All B=Exempt/ >10 Allowances E=Claim Exempt T=More Than Ten Allowances Default Value: B |
| 6 | TAX_YEAR | Signed Number(5,0) | DECIMAL(4) NOT NULL | Tax Year |
| 7 | TAX_QTR | Number(3,0) | SMALLINT NOT NULL | Tax quarter |
| 8 | ELECTRONIC_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Electronic Processing
Y/N Table Edit Default Value: N |
| 9 | TRANS_CNTL_CODE | Character(5) | VARCHAR2(5) NOT NULL | Transmitter control code. |
| 10 | MEDIA | Character(1) | VARCHAR2(1) NOT NULL |
Media
D=Diskette N=None R=Report T=Tape |
| 11 | DISKETTE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Diskette Type
0=Not Applicable 1=3.5 Inches High Density 2=3.5 Inches Double Density |
| 12 | INCLUDE_TIPPED_EES | Character(1) | VARCHAR2(1) NOT NULL |
Process Tipped Employees
Y/N Table Edit Default Value: N |