RC_TAX010PA(SQL Table) |
Index Back |
|---|---|
Payroll Report ParametersProcess Scheduler report parameter record utilized by a number of payroll and tax SQRs. |
| # | 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: BAL_YR_NO_CO_VW |
| 5 | BALANCE_QTR | Number(3,0) | SMALLINT NOT NULL |
Balances for Quarter
Prompt Table: BALQTR_PNAME_VW |
| 6 | BALANCE_PERIOD | Number(3,0) | SMALLINT NOT NULL |
Balances for Period
Prompt Table: BALPRD_NO_CO_VW |
| 7 | EE_DETAIL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Show Employee Detail Report?
Y/N Table Edit Default Value: N |
| 8 | PRINT_SSN | Character(1) | VARCHAR2(1) NOT NULL |
Print Social Security Number
Y/N Table Edit Default Value: N |
| 9 | 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 |
| 10 | SORT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Sort Option for PA OPT Report
C=COMPANY WITHIN LOCALITY L=LOCALITY WITHIN COMPANY Default Value: C |