RC_TAX810KY

(SQL Table)
Index Back

RC Tax810 KY

RC Tax810 KY

# 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 SUT_EXPERIENCE_RT Number(8,5) DECIMAL(7,5) NOT NULL SUT Experience Rate.
5 SURCHARGE_RT_PCT Number(6,4) DECIMAL(5,4) NOT NULL Surcharge rate percentage
6 ADJ_UC_RATE Signed Number(9,5) DECIMAL(7,5) NOT NULL Adjusted UC Rate %
7 KY_MONTH1_COUNT Signed Number(8,0) DECIMAL(7) NOT NULL Month 1 Employee Count
8 KY_MONTH2_COUNT Signed Number(8,0) DECIMAL(7) NOT NULL Month 2 Employee Count
9 KY_MONTH3_COUNT Signed Number(8,0) DECIMAL(7) NOT NULL Month 3 Employee Count