GPAU_AUD_HR_STG(SQL Table) |
Index Back |
|---|---|
STP Non-Payroll DataNon-Payroll Data Staging Record - 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 5 | BALANCE_GRP_NUM | Character(3) | VARCHAR2(3) NOT NULL | This field will be used to determine the grouping of balances from the different jobs of the employee. |
| 6 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT_SGPAU |
| 7 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GPAU_PYGRP_VW |
| 8 | GPAU_TAX_YEAR | Number(4,0) | SMALLINT NOT NULL | Tax Year - End of Year Processing |
| 9 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPAU_UPD_CALRUN |
| 10 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 11 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 12 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 13 | EMPLID_BGRP | Character(14) | VARCHAR2(14) NOT NULL | Emplid |
| 14 | GPAU_STP_EVENT | Character(1) | VARCHAR2(1) NOT NULL |
Event Type is used to determine if it is Update Event or Payee Override.
P=Payee Override U=Update Event |
| 15 | GPAU_STP_VERSION | Number(3,0) | SMALLINT NOT NULL |
Version for STP Update Event
Default Value: 0 |
| 16 | GPAU_STP_UPDEVT_DT | Date(10) | DATE | Update Event Date |
| 17 | INSTANCE | Number(3,0) | SMALLINT NOT NULL |
Instance Number
Default Value: 0 |
| 18 | GPAU_ABN | Character(11) | VARCHAR2(11) NOT NULL | A unique number used by the ATO to identify a contractor. |
| 19 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 20 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 21 | ADDRESS_150 | Character(150) | VARCHAR2(150) NOT NULL | Preparer's Address |
| 22 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 23 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_AUS_VW |
| 24 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 25 | COUNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-Char Country Code |
| 26 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 27 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Address Type |
| 28 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 29 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 30 | DAY1 | Number(2,0) | SMALLINT NOT NULL | Day 1 |
| 31 | MONTH1 | Number(2,0) | SMALLINT NOT NULL | Month 1 |
| 32 | YEAR_DISPLAY | Number(4,0) | SMALLINT NOT NULL | Year Display |
| 33 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 34 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 35 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 36 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 37 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 38 | REHIRE_DT | Date(10) | DATE | Rehire Date |
| 39 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 40 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 41 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 42 | GPAU_PAYMENT_BASIS | Character(2) | VARCHAR2(2) NOT NULL |
This is the payee's basis of payment. It identiy whether the payment was made from full time, part time, casual, or labour hire employment, This field is part of the TFN Declaration form to be filled in by the employee.
10=Casual 20=Full Time 30=Labour Hire 40=Part Time 50=Pension/Annuity |
| 43 | GPAU_HECS_YN | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No flag. This will identify if the payee should be paying HECS payments or not.
Y/N Table Edit |
| 44 | GPAU_SFSS_YN | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No flag. This will identify if payee should be paying SFSS contributions or not.
Y/N Table Edit |
| 45 | GPAU_TFN | Character(9) | VARCHAR2(9) NOT NULL | This is the payee's tax file number. This is the payee's unique identification number for tax purposes. |
| 46 | GPAU_TFN_SIGNED_DT | Date(10) | DATE | This is the date when the employee has signed the TFN Declaration Form. |
| 47 | GPAU_TFN_SIGNED_YN | Character(1) | VARCHAR2(1) NOT NULL | Yes/No flag. This will determine whether the payee has signed the TFN Declaration form that was submitted to the employer. |
| 48 | GPAU_RES_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Payee residency status |
| 49 | GPAU_TXFRE_CLAIMED | Character(1) | VARCHAR2(1) NOT NULL |
Tax free treshold claimed
Y/N Table Edit |
| 50 | GPAU_TFN_TERM_IND | Character(1) | VARCHAR2(1) NOT NULL | Payee terminated indicator |
| 51 | GPAU_STP_FINAL_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Final Event Indicator - Single Touch Payroll
A=All Payees N=Not Applicable T=Terminated Payees Y=Active Payees Y/N Table Edit |
| 52 | GPAU_TAX_SCALE | Character(3) | VARCHAR2(3) NOT NULL | This is used to identify the rates, thresholds, and other factors that will be used in the calculation of the payee's tax. |
| 53 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 54 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |