RTBL_PURGE_CNTL

(SQL Table)
Index Back

RTBL Purge control

# 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 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
3 RTBL_SCENARIO Character(18) VARCHAR2(18) NOT NULL Scenario Name
4 SCE_CREATE_DTTM DateTime(26) TIMESTAMP Create Datetime
5 LAST_PROC_DTTM DateTime(26) TIMESTAMP last processed datetime.
6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7 STATUS_SCENARIO Character(2) VARCHAR2(2) NOT NULL Status
CE=Complete with Errors
CS=Cancelled
CW=Complete with Warning
EE=Edit Errors
HS=On Hold
NS=No Success
NY=Not Yet Processed
PC=Paused for Checkpoint
PN=Processing Now
RA=Request Approved
RC=Request Cancelled
RD=Request Denied
RP=Request Pending
RY=Request Deployed
SC=Successfully Complete
8 OWNER_SCENARIO Character(30) VARCHAR2(30) NOT NULL Owner
9 RTBL_ALOW_PURGE Character(1) VARCHAR2(1) NOT NULL Allow Batch Data Purge
10 RTBL_ENFORCE Character(1) VARCHAR2(1) NOT NULL Notify User?
11 BTN_ERROR_WARNING Character(1) VARCHAR2(1) NOT NULL Errors/Warnings