RB_SLA_SCHD_AET

(SQL Table)
Index Back

Sla Scheduler AET

AET for SLa Scheduler

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 CURR_DTTM DateTime(26) TIMESTAMP Current DateTime
5 MCF_EMAIL_ID Number(16,0) DECIMAL(16) NOT NULL Email Id
6 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
7 SLA_TYPE Character(4) VARCHAR2(4) NOT NULL SLa Type
MBDU=Mailbox Due Datetime
MBEW=Mailbox Early Warning
WLDU=Worklist Due DateTime
WLEW=Worklist Early Warning
8 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
9 DELAY_DTTM DateTime(26) TIMESTAMP Delay Datetime
10 RB_DUMMY1 Character(3) VARCHAR2(3) NOT NULL Multi-purpose Dummy field-----