EMPLIDBENEFIT_PLANSP_IDDTTM_COMPLETEO=Post-Tax
R=Pre-Tax
PA_SP_TAXTYPLOG(SQL Table) |
Index Back |
|---|---|
Tax Type Change LogThis record records a log of changes to the tax type of the payment options on a Service Purchase transaction. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 3 | SP_ID |
Number(11,0) | DECIMAL(11) NOT NULL | Service Purchase ID |
| 4 | DTTM_COMPLETE |
DateTime(26) | TIMESTAMP | Date/Time Completed |
| 5 | INSTALL_NBR | Number(2,0) | SMALLINT NOT NULL | Installation Number for Service Purchase Installment Payments. |
| 6 | DUE_DATE | Date(10) | DATE | Due Date |
| 7 | ORIG_AMT | Number(12,2) | DECIMAL(11,2) NOT NULL | Original Amount |
| 8 | PYMT_AMT | Number(12,2) | DECIMAL(11,2) NOT NULL | Payment Amount |
| 9 | AMT_TO_CHANGE | Number(12,2) | DECIMAL(11,2) NOT NULL | Change Amount |
| 10 | EACCT_TRAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Type of Pension amounts.
O=Post-Tax R=Pre-Tax |