RC_TAX810WA_PRM

(SQL Table)
Index Back

TAX810WA.SQR Run Control

Process Scheduler report parameter record utilized by TAX810WA - Quarterly Unemployment Wage Tape for Washington.

# 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 UI_TAXES_DUE Signed Number(15,2) DECIMAL(13,2) NOT NULL Taxes Due
5 UI_PREV_QTR_UNDRPY Signed Number(13,2) DECIMAL(11,2) NOT NULL Previous Quarter Underpay
6 UI_INTEREST_DUE Signed Number(13,2) DECIMAL(11,2) NOT NULL Interest Due
7 UI_PENALTY_DUE Signed Number(13,2) DECIMAL(11,2) NOT NULL Penalty Due
8 UI_PREVIOUS_CREDIT Signed Number(13,2) DECIMAL(11,2) NOT NULL Previous Credit
9 UI_TOTAL_PAYMENT Signed Number(13,2) DECIMAL(11,2) NOT NULL Total Payment Due
10 UI_MONTH1_COUNT Signed Number(8,0) DECIMAL(7) NOT NULL Month 1 Employee Count
11 UI_MONTH2_COUNT Signed Number(8,0) DECIMAL(7) NOT NULL Month 2 Employee Count
12 UI_MONTH3_COUNT Signed Number(8,0) DECIMAL(7) NOT NULL Month 3 Employee Count
13 EAF_ASSESSMENT_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL EAF Assessment Amount
14 TTL_EXEM_EARNS_OPT Signed Number(16,2) DECIMAL(14,2) NOT NULL Total exempt corporate officer earnings and total exercised stock options
15 TTL_EXEMP_OFFICERS Number(3,0) SMALLINT NOT NULL Total number of exempt corporate officers
16 OUT_OF_STATE_WAGES Character(1) VARCHAR2(1) NOT NULL Out of state wages indicator

Y/N Table Edit

Default Value: N