GPAU_RC_REPORTS(SQL Table) |
Index Back |
---|---|
Run Cntl - Australia ReportsThis table will be used to record the parameters for running programs. The key fields for this table include the operator ID and run control ID. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
4 | GPAU_TFN_RUN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
This will identify whether the report is a Test run or a Production run.
10=Production Run 20=Test Run Default Value: 10 |
5 | DATE_FROM | Date(10) | DATE |
Date From
Default Value: %date |
6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL_ACCESS |
8 | ABS_TYPE_OPTN | Character(3) | VARCHAR2(3) NOT NULL |
Absence Type
Prompt Table: GP_ABS_TYPE |
9 | GPAU_TERM_EMP_YN | Character(1) | VARCHAR2(1) NOT NULL |
Include Terminated Employees
Y/N Table Edit Default Value: N |
10 | DATE_TO | Date(10) | DATE |
Previous Period Date To
Default Value: %date |
11 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
12 | ASOFDATE | Date(10) | DATE |
As of Date
Default Value: %date |
13 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPAU_NP_CAL_VW |
14 | GPAU_TFN_UPDATE_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field is a yes/no flag. When set to 'Y', it means that when the auto tax scale update process is run, all employees with an expired TFN exemption date, will be updated to a tax scale of '4R'.
Y/N Table Edit Default Value: N |
15 | GPAU_SORT_SEQ | Character(2) | VARCHAR2(2) NOT NULL |
This field will be used to identify the sort sequnce of the report that list all employees with an expired TFN exemption date.
10=Employee ID 20=Exemption Expiry date Default Value: 10 |
16 | GPAU_RPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the level of details required in the reports. Valid values are Detail report or Summary report.
1=Detail 2=Summary Default Value: 1 |
17 | GPAU_ELEMENT_LIST | Character(1) | VARCHAR2(1) NOT NULL | Used to display the label in the page GPAU_RC_PY13, to generate the Payroll component report |
18 | GPAU_PAYEES_LIST | Character(1) | VARCHAR2(1) NOT NULL | Field to display label for the hyperlink button 'Payees' on GPAU_RC_PY11 page |
19 | GPAU_PYGRP_LIST | Character(1) | VARCHAR2(1) NOT NULL | Field used to display the label on the hyperlink to the secondary page. It is used in the page GPAU_RC_PY11 and PY12 |
20 | GPAU_RPT_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Provide user with the oprion to report all element in a component or selectively
10=All 20=Select Element 30=Select Pay Group 40=Select Payee |
21 | GPAU_RPT_SECTION | Character(2) | VARCHAR2(2) NOT NULL |
This field store the Components to be reported.
10=Earnings 20=Deductions 30=Deductions & Arrears 40=Accumulators 50=Earnings & Deductions 60=All Default Value: 50 |
22 | GPAU_RPT_SUMMARY | Character(1) | VARCHAR2(1) NOT NULL |
Report Summary indicator
Default Value: N |
23 | GPAU_RPT_YTD | Character(2) | VARCHAR2(2) NOT NULL | Indicator Y/N to report YTD result; used in the Reconcilation report, in page GPAU_RC_PY12. |
24 | GPAU_SORT_DEPT | Character(1) | VARCHAR2(1) NOT NULL | Sort by Department, Y/N |
25 | GPAU_SORT_LOC | Character(1) | VARCHAR2(1) NOT NULL | Sort by Location, Yes/No |
26 | GPAU_SORT_PYNAME | Character(1) | VARCHAR2(1) NOT NULL |
Sort by Payee Name, Y/N
Y/N Table Edit |
27 | GPAU_GRP_ENT | Character(10) | VARCHAR2(10) NOT NULL |
State Payroll Tax Group Entity
Prompt Table: GPAU_GRP_ENT |
28 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
29 | GPAU_SPT_BASE_DT | Character(2) | VARCHAR2(2) NOT NULL |
This field is used to determine the base date when running the SPT tax reporting process.
10=Pay End Date 20=Payment Date 30=Earlier of End/Payment Dates Default Value: 10 |
30 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: AUS |
31 | USED_BY | Character(1) | VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries C=Specific Country Default Value: C |
32 | GPAU_SORT_KEY1 | Character(2) | VARCHAR2(2) NOT NULL |
This field will be used to identify the first sort key.
00=Not Applicable 10=Pay Entity 20=Location 30=Department 40=Employee Name 50=Paygroup Default Value: 00 |
33 | GPAU_SORT_KEY2 | Character(2) | VARCHAR2(2) NOT NULL |
This field will be used to determine the second sort key
00=Not Applicable 10=Pay Entity 20=Location 30=Department 40=Employee Name 50=Paygroup Default Value: 00 |
34 | GPAU_SORT_KEY3 | Character(2) | VARCHAR2(2) NOT NULL |
This field will be used to identify the third sort key.
00=Not Applicable 10=Pay Entity 20=Location 30=Department 40=Employee Name 50=Paygroup Default Value: 00 |
35 | GPAU_PAY_RPT_ID | Character(8) | VARCHAR2(8) NOT NULL |
Payroll Report ID for Accumulators elements inclusion and Earns/Dedns elements exclusion
Prompt Table: GPAU_PAY_RPT |