PA_SP_TAXTYPYMT(SQL View) |
Index Back |
|---|---|
Payments for Tax Type ChangeLump Sum Payments for Tax Type Change. |
| SELECT E.EMPLID , E.BENEFIT_PLAN , E.SP_ID , E.ESTIMATE_NBR , P.SEQUENCE_NBR , P.EACCT_TRAN_TYPE , P.PYMT_DATE , P.PYMT_AMT , P.TAX_TYPE_CHNG , P.ORIG_AMT , I.INSTALL_NBR FROM PS_PA_SP_TRAN_EST E , PS_PA_SP_TRAN_PYMT P ,PS_PA_SP_TRAN_INST I WHERE E.EST_SELECTED = 'Y' AND P.EMPLID = E.EMPLID AND P.BENEFIT_PLAN = E.BENEFIT_PLAN AND P.SP_ID = E.SP_ID AND P.ESTIMATE_NBR = E.ESTIMATE_NBR AND P.PYMT_METHOD = 'L' AND I.EMPLID = P.EMPLID AND I.BENEFIT_PLAN = P.BENEFIT_PLAN AND I.SP_ID = P.SP_ID AND I.ESTIMATE_NBR = P.ESTIMATE_NBR AND I.SEQUENCE_NBR = P.SEQUENCE_NBR |
| # | 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 | ESTIMATE_NBR | Number(2,0) | SMALLINT NOT NULL | Estimate Number |
| 5 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | EACCT_TRAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Type of Pension amounts.
O=Post-Tax R=Pre-Tax |
| 7 | PYMT_DATE | Date(10) | DATE | Payment Date |
| 8 | PYMT_AMT | Number(12,2) | DECIMAL(11,2) NOT NULL | Payment Amount |
| 9 | TAX_TYPE_CHNG | Character(1) | VARCHAR2(1) NOT NULL | Tax Type Change |
| 10 | ORIG_AMT | Number(12,2) | DECIMAL(11,2) NOT NULL | Original Amount |
| 11 | INSTALL_NBR | Number(2,0) | SMALLINT NOT NULL | Installation Number for Service Purchase Installment Payments. |