EFFDTDefault Value: %date
PIN_NUMPrompt Table: GPAR_EDAELEM_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
GPAR_NRP_IPD_VW(SQL View) |
Index Back |
|---|---|
Income tax parameters detailIncome tax parameters detail element relationship view. |
| SELECT EFFDT , PIN_NUM + 50000000 , GP_LABEL_NAME , GPAR_DEDUCTIBLE , GPAR_PREVYRRETRO , GPAR_F649_CD FROM PS_GPAR_INC_TAX_PD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPAR_EDAELEM_VW |
| 3 | GP_LABEL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Label name. |
| 4 | GPAR_DEDUCTIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Field used to define if and element is deductible.
Y/N Table Edit Default Value: N |
| 5 | GPAR_PREVYRRETRO | Character(1) | VARCHAR2(1) NOT NULL |
Field used to indicate if an element is retroactive.
Y/N Table Edit Default Value: N |
| 6 | GPAR_F649_CD | Character(3) | VARCHAR2(3) NOT NULL | 649 Form code for income tax elements |