TAXRPT_RUNCTL

(SQL Table)
Index Back

Tax Report Run Control

This record is used to store parameters required by SQRs for quarterly and annual tax reporting.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID

Default Value: INSTALLATION.BAL_ID_FOR_CAL_YR

Prompt Table: BALANCE_ID_TBL

2 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year

Prompt Table: BAL_YR_NO_CO_VW

3 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

Default Value: 4

Prompt Table: BALQTR_NO_CO_V

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

5 XMITTER_IS_ER Character(1) VARCHAR2(1) NOT NULL Transmitter Same as Employer?

Y/N Table Edit

Default Value: Y

6 COMPUTER_MFR Character(8) VARCHAR2(8) NOT NULL Computer Manufacturer
7 ORG_TYPE Character(1) VARCHAR2(1) NOT NULL Organization Type
G=State or Local Government
O=Other

Default Value: O

8 EMPLOYMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Employment
A=Agriculture
F=Form 944
H=Household
M=Military
Q=Medicare Qualified Govt Emplmt
R=Regular (All Others)
X=Railroad

Default Value: R

9 TAPE_LABEL Character(2) VARCHAR2(2) NOT NULL Tape Label
NA=Not Applicable
NL=No Label
NS=Nonstandard Label
SL=Standard Label

Default Value: NL

10 TAPE_DENSITY Character(2) VARCHAR2(2) NOT NULL Tape Density
08=800 CPI
16=1600 CPI
18=Code 18
34=Code 34
38=3480 Cartridge
62=6250 CPI
77=3490E Cartridge
NA=Not Applicable

Default Value: 62

11 RECORDING_CD Character(3) VARCHAR2(3) NOT NULL Recording Code
ASC=ASCII
EBC=EBCDIC

Default Value: ASC

12 BLOCKING_FACTOR Number(2,0) SMALLINT NOT NULL Blocking Factor
13 ALIGN_COUNT Number(3,0) SMALLINT NOT NULL Alignment Count
14 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

Prompt Table: FORM_ID_VW

15 EMPLOYEES_PER_PAGE Number(1,0) SMALLINT NOT NULL Employees Per Page
16 REPRINT_NBR Number(5,0) INTEGER NOT NULL Reprint Numberf

Default Value: 1

17 ELEC_FILE_CONF_NO Character(7) VARCHAR2(7) NOT NULL Puerto Rico Electronic Filing Confirmation Number