WCS_ALERT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WCS_ECM_EVENT_CD	Character(3)	VARCHAR2(3) NOT NULL	WCS ECM Event Code Prompt Table: WCS_EVENT_TBL
2	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier Default Value: HWCS Prompt Table: HR_SSTEXT_CFG
3	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. Default Value: ALRT Prompt Table: HR_SSTEXT_CFG
4	TEXT_ID	Character(18)	VARCHAR2(18) NOT NULL	Text ID Default Value: MESSAGE Prompt Table: HR_SSTEXT_MSGID
5	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
6	ALLOW_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Allow Delete Y/N Table Edit Default Value: N
7	ALLOW_DUPS_IND	Character(1)	VARCHAR2(1) NOT NULL	Allow Duplicates Indicator Y/N Table Edit Default Value: N
8	WCS_SS_TARGET_CD	Character(3)	VARCHAR2(3) NOT NULL	Defines the target of a navigational link or launch selection made on the Application Alerts page by the User. AT=Attachment Only GS=Group Summary Page NA=Not Applicable Default Value: GS
9	WCS_PREF_DISP_CD	Character(4)	VARCHAR2(4) NOT NULL	Preferred Date Range Display Code. Although this has a slightly different usage, it shares the same set of translates as the WCS_EVT_DISP_CD field definition. COMM=Notification Period DFLT=Default OPNR=Review Period OPNU=Update Period