GPAU_AUD_EVTOVR(SQL Table) |
Index Back |
|---|---|
PAYEVNT PTD OverridePAYEVNT PTD Override - Single Touch Payroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AUDIT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 2 | AUDIT_STAMP | DateTime(26) | TIMESTAMP | Date and Time Stamp |
| 3 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT_SGPAU |
| 5 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPAU_CALPTD_VW |
| 6 | GPAU_GROSS_PTD | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | PAYEVNT consolidated PTD Gross Amount - Single Touch Payroll |
| 7 | GPAU_TAX_WHELD_PTD | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | PayEvnt Tax Witholding PTD Amount - Single Touch Payroll |
| 8 | GPAU_EVNT_CSD_PAY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Child Support Deduction PTD of Employee - Single Touch Payroll |
| 9 | GPAU_EVNT_CSG_PAY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Child Support Garnishment PTD of Employee - Single Touch Payroll |