GPMY_TAX_CP38

(SQL Table)
Index Back

Payee CP38 Details

Payee CP38 Details

# 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 Record
3 TAX_YEAR Signed Number(5,0) DECIMAL(4) NOT NULL Tax Year
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 GPMY_CP38_IRB_NO Character(30) VARCHAR2(30) NOT NULL Internal revenue Board Number
7 GPMY_CP38_AMOUNT Number(19,6) DECIMAL(18,6) NOT NULL Total Amount to Recover
8 GPMY_CP38_INSTALL Number(19,6) DECIMAL(18,6) NOT NULL Installment Amount
9 GPMY_CP38_NBR_INST Number(6,0) INTEGER NOT NULL Number of Installments
10 GPMY_CP38_BNS_AMT Number(19,6) DECIMAL(18,6) NOT NULL Bonus Amount
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

Prompt Table: CURRENCY_CD_TBL