WCS_ALRTS_TMP (SQL Table)	Index Back
WCS Employee Alert Messages This table cotains the Employee's Alert Messages.

WCS_ALRTS_TMP

(SQL Table)

WCS Employee Alert Messages

This table cotains the Employee's Alert Messages.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 WCS_ECM_EVENT_CD Character(3) VARCHAR2(3) NOT NULL WCS ECM Event Code

4 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID

5 WCS_ALERT_DTTM DateTime(26) TIMESTAMP Date/Time Stamp of Employee Alert Creation

6 BUDGET_START_DT Date(10) DATE Budget Start Date

7 WCS_SP_ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type/Role
A=Confirmer
C=Compensation Adminstrator
R=Reviewer
S=Submitter

8 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number

9 HR_SSTEXT_TEXT Long Character(8095) CLOB Long Text field for HR Self-Service Text Catalog. This is the text that is displayed on a page from the Text Catalog.

10 HR_SSTEXT_SUB_ID Character(4) VARCHAR2(4) NOT NULL The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID. For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId.

11 START_DT Date(10) DATE Start Date

12 END_DT Date(10) DATE end date

13 DATE_CREATED Date(10) DATE A Date value used to capture a creation date for a record.

14 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

15 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

16 ALLOW_DELETE Character(1) VARCHAR2(1) NOT NULL Allow Delete
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	WCS_ECM_EVENT_CD	Character(3)	VARCHAR2(3) NOT NULL	WCS ECM Event Code
4	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
5	WCS_ALERT_DTTM	DateTime(26)	TIMESTAMP	Date/Time Stamp of Employee Alert Creation
6	BUDGET_START_DT	Date(10)	DATE	Budget Start Date
7	WCS_SP_ACCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Access Type/Role A=Confirmer C=Compensation Adminstrator R=Reviewer S=Submitter
8	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
9	HR_SSTEXT_TEXT	Long Character(8095)	CLOB	Long Text field for HR Self-Service Text Catalog. This is the text that is displayed on a page from the Text Catalog.
10	HR_SSTEXT_SUB_ID	Character(4)	VARCHAR2(4) NOT NULL	The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID. For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId.
11	START_DT	Date(10)	DATE	Start Date
12	END_DT	Date(10)	DATE	end date
13	DATE_CREATED	Date(10)	DATE	A Date value used to capture a creation date for a record.
14	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
15	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
16	ALLOW_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Allow Delete Y/N Table Edit Default Value: N