HR_TPOOL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_TP_ID	Character(30)	VARCHAR2(30) NOT NULL	Talent Pool ID Default Value: NEW
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	HR_TP_CAT_ID	Character(30)	VARCHAR2(30) NOT NULL	Talent Pool Category Prompt Table: HR_TP_CAT_VW
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
5	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
6	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUSUNIT_HR_VW
8	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSN_DATA_VW
9	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
10	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID Default Value: OPR_DEF_TBL_HR.SETID
11	JOB_FAMILY	Character(6)	VARCHAR2(6) NOT NULL	Job Family Prompt Table: JOB_FAMILY_TBL
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
13	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID Default Value: OPR_DEF_TBL_HR.SETID
14	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
15	HR_SP_CAND_SRCH	Character(1)	VARCHAR2(1) NOT NULL	Use Talent Pool for succession plan candidate searches Y/N Table Edit Default Value: N
16	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.
17	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.