GPAU_STP_REC_MP(SQL Table) |
Index Back |
|---|---|
Income Type Record MappingIncome Type Record Mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Category Information - Single Touch Payroll | |
| 2 | Character(4) | VARCHAR2(4) NOT NULL |
STP Income Types
CHP=Closely Held Payees FEI=Foreign Employment IAA=Inbound Assignees to Australia LAB=Labour-Hire OSP=Other Specified Payments SAW=Salary and Wages SWP=Seasonal Worker Programme VOL=Voluntary Agreement WHM=Working Holiday Makers |
|
| 3 | Character(15) | VARCHAR2(15) NOT NULL |
Target Record
Prompt Table: PSRECDEFN |
|
| 4 | Character(15) | VARCHAR2(15) NOT NULL |
Source Record
Prompt Table: PSRECDEFN |
|
| 5 | Date(10) | DATE |
Effective Date
Default Value: %date |