RC_TAX011PA(SQL Table) |
Index Back |
|---|---|
TAX011PA Run ControlProcess Scheduler report parameter record utilized by TAX011PA to select Balance Qtr/Period for reporting PA Act 32 EIT Report. |
| # | 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 | BALANCE_ID | Character(2) | VARCHAR2(2) NOT NULL |
Balance ID
Default Value: INSTALLATION.BAL_ID_FOR_CAL_YR |
| 4 | BALANCE_YEAR | Number(4,0) | SMALLINT NOT NULL |
Balances for Year
Prompt Table: PY_BALYR_VW |
| 5 | BALANCE_QTR | Number(3,0) | SMALLINT NOT NULL |
Balances for Quarter
Prompt Table: PY_BALQTR_VW |
| 6 | BALANCE_PERIOD | Number(3,0) | SMALLINT NOT NULL |
Balances for Period
Prompt Table: PY_BALPRD_VW |
| 7 | PY_BAL_FOR_YR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Balances for Year
Y/N Table Edit Default Value: N |
| 8 | EE_DETAIL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Show Employee Detail Report?
Y/N Table Edit Default Value: N |
| 9 | PRINT_SSN | Character(1) | VARCHAR2(1) NOT NULL |
Print Social Security Number
Y/N Table Edit Default Value: N |
| 10 | PRINT_ADDR | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate whether employee addresses should be printed for report TAX010PA or not
Y/N Table Edit Default Value: N |
| 11 | PY_SORT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
The field is for the sort options for the PA Act 32 EIT report.
C=Company within Work PSD T=Work PSD within Tax Collector W=Work PSD within Company Default Value: C |