TC_POPULATION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Total Comp Plan ID
2	TC_PLAN_EFFDT	Date(10)	DATE	Total Comp Plan Effdt
3	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	THRU_DATE	Date(10)	DATE	Thru Date
7	FROM_DATE	Date(10)	DATE	From Date
8	JOB_EFFDT	Date(10)	DATE	Job Effective Date
9	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
13	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
14	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
16	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
17	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
18	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
19	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
20	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
21	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
22	STEP	Number(2,0)	SMALLINT NOT NULL	Step
23	PRIMARY_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Primary Indicator for Multiple
24	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
25	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
26	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category
27	TC_HEAD_COUNT	Number(6,0)	INTEGER NOT NULL	Head Count
28	TC_FTE	Number(15,6)	DECIMAL(14,6) NOT NULL	FTE
29	SETID_LBR_AGRMNT	Character(5)	VARCHAR2(5) NOT NULL	Labor Agreement SetID