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	TBH_TMPL_ID	Character(18)	VARCHAR2(18) NOT NULL	Template ID Prompt Table: HR_TBH_TMPL_HDR
3	TBH_TMPL_EFFDT	Date(10)	DATE	Template Effective Date
4	TBH_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Template Status ACTR=Action Required CANL=Cancel COMP=Completed DRFT=Draft EROR=Error HIRD=Hired/Added SBMT=Requested Default Value: DRFT
5	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
8	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
9	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
10	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
11	JOB_EFFDT	Date(10)	DATE	Job Effective Date
12	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
13	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
15	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Name Format Types
16	COUNTRY_AD_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Address Format Types
17	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
18	TBH_ACT_SEL	Character(4)	VARCHAR2(4) NOT NULL	Select an Action EMAD=Send to HR EMHR=Hire EMNH=New Hire EMRH=Rehire
19	EMPLOYEE_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Employee Record E=Use Existing Assignment N=Create New Assignment
20	DESCRLONG_NOTES	Long Character	CLOB	Long Description