RC_QTR_UI

(SQL Table)
Index Back

Run Control for Tax Reporting

Process Scheduler report parameter record utilized by SQRs which create quarterly unemployment wage listings on paper or magnetic media.

# 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 REPORT_DUE_DATE Date(10) DATE Report Due Date
4 RPT_TOTALS_ONLY Character(1) VARCHAR2(1) NOT NULL Report Totals Only

Y/N Table Edit

Default Value: N

5 REPORT_PROBATNARY Character(1) VARCHAR2(1) NOT NULL Report Probationary Employees

Y/N Table Edit

Default Value: N

6 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
7 REPORTING_MEDIUM Character(1) VARCHAR2(1) NOT NULL Reporting Medium
C=Cartridge
D=Diskette
T=Tape
X=Electronic

Default Value: D

8 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

Default Value: 1

9 REMITTER_NUMBER Number(6,0) INTEGER NOT NULL Remitter Number
10 CONTACT_PERSON Character(30) VARCHAR2(30) NOT NULL Contact Person
11 CONTACT_PHONE Character(12) VARCHAR2(12) NOT NULL Contact Phone
12 TEC_SUFFIX Character(5) VARCHAR2(5) NOT NULL TEC Suffix Code
13 RETURN_NAME Character(44) VARCHAR2(44) NOT NULL Return Name
14 RETURN_STREET Character(35) VARCHAR2(35) NOT NULL Return Street
15 RETURN_CITY Character(20) VARCHAR2(20) NOT NULL Return City
16 RETURN_STATE Character(2) VARCHAR2(2) NOT NULL Return State

Prompt Table: STATE_NAMES_VW

17 RETURN_ZIP Character(10) VARCHAR2(10) NOT NULL Return Zip
18 MAXIMUM_WEEKS Number(2,0) SMALLINT NOT NULL Maximum Weeks
19 TAPE_AUTH_NUMBER Number(4,0) SMALLINT NOT NULL Tape Authorization Number
20 NJ_STATE_MINIMUM Signed Number(12,2) DECIMAL(10,2) NOT NULL State Minimum Wages
21 CONTACT_PHONE_EXT Character(4) VARCHAR2(4) NOT NULL Contact Phone Extension
22 CONTACT_SIG_TITLE Character(40) VARCHAR2(40) NOT NULL Contact Person's Title
23 PROGRAM_MODE Character(1) VARCHAR2(1) NOT NULL Program Mode
R=Report Only
U=Update

Default Value: R

24 CURRENT_ONLY Character(1) VARCHAR2(1) NOT NULL Current Table Entries Only

Y/N Table Edit

Default Value: Y

25 REPORT_COUNTRY Character(1) VARCHAR2(1) NOT NULL Reporting Country
B=Both Canada and US
C=Canada
U=USA

Default Value: B

26 CANADA_FORM_TYPE Character(3) VARCHAR2(3) NOT NULL Canadian Form Type
A=T4A Footnotes Only
ART=All
R=RL-1 Footnotes Only

Default Value: ART

27 WAGE_RPT_CHECK_AMT Number(12,2) DECIMAL(11,2) NOT NULL Wage Report Check Amt
28 PROVIDERID Character(8) VARCHAR2(8) NOT NULL Provider ID
29 REIMBURSABLE_ER Character(1) VARCHAR2(1) NOT NULL Reimbursable Employer

Y/N Table Edit

Default Value: N

30 TAXFORM_OPT Character(1) VARCHAR2(1) NOT NULL Reporting Option
A=All Tax Form IDs
S=Selected Tax Form IDs

Default Value: A

31 CONTACT_NAME_SSA Character(27) VARCHAR2(27) NOT NULL Name of the Person to be contacted by SSA.
32 TELEPHONE_NBR Character(15) VARCHAR2(15) NOT NULL Telephone Number
33 PHONE_EXTN Number(5,0) INTEGER NOT NULL Telephone Extension.
34 CONTACT_FAX Character(10) VARCHAR2(10) NOT NULL Contact FAX Number.
35 EMAIL_ADDR_MMREF Character(40) VARCHAR2(40) NOT NULL Email Address for MMREF
36 THIRD_PARTY_ID Character(10) VARCHAR2(10) NOT NULL Third Party Admin ID