TAX_CR_RED_TBL(SQL Table) |
Index Back |
|---|---|
Tax Credit Reductions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | LC_CNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
The local country.
Default Value: OPR_DEF_TBL_FS.LC_CNTRY Prompt Table: LC_CNTRY_VW |
| 3 | TAX_CREDIT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Tax Credit Type
E=Energy Tax Credit I=Regular Investment Tax Credit R=Rehabilitation Tax Credit U=User-Defined |
| 4 | TAX_CREDIT_CD |
Character(6) | VARCHAR2(6) NOT NULL | Tax Credit Code |
| 5 | BASIS_RED_OPT |
Character(1) | VARCHAR2(1) NOT NULL |
Basis Reduction Option
B=Basis Reduction N=None - No Basis Reduction P=Percentage Rate Reduction |
| 6 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 8 | TAX_CR_RT | Signed Number(11,8) | DECIMAL(9,8) NOT NULL | Tax Credit Rate |
| 9 | BASIS_RED_RT | Signed Number(11,8) | DECIMAL(9,8) NOT NULL | Basis Reduction Percentage |