HR_TBH_ERROR (SQL Table)	Index Back
Template Error table Smart HR Transactions Error table.This table is used to store the text of errors occurring during the creation of the Person or the Job Record using the Person Services, the Job Services or CIs.

HR_TBH_ERROR

(SQL Table)

Template Error table

Smart HR Transactions Error table.This table is used to store the text of errors occurring during the creation of the Person or the Job Record using the Person Services, the Job Services or CIs.

Parent record: HR_TBH_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TBH_SEQ Number(12,0) DECIMAL(12) NOT NULL Template Sequence

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

4 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

5 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning

6 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TBH_SEQ	Number(12,0)	DECIMAL(12) NOT NULL	Template Sequence
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
4	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
5	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
6	DESCRLONG	Long Character	CLOB	Long Description