GPMX_NRP_INT_AD(SQL Table) |
Index Back |
---|---|
Inter-company Parameter DetailInter-company Transfer Parameters Detail |
# | 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 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL | entry type element |
5 | GPMX_PIN_ANNL_NUM | Number(8,0) | INTEGER NOT NULL | Multiple Information Pin Number |
6 | GPMX_ERNDED_CD | Character(4) | VARCHAR2(4) NOT NULL |
Earning or Deduction Code for Other Employer Table
0010=Total Earnings 0020=Non Taxable Christmas Bonus 0030=Non Taxable Vacation Premium 0040=Non Taxable Profit Sharing 0050=Other Non Taxable 0060=Creditable Subsidy Portion 0070=Subsidy 0080=Subsidy NA 0090=Withheld Tax 0100=Cash Salary Credit 0110=Termination Earnings 0120=Non Taxable Termination 0130=Taxable Termination Earnings 0140=Withheld Termination Tax 0170=Employment Subsidy |