PA_CLC_SVC_ADJ(SQL Table) |
Index Back |
|---|---|
Pension Calc Defn Svc AdjPension Calculation Definition Service Adjustment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Default Value: PA_EACCT_TRANS.BENEFIT_PLAN |
| 2 | FUNCTN_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL |
Function Result Name
Default Value: PA_EACCT_TRANS.FUNCTN_RESULT_NM |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PA_EACCT_TRANS.EMPLID |
| 4 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: PA_EACCT_TRANS.SEQNUM |
| 5 | TRANSACTION_DATE |
Date(10) | DATE |
TRANSACTION_DATE
Default Value: PA_EACCT_TRANS.TRANSACTION_DATE |
| 6 | DATE_FROM |
Date(10) | DATE | Date From |
| 7 | DATE_TO |
Date(10) | DATE | Previous Period Date To |
| 8 | PA_SVC_DURATN | Signed Number(17,6) | DECIMAL(15,6) NOT NULL | Service Duration |