GPAU_PSM_RP_AET (SQL Table)	Index Back
State record for PSM State record for PSM

GPAU_PSM_RP_AET

(SQL Table)

State record for PSM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing

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

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

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

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

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

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

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

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

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

14 GPAU_POP_IND Character(2) VARCHAR2(2) NOT NULL Population Indicator
10=Pay Entity
20=Pay Group
30=Payee

15 SQL_STMT_800 Long Character(800) VARCHAR2(800) SQL_Stmt_800

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
5	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.
6	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.
7	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.
8	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.
9	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.
10	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.
11	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.
12	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.
13	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.
14	GPAU_POP_IND	Character(2)	VARCHAR2(2) NOT NULL	Population Indicator 10=Pay Entity 20=Pay Group 30=Payee
15	SQL_STMT_800	Long Character(800)	VARCHAR2(800)	SQL_Stmt_800