TAXRPT_RUNCTL(SQL Table) |
Index Back |
---|---|
Tax Report Run ControlThis 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 |