GPAU_RC_PSM

(SQL Table)
Index Back

PSM Run Control

This is a run control record fo running the different year-end processed and reports, lkie FBT Collection, Payment Summary Creation, Magnetic Media, Payment Summary Exception and Reconciliation, etc

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 GPAU_POP_IND Character(2) VARCHAR2(2) NOT NULL Population Indicator
10=Pay Entity
20=Pay Group
30=Payee
4 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing
5 GPAU_AMENDED_IND Character(1) VARCHAR2(1) NOT NULL Amended Payment Summary Indicator

Default Value: N

6 GPAU_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Update when Record Exists Flag

Y/N Table Edit

Default Value: N

7 GPAU_PSM_REPRINTSW Character(1) VARCHAR2(1) NOT NULL Part of Year End Processing. To determine if the Payment Summaries that have previously been printed be printed again.

Y/N Table Edit

Default Value: N

8 GPAU_PSM_PYG_NB_SW Character(1) VARCHAR2(1) NOT NULL Year End Processing. Flag used to determine if a "PAYG Payment Summary (Non-Business)" payment summary is required.

Y/N Table Edit

Default Value: N

9 GPAU_PSM_PYG_VOLSW Character(1) VARCHAR2(1) NOT NULL Year End Processing. Flag used to determine if a "PAYG Payment Summary (Voluntary)" payment summary is required.

Y/N Table Edit

Default Value: N

10 GPAU_PSM_ETP_SW Character(1) VARCHAR2(1) NOT NULL Year End Processing. Flag used to determine if a "ETP Payment Summary" payment summary is required.

Y/N Table Edit

Default Value: N

11 GPAU_PSM_EMPL_SW Character(1) VARCHAR2(1) NOT NULL Part of Year End Processing. To determine if the Employee requires optional notice on the back of the Payment Summary.

Y/N Table Edit

Default Value: N

12 GPAU_PSM_PYENT_SW Character(1) VARCHAR2(1) NOT NULL Part of Year End Processing. To determine if the Pay Entity is to be considered in the sort sequence when printing the Payment Summaries.

Y/N Table Edit

Default Value: Y

13 GPAU_PSM_PYGRP_SW Character(1) VARCHAR2(1) NOT NULL Part of Year End Processing. To determine if the Pay Group is to be considered in the sort sequence when printing the Payment Summaries.

Y/N Table Edit

Default Value: Y

14 GPAU_PSM_DEPT_SW Character(1) VARCHAR2(1) NOT NULL Part of Year End Processing. To determine if the Department is to be considered in the sort sequence when printing the Payment Summaries.

Y/N Table Edit

Default Value: Y

15 GPAU_PSM_LOCN_SW Character(1) VARCHAR2(1) NOT NULL Part of Year End Processing. To determine if the Location is to be considered in the sort sequence when printing the Payment Summaries.

Y/N Table Edit

Default Value: Y

16 GPAU_PSM_PAYEE_SW Character(1) VARCHAR2(1) NOT NULL Part of Year End Processing. To determine if the Payee Name is to be considered in the sort sequence when printing the Payment Summaries.

Y/N Table Edit

Default Value: Y

17 GPAU_RUN_TYPE Character(2) VARCHAR2(2) NOT NULL Run Type for EOY Magnetic Type
10=Production
20=Test

Default Value: 10

18 GPAU_MAGMED_TYPE Character(2) VARCHAR2(2) NOT NULL Magnetic Media Type for EOY
10=PAYG Payment Summary
20=PAYG Withholding with No ABN

Default Value: 10

19 GPAU_REPORT_TYPE Character(2) VARCHAR2(2) NOT NULL PSM Reconciliation report.
10=Details/Summary
20=Summary only

Default Value: 10

20 GPAU_PSM_DPLX_SW Character(1) VARCHAR2(1) NOT NULL Paymen Summary Reporting - Duplex Printing Flag. Allows to choose one- ore two-sided printing.

Y/N Table Edit

Default Value: N

21 GPAU_PSM_PYG_FE_SW Character(1) VARCHAR2(1) NOT NULL Year End Processing. Flag used to determine if a "PAYG Payment Summary (Foreign Empl)" payment summary is required.

Y/N Table Edit

Default Value: N

22 GPAU_UNFIN_SW Character(1) VARCHAR2(1) NOT NULL Single Touch Payroll Switch

Y/N Table Edit

Default Value: N

23 GPAU_DELRECON Character(1) VARCHAR2(1) NOT NULL This field is created to identify whether to delete historic reconciliation data.

Y/N Table Edit

Default Value: Y