GPBR_NRP_TXB_AD(SQL Table) |
Index Back |
---|---|
Income, Deductable and WitholdTaxable Income, Tax-Deductable and Witholding Tax |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
3 | EFFDT | Date(10) | DATE | Effective Date |
4 | GPBR_IREN_TXBL | Character(2) | VARCHAR2(2) NOT NULL |
Taxable Parameters
01=01-Total Income 02=02-Officl Contrib for Retirmnt 03=03-Cntribs Private Fund 04=04-Pensn Allimony Grnshmnts 05=05-Withholding Tax |
5 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL | entry type element |
6 | GPBR_PIN_IREN_NUM | Number(8,0) | INTEGER NOT NULL | IREN Pin Number |
7 | GPBR_ERDD_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Sign
A=Add S=Subtract |