TL_ALERT_RUNCTL

(SQL Table)
Index Back

Alert Process

Main run control record for the Alert process.

# 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 ALERT_RUN_OPTION Character(1) VARCHAR2(1) NOT NULL Alert Run Option; enables time period settings for the Alert generation process, specifically indicating the time span to be covered (current period, or between a specified start and end dates).
C=Current Period
D=Specified Date Range

Default Value: C

4 START_DATE Date(10) DATE Start Date for Gen Standing PO
5 END_DATE Date(10) DATE End Date