EM_PYMNTAPR_DAT (SQL Table)	Index Back
EBPP Payment Approval Logs Record that keeps track of which pay cycles have been already run against for payment approval email notification. RSR MarketPay Development

EM_PYMNTAPR_DAT

(SQL Table)

EBPP Payment Approval Logs

Record that keeps track of which pay cycles have been already run against for payment approval email notification. RSR MarketPay Development

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

3 EM_DATE_NOTIFIED Date(10) DATE Used in eS workflow to store the date an invoice was sent a notification.
Default Value: %Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
2	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
3	EM_DATE_NOTIFIED	Date(10)	DATE	Used in eS workflow to store the date an invoice was sent a notification. Default Value: %Date