GPGB_EE_PAY_REC(SQL Table) |
Index Back |
|---|---|
GPGB_EE_PAY_RECGPGB_EE_PAY_REC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | HIRE_DT | Date(10) | DATE | First Start Date |
| 4 | LEAVE_DT | Date(10) | DATE | Leave Date |
| 5 | GPGB_QUAL_ID | Character(18) | VARCHAR2(18) NOT NULL | Global Payroll UK - RTI Qualifier |
| 6 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |