RC_TAX870EU

(SQL Table)
Index Back

TAX870EU Run Control

# 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 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

Prompt Table: SRC_BANK

5 PY_EE_PREPAY Number(15,2) DECIMAL(14,2) NOT NULL Prepayments Made
6 PY_EE_PENALTY Number(10,2) DECIMAL(9,2) NOT NULL Penalty Due
7 PY_EE_INTEREST Number(10,2) DECIMAL(9,2) NOT NULL Interest Due
8 PY_EE_PNLTY_LT_FL Number(10,2) DECIMAL(9,2) NOT NULL Late File Penalty
9 PY_ER_PREPAY Number(15,2) DECIMAL(14,2) NOT NULL Prepayments Made
10 PY_ER_PENALTY Number(10,2) DECIMAL(9,2) NOT NULL Penalty Due
11 PY_ER_INTEREST Number(10,2) DECIMAL(9,2) NOT NULL Interest Due
12 PY_ER_PNLTY_LT_FL Number(10,2) DECIMAL(9,2) NOT NULL Late File Penalty
13 PY_AVG_ANN_EMPL Number(9,0) DECIMAL(9) NOT NULL Average Annual Employment
14 PY_QTR_WAGES_Q123 Number(17,2) DECIMAL(16,2) NOT NULL Total Wages Paid During Q123
15 PY_ER_Q4_PREPAY Number(15,2) DECIMAL(14,2) NOT NULL Prepayments Made
16 PY_ER_Q4_PENALTY Number(10,2) DECIMAL(9,2) NOT NULL Penalty Due
17 PY_ER_Q4_INTEREST Number(10,2) DECIMAL(9,2) NOT NULL Interest Due
18 PY_ER_Q4_PNL_LT_FL Number(10,2) DECIMAL(9,2) NOT NULL Late File Penalty