GPAU_RC_REPORTS

(SQL Table)
Index Back

Run Cntl - Australia Reports

This 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.

  • Parent Record Of GPAU_RC_TFN001
  • # 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