HR_TBH_TMPL_HDR (SQL Table)	Index Back
Template Header table The Template Header table will store only the status and description of the template.

HR_TBH_TMPL_HDR

(SQL Table)

Template Header table

The Template Header table will store only the status and description of the template.

Related Language Record: HR_TBH_TMPLHDRL

Parent Record Of HR_TBH_PAGE0_VW HR_TBH_TMPLR_VW HR_TBH_TMPLSCHL HR_TBH_TMPLS_VW HR_TBH_TMPL_CFG HR_TBH_TMPL_DTL HR_TBH_TMPL_SCH HR_TBH_TMPL_SEC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TBH_TMPL_ID Character(18) VARCHAR2(18) NOT NULL Template ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 TBH_TMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Template Status
A=Active
I=Inactive
T=Test
Default Value: T

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

6 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TBH_TMPL_ID	Character(18)	VARCHAR2(18) NOT NULL	Template ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	TBH_TMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Template Status A=Active I=Inactive T=Test Default Value: T
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	DESCRLONG	Long Character	CLOB	Long Description