PAY_ISS_STG_PUB (SQL Table)	Index Back
Pay Issued Staging Table Staging table which contains payments issued published to Expenses after running Batch Payroll and GL interface.

PAY_ISS_STG_PUB

(SQL Table)

Pay Issued Staging Table

Staging table which contains payments issued published to Expenses after running Batch Payroll and GL interface.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Expense Doc ID

4 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Expense Doc Type

5 EX_LINE_NBR Number(5,0) INTEGER NOT NULL Expense Line #

6 MONETARY_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Monetary Amount

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

8 PAYCHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Paycheck status.
A=Adjusted
C=Calculated
F=Confirmed
R=Reversed
V=Reversing Check

9 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.

10 CHECK_DT Date(10) DATE Check date.

11 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

12 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

13 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Expense Doc ID
4	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Expense Doc Type
5	EX_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Expense Line #
6	MONETARY_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Monetary Amount
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	PAYCHECK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paycheck status. A=Adjusted C=Calculated F=Confirmed R=Reversed V=Reversing Check
9	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
10	CHECK_DT	Date(10)	DATE	Check date.
11	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
12	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
13	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance