TL_ALERT (SQL Table)	Index Back
Alerts Contains alerts generated in response to a data condition qualified as requiring further review or attention.

TL_ALERT

(SQL Table)

Alerts

Contains alerts generated in response to a data condition qualified as requiring further review or attention.

Parent Record Of TL_ALERT_RCP TL_ALRT_RCP_HST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 ALERT_ID Character(10) VARCHAR2(10) NOT NULL Alert Criterion ID

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

5 END_DATE Date(10) DATE End Date

6 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

7 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.

8 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.

9 DATETIME_CREATED DateTime(26) TIMESTAMP DateTime Created

10 DATETIME_UPDATED DateTime(26) TIMESTAMP DateTime Updated

11 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last Operator to Update

12 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	ALERT_ID	Character(10)	VARCHAR2(10) NOT NULL	Alert Criterion ID
4	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
5	END_DATE	Date(10)	DATE	End Date
6	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
7	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.
8	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.
9	DATETIME_CREATED	DateTime(26)	TIMESTAMP	DateTime Created
10	DATETIME_UPDATED	DateTime(26)	TIMESTAMP	DateTime Updated
11	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last Operator to Update
12	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.