TL_ALERTS_VW

(SQL View)
 Index Back

Alert View

Combines alerts with information from the alert criteria and the associated navigation path.

SELECT AR.OPRID , A.EMPLID , A.EMPL_RCD , A.ALERT_ID , A.START_DATE , A.FIRST_PROC_DT , A.END_DATE , AC.ALERT_TYPE , AC.ALERT_SOURCE , A.ALERT_STATUS , A.ALERT_VAL_NUM , A.ALERT_VAL_CHAR , AC.PORTAL_NAME , AC.PORTAL_OBJNAME , I.MENUNAME , I.BARNAME , AC.PANELNAME , AC.ITEMNAME , I.ITEMLABEL , P.PORTAL_LABEL FROM PS_TL_ALERT_RCP AR , PS_TL_ALERT A , PS_TL_ALRT_CRT AC , PSMENUITEM I , PSPRSMDEFN P WHERE A.EMPLID = AR.EMPLID AND A.EMPL_RCD = AR.EMPL_RCD AND A.ALERT_ID = AR.ALERT_ID AND A.START_DATE = AR.START_DATE AND A.END_DATE = AR.END_DATE AND A.ALERT_ID = AC.ALERT_ID AND AC.PORTAL_NAME = P.PORTAL_NAME AND AC.PORTAL_OBJNAME = P.PORTAL_OBJNAME AND I.MENUNAME = P.PORTAL_URI_SEG1 AND ((I.ITEMNAME = P.PORTAL_URI_SEG2 AND I.ITEMNAME = I.PNLGRPNAME) OR (I.PNLGRPNAME= P.PORTAL_URI_SEG2 AND I.ITEMNAME <> I.PNLGRPNAME))

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 ALERT_ID Character(10) VARCHAR2(10) NOT NULL Alert Criterion ID
5 START_DATE Date(10) DATE Start Date for Gen Standing PO
6 FIRST_PROC_DT Date(10) DATE GP Core/Abs Mgt field to track when an absence was first processed. This date will not change regardless of how many retro runs are run against the absence subsequent to the initial calculation.
7 END_DATE Date(10) DATE End Date
8 ALERT_TYPE Character(2) VARCHAR2(2) NOT NULL Alert Type
B=Balances
E=Exception
L=Limit
P=Pattern
S=Status
U=Unprocessed Data
V=Data Verification
9 ALERT_SOURCE Character(2) VARCHAR2(2) NOT NULL Alert Source
A=Absence Event
B=Benefit Plan
C=Comp or Leave Time
E=Exceptions
P=Payable Time
R=Reported Time
10 ALERT_STATUS Character(2) VARCHAR2(2) NOT NULL Alerts Status
AA=Complete
AU=Accepted - Unrestricted
OP=Open
PC=Pending Correction
RA=Removed by Administrator
RW=Reviewed
11 ALERT_VAL_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Alert Triggering value. The value that was found in the data source - e.g. the sum of hours in Reported Time - that triggered a given alert to be created.
12 ALERT_VAL_CHAR Character(30) VARCHAR2(30) NOT NULL Alert Triggering value. The value that was found in the data source - e.g. the reported TRC - that triggered a given alert to be created.
13 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
14 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
15 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
16 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
17 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname
18 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
19 ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
20 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label