RY_EM_CNT_RUN

(SQL Table)
Index Back

Freq. Policy Batch Run Status

Run control record for the email frequency policy batch count process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 RY_EM_CNT_RUNSTAT Character(4) VARCHAR2(4) NOT NULL Email Frequency Policy batch count process run status.
ERR=Error
PROC=Processing
QUED=Queued
SUCC=Success

Default Value: QUED

4 BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
5 ENDDTTM DateTime(26) TIMESTAMP End Date/Time
6 RY_CNT_REFRSH_DTTM DateTime(26) TIMESTAMP Email Frequency Policy count refresh timestamp.
7 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
8 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
9 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
10 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
11 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
12 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time