GPGB_RTI_REF_NO(SQL Table) |
Index Back |
|---|---|
Unique Reference RTIStores the unique reference number for RTI |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPGB_RTI_TRANS | Character(4) | VARCHAR2(4) NOT NULL |
RTI Transaction Types
A=Employer Alignment Submission B=Full Payment Submission C=Employer Payment Summary D=NINO Verification Request E=NINO Verification Reply F=Early Year Update |
| 2 | GPGB_TAX_BGN_YR | Number(4,0) | SMALLINT NOT NULL | Tax Year Begins In This Calendar Year |
| 3 | GPGB_EDI_RUN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
GP UK EDI Run Type
0=Final Run 1=Trial Run |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 5 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 6 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 7 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 8 | EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL | EMPLID (first for a range) |
| 9 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | Empl ID To |
| 10 | GPGB_EDI_REF | Number(14,0) | DECIMAL(14) NOT NULL | GPUK EDI stores EDI transaction number |