HR_TBH_HDRHIST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	TBH_SEQ	Number(12,0)	DECIMAL(12) NOT NULL	Template Sequence
4	TBH_TMPL_ID	Character(18)	VARCHAR2(18) NOT NULL	Template ID Prompt Table: HR_TBH_TMPL_HDR
5	TBH_TMPL_EFFDT	Date(10)	DATE	Template Effective Date
6	TBH_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Template Status ACTR=Action Required CANL=Cancel COMP=Completed DLTD=Deleted DRFT=Draft EROR=Error HIRD=Hired/Added SBMT=Requested X=All Default Value: DRFT
7	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.
8	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.
9	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
10	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
11	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
12	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
13	JOB_EFFDT	Date(10)	DATE	Job Effective Date
14	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
15	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
16	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
17	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Name Format Types
18	COUNTRY_AD_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Address Format Types
19	TBH_TMPL_TXN_TYP	Character(10)	VARCHAR2(10) NOT NULL	Template Transaction Type Default Value: HIRE
20	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
21	TBH_ACT_SEL	Character(4)	VARCHAR2(4) NOT NULL	Select an Action EMAD=Send to HR EMHR=Hire EMNH=New Hire EMRH=Rehire EMUP=Update Assignment
22	EMPLOYEE_RECORD	Character(1)	VARCHAR2(1) NOT NULL	Employee Record E=Use Existing Assignment N=Create New Assignment
23	DESCRLONG_NOTES	Long Character	CLOB	Long Description