PI_TAX_BAL(SQL Table) |
Index Back |
|---|---|
PI Imported Tax BalancesPayroll Interface Imported Tax Balances |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PI_RUN_NUM |
Number(4,0) | SMALLINT NOT NULL |
Payroll Interface Run Number
Prompt Table: PI_RUN_TBL |
| 2 | PI_SYSTEM_ID |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll Interface System ID
Prompt Table: PI_SYSTEM_TBL |
| 3 | PI_CONFIG_ID |
Character(6) | VARCHAR2(6) NOT NULL |
PI Configuration ID
Prompt Table: PI_CONFIG_TBL |
| 4 | PI_PAY_GROUP1 |
Character(6) | VARCHAR2(6) NOT NULL | PI Paygroup 1 |
| 5 | PI_PAY_GROUP2 |
Character(6) | VARCHAR2(6) NOT NULL | PI Paygroup 2 |
| 6 | PI_EMPLID |
Character(20) | VARCHAR2(20) NOT NULL | Payroll Interface EMPLID |
| 7 | PI_BALANCE_ID |
Character(2) | VARCHAR2(2) NOT NULL | Balance ID |
| 8 | PI_BALANCE_YEAR |
Number(4,0) | SMALLINT NOT NULL | PI Balances for Year |
| 9 | PI_BALANCE_QTR |
Number(3,0) | SMALLINT NOT NULL | PI Balances for Quarter |
| 10 | PI_BALANCE_PERIOD |
Number(3,0) | SMALLINT NOT NULL | PI Balances for Period |
| 11 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | PI_TAX_TYPE |
Character(6) | VARCHAR2(6) NOT NULL | Payroll Tax Type |
| 13 | PI_TAX_CD |
Character(6) | VARCHAR2(6) NOT NULL | Payroll Tax Code |
| 14 | PI_COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Payroll Country |
| 15 | PI_STATE |
Character(6) | VARCHAR2(6) NOT NULL | Payroll State Code |
| 16 | PI_LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL | Payroll Locality Code |
| 17 | PI_NLGRS_YTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | No Limit Gross YTD |
| 18 | PI_NLGRS_QTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | No Limit Gross QTD |
| 19 | PI_NLGRS_MTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | No Limit Gross MTD |
| 20 | PI_TXGRS_YTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Taxable Gross YTD |
| 21 | PI_TXGRS_QTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Taxable Gross QTD |
| 22 | PI_TXGRS_MTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Taxable Gross MTD |
| 23 | PI_TAX_YTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Tax YTD |
| 24 | PI_TAX_QTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Tax QTD |
| 25 | PI_TAX_MTD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Tax MTD |
| 26 | PI_BALANCE_KEY1 | Character(10) | VARCHAR2(10) NOT NULL | User Defined Search Key 1 |
| 27 | PI_BALANCE_KEY2 | Character(10) | VARCHAR2(10) NOT NULL | User Defined Search Key 2 |