GP_PG_DTL_SGPAU(SQL Table) |
Index Back |
|---|---|
Paygroup Details - AUSThis is the paygroup record for Australia. It is a sibling to the GP_PYGRP_DTL table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Default Value: GP_PYGRP_DTL.GP_PAYGROUP |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | GPAU_FREQ_ID_DY | Character(5) | VARCHAR2(5) NOT NULL |
GP Australia - Superannuation Daily indicator
Prompt Table: GPAU_DY_FREQ_VW |
| 4 | GPAU_FREQ_ID_WK | Character(5) | VARCHAR2(5) NOT NULL |
GP Australia - Superannuation weekly indicator
Prompt Table: GPAU_WK_FREQ_VW |
| 5 | GPAU_FREQ_ID_BWK | Character(5) | VARCHAR2(5) NOT NULL |
GP Australia - Superannuation Bi-Weekly indicator
Prompt Table: GPAU_BWK_FRQ_VW |
| 6 | GPAU_FREQ_ID_SMTH | Character(5) | VARCHAR2(5) NOT NULL |
GP Australia - Superannuation Semi monthly
Prompt Table: GPAU_SMTH_FRQVW |
| 7 | GPAU_FREQ_ID_MTH | Character(5) | VARCHAR2(5) NOT NULL |
GP Australia - Superannuation Monthly indicator
Prompt Table: GPAU_MTH_FRQ_VW |
| 8 | GPAU_FREQ_ID_QTR | Character(5) | VARCHAR2(5) NOT NULL |
GP Australia - Superannuation Quarterly indicator
Prompt Table: GPAU_QTR_FRQ_VW |
| 9 | GPAU_FREQ_ID_YR | Character(5) | VARCHAR2(5) NOT NULL |
GP Australia - Superannuation Yearly indicator
Prompt Table: GPAU_YR_FREQ_VW |
| 10 | GPAU_PAYSLIP_ID | Character(18) | VARCHAR2(18) NOT NULL |
This field is used to uniquely identify a payslip template.
Prompt Table: GPAU_PSLP_ID_VW |
| 11 | GPAU_REG_RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
The Regular Run Type identifies a single Run Type that will be used when determining when an Advance Payment is to be made.
The Advance calculation will use the dates from Calendars of the is Run Type to determine which Calendar Group the advance should be paid in.
Prompt Table: GPAU_RTYP_P_VW |
| 12 | PAY_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Pay Frequency
A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly Prompt Table: FREQUENCY_TBL |