GPAU_RC_PSM(SQL Table) |
Index Back |
---|---|
PSM Run ControlThis 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 |