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

TL_ALERT_HST

(SQL Table)

Alerts History Record

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

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

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

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

7 END_DATE Date(10) DATE End Date

8 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

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

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

11 DATETIME_CREATED DateTime(26) TIMESTAMP DateTime Created

12 DATETIME_UPDATED DateTime(26) TIMESTAMP DateTime Updated

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

14 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	ALERT_ID	Character(10)	VARCHAR2(10) NOT NULL	Alert Criterion ID
6	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
7	END_DATE	Date(10)	DATE	End Date
8	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
9	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.
10	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.
11	DATETIME_CREATED	DateTime(26)	TIMESTAMP	DateTime Created
12	DATETIME_UPDATED	DateTime(26)	TIMESTAMP	DateTime Updated
13	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last Operator to Update
14	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.