PA_WTHDRW_CTB

(SQL Table)
Index Back

Payment Adjustments

This is an employee table for Retiree Admin.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 PA_RUN_ID Character(10) VARCHAR2(10) NOT NULL Run ID
4 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

Prompt Table: PA_PEN_PLAN_VW

5 PA_PMT_NBR Number(2,0) SMALLINT NOT NULL Payment Number

Default Value: 1

6 EFFDT Date(10) DATE Effective Date

Default Value: %date

7 PA_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

8 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name

Prompt Table: PA_EACCT_WDR_VW

9 EACCT_FR_NAME Character(10) VARCHAR2(10) NOT NULL Parent Contribution Account

Default Value: PA_EACCT_WDR_VW.EACCT_FR_NAME

10 PA_ADJ_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjustment Amount
11 PA_ADJ_AMT_NOTAX Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjustment Amount Non Taxable
12 PA_WITHDRAW_ALL Character(1) VARCHAR2(1) NOT NULL Withdraw All Contributions

Y/N Table Edit

Default Value: Y

13 PA_SVC_FORFEIT Character(1) VARCHAR2(1) NOT NULL Forfeit Service Credit

Y/N Table Edit

Default Value: Y

14 SERVICE_FR_NAME Character(10) VARCHAR2(10) NOT NULL Service Function Result Name

Default Value: PA_EACCT_WDR_VW.SERVICE_FR_NAME

15 PA_PMT_END_DT Date(10) DATE Pay Period End Date
16 PA_CHECK_DATE Date(10) DATE Check Date
17 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

18 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PROV_VW

19 PA_POSTED_SW Character(1) VARCHAR2(1) NOT NULL Payment Posted
N=
Y=Status = Processed

Default Value: N

20 ROLLOVER_IND Character(1) VARCHAR2(1) NOT NULL Rollover

Y/N Table Edit

Default Value: N

21 COMMENTS Long Character CLOB Comment