R_TAX004ST

(SQL Table)
Index Back

Temp Table - SQR TAX004ST

Temporary table required for processing of TAX004.SQR - Multiple Worksite Report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 F_WORKERS_MONTH1 Number(6,0) INTEGER NOT NULL F Workers 1st Month of Qtr
4 F_WORKERS_MONTH2 Number(6,0) INTEGER NOT NULL F Workers 2nd Month of Qtr
5 F_WORKERS_MONTH3 Number(6,0) INTEGER NOT NULL F Workers 3rd Month of Qtr
6 M_WORKERS_MONTH1 Number(6,0) INTEGER NOT NULL M Workers 1st Month of Qtr
7 M_WORKERS_MONTH2 Number(6,0) INTEGER NOT NULL M Workers 2nd Month of Qtr
8 M_WORKERS_MONTH3 Number(6,0) INTEGER NOT NULL M Workers 3rd Month of Qtr