GPBR_NRP_NTX_VW (SQL View)	Index Back
IREN Element Relationship Tax-exempt and Non Taxable Income Element Relationship

GPBR_NRP_NTX_VW

(SQL View)

IREN Element Relationship

Tax-exempt and Non Taxable Income Element Relationship

SELECT EFFDT ,COMPANY ,GPBR_IREN_NTXBL ,ENTRY_TYPE_ELEM ,GPBR_PIN_IREN_NUM + 50000000 ,GPBR_ERDD_SIGN FROM PS_GPBR_IREN_NTXBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

3 GPBR_IREN_NTXBL Character(2) VARCHAR2(2) NOT NULL IREN NonTaxable Parameters
01=Tax-deductible Part Income
01=01-Tax-deductible Part Incme
02=Per Diem Cost & Allowances
02=02-Per Diem Cost & Allowances
03=Labor Sckns/Accdnt Income
03=03-Labor Sckns/Accdnt Incm
04=Profits and Dividends
04=04-Profits and Dividends
05=Profit Distrib M/S Companies
05=05-Profit Distrib M/S Compnies
06=Indemnification
06=06-Indemnification
07=Abonos
07=07-Abonos
08=Other Non-Taxable Income
08=08-Other Non-Taxable Income
50=Tax Deductible 13th Salary
55=Late Payment Interest Received

4 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

5 GPBR_PIN_IREN_NUM Number(8,0) INTEGER NOT NULL IREN Pin Number

6 GPBR_ERDD_SIGN Character(1) VARCHAR2(1) NOT NULL Sign
A=Add
S=Subtract

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	GPBR_IREN_NTXBL	Character(2)	VARCHAR2(2) NOT NULL	IREN NonTaxable Parameters 01=Tax-deductible Part Income 01=01-Tax-deductible Part Incme 02=Per Diem Cost & Allowances 02=02-Per Diem Cost & Allowances 03=Labor Sckns/Accdnt Income 03=03-Labor Sckns/Accdnt Incm 04=Profits and Dividends 04=04-Profits and Dividends 05=Profit Distrib M/S Companies 05=05-Profit Distrib M/S Compnies 06=Indemnification 06=06-Indemnification 07=Abonos 07=07-Abonos 08=Other Non-Taxable Income 08=08-Other Non-Taxable Income 50=Tax Deductible 13th Salary 55=Late Payment Interest Received
4	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element
5	GPBR_PIN_IREN_NUM	Number(8,0)	INTEGER NOT NULL	IREN Pin Number
6	GPBR_ERDD_SIGN	Character(1)	VARCHAR2(1) NOT NULL	Sign A=Add S=Subtract