WF_HR_TR_NC_NOT (SQL Table)	Index Back
HR SelfService Workflow Config Child table to WF_HR_TRANS - defines Administrator Notification using Notification composer

WF_HR_TR_NC_NOT

(SQL Table)

HR SelfService Workflow Config

Child table to WF_HR_TRANS - defines Administrator Notification using Notification composer

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

2 NOTIFY_ON_ERR_NC Character(50) VARCHAR2(50) NOT NULL Field to store Notification Composer application Id to notify Admin on error
Prompt Table: HR_NC_XREF_VW

3 NOTIFY_ON_WARN_NC Character(50) VARCHAR2(50) NOT NULL Field to store Notification Composer application Id to notify Admin on warning
Prompt Table: HR_NC_XREF_VW

4 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N

5 ADMN_MANUAL_UPD_NC Character(50) VARCHAR2(50) NOT NULL Field to store Notification Composer application Id to notify Admin on Manual Update
Prompt Table: HR_NC_XREF_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
2	NOTIFY_ON_ERR_NC	Character(50)	VARCHAR2(50) NOT NULL	Field to store Notification Composer application Id to notify Admin on error Prompt Table: HR_NC_XREF_VW
3	NOTIFY_ON_WARN_NC	Character(50)	VARCHAR2(50) NOT NULL	Field to store Notification Composer application Id to notify Admin on warning Prompt Table: HR_NC_XREF_VW
4	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Default Value: N
5	ADMN_MANUAL_UPD_NC	Character(50)	VARCHAR2(50) NOT NULL	Field to store Notification Composer application Id to notify Admin on Manual Update Prompt Table: HR_NC_XREF_VW