HP_BDGT_TAXCHG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION_DTTM	DateTime(26)	TIMESTAMP	Override Date Time
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
3	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
4	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	POSITION_POOL_ID	Character(3)	VARCHAR2(3) NOT NULL	Position Pool ID
6	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
7	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
8	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
11	EFFDT	Date(10)	DATE NOT NULL	Effective Date
12	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: 0
13	BUDGET_LEVEL_INDC	Character(1)	VARCHAR2(1) NOT NULL	Budget Level A=Appointment D=Department J=Jobcode O=Position Pool P=Position
14	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
15	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
16	TAX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Tax Balance Class
17	BUDGET_SEQ	Number(2,0)	SMALLINT NOT NULL	Budget Sequence
18	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: ACCT_CD_CA_VW
19	HP_PRIOR_ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Previous Account Code before Change
20	HP_PREV_EFFDT	Date(10)	DATE	Previous Effective Date
21	HP_PREV_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Previous Effective Sequence
22	HP_NEXT_EFFDT	Date(10)	DATE	Next Effective Date
23	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
24	PRIOR_EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prior Effective Status